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

Multi-source replication and PRM

niksav77niksav77 EntrantCurrent User Role Beginner
Hi all,

We have classifieds web app which uses Percona for MySQL in master-master setup, with several slave servers. To maintain HA, mmm tool is used at moment.

Database is getting bigger and we would like to separate groups of functionally related tables to their own MySQL clusters (eg. messages, logs). For messaging part to work, we need some tables from main database (eg. users). This is why we looked into multi-source replication, since every cluster would have own master-master setup with slave servers, but also have replication channel to main DB cluster. Do you think this is possible?

If this kind of setup is possible using multi-source replication, we need to look into HA setup. As far as I know, mmm is not able to support mysql clusters with multi-source replication. It's also old tool, so we would like to replace it with somethign newer and better. We're looking into PRM. Can PRM be used to maintain mysql servers/clusters connected using multi-source replication, while maintaining master-master setup in every individual cluster?

Thank you in advance for help!

Best Regards,
Nikola

Comments

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.