0

In other words; I'm trying to figure out how to restore multiple mariabackup dumps to one server (different databases). I assume I'm missing something obvious in the documentation, but I've been looking for months with no luck.

I have a number of different databases (different schema names) on a number of different servers. I would like to have all these databases replicated to one server, for various reasons. All the databases have replication set up and working already (each have one master and several replicas), that's no issue. It's "just" the part where I want to add an extra server, which should replicate all schemas, that's causing me headache.

I know how to create such a replica by using mysqldump and importing each db individually. But in this case, all databases are far too large for mysqldump, so I (believe I) need to use mariabackup. But I simply can't figure out how to import multiple dumps into one server instance.

Again; I'm sure I'm missing something obvious. Any hint will be greatly appreciated :)

I know it's not that simple, but all I want for christmas is the ability to set up a blank server, and tell it to "replicate this schema from that server", after which the server should "just" stream the entire database from the other server - redis style :P

Improve this question
1
  • Please, could you include details in your question about how you have tried to restore from multiple mariabackups to a single mariadb server, and any error messages you have encountered?
    – dbdemon
    Commented Dec 9, 2021 at 12:15

1 Answer 1

Reset to default
0

If you want an actual replication solution for this, then you can use multi-source replication. See the MariaDB documentation and this MariaDB blog article for details and examples.

As for using mariabackup as part of this, I suppose it could make sense for the initial provisioning of the server. I don't have experience with restoring multiple such backups to one MariaDB server, but I think it can be done. You may want to perform partial mariabackups of the source databases (so you exclude the system schemas/tables), and then restoring can possibly be done one backup at a time, either with mariabackup's --copy-back option or by manually copying the table files.

You probably don't want to use mariabackup as a full-time replication solution, amongst other reasons because it does briefly lock your database while the backup is running.

Improve this answer
2
  • Apologies for the guesswork and lack of detail in this answer. Hopefully, someone else with more experience can give a better answer, just thought a poor answer would be better than no answer.
    – dbdemon
    Commented Dec 9, 2021 at 11:08
  • Thank you for the answer. I just use Mariabackup for backups (from replicas, to avoid blocking master). And for occasionally setting up a new replica. The multi-source replication I'm familiar with (this is definitely the last time I don't set this kind of "collection" server up when starting a new project), it's just been the "getting the initial data in there" part that's messing me up here. I'll have another look at partial backups, though I've never actually gotten those to work before. But thank you for pointing me in a direction :)
    – Vonsild
    Commented Dec 9, 2021 at 11:56

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.