0

I'm planning to use MariaDB Cluster, as a way to sync several databases from different peripherals (raspberry pis). The peripherals don't share data, but all data should be shared with the main server.

Is there a way to keep the same database, but create a cluster with 2 nodes for each schema ?

Thanks

1

If the Pis are the source of the data, use "multi-source" replication from them to MariaDB.

Then have 3 nodes for the cluster (2 is mostly useless), and have all the data for both databases on all the nodes.

Or, more simply, the 2 Pis replicate to a single Master (no cluster).

  • Thank you,I searched for multi-source it seems to be what i need. Can multi-source replication work if the Pis don't have a public IP so a one way connection ? – Dany Y Sep 12 at 9:18
  • 1
    @DanyY - The Slave (non-Pi) connects to the Masters (Pis), so you may need to build an ssh bridge. – Rick James Sep 12 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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