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
> 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.38
>Read_Master_Log_Pos: 74709312
> Relay_Log_File: slave-relay.000577
> Relay_Log_Pos: 8579562
> Relay_Master_Log_File: mysql-bin.38
> 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/mysql?unsub=claudio.na...@gmail.com
>
>
--
Claudio
