New answers tagged

2

There is absolutely no impact to the master's operations whether there is active replication or not, except of course for the load created by the replication process itself. To be 100% clear, the master's transactions do not depend on its replication and therefore will not perform differently. The only two actual risks of stopping the replication process ...


4

The problem is that the AWS RDS MySQL read-replica mechanism requires that the two schemas be exact. Replication, in general, requires this. But, if your definition of "close enough" is indeed close enough, this can be done in RDS for MySQL the same way you'd always do it. create a DB instance ... and SET it to be the replica. Well, that won't be ...


0

Here are the step by step instructions to reset the MySQL root password from their manual: Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges, and disables account-management statements such as ALTER USER and SET PASSWORD. Because this is ...


0

For the sake of this answer, you want to replicate database mydb STEP 01 : Add Replication Filter to my.cnf on ServerD [mysqld] replication-do-db=mydb STEP 02 : Stop Replication on ServerD mysql> STOP SLAVE; mysql> FLUSH TABLES; mysql> FLUSH LOGS; mysql> SET GLOBAL innodb_fast_shutdown = 0; STEP 03 : Restart MySQL on ServerD service mysql ...



Top 50 recent answers are included