<img alt="" src="https://secure.bomb5mild.com/193737.png" style="display:none;">

Turbonomic Blog

How to Manage Relational Database Services in the Cloud

Posted by Ryan DeWaele on Oct 17, 2017 4:07:58 PM

With its newest release of 6.0, Turbonomic introduces the ability to control Relational Database Services (RDB), the fastest growing service in the public cloud today. It also becomes the only hybrid cloud management platform that is capable of managing RDBs in the cloud.

Many organizations focus on cost savings for compute alone, leaving RDBs unmanaged, and at a constant risk of underperforming or overspending. Turbonomic 6.0 allows organizations to focus on maintaining consistent control of their RDBs in the cloud by assuring performance, lowering cost, and maintaining complaince. Turbonomic 6.0 introduces the following benefits as part of its RDB control.

How to Target RDBs with Turbonomic 6.0RDB blog photo 1

RDBs will be presented through a HTML5 UI in an easy to consume fashion. After logging into Turbonomic, The Home Page, presents the Supply Chain view, shown in the following example.

Within the Supply Chain view, we can drill into the Database and Database Servers that have been Targeted through Turbonomic. Upon choosing your RDB, Turbonomic will provide Actions for your RDB to assure performance. From the following example, from the ‘Actions’ tab for the selected RDB, the Aurora DB needs to increase to a different template, assuring application performance of the selected RDB.

Assuring the Performance of Relational Database Services

Turbonomic 6.0 provides you with actionable recomendations by assessing the demand of your RDBs based on the metrics it collects from either AWS or Azure. These metrics include:

  • For AWS: CPU, Memory, IO and NetThroughput.
  • For Azure: DTU (Database Transaction Unit, which is a blended measure of CPU, memory, I/O (data and transaction log I/O).

By using these metrics Turbonomic understands if your RDBs are not getting the resources they need in order to be performant. If this happens, Turbonomic will provide you with a recommendation to scale up to the next DB tier to ensure that end users are not affected and that performance is assured.

RDB blog photo 3

Lower Cloud Costs of Relational Database Services

If your RDB is not using all of the resources allocated,  you would end up paying too much for unnecessary resources in the cloud. This is a trend that has been seen across all cloud services and is as important to solve on the RDB side as it is to solve for compute or storage, especially considering the increasing adoption of RDBs in the cloud.

An example of this would be if you were running an Aurora:db.t2.medium ($0.082/hr in US East N. Virginia) instance when your RDB could be running an Aurora:db.t2.small instance ($0.041/hr in US East N. Virginia). It turns out that you will end up paying 2x what you actually need to spend… and that’s if you elect to run this instance in US East.

So, in this case, Turbonomic will provide you with the recommendation to scale down to a smaller template, which in turn, would promote cost savings for your organization. Turbonomic will also provide the cost breakdown to a single instance in association with the RDB instance for compute and license, so there is no need to guess where you are spending or why you are spending it.  The following presents an example of the Cost Breakdown and Estimated Costs with Turbonomics.

RDB Blog Photo last

Enforce Placement Policies of Relational Database Services in the Cloud

Maintaining the compliance of your RDBs HA policies to ensure business continuity of your RDBs you might be obligated to follow the requirements setforth by your business units. Whether you are in need of a single region/availability zone or multiple instances across multiple regions/availability zones for HA, policies must be enforced to ensure this level of service. Turbonomic 6.0 provides the ability to enforce placement policies for your RDBs; a geographic redundancy flag can be set for a group of entities which will limit the amount of RDBs in a certain region.

Turbonomic 6.0 allows you to dictate where your RDBs reside and to customize placement policies for them, ensuring they remain in the correct region or availability zone so that you do not need to worry about your RDBs taking an international trip without your permission.

In Summary…

Whether it is scaling up to ensure performance, scaling down to reduce costs, or restricting your RDBs from taking a transcontinental trip throwing you out of compliance, Turbonomic 6.0 ensures that as you continue on your journey to the public cloud and explore relational database services that you are covered.

Subscribe Here!

Recent Posts

Posts by Tag

See all