Galera Case Study: Managing synchronous replication of MySQL across data centers

Best Practices for Businesses
25 April 3:00pm - 3:50pm @ Ballroom B

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


Johan Andersson
CTO, Severalnines
Johan is CTO at Severalnines, a company that enables developers to easily deploy, manage, monitor and scale highly-available MySQL clusters in the data center, in hosted environments and on the cloud. Prior to Severalnines, Johan worked at MySQL/Sun/Oracle and was the Principal Consultant and lead of the MySQL Clustering and High Availability consulting group, where he designed and implemented large-scale MySQL systems at key customers.
Ibrahim Hamouda
CEO, Sphinx Information Technologies Inc.
Ibrahim applies his combined expertise in software development, network support and business development to lead the operations of Sphinx InfoTech services and solutions. A leader in providing networked solutions since the earliest days of commercial Internet service, Ibrahim has launched several successful Canadian technology businesses, including one of Calgary’s most successful independent Internet Service Provider. His international experience allows him to draw upon diverse technical expertise for any project or client from a global network of highly-skilled technologists and engineers. Ibrahim has been a Microsoft Certified Professional since 1998, and is also a leading edge developer of Linux-based enterprise software. He has engineered complete Linux systems for office, distribution and VOIP telephone services. He has experience working with numerous mini and mainframe operating systems and developing custom code for groupware applications such as Lotus Notes and ACT! Ibrahim Hamouda earned his B.Sc. in Mechanical Production Engineering from Ain Shams University in Cairo.