使awsmysql主从_AWSRDSMySQL双活

是的&＃xff0c;可以在RDS MySql Engine中进行Master-Master复制。但它需要一些操作与实例。先决条件&＃xff1a;1)为启用二进制日志记录创建两个实例的只读副本。2)如果不需要&＃xff0c;删除它们的只读副本。3)按照下面提到的主从设置说明进行操作。

在Master1上创建复制用户

grant replication slave on *.* to &＃39;admin&＃39;&＃64;&＃39;%&＃39; identified by &＃39;admin&＃39;;

Query OK, 0 rows affected (0.00 sec)

请注意以下命令的输出

show server status

; &＃43; ---------------------------- &＃43; ---------- &＃43; --------- ----- &＃43; ------------------ &＃43; ------------------- &＃43; | 文件| 位置| Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | &＃43; ---------------------------- &＃43; ---------- &＃43; --------- ----- &＃43; ------------------ &＃43; ------------------- &＃43; | mysql-bin-changelog.000007 |120 | | | | &＃43; ---------------------------- &＃43; ---------- &＃43; --------- ----- &＃43; ------------------ &＃43; ------------------- &＃43; 1 row in set( 0.00秒)

在Master2上

mysql> call mysql.rds_set_external_master(&＃39;master1.endpoint.amazonaws.com&＃39;,3306,&＃39;admin&＃39;,&＃39;admin&＃39;,&＃39;**mysql-bin-changelog.000007**&＃39;,**120**,0);

Query OK, 0 rows affected (0.05 sec)

mysql> call mysql.rds_start_replication;

&＃43;-------------------------&＃43;

| Message |

&＃43;-------------------------&＃43;

| Slave running normally. |

&＃43;-------------------------&＃43;

1 row in set (1.01 sec)

mysql -u admin123 -padmin123 -h master2.endpoint.amazonaws.com -e "show slave status\G;" | grep Running

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it

&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61; &＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;

在Master2上

grant replication slave on *.* to &＃39;admin&＃39;&＃64;&＃39;%&＃39; identified by &＃39;admin&＃39;;

Query OK, 0 rows affected (0.00 sec)

show master status;

&＃43;----------------------------&＃43;----------&＃43;--------------&＃43;------------------&＃43;-------------------&＃43;

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

&＃43;----------------------------&＃43;----------&＃43;--------------&＃43;------------------&＃43;-------------------&＃43;

| **mysql-bin-changelog.000007** | **120** |

| | | &＃43;----------------------------&＃43;----------&＃43;--------------&＃43;------------------&＃43;-------------------&＃43; 1 row in set (0.00 sec)

在Master1上

mysql> call mysql.rds_set_external_master(&＃39;master2.endpoint.amazonaws.com&＃39;,3306,&＃39;admin&＃39;,&＃39;admin&＃39;,&＃39;**mysql-bin-changelog.000007**&＃39;,**120**,0);

Query OK, 0 rows affected (0.05 sec)

mysql> call mysql.rds_start_replication; &＃43;-------------------------&＃43; | Message | &＃43;-------------------------&＃43; | Slave running normally. | &＃43;-------------------------&＃43; 1 row in set (1.01 sec)

mysql -u admin123 -padmin123 -h master1.endpoint.amazonaws.com -e "show slave status\G;" | grep Running

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it