Not the answer you need?
Register and ask your own question!

how to sync master and slave tables

smith18smith18 EntrantCurrent User Role Beginner
Hello, I have a master and slave replication where the slave has read-only access and we are out of sync with one table in slave compared to master -- is there way i can sync master and slave so that slave will be updated? can we do that if we have read-only access to slave? say like table T1 is in master has 100 rows and table T1 slave has only 50 rows I want to sync master to slave so that slave T1 will also have 100 rows. -- any help would be appreciated -- table currently holds 2B rows and how much time would it take to get the process completed


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.