Easy question. Not super familar with mysql yet but can't figure out how to debug a setup of two mysql instance with ssl replication. It works randomly and all the basic commands show that it working. Have the info below and of cource I can connect to both boxes from each other, the firewall is open to 3306 on each machine and etc. Have tested this but status windows show it working but when I manually change something in mysqlworkbench sometimes I see the change being replicated and then sometimes after say a reboot, with insuring that the slave is started through mysqladmin, it just stops working when I am testing it. My question is I can't seem to figure out what logs would show me what is happening between these two servers. Need to figure out if the ssl is doing its handshack and the slave is connection to the *.bin files to see what has changes and etc. Any help on how I can debug would be greatly appreciated. current slave status *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: server.seersoft.co Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000018 Read_Master_Log_Pos: 106 Relay_Log_File: mysqld-relay-bin.000042 Relay_Log_Pos: 251 Relay_Master_Log_File: mysql-bin.000018 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: test,test_gui,test_gui_copy Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 106 Relay_Log_Space: 552 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /etc/mysql/newcerts/ca-cert.pem Master_SSL_CA_Path: Master_SSL_Cert: /etc/mysql/newcerts/client-cert.pem Master_SSL_Cipher: Master_SSL_Key: /etc/mysql/newcerts/client-key.pem Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) current master staus *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: server.seersoft.co Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000018 Read_Master_Log_Pos: 106 Relay_Log_File: mysqld-relay-bin.000042 Relay_Log_Pos: 251 Relay_Master_Log_File: mysql-bin.000018 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: test,test_gui,test_gui_copy Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 106 Relay_Log_Space: 552 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /etc/mysql/newcerts/ca-cert.pem Master_SSL_CA_Path: Master_SSL_Cert: /etc/mysql/newcerts/client-cert.pem Master_SSL_Cipher: Master_SSL_Key: /etc/mysql/newcerts/client-key.pem Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) All looks good, especially the slave IO and SQL yes yes and the position and bin number match. Should work.
