I am new to this forum, and relatively new to MySQL, but have been a DBA for over 15 years with other DB’s.
I am trying to setup servers for a new product, and we have limited time to do this, so not much time to experiment.
We want to have two masters running Percona 5.5 and a slave also running percona 5.5. We will set this up using MMM and this bit should be OK.
However, we have another legacy database that needs to be replicated into one of the masters, which is running MySQL 5.1, and I only want to replicate some of the tables.
What would be the best way to replicate this data? (Needs to be real time)
Oracle, MySQL, SQL Server, PostgreSQL and more!