MySQL Forums
Forum List  »  Replication

Replication - single vs multiple databases, many databases or many tables
Posted by: Sla Slaw
Date: January 29, 2019 02:00PM

Hello everyone,

I have some problems with replication on Mysql 5.6.27.

Is better to split all tables between multiple databases or better is to use the single database with a lot of tables inside (from replication perspective) or it doesn't matter?

For example will it help if I split my tables (+- 100 tables, some of them +- 50 mln records) between e.g. 5 databases or it doesn't matter?

also my master has a few cores and each one is used heavily (+- 80% resources is used on every core) but on Slave I have similar hardware but only 1 core is used (+-80%), the other ones are used in only 10%.

Many thanks for any advices Regards, S

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication - single vs multiple databases, many databases or many tables
603
January 29, 2019 02:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.