We need to replicate a set of tables from one database to another database. I am going for multi master replication. When I tried adding these tables to master site, it took 3 days to complete. I tried to tune it by checking wait events. But, they looked fine. What I could find out is that only one table is getting added at a time. Is there a way by which I can add more than one table at the same time?
I am also looking out for using export/import for adding tables at other master sites. But, I am not sure about the firther steps to enable the propogation. Can anybody provide me with high level steps for multimaster replication using export/import?
I am trying to read this advanced replication document. It keeps going on. I would appreciate if somebody can chip in with their experience too.