Slave using SSL?

Hey can anyone tell me is my slave is utilizing SSL?=0AI am unsure why the =
Master SSL Cipher is not=0Alisted under show slave status. Here's some=
info: mysql> show slave status\G=0A*************************** 1. row=
***************************=0A Slave_IO_State: Waiting for mas=
ter to send event=0A Master_Host: host=0A Mas=
ter_User: rep=0A Master_Port: 3306=0A Connect_R=
etry: 60=0A Master_Log_File: mysql-bin.000038=0A Read_Mas=
ter_Log_Pos: 74709312=0A Relay_Log_File: slave-relay.000577=0A =
Relay_Log_Pos: 8579562=0A Relay_Master_Log_File: mysql-bi=
n.000038=0A Slave_IO_Running: Yes=0A Slave_SQL_Running: =
Yes=0A Replicate_Do_DB: crm=0A Replicate_Ignore_DB: =0A =
Replicate_Do_Table: =0A Replicate_Ignore_Table: =0A Replicate=
_Wild_Do_Table: =0AReplicate_Wild_Ignore_Table: =0A Last_Er=
rno: 0=0A Last_Error: =0A Skip_Counter: 0=0A =
Exec_Master_Log_Pos: 74709312=0A Relay_Log_Space: 8579562=
=0A Until_Condition: None=0A Until_Log_File: =0A =
Until_Log_Pos: 0=0A Master_SSL_Allowed: Yes=0A Ma=
ster_SSL_CA_File: /etc/mysql/ssl/ca-cert.pem=0A Master_SSL_CA_Path:=
/etc/mysql/ssl/=0A Master_SSL_Cert: /etc/mysql/ssl/client-cert.=
pem=0A Master_SSL_Cipher: =0A Master_SSL_Key: /etc/mys=
ql/ssl/client-key.pem=0A Seconds_Behind_Master: 0=0A1 row in set (0.00=
sec) mysql> SHOW VARIABLES LIKE 'have_ssl';=0A+---------------+-----=
--+=0A| Variable_name | Value |=0A+---------------+-------+=0A| have_ssl =
| YES | =0A+---------------+-------+=0A1 row in set (0.01 sec) =
mysql> SHOW STATUS LIKE 'Ssl_cipher';=0A+---------------+------------=
--------+=0A| Variable_name | Value |=0A+---------------+-----=
---------------+=0A| Ssl_cipher | DHE-RSA-AES256-SHA | =0A+-------------=
--+--------------------+=0A1 row in set (0.00 sec) =0AThan=
k you, Paul =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Slave using SSL?

--20cf301d3ec8fa2d5b0494b79eb7
Content-Type: text/plain; charset=ISO-8859-1

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.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/mysql?unsub=claudio.nanni@gmail.com
>
>


--
Claudio

--20cf301d3ec8fa2d5b0494b79eb7--