Synchronous Replication Use Cases

Galera is groundbreaking new replication technology powering clustering solutions like Percona XtraDB Cluster. Galera gives you synchronous replication, which is a powerful tool changing the rules in the game when designing HA application stacks. With synchronous replication all database nodes can be treated equally and this simplifies the HA architecture remarkably - the complexity is boxed in cluster implementation.

But, how to make best use of synchronous replication? This presentation will answer questions,like:
How to organize the synchronous cluster topology?

  • synchronous master-slave, is good migration target topology from mysql replication pair, yielding no lost transactions and no slave lag benefits
  • synchronous multi-master, yields write scalability and removes the need to "fail-over"
  • replicating over WAN is possible as well

What kind of alternatives are there for connecting with the cluster?

  • direct client connection gives the best performance, but load balancer can help in managing cluster configuration changes in systematic way
  • PHP connectivity through mysql native driver (mysqlnd)
  • JDBC Connector/J for multi-master use case

Which load balancing solution to use?

  • TCP load balancing as user land daemon or a hardware load balancer
  • using proxy for read/write splitting, looking at MySQL Proxy and ScaleBase alternatives
Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Room: 
Tribeca

Schedule Info

2 October 14:30 - 15:20 @
Tribeca

Speakers

Seppo Jaakola's picture
CEO, Codership

Database replication specialist, with long track record of developing various replication and clustering solutions for MySQL and PostgreSQL databases.
Currently holding CEO position at Codership, working for Galera open source project with the target of developing a universally applicable synchronous multi-master replication solution.

Slides


Sponsored By