ScaleBase delivers MySQL high availability - automating fail over in the event of database failure.
In the ScaleBase Data Traffic Manager architecture, standard MySQL replication or Galera Cluster are utilized to transport data from a master database to one or more slave databases.
Data Traffic Manager functions as a proxy to a cluster of identical databases, a single point of connectivity to your client applications. When Data Traffic Manager detects that a master database has failed, it automatically redirects all traffic to one of the slave databases ensuring continuous uptime and availability.
Data Traffic Manager employs a smart failover determination process that eliminates false alarms from temporary losses of database connectivity (such as temporary network slowdowns). In this way Data Traffic Manager avoids triggering unnecessary failovers that would necessitate manual labor of a failback.
If the master database crashes and a failover takes place, applications continue to run uninterrupted by the automated failover. Applications retain their open connections and statements states:
- Read operations are automatically re-routed to a working database without any disruptions, delays or performance impact.
- Write operations will be held temporarily until a failover decision is made (typically 5-10 seconds), after which either they are sent to the recovered master, or, in case of a failover, they are forwarded to a new master transparently. In case of an active transaction, an error message is returned to the client. This logic eliminates false alarms that lead to costly failbacks and avoids almost any disruption to running applications.
Data Traffic Manager also constantly monitors all slave databases’ replication lags and when it detects a broken replication process, or a large slave replication lag, it will eliminate non-performing slave databases from the failover processes and will create an alert notification identifying the situation to help operators to quickly remedy the problem.
ScaleBase provides administration of distributed MySQL database instances.
Data Traffic Manager is a database middleware tier that mimics a single large database instance. It provides a single centralized “point of entry” for database access to multiple applications.
A central console provides real time SQL traffic statistics and information about load distribution to individual databases in the backend MySQL array.
Data Traffic Manager enables controlled switchover between the master and slave to easily perform up-maintenance and change-management tasks such as:
- Server replacement