dveeden@daniel-thinkpad:~/sandboxes/rsandbox_5_6_3$ ./start_all executing "start" on master .. sandbox server started executing "start" on slave 1 .. sandbox server started executing "start" on slave 2 .. sandbox server started dveeden@daniel-thinkpad:~/sandboxes/rsandbox_5_6_3$ ./m Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.3-m5-log MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. master [localhost] {msandbox} ((none)) > SHOW GRANTS FOR 'rsandbox'@'127.%'; +-------------------------------------------------------------------------------------------------------------------------------------+ | Grants for rsandbox@127.% | +-------------------------------------------------------------------------------------------------------------------------------------+ | GRANT REPLICATION SLAVE ON *.* TO 'rsandbox'@'127.%' IDENTIFIED BY PASSWORD '*B07EB15A2E7BD9620DAE47B194D5B9DBA14377AD' REQUIRE SSL | +-------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) master [localhost] {msandbox} ((none)) > \q Bye dveeden@daniel-thinkpad:~/sandboxes/rsandbox_5_6_3$ ./s1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.3-m5-log MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. slave1 [localhost] {msandbox} ((none)) > SHOW SLAVE STATUS \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 12228 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 114 Relay_Log_File: mysql_sandbox12229-relay-bin.000010 Relay_Log_Pos: 267 Relay_Master_Log_File: mysql-bin.000004 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: 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: 114 Relay_Log_Space: 596 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /home/dveeden/mysql/5.6.3/mysql-test/std_data/cacert.pem Master_SSL_CA_Path: Master_SSL_Cert: /home/dveeden/mysql/5.6.3/mysql-test/std_data/server-cert.pem Master_SSL_Cipher: Master_SSL_Key: /home/dveeden/mysql/5.6.3/mysql-test/std_data/server-key.pem Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: 67a4345b-7a37-11e0-8fd0-f0def1356547 Master_Info_File: /home/dveeden/sandboxes/rsandbox_5_6_3/node1/data/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 1 row in set (0.00 sec) slave1 [localhost] {msandbox} ((none)) > SHOW VARIABLES LIKE '%ssl%'; +---------------+---------------------------------------------------------------+ | Variable_name | Value | +---------------+---------------------------------------------------------------+ | have_openssl | YES | | have_ssl | YES | | ssl_ca | /home/dveeden/mysql/5.6.3/mysql-test/std_data/cacert.pem | | ssl_capath | | | ssl_cert | /home/dveeden/mysql/5.6.3/mysql-test/std_data/server-cert.pem | | ssl_cipher | | | ssl_key | /home/dveeden/mysql/5.6.3/mysql-test/std_data/server-key.pem | +---------------+---------------------------------------------------------------+ 7 rows in set (0.00 sec) slave1 [localhost] {msandbox} ((none)) > status -------------- /home/dveeden/opt/mysql/5.6.3/bin/mysql Ver 14.14 Distrib 5.6.3-m5, for Linux (x86_64) using readline 5.1 Connection id: 3 Current database: Current user: msandbox@localhost SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.6.3-m5-log MySQL Community Server (GPL) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /tmp/mysql_sandbox12229.sock Uptime: 1 min 3 sec Threads: 1 Questions: 7 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 44 Queries per second avg: 0.111 -------------- slave1 [localhost] {msandbox} ((none)) > SHOW STATUS LIKE 'Ssl%'; +--------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | DHE-RSA-AES256-SHA | | Ssl_cipher_list | DHE-RSA-AES256-SHA:AES256-SHA:DHE-RSA-AES128-SHA:AES128-SHA:AES256-RMD:AES128-RMD:DES-CBC3-RMD:DHE-RSA-AES256-RMD:DHE-RSA-AES128-RMD:DHE-RSA-DES-CBC3-RMD:RC4-SHA:RC4-MD5:DES-CBC3-SHA:DES-CBC-SHA:EDH-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC-SHA | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 500 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_server_not_after | Jan 28 11:56:49 2015 GMT | | Ssl_server_not_before | Jan 29 11:56:49 2010 GMT | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | Unknown | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | TLSv1 | +--------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 25 rows in set (0.00 sec) slave1 [localhost] {msandbox} ((none)) > \q Bye