# Synchronization between branches and Main Servers **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [October 10, 2018, 1:23am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620 "2018-10-10T01:23:03Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![martin.jackson](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@martin.jackson](https://forums.percona.com/u/martin.jackson)\ **Post date:** [October 10, 2018, 1:23am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/1 "2018-10-10T01:23:03Z")
Hi Support We are provisioning a multi branch infrastructure for our online and offline business.Offline business must always be available with local database of customer information and activities.offline(branches) and online business(data centers) are connected with an adsl connection -so not always reliable:This means we may have frequent disconnection- also avoiding static IP for branches is more preferable. I’ve attached a picture of problem. [LIST=1] [_]I want to know what is the best option for branch and data center synchronization in percona? [_]What is the best option for synchronization between data centers in different locations? and percona servers in data center themselves? [/LIST] I’ll appreciate all recommendations. ![photoid=52607](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/e579b429c387219df300850ecdca92f590d05901.jpeg) ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 10, 2018, 4:52am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/2 "2018-10-10T04:52:51Z")
Hello Martin, welcome to the Percona community forum. 🙂 So, first of all I need to check with you that you’re not a customer of Percona i.e. you don’t have a contract with us? Support is handled separately from the open source forum (which is where we are right now). Also, to clarify that the Forum isn’t “support” in the traditional sense. We welcome community (non-Percona) dialogue here and there’s no guarantee that you will always get a full answer. Certainly, though the Percona engineers do their best, anything that is particular to a given implementation and would require in-depth investigation of an issue won’t be addressed via the Forum. By definition the answers here have to be generic. SO… onto your question. This is one of those cases where the answers lie perilously close to consultancy, and I doubt you’ll get a full answer here though you might get some useful pointers. If you’re a customer, you can, of course, contact Percona via your Customer Success team. If not, but you’re interested in our professional services, then let me know and I’ll get someone to reach out. Meanwhile… I’ll do some research and see if there are any blog posts or resources such as webinars that could help you with this. Will be back soon! ---
**Author:** ![martin.jackson](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@martin.jackson](https://forums.percona.com/u/martin.jackson)\ **Post date:** [October 10, 2018, 7:14am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/3 "2018-10-10T07:14:45Z")
Hi Lorraine Thanks for your reply. I don’t want a comprehensive reply. I am here to research and report to my manager about Percona’s Solution to our problem.If I found any solution, I’ll provide him a report of initial and ongoing costs.If agreed we’ll be able to have a customer contract with you and benefit full consultancy. Regards ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 10, 2018, 7:30am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/4 "2018-10-10T07:30:12Z")
Hey no, that’s great. Not everyone understands the scope - I didn’t want you to be disappointed.🙂 Let me see what I can find that might help your research. ---
**Author:** ![martin.jackson](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@martin.jackson](https://forums.percona.com/u/martin.jackson)\ **Post date:** [October 10, 2018, 10:15am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/5 "2018-10-10T10:15:29Z")
Thanks for your understanding 🙂 ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 10, 2018, 11:11am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/6 "2018-10-10T11:11:39Z")
I’ll update with some info tomorrow, I just want to dig around a little… ---
**Author:** ![martin.jackson](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@martin.jackson](https://forums.percona.com/u/martin.jackson)\ **Post date:** [October 13, 2018, 1:26am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/7 "2018-10-13T01:26:42Z")
Hi Lorraine, Is there any new update? ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 15, 2018, 5:28am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/8 "2018-10-15T05:28:02Z")
Apologies, Martin! Here are a few links that might help in your research. These articles give some good summary information about replication options. [url][https://www.percona.com/blog/2017/06/20/the-mysql-high-availability-landscape-in-2017-the-elders/[/url]](https://www.percona.com/blog/2017/06/20/the-mysql-high-availability-landscape-in-2017-the-elders/%5B/url%5D) [url][https://www.percona.com/blog/2017/08/22/mysql-high-availability-landscape-2017-adults/[/url]](https://www.percona.com/blog/2017/08/22/mysql-high-availability-landscape-2017-adults/%5B/url%5D) [url][https://www.percona.com/blog/2017/09/15/the-mysql-high-availability-landscape-in-2017-the-babies/[/url]](https://www.percona.com/blog/2017/09/15/the-mysql-high-availability-landscape-in-2017-the-babies/%5B/url%5D) This article talks about multi-master replication [url][https://www.percona.com/blog/2012/01/19/percona-xtradb-cluster-feature-2-multi-master-replication/[/url]](https://www.percona.com/blog/2012/01/19/percona-xtradb-cluster-feature-2-multi-master-replication/%5B/url%5D) This one looks at multi-source replication [url][https://www.percona.com/blog/2018/03/30/multi-source-replication-performance-with-gtid/[/url]](https://www.percona.com/blog/2018/03/30/multi-source-replication-performance-with-gtid/%5B/url%5D) And another: [url][https://www.percona.com/blog/2018/03/13/the-multi-source-gtid-replication-maze/[/url]](https://www.percona.com/blog/2018/03/13/the-multi-source-gtid-replication-maze/%5B/url%5D) There should be some pointers to documentation in those blog posts. In addition, you might want to take a look at a couple of our webinars: [url][https://www.percona.com/webinars/hazards-multi-writing-dual-master-setup[/url]](https://www.percona.com/webinars/hazards-multi-writing-dual-master-setup%5B/url%5D) (note that this one is old and might have been superseded, but nevertheless will probably give you some good questions to answer) [url][Upcoming Webinars](https://www.percona.com/resources/webinars/percona-xtradb-cluster-pxc-101%5B/url%5D) - an introduction to Percona XtraDB Cluster Here’s a couple of solution briefs that are aimed at the decision maker: [url][Solution Brief](https://www.percona.com/resources/solution-brief/always-online-critical-website-percona-xtradb-cluster%5B/url%5D) [url][Solution Brief](https://www.percona.com/resources/solution-brief/never-lose-mysql-data-percona-xtradb-cluster-aws-ec2-environment%5B/url%5D) If you digest those, hopefully you’ll be able to pinpoint the kind of architecture that you want to support and from there you might find other searches on our blog and forum. ---
**Author:** ![martin.jackson](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@martin.jackson](https://forums.percona.com/u/martin.jackson)\ **Post date:** [October 18, 2018, 2:03pm UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/9 "2018-10-18T14:03:17Z")
Thanks Lorraine, what I got from those is that it is better to use percona xtradb cluster with galera for inside of data centers. between data centers , we can use galera but it will increase point of failure and transaction time?!(if one of nodes was faulty, synchronized transactions won’t work?! Between branches and datacenter we must use an async solution like master-master replication, but it seems that master-master replication is depreciated in favor of group replication?! another question is if is it possible to setup replication for table or tables instead of whole database? ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [October 19, 2018, 5:58am UTC](https://forums.percona.com/t/synchronization-between-branches-and-main-servers/6620/10 "2018-10-19T05:58:45Z")
Hi Martin, glad those helped. The cluster solutions aren’t designed for geographically dispersed implementations, it’s true, since the network would have a big impact on their ability to function. You’ve already mentioned that you have network challenges. So, depending on your set up these are quite in-depth discussions that are specific to your application and it might be that it’s pretty much out of scope for this Forum: an answer to something like this is inevitably “it depends”. There may be other good solutions for your circumstance. Again, if you’d like to discuss what we can offer professionally, let me know, not a problem. Meanwhile, that said, someone could perhaps answer about tables vs databases, master-master vs group etc. I will see if I can find someone.