Hi everyone. I need some help designing the infrastructure for deploying a large scale Sugar installation. The company I work for is a financial institution that has users across the globe. We will have initially 400 users, but most probably this number will increase. Most of these users are based in Europe in a single location. As we expand in Asia, we need to keep another installation in our datacenter there for our users there. Ideally we will need to synchronize the two database installations with a master-master configuration. We were thinking of a single installation in Europe but ping times from Asia are way to high so we are going with 2 installations (one in Europe and one in Asia). Both installations need to have a fall back in case of one installation going offline.
Initially we were thinking of having 4 Oracle installations (2 on each datacenter, live and backup in each location). The cost however for licensing Oracle for such scenario is massive. So we were thinking of going with MySQL. Our problem is that we have never used MySQL for remote replication and we wanted to know if anyone has experience in setting up Sugar in similar cases (and MySQL for that matter). The requirement is that there should be 4 installations: 2 datacenters, 2 installations in each datacenter (one live and one backup). Sugar response times should be kept to minimum.
Any help would be greatly appreciated!