header-2

GALERA CLUSTER FOR MYSQL
THE TRUE MULTI-MASTER

Download
Galera Cluster
galera_replication

Benchmark in data loss protection

Galera Cluster for MySQL is  a true Multimaster Cluster based on synchronous replication. Galera Cluster is an easy-to-use, high-availability solution, which provides high system uptime, no data loss and scalability for future growth.

 

World’s most advanced features

  • Synchronous replication
  • Active-active multi-master topology
  • Read and write to any cluster node
  • Automatic membership control, failed nodes drop from the cluster
  • Automatic node joining
  • True parallel replication, on row level
  • Direct client connections, native MySQL look & feel

Un-seen benefits

  • No slave lag
  • No lost transactions
  • Both read and write scalability
  • Smaller client latencies

 

Read about technology behind Galera Cluster >

 

Use cases

use_cases

Use case

Read Master

Traditional MySQL master-slave topology, but with Galera all “slave” nodes are capable masters at all times, it is just the application who treats them as slaves. Galera replication can guarantee 0 slave lag for such installations and due to parallel slave applying, much better throughput for the cluster.

Use case

Write scalability

Distributing writes across the cluster will harness the CPU power in slave nodes for better use to process client write transactions. Due to the row based replication method, only changes made during a client transaction will be replicated and applying such a transaction in slave applier is much faster than the processing of the original transaction. Therefore the cluster can distribute the heavy client transaction processing across many master nodes and this yields in better write transaction throughput overall.
 

Use case

WAN Clustering

Synchronous replication works fine over the WAN network. There will be a delay, which is proportional to the network round trip time (RTT), but it only affects the commit operation.

Use case

Disaster Recovery

Disaster recovery is a sub-class of WAN replication. Here one data center is passive and only receives replication events, but does not process any client transactions. Such a remote data center will be up to date at all times and no data loss can happen. During recovery, the spare site is just nominated as primary and application can continue as normal with a minimal fail over delay.

Use case

Latency Eraser

With WAN replication topology, cluster nodes can be located close to cilents.Therefore all read & write operations will be super fast with the local node connection. The RTT related delay will be experienced only at commit time, and even then it can be generally accepted by end user, usually the kill-joy for end user experiences is the slow browsing response time, and read operations are as fast as they possibly can be.


Case studies

press_releases

Case study

MercadoLibre chooses Galera Cluster

58 MILLION MERCADOLIBRE CONSUMERS GENERATE PLENTY OF DATA; GALERA CLUSTER MANAGES IT

 

“Codership’s Galera Cluster community and support are fantastic. It’s difficult to find a dedicated support team such as theirs these days. The product is great, it just works as we expected it to with no surprises. It scales and we happily promote it ourselves as the defacto database for Openstack and for everyone that needs an active-active schema that really works.”

- Leandro Reox & Alejandro Comisario.

 

Download PDF >