I have MySQL 5.6.27 and some problems with replication (huge delay between master and slave). I have a Master instance with 10 cores and Slave instance with the same hardware. My Master uses all resources heavily (all cores, 80% from each one) but Slave only 1 core (80% from one core and maybe 5% or less from the other ones) and my replication is very delayed.
Is better to split all tables between many databases on the same instance or is better to keep all tables in the same DB and instance or it doesn’t matter from replication point of view? For example is better to have 100 tables in 10 databases (the same MySQL instance) or 100 tables in 1 database (the same instance)?
all the best