I manage a MySQL server hosting over 100 databases.
We have set up standard master-slave replication, but the SQL Thread tends to break every so often, and requires manual intervention to re-start it. During this time the servers get out of sync.
I know that there is an option to specify which databases are/not replicated.
Is it possible to set up multiple instances of the replication thread (ideally one per database), so that if the replication breaks (and stops) on one thread, it does not stop the replication on all the rest?