Tag Archives: MySQL

Sneak Peek at SchoonerSQL 5.1 with Auto Failover Across WAN

By pvenkatesh - Last updated: Monday, November 7, 2011

Cross-region or cross-country datacenters are popular and often essential for databases that need enterprise-grade reliability and availability.
SchoonerSQL™ 5.1 provides an ideal solution for such scenarios with

  • Automatic WAN failover
  • Asynchronous parallel appliers across the data center for increased throughput

Join this webinar tomorrow (November 8th - 10 am PST) to learn how SchoonerSQL 5.1:

  • Maximizes service availability at high scale through its parallel threads approach
  • Provides superior disaster recovery with automatic WAN failover
  • Ensures no lost data
  • Radically simplifies the management of MySQL clusters

https://www3.gotomeeting.com/register/635284982

Have you ever heard about “Read Masters” in MySQL??? Enterprise-ready SchoonerSQL provides them.

By pvenkatesh - Last updated: Thursday, October 20, 2011

A typical MySQL deployment involves one Master handling writes and multiple Slaves to scale the reads.

The term “slave” has been used in MySQL because the Slave servers have to perform every task in copying from the Master binlog, then updating their relay logs and finally committing to the Slave databases. The Master plays no role in replication here other than storing the replication events in the binlog.

This kind of Master - Slave set up imposes several limitations:
- Slave lag
- Stale or old data
- Data loss
- Manual failover which is error-prone and time consuming

In SchoonerSQL™, there is no concept of “slaves” inside a synchronous cluster. It’s far more accurate to use the term “Read Masters” because of our unique synchronous approach and replication architecture. SchoonerSQL uses a push mechanism of replication events coupled with faster processing through multiple parallel threads. This ensures that the Master and each Read Master’s data in a synchronous cluster is always consistent. So you can write data to a Master and at the same time query it from any Read Masters and get fully consistent data.

SchoonerSQL Synchronous Replication Architecture

Schooner’s approach provides several benefits:

  • Zero data loss
  • Guaranteed data consistency across all nodes
  • No stale data
  • Zero lag
  • Faster response time than traditional MySQL
  • Immediate automated failover to any of the nodes in the cluster, since the data is always consistent, for full service continuity.

This type of replication is very useful for Websites or Enterprises looking for a scalable MySQL - InnoDB with no lost or stale data and no slave lag.