Cluster configuration/ setup

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

After some time I have now managed to get a working cluster in a test-enviroment and want to proceed. But have a little question regarding the setup.

I have our Main office, 3 regional sites.

I had hoped that I could have 1 server in our Main site, and each site connected to this server. I have 2 servers on each site so they can continue operations in case of WAN disconnect.

What I discovered is that, each site is also trying to replicate to the other sites (which makes sense, but not what I wanted)
I want each site to replicate only to the main site. Is this not possible? Do I have to create a server on the main site for each sub site we have or is possible to run several clusters on a single Main-server?
(the subsites are configured to contact MainSite and local site only in mysql.conf, but the main server have all site servers listed in gcomm://)

1 Like
2

Percona XtraDB Cluster is exactly that, a cluster. Which means all nodes will accept writes and all nodes will synchronously replicate all transactions to every other node.

It sounds like what you want is to use is MySQL’s asynchronous replication and create a ‘fan-in’ topology. Something like this?

1 Like
3

Thanks for replying and yes it is very close. But I also need to write to the database on Host 4 on the illustration.

So I might have to create a server for each site I have, when I want this configuration.

1 Like
4

As long as you are writing to different logical databases, you can write to all at any time.

1 Like