MySQL 8.0 master standby replication
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
Subject
Views
Written By
Posted
MySQL 8.0 master standby replication
35
May 05, 2023 04:39AM
Sorry, only registered users may post in this forum.
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.