mysql加密复制_MySQL/MariaDB数据库的复制加密

[root@node103.yinzhengjie.org.cn ~]# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connectionid is 2Server version:5.5.64-MariaDB MariaDB Server

Copyright (c)2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type'help;' or '\h' for help. Type '\c' to clearthe current input statement.

MariaDB [(none)]>MariaDB [(none)]>CHANGE MASTER TO-> MASTER_HOST='172.30.1.102',-> MASTER_USER='sslcopy',-> MASTER_PASSWORD='yinzhengjie',-> MASTER_LOG_FILE='master-102.000003',-> MASTER_LOG_POS=416,　　　　#注意，以下4项可以不配置,但是得在"/etc/my.cnf"配置文件中写上相应的信息,具体的格式可参考master节点的配置文件。-> MASTER_SSL=1,-> MASTER_SSL_CA = '/etc/my.cnf.d/ssl/cacert.pem',-> MASTER_SSL_CERT = '/etc/my.cnf.d/ssl/slave.crt',-> MASTER_SSL_KEY = '/etc/my.cnf.d/ssl/slave.key';

Query OK,0 rows affected (0.01sec)

MariaDB [(none)]>MariaDB [(none)]>SHOW SLAVE STATUS\G*************************** 1. row ***************************Slave_IO_State:

Master_Host:172.30.1.102Master_User: sslcopy

Master_Port:3306Connect_Retry:60Master_Log_File: master-102.000003Read_Master_Log_Pos:416Relay_Log_File: relay-log-103.000001Relay_Log_Pos:4Relay_Master_Log_File: master-102.000003Slave_IO_Running: No

Slave_SQL_Running: No

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno:0Last_Error:

Skip_Counter:0Exec_Master_Log_Pos:416Relay_Log_Space:245Until_Condition: None

Until_Log_File:

Until_Log_Pos:0Master_SSL_Allowed: Yes

Master_SSL_CA_File:/etc/my.cnf.d/ssl/cacert.pem

Master_SSL_CA_Path:

Master_SSL_Cert:/etc/my.cnf.d/ssl/slave.crt

Master_SSL_Cipher:

Master_SSL_Key:/etc/my.cnf.d/ssl/slave.key

Seconds_Behind_Master: NULL

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno:0Last_IO_Error:

Last_SQL_Errno:0Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id:0

1 row in set (0.00sec)

MariaDB [(none)]>MariaDB [(none)]>START SLAVE;

Query OK,0 rows affected (0.00sec)

MariaDB [(none)]>MariaDB [(none)]>SHOW SLAVE STATUS\G*************************** 1. row ***************************Slave_IO_State: Waitingformaster to send event

Master_Host:172.30.1.102Master_User: sslcopy

Master_Port:3306Connect_Retry:60Master_Log_File: master-102.000003Read_Master_Log_Pos:416Relay_Log_File: relay-log-103.000002Relay_Log_Pos:530Relay_Master_Log_File: master-102.000003Slave_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:0Last_Error:

Skip_Counter:0Exec_Master_Log_Pos:416Relay_Log_Space:822Until_Condition: None

Until_Log_File:

Until_Log_Pos:0Master_SSL_Allowed: Yes

Master_SSL_CA_File:/etc/my.cnf.d/ssl/cacert.pem

Master_SSL_CA_Path:

Master_SSL_Cert:/etc/my.cnf.d/ssl/slave.crt

Master_SSL_Cipher:

Master_SSL_Key:/etc/my.cnf.d/ssl/slave.key

Seconds_Behind_Master:0Master_SSL_Verify_Server_Cert: No

Last_IO_Errno:0Last_IO_Error:

Last_SQL_Errno:0Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id:102

1 row in set (0.00sec)

MariaDB [(none)]>