Email : inbox [at] sysadmin.lk
Linkedin : https://www.linkedin.com/in/prabatht
Facebook : https://www.facebook.com/prabath.hinoize
Related Articles
Install and configure LSYNCD on Centos 7
Enviroment: – Server01.192.168.30.201 – Server02.192.168.30.202 – Directory to be Sync : “/opt/web/htdocs/prompt and /opt/vxml ” 2.Step Key based authentication Configuration -Login to Master server & generate the public and Private keys using the following command: [root@server01 ~]# ssh-keygen -t rsa [root@server01 ~]# ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.30.202 2.Step Installation Lsyncd [root@server01 ~]# yum install epel-release [root@server01 […]
Password less command line scripts with MySQL 5.6
I have a number of command line scripts that copy MySQL databases down from staging servers and store them locally. These scripts set the password on the command line using the -p option. With MySQL 5.6, a new warning is displayed every time my scripts run: Warning: Using a password on the command line interface […]
Purge binary logs in MySQL
Please do not just delete them in the OS. You need to let mysqld do that for you. Here is how mysqld manages it: The file mysql-bin.[index] keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.[index] are: PURGE BINARY LOGS TO […]