Database Automation – Seeing Is Believing

NuoDB’s “No Knobs” approach to administration delivers full database automation for all NuoDB databases. The Automation Console handles database configuration, deployment, and monitoring, making it extremely easy to automate starting, stopping and scaling out your databases via templates from a central console. Seeing is believing; so watch this short video demo.

As you can see in the video, the Automation Console dashboard allows you to place various widgets to give a holistic view of the NuoDB database system at any point in time.

The dashboard view includes widgets for memory consumption and CPU usage for each host, a view of currently running NuoDB databases (where you can see that we have three databases configured), available hosts, total commits per second, and geographic database regions.

In the demo example, we have storefront, telco and System databases running, with operational load running against the Storefront database. The Automation Console gives you a powerful, yet easy to understand dashboard that combines both systems administration and DBA level details into a single view for monitoring any scale-out or multi-tenant deployment.

As you can see, the demonstration then drills down into the “telco” database to see what’s going on. The database is deployed in one region on three hosts with five processes running. In NuoDB, databases are managed by templates that enforce different service level agreements. In the case of the Telco database we used the Multi Host template to manage scale out deployments in a single region.

Additional templates available include a single host deployment for starter applications, a minimally redundant template that provides a minimum level of high-availability and data redundancy, and a geo-distributed template that enables you to scale a single logical NuoDB database across multiple geographic regions.

If we suppose that the telco database, which is currently running solely in the AWS west coast datacenter, is being used by a mobile application that has become immensely popular in other regions as well. To improve performance across these new regions, we’ll want to deploy that database globally.

With NuoDB’s easy-to-use templates, all you need to do is change the template for the telco database from multi host to our geo-distributed template. Within seconds, the Console automatically starts new database processes in the AWS US-East and EU-Central regions. As all processes come on line, the telco database is now deployed in 3 regions on 9 host machines.

This simple act of changing from one database template to another can be performed easily – and can be executed on active databases regardless of transaction volume.

The NuoDB Automation Console makes deploying, and managing a database, or multiple databases, a flexible and simple experience.

Take a look at our database automation capabilities and let us know what you think.

Add new comment