Galera Case Study: Managing synchronous replication of MySQL across data centers
Sphinx Information Technologies Inc. is a global network solutions and hosting provider with presence and hosting facilities in Canada, the US and Egypt.
One of Sphinx’s clients is a global leader in providing Compliance Management Solutions to help customers streamline contractor and supplier management and supply chain processes. Their solutions automate the collection and monitoring of relevant data for specific job sites and regions, and provide that data to decision makers as actionable intelligence. Over 50,000 companies rely on their systems to securely exchange private business compliance data.
Looking for a global hosting solution to cover their worldwide customer base, the client contracted Sphinx to research, design, implement and host their solution wordwide.
After extensive research, it was decided that Galera is the best solution for the data availability.
In this talk, we will explore:
* the new system architecture
* load balancing in a multi-site configuration
* how they migrated to the new solution
* lack of skills in Galera clustering
* problems encountered and how they were resolved