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

Have subset of data/fields replicated on slave

niksav77niksav77 EntrantCurrent User Role Beginner
Hi all,

We have database with several big tables which are core of our system. Everyhing is in one DB at moment, which I'll call Core DB. We're working on separating messaging subsystem to separate Msg DB, which will be connected to Core DB using replication. On Msg DB we would need to have some data from one of biggest tables in Core DB. That means that in Msg DB, from that big table, we would need to have only some fields and only records that satisfy certain conditions.

Standard replication doesn't support this scenario.

Does anyone have any experience and suggestion on how to implement this?

Thank you in advance!
Regards,
Nikola
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.