MySQL Forums
Forum List  »  Replication

MySQL 8.0 master standby replication
Posted by: Kaushal Shriyan
Date: May 05, 2023 04:39AM

Hi,

I am setting up MySQL 8.0.31 DB Master and Standby replication on two separate servers. How do I replicate the existing Database which is already present on the Master MySQL DB server?

For example,

Master MySQL DB server

mysql> show databases;
applicationproddb
mysql
testdb
mysql>

MySQL Master Standby Replication is configured.

mysql> create database testproddb;
mysql> show databases;
applicationproddb
mysql
testdb
testproddb
mysql>

Standby MySQL DB server
mysql>
testproddb
mysql>


When I create any database in Master it gets replicated to slave but the existing database, for example, the existing database applicationproddb is not getting replicated.

Please guide.

Thanks in advance.

Best Regards,

Kaushal

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0 master standby replication
327
May 05, 2023 04:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.