Some times process list out put show negative value like bellow : Command : watch /usr/local/mysql/bin/mysqladmin -ppass processlist 8 | system user | | Connect | -1247 | Has read all relay log; waiting for the slave I/O thread to update it | One of the reason : make sure both Server has same time [...]
Archive for June 9th, 2010
Mysql Server processlist shows negative value(-) in connect column for system user
Wednesday, June 9th, 2010How To Set Up MySQL Database Replication With SSL Encryption
Wednesday, June 9th, 2010Step1 : Set up normal replication first and find out if mysql server is compiled with ssl supports Ref:http://www.fosiul.com/index.php/2009/11/mysql-server-master-master-active-active-replication/ Bellow commands will verify if mysql server is compiled with ssl supports SHOW VARIABLES LIKE ‘have_openssl’; output : Step2 : in Server1 : (a)Create Self signed certificate . Note : While Creating self signed certificate use [...]