From: Paul Nowosielski
Date: November 10 2010 7:04pm
Subject: Slave using SSL?
List-Archive: http://lists.mysql.com/mysql/223561
Message-Id: <318081.91253.qm@web30403.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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.=0A=0AHere's some=
 info:=0A=0Amysql> 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)=0A=0Amysql>  SHOW VARIABLES LIKE 'have_ssl';=0A+---------------+-----=
--+=0A| Variable_name | Value |=0A+---------------+-------+=0A| have_ssl   =
   | YES   | =0A+---------------+-------+=0A1 row in set (0.01 sec)=0A=0A=
=0A=0Amysql> 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)=0A=0A=0A=0A=0A=0A=0AThan=
k you,=0A=0APaul=0A=0A=0A