From: Claudio Nanni
Date: November 10 2010 7:11pm
Subject: Re: Slave using SSL?
List-Archive: http://lists.mysql.com/mysql/223562
Message-Id: <AANLkTimQJwNe--iQdo-DY-NDN6bdmi+ugQp1Mnc-ScwN@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf301d3ec8fa2d5b0494b79eb7

--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 <paulnowosielski@stripped>

> 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@stripped
>
>


-- 
Claudio

--20cf301d3ec8fa2d5b0494b79eb7--