Hello,

I am trying to setup a cluster of 3 servers in 3 different locations; Dallas-US, London-UK, Mumbai-India. On each location I have setup a webserver and db server. On db server I have configured Galera Mariadb Multi-Master cluster to replicate db among all three servers. My each webservers are connected with local IP to their regional db server. I am expecting that my Dallas webserver will fetch db records from Dallas db server only; London webserver from London db server only and Mumbai webserver from Mumbai db server only. So I am having this setup

Dallas: 1 Webserver, 1 db server connected to webserver with local IP

London: 1 Webserver, 1 db server connected to webserver with local IP

Mumbai: 1 Webserver, 1 db server connected to webserver with local IP

Everything is working well but I have found that mysql query takes much time above 200ms while fetching record. I have tried Mariadb with single instance and its fetching data within 5s.

What am I doing wrong? Is it possible to setup something like this where every db server will geo-replicate its data but every webserver will fetch data only from its local db server?

Regards,
Zishan Javaid

Disclaimer: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.