Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Replicate a single table

Is it possible to replicate a single table?

like image 593
shantanuo Avatar asked Jun 03 '10 01:06

shantanuo


2 Answers

Yes this is possible. Have a look at the slave options of the MySQL manual. This still requires to create a complete binlog of the whole database though.

like image 88
halfdan Avatar answered Nov 03 '22 18:11

halfdan


To sync specific tables again to one or more slaves rather use pt-table-checksum and then pt-table-sync

That should automatically identify the out-of-sync tables and only sync those.

like image 45
Rainer Stumbaum Avatar answered Nov 03 '22 19:11

Rainer Stumbaum