*/5 * * * * /usr/local/bin/lockrun --lockfile=/var/run/php.lockrun -- /usr/bin/php -f /usr/local/bin/run.php &> /dev/null
Monthly Archives: September 2020
check binlog enabled mysql
SHOW VARIABLES LIKE ‘log_bin’;
ubuntu 18.04 percona install
apt-get install gnupg2
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
apt-get update
apt install percona-server-server-5.7
innobackupex Error: Unsupported server version
apt-get install percona-xtrabackup-24
SSD Health Status on VMware ESXi
/opt/smartstorageadmin/ssacli/bin/ssacli ctrl slot = 0 pd all show detail
mariadb 10.4.14 centos 8
cat << EOF > /etc/yum.repos.d/mariadb.repo
[mariadb]
name = MariaDB-10.4
baseurl=http://yum.mariadb.org/10.4/centos8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
rpm –import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
dnf update
dnf –disablerepo=AppStream install MariaDB-server MariaDB-client
Google datastudio connect MySQL 8 problem
Workaround is tu use proxysql
mysql_query_rules:
{
rule_id=1
active=1
match_pattern="\@\@query_cache_size"
replace_pattern="null"
apply=0
},
{
rule_id=2
active=1
match_pattern="\@\@query_cache_type"
replace_pattern="null"
apply=0
},
{
rule_id=3
active=1
match_pattern="\@\@tx_isolation"
replace_pattern="null"
apply=0
},
find mysql sock
mysqladmin variables | grep socket
sslh
sslh accepts connections on specified ports, and forwards them further based on tests performed on the first data packet sent by the remote client.
Probes for HTTP, TLS/SSL (including SNI and ALPN), SSH, OpenVPN, tinc, XMPP, SOCKS5, are implemented, and any other protocol that can be tested using a regular expression, can be recognised. A typical use case is to allow serving several services on port 443 (e.g. to connect to SSH from inside a corporate firewall, which almost never block port 443) while still serving HTTPS on that port.
vmware check smart
esxcli storage core device list
esxcli storage core device smart get -d disk_name
vmware get version cli
vmware -vl
monit check fpm
grep -r "listen =" /etc/php/*/fpm/pool.d/*
find /run -iname php*.pid
vi /etc/monit/conf.d/php-fpm
check process php-fpm with pidfile /run/php/7/php-fpm.pid
start program = "/usr/sbin/service php7-fpm start" with timeout 60 seconds
stop program = "/usr/sbin/service php7-fpm stop"
if failed unixsocket /var/run/php7-fpm.sock then restart
monit -t
service monit reload
nginx start from command line
nginx -g "pid /var/run/nginx.pid; worker_processes `sysctl -n hw.ncpu`;"
ubuntu upgrade filebeat
wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | apt-key add -
echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | tee /etc/apt/sources.list.d/elastic-7.x.list
apt-get update
apt list --upgradable | grep filebeat
apt-get --only-upgrade install filebeat
ERROR instance/beat.go:951 Exiting: 1 error: setting ‘filebeat.prospectors’ has been removed
Change filebeat.prospectors:
to:
filebeat.inputs: