Monday Oct 08, 2012

New Options for MySQL High Availability

Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of revenue and reputation.

There is not a “one size fits all” approach to delivering High Availability (HA). Unique application attributes, business requirements, operational capabilities and legacy infrastructure can all influence HA technology selection. And then technology is only one element in delivering HA – “People and Processes” are just as critical as the technology itself.

For this reason, MySQL Enterprise Edition is available supporting a range of HA solutions, fully certified and supported by Oracle. MySQL Enterprise HA is not some expensive add-on, but included within the core Enterprise Edition offering, along with the management tools, consulting and 24x7 support needed to deliver true HA.

At the recent MySQL Connect conference, we announced new HA options for MySQL users running on both Linux and Solaris:

- DRBD for MySQL

- Oracle Solaris Clustering for MySQL

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.


DRBD Stack: Providing Synchronous Replication for the MySQL Database with InnoDB

Download the DRBD for MySQL whitepaper to learn more, including step-by-step instructions to install, configure and provision DRBD with MySQL

Oracle Solaris Cluster provides high availability and load balancing to mission-critical applications and services in physical or virtualized environments. With Oracle Solaris Cluster, organizations have a scalable and flexible solution that is suited equally to small clusters in local datacenters or larger multi-site, multi-cluster deployments that are part of enterprise disaster recovery implementations. The Oracle Solaris Cluster MySQL agent integrates seamlessly with MySQL offering a selection of configuration options in the various Oracle Solaris Cluster topologies.


Putting it All Together

When you add MySQL Replication and MySQL Cluster into the HA mix, along with 3rd party solutions, users have extensive choice (and decisions to make) to deliver HA services built on MySQL

To make the decision process simpler, we have also published a new MySQL HA Solutions Guide.

Exploring beyond just the technology, the guide presents a methodology to select the best HA solution for your new web, cloud and mobile services, while also discussing the importance of people and process in ensuring service continuity.

This is subject recently presented at Oracle Open World, and the slides are available here.

Whatever your uptime requirements, you can be sure MySQL has an HA solution for your needs


Please don't hesitate to let us know of your HA requirements in the comments section of this blog. You can also contact MySQL consulting to learn more about their HA Jumpstart offering which will help you scope out your scaling and HA requirements.

Wednesday Jul 06, 2011

Virtualizing MySQL: 1-Click, Kick Back…and Relax

Virtualizing all parts of today’s software infrastructure has become a priority for many. Creating a more flexible and dynamic environment with improved availability enables organizations to accelerate innovation, reduce time to market, cut costs and deliver higher uptime.

Databases have rarely been the first candidates for virtualization – mainly as a result of fears in consolidating such critical resources, and in I/O overhead that may have degraded service levels. However with improvements in hypervisor designs coupled with more powerful commodity server hardware and repeatable best practices, many of these concerns are rapidly diminishing.

It was in this context that we began development of the Oracle VM Template for MySQL Enterprise Edition, making the world’s leading web database radically simpler to deploy, manage, and support in a virtualized environment.

Along with the development team, we will be hosting a live webinar on Wednesday July 13th where we will introduce the Template and demonstrate how to deploy it in production environments.

We will show how, in 1-click, users can download the Oracle VM Template - providing a pre-installed, pre-configured, pre-tested virtualized MySQL instance running on Oracle Linux and Oracle VM, packaged and certified for production deployment.

With the download complete, users simply import the template into the Oracle VM Manager and then configure for their local environment via a self-running first boot script. The image is then provisioned to the Oracle VM Server Pool where it is ready for use. It is simple to clone the image to create multiple MySQL instances in seconds and customize the template with additional software stacks to create new Golden Images.

In addition to rapid deployment, users also benefit from the integrated High Availability technologies that are part of the Template. Oracle VM provides native clustering mechanisms that can detect failures in the underlying server, VM or MySQL instances and automatically fail over to the other nodes in the VM Server Pool. User can configure the recovery to a specific server, or can allow Oracle VM to load balance the recovery to any server in the pool.

With downtime resulting from scheduled maintenance activities now representing the majority of outages in today’s data centers, Oracle VM also offers live migration. A user can initiate the migration of a running MySQL instance to another server across secure SSL links, without downtime.

And of course, users can receive support for the entire stack – from hypersior to database – from Oracle, eliminating all that nasty finger pointing that you might find with other VM / Database combinations.

We’ve created a couple of resources you can use to get started with the Oracle VM Template for MySQL Enterprise Edition:

- Register for the live webinar on July 13th. Don’t worry if you can’t make it – by registering you will automatically be notified when the replay is available

- Download the new whitepaper which discusses the components of the template, and then how to download, configure and deploy it.

In summary, 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 MySQL instances. By using the template, users are able to meet the explosive demand for web-based services with a low Total Cost of Ownership, while providing a foundation for cloud computing. So download, kick back, and relax.....


About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
5
6
9
10
11
12
13
15
16
17
18
19
20
23
25
26
27
28
29
30
   
       
Today