Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

Question

MySql Master/Slave replication

Posted April 20, 2021 176 views
Databases

Hi, is it possible to replicate only selected tables with MySql Master/Slave replication?

Add a comment
Raptortech
By:
Raptortech

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
KFSys April 20, 2021

Hi @marcoSnorkler,

As the master-slave replication is a one-way replication (from master to slave), only the master database is used for the write operations, while read operations may be spread on multiple slave databases.

With the above said, I don’t think it’s possible to replicate only selected tables, only databases. Having said that, I don’t think it would be a good idea to replicate only selected tables as well but I don’t know the whole situation.

If you do find a way to do so, please do let me know I’ll be interested to check it out!

Reply Report

Related

Looking for something else?

Ask a new question Search for more help