MySQL Enterprise High Availability
MySQL Enterprise Edition
Databases are the center of today's enterprise and web applications, storing and protecting an organization's most valuable assets and running business-critical applications. Just minutes of downtime can often result in significant amounts of lost revenue and unsatisfied customers. Making database applications highly available is therefore a top priority for all organizations.
MySQL Replication is the most popular and cost-effective high availability solution. Many of the world's most trafficked web properties like Facebook, Twitter, Zappos and Zynga rely on MySQL Replication to serve millions of users and handle their exponential growth.
MySQL Fabric provides a framework for managing farms of MySQL servers. MySQL Fabric provides two services that can be used individually or in combination. High Availability is built on top of MySQL Replication to provide automated failure detection and failover. On the failure of a master, a slave is automatically promoted and writes from the application routed to the correct servers.
MySQL Enterprise Edition offers a range of solutions for database high availability, to automatically detect and recover from failures - whether these occur at the network, host, OS or database layer - as well as minimize downtime resulting from scheduled maintenance activities.
Oracle VM Template
Integrating MySQL Enterprise Edition with Oracle VM and Oracle Linux, the Oracle VM Template for MySQL is the fastest, easiest and most reliable way to provision virtualized and highly available MySQL databases.
The Oracle VM Template for MySQL Enterprise Edition ensures rapid deployment and helps eliminate configuration efforts and risks by providing a pre-installed and pre-configured virtualized software image, taking advantage of Oracle VM's mechanisms to deliver high availability.
Organizations can meet stringent SLA (Service Level Agreement) demands by using the High Availability features of the Oracle VM Template for MySQL Enterprise Edition:
- Automatic recovery from failures, Oracle VM automatically restarts failed MySQL instances on available servers in the server pool after outages of the physical server, VM or MySQL database.
- Live Migration, enables operations staff to move running instances of MySQL to alternative hosts within a server pool when they need to perform maintenance operations.
Oracle Linux and DRBD
DRBD (Distributed Replicated Block Device) is an open source Linux kernel module which leverages synchronous replication to deliver high availability database applications across local storage. DRBD synchronizes database changes by mirroring data from an active node to a standby node and supports automatic failover and recovery. Linux, DRBD, Corosync and Pacemaker, provide an integrated stack of mature and proven open source technologies.
New! Oracle Clusterware Agent for MySQL
Oracle Clusterware delivers high availability by unifying servers to form a cluster. The Oracle Clusterware XAG Agent for MySQL enables Oracle Clusterware to provide a Highly Available MySQL Service using MySQL Enterprise Edition. It ensure that the MySQL Server process can be moved between different machines - either manually or as part of an automated failover.
Oracle Solaris Clustering
Windows Server Failover Clustering
With the certification and support of MySQL with Windows Server Failover Clustering (WSFC), organizations can safely deploy business-critical applications demanding high levels of availability, powered by MySQL Enterprise Edition and using native Windows Clustering services.
Failures of either MySQL or the underlying server are automatically detected and the MySQL instance is restarted on the Standby node. Applications accessing the database, as well as any MySQL replication slaves, can automatically reconnect to the new host running MySQL using the same Virtual IP address. Administrators can also initiate a failover themselves when they need to take a server offline for maintenance.
MySQL Cluster CGE
MySQL Cluster enables organizations to deliver 5 Nines (99.999%) availability using a distributed, shared-nothing, multi-master architecture with no single point of failure that can be scaled out on commodity hardware.
MySQL Cluster can be configured as in-memory and disk-based storage engine that synchronously replicates data to all data nodes in the cluster. This results in sub-second response time and extremely fast failover. Auto-sharding (partitioning), fail-over, and recovery are all automatically handled by MySQL Cluster, in addition to the ability to perform administrative functions online, including adding nodes, modifying schema, upgrades and back-ups, all without downtime. MySQL Cluster is used by the world's most demanding organizations including Alcatel-Lucent, BT Plusnet, Cisco, Docudesk, Neckermann, Shopatron, Telenor and Zillow.com.