AWS AmazonRDS documentation change
Summary
Added MySQL 8.4+ syntax updates for replication privileges and commands
Security assessment
Updates reflect MySQL version-specific syntax changes without introducing security features or addressing vulnerabilities.
Diff
diff --git a/AmazonRDS/latest/UserGuide/mysql-multi-source-replication.md b/AmazonRDS/latest/UserGuide/mysql-multi-source-replication.md index bbfc0b475..87c3168f9 100644 --- a//AmazonRDS/latest/UserGuide/mysql-multi-source-replication.md +++ b//AmazonRDS/latest/UserGuide/mysql-multi-source-replication.md @@ -49,0 +50,7 @@ Before you configure multi-source replication, complete the following prerequisi +###### Note + +Starting with MySQL 8.4, the `REPLICATION SLAVE` privilege has been deprecated and replaced with `REPLICATION REPLICA`. For MySQL 8.4 and later versions, use the following syntax instead: + + CREATE USER 'repl_user' IDENTIFIED BY 'password'; + GRANT REPLICATION CLIENT, REPLICATION REPLICA ON *.* TO 'repl_user'; + @@ -73,0 +81,4 @@ Before you import the data from a source to the multi-source replica, determine +###### Note + +Starting with MySQL 8.4, the `SHOW MASTER STATUS` command has been deprecated and replaced with `SHOW BINARY LOG STATUS`. For MySQL 8.4 and later versions, use `SHOW BINARY LOG STATUS` instead. + @@ -99 +110 @@ After copying the database, you can set the read-only parameter to `OFF` on the -For each source DB instance, use the master user credentials to connect to the instance, and run the following two stored procedures. These stored procedures configure replication on a channel and start replication. This example uses the binlog file name and position from the example output in the previous step. +For each source DB instance, use the administrative user credentials to connect to the instance, and run the following two stored procedures. These stored procedures configure replication on a channel and start replication. This example uses the binlog file name and position from the example output in the previous step.