To me it really looks you are SSL replicating. In my experience If you are replicating in SSL either it works or not, I dont remember what should be there at "Master SSL Cipher", but I remember I had clear problems when SSL replication was not working.
Claudio 2010/11/10 Paul Nowosielski <[email protected]> > Hey can anyone tell me is my slave is utilizing SSL? > I am unsure why the Master SSL Cipher is not > listed under show slave status. > > Here's some info: > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Waiting for master to send event > Master_Host: host > Master_User: rep > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: mysql-bin.000038 > Read_Master_Log_Pos: 74709312 > Relay_Log_File: slave-relay.000577 > Relay_Log_Pos: 8579562 > Relay_Master_Log_File: mysql-bin.000038 > Slave_IO_Running: Yes > Slave_SQL_Running: Yes > Replicate_Do_DB: crm > 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: 74709312 > Relay_Log_Space: 8579562 > Until_Condition: None > Until_Log_File: > Until_Log_Pos: 0 > Master_SSL_Allowed: Yes > Master_SSL_CA_File: /etc/mysql/ssl/ca-cert.pem > Master_SSL_CA_Path: /etc/mysql/ssl/ > Master_SSL_Cert: /etc/mysql/ssl/client-cert.pem > Master_SSL_Cipher: > Master_SSL_Key: /etc/mysql/ssl/client-key.pem > Seconds_Behind_Master: 0 > 1 row in set (0.00 sec) > > mysql> SHOW VARIABLES LIKE 'have_ssl'; > +---------------+-------+ > | Variable_name | Value | > +---------------+-------+ > | have_ssl | YES | > +---------------+-------+ > 1 row in set (0.01 sec) > > > > mysql> SHOW STATUS LIKE 'Ssl_cipher'; > +---------------+--------------------+ > | Variable_name | Value | > +---------------+--------------------+ > | Ssl_cipher | DHE-RSA-AES256-SHA | > +---------------+--------------------+ > 1 row in set (0.00 sec) > > > > > > > Thank you, > > Paul > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[email protected] > > -- Claudio
