Support: 1-800-961-4454
1-800-961-2888

Larger Flavors, More Storage For Cloud Databases

2

Cloud Databases helps you provision and manage high performance MySQL instances on Rackspace’s open cloud. Our service helps with the installation, configuration, deployment and on-going management of MySQL, and more importantly it helps you deliver fast apps through an architecture that is purpose-built with performance in mind using container-based virtualization.

Since launching the service last year, we have heard constantly from you that you are dealing with MySQL databases of increasing complexity and size. To assist you with those requirements, we have updated Cloud Databases to include:

  • Higher memory flavors: We are adding the option to create 8GB and 16GB instances, four times what was previously available. The new flavors have more memory, CPU, network bandwidth and I/O priority, which give you greater performance for your workloads and, as you can see in the Cloud Databases pricing page, they are competitively priced.
  • Triple storage: With more I/O comes larger datasets, so we are also tripling the maximum storage for instances from 50GB to 150GB.
  • Storage capacity alerts: To help you avoid inadvertently reaching your storage limit, we will automatically send you a ticket when you consume more than 90 percent of your storage allocation.
  • Enhanced user management: We are giving you the ability to perform password changes and to assign user access on existing database users via the API (coming soon to the Control Panel).

We ran SysBench, the popular performance benchmark tool for MySQL, across all flavors to do a quick performance spot check and give you an idea of what to expect from our new and existing flavors.  As you may know, SysBench has several test modes, including CPU, threads, memory, File IO, OLTP, etc. We used the OLTP test mode, which is used to benchmark the performance of a database under transactional loads. The test involved point value queries, ranges, SUM(), ORDER BY, UPDATEs, DELETEs, INSERTs, etc. In other words, it tries to emulate the type of workloads your applications are currently handling.

Below is the five-run average of what Sysbench reported in Transactions per Second (TPS) on an OLTP workload with binary logging off and 64 threads on all flavors:

Of course, your mileage will vary based on your workload’s individual characteristics, but the above should give you a good idea of what you can expect.

WHAT OTHERS ARE DOING: BUILDING BEAUTIFUL CHARTS WITH YOUR DATA AND CHARTIO

I love to hear what others are doing with Cloud Databases. Today, I would like you to learn from Dave Fowler, founder of Chartio. Chartio provides data analytics and visualization tools for business intelligence applications, and allows you to bring data from Cloud Databases and other data sources together into beautiful visualizations. Read the guest blog that Dave wrote about how to use Chartio with Cloud Databases, or visit Chartio directly.

As usual, let me know what apps you are building these days with Cloud Databases or any one of our products @jrarredondo.

About the Author

This is a post written and contributed by Rackspace Blogger.

Rackspace Blogger


More
  • J.R. Arredondo

    By the way, I am doing a webinar tomorrow April 4, 2013 at 2:00 PM (Central Time) with Kelly Golsby, Daniel Morris and Dave Fowler (founder of Chartio). We will talk about Cloud Databases, how to use them in the Control Panel, how to set up your WordPress blog on it, how to create beautiful visualizations using Chartio, and how to use Sysbench to benchmark the performance of your instance. A little bit of everything.

    If you are interested, register here: https://cc.readytalk.com/r/6r6qdx00xbay

  • E.W.

    Can you post the Sysbench commands you used?

    I’d be curious to know how it compares to running mysql on cloud block storage with SSD?

Racker Powered
©2014 Rackspace, US Inc.