Building MySQL DBaaS on OpenStack And Ceph Clouds - InformationWeek
IoT
IoT
Partner Perspectives  Connecting marketers to our tech communities.
Commentary
12/5/2016
11:36 AM
Brent Compton
Brent Compton
Partner Perspectives
50%
50%

Building MySQL DBaaS on OpenStack And Ceph Clouds

A cloud-based database-as-a-service offering can relieve the overwhelming burden of supporting today's scale of computing with yesterday's architectures.

Enterprises hosting hundreds or thousands of MySQL or MariaDB databases seek the benefits of cloud storage to dramatically improve their operational efficiency. Compared to hosting this quantity of databases on traditional MySQL clusters, the benefits of cloud storage such as dynamic volume resizing and elastic provisioning from a global storage pool provide big efficiency improvements. For proprietary public cloud customers, this is illustrated by the growing use of services such as RDS from Amazon Web Services.

For private clouds, architects who have selected OpenStack as the “operating system” for their software-defined data centers are increasingly asked to provide DBaaS (database as a service), comparable to AWS RDS, for their constituents. The popularity of LAMP stack-based applications on OpenStack further amplifies the demand for providing DBaaS services to these customers, either internal or external. The April 2016 OpenStack.org survey notes that a full 70% of custom applications running on OpenStack are built on the LAMP stack. The “M” in LAMP is commonly defined as MySQL, although its compatible cousin, MariaDB, is often a substitute. Thus, cloud architects in large enterprises frequently need to provide their customers with the ability for on-demand provisioning of tens, hundreds, or thousands of database instances.

With a properly configured OpenStack deployment and Red Hat Ceph storage backend, DBaaS clients merely go to a self-service interface and request the number and configuration of databases they require. OpenStack dynamically provisions the required storage capacity from the appropriate Ceph storage pool. No more manual placement of these database instances on MySQL clusters of various shapes and sizes. This manual exercise was a bit like playing the old Tetris game, trying to fit new database instances into fixed-sized clusters, followed by moving or rearranging them to new clusters when they outgrew available capacity.

Optimized DBaaS Storage

In an environment where thousands of databases are constantly being instantiated, populated to a larger scale, mutated, cloned, and repurposed, storage is at the foundation of success. Here, too, the OpenStack community provides the required guidance.

Ceph is the de facto storage for OpenStack, and it is used to manage storage in nearly 60% of OpenStack deployments. It has the distinct advantage of being able to manage object, block, and shared file system storage. Many cloud architects immediately associate Ceph with archive-level content and scale-out storage for unstructured data at petabyte scale, and indeed Ceph is well-suited for such tasks.

However, recent joint Red Hat testing with database consulting experts at Percona has demonstrated that Ceph storage clusters can also handle the high IOPS (input/output operations per second) workload requirements of transactional MySQL deployments, the de facto database for custom apps running in OpenStack. In fact, Red Hat testing revealed that it is possible to match, and in some cases surpass, the performance of the highest performing class of AWS EBS storage -- provisioned IOPS -- dependent on provisioned capacity.

A Realistic View

It may be some time before an enterprise feels comfortable migrating its core financial databases to a cloud environment. But for the hundreds or thousands of utility databases in use by today’s custom applications, a cloud-based DBaaS offering can relieve the overwhelming burden of supporting today’s scale of computing with yesterday’s architectures.

Brent Compton, Red Hat Director of Storage and Big Data Ecosystem, manages the Red Hat Storage Ecosystem Program, including optimization with complementary Red Hat and partner-based solutions. His experience includes executive product management at Fusion IO and Micromuse. He ... View Full Bio
We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
Register for InformationWeek Newsletters
Partner Perspectives
What's This?
Red Hat is the world's leading provider of open source software solutions, using a community-powered approach to reliable and high-performing cloud, Linux, middleware, storage and virtualization technologies. Red Hat also offers award-winning support, training, and consulting services. As a connective hub in a global network of enterprises, partners, and open source communities, Red Hat helps create relevant, innovative technologies that liberate resources for growth and prepare customers for the future of IT. Learn more at redhat
Featured Writers
White Papers
Current Issue
Top IT Trends for 2018
As we enter a new year of technology planning, find out about the hot technologies organizations are using to advance their businesses and where the experts say IT is heading.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll