0

I currently have two 3 node mariadb (10.5.9) Galera clusters set up in different locations, I'm using standard replication to copy data between the primary and secondary.

What I've recently noticed is that while the slave node in the secondary location gets all of the data, it appears to be omitting things like the creation of new databases.

For example the slave node would have 100 db's while the other 2 nodes in the same galera cluster would have 85

Has anyone else experienced similar is there a setting or configuration i'm missing?

Improve this question
4
  • 1
    Check permissions.
    – Rick James
    Nov 20 at 2:06
  • If using replication filtering, read the docs very carefully. database include/excludes aren't as obvious as the configuration options make them seem. Also are you using log-slave-updates on the Galera async master node to replication between Galera and its Async master. Are server-ids unique?
    – danblack
    Nov 20 at 5:58
  • RickJames - permissioning doesn't appear to be an issue @danblack - I'm not currently using replication filtering, server id's are unique and we do have log-slave-updates enabled.
    – imbrian21
    Nov 20 at 19:37
  • Check if there are no replication filters set up that might be excluding certain databases from being replicated. Replication filters could be set up in your configuration file with settings like replicate-ignore-db or replicate-do-db.
    – TSCAmerica.com
    Nov 23 at 14:29

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.