C:\>net user User
windows check if user has admin rights
Leave a reply
mysql master slave replication
log-bin=mysql-bin
server-id=1
innobackupex --user=root --password=password /path/to/backupdir
innobackupex --user=root --password=password --apply-log /path/to/backupdir/$TIMESTAMP/
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'remote_ip' IDENTIFIED BY 'slave_password';
server-id=2
cat /var/lib/mysql/xtrabackup_binlog_info
mysql-bin.000001 100
CHANGE MASTER TO MASTER_HOST='master_ip', MASTER_USER='repl', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=100;
START SLAVE;
mysql> SHOW SLAVE STATUS \G
...
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
...
Seconds_Behind_Master: 13
Adding another slave, run on slave:
innobackupex --user=root --password=password --slave-info /path/to/backupdir
innobackupex --apply-log --use-memory=2G /path/to/backupdir/$TIMESTAMP/
On master:
GRANT REPLICATION SLAVE ON *.* TO 'repl2'@'new_slave_ip' IDENTIFIED BY 'new_slave_pass';
cat /var/lib/mysql/xtrabackup_binlog_info
mysql-bin.000001 100
CHANGE MASTER TO MASTER_HOST='master_ip', MASTER_USER='repl2', MASTER_PASSWORD='new_slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=100;
START SLAVE;
skip-slave-start
server-id=3
Use sshfs or rsync to move data
du skip directory
du -sh --exclude=/home/some/data /home
ncdu -x /home --exclude /home/some/data
new-authz error: {“type”:”urn:acme:error:unauthorized”,”detail”:”Error creating new authz :: Validations for new domains are disabled in the V1 API (https://community.letsencrypt.org/t/end-of-life-plan-for-acmev1/88430)”,”status”: 403}
./acme.sh –upgrade
atop history
atop -r /var/log/atop/atop_20200606
t to go forward in 10 minute
T to go backward
dpkg file belongs to package
dpkg -S /usr/bin/ssh
dpkg list installed packages
dpkg-query -l | less
mysql /etc/init.d restart not working
/etc/init.d/mysql does not start mysqld at system start up on Ubuntu
grep debian-sys-maint /etc/mysql/debian.cnf
ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)
mysql> UPDATE mysql.user SET Password = password(‘password’) WHERE User = ‘debian-sys-maint’;
service mysql restart
linux find inode usage by directory
find / -xdev -printf '%h\n' | sort | uniq -c | sort -k 1 -n
lock run php
*/5 * * * * /usr/local/bin/lockrun --lockfile=/var/run/php.lockrun -- /usr/bin/php -f /usr/local/bin/run.php &> /dev/null
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