Best Practices for Deploying
OpenStack Trove:
An Inside look at Database as a Service Architecture
OpenStack Summit at Barcelona, October 2016
Who are we?
• Sriram Kalyanasundaram, Director
Implementations
– Tesora Inc.
OpenStack Summit Barcelona, October 2016 2
What are we covering in this session?
• Introduction to Trove
– Trove Concepts
– Tutorial demonstrating Trove functionality
– Trove Architecture
• Access to Trove environment
– DevStack VM
– Trove VM
• MySQL and MongoDB Guest Images
– Step-by-step Lab Tutorial
• Questions
OpenStack Summit Barcelona, October 2016 3
What is Trove?
Introduction to OpenStack Trove Project
• Motivation: Provide DBaaS within OpenStack framework
– Incubated in Havana (October 2013)
– Integrated in Icehouse (April 2014)
• Original project sponsors: HP and Rackspace
• Major contributors include Tesora, Rackspace, HP, IBM, Redhat,
eBay, Mirantis
OpenStack Summit Barcelona, October 2016 5
What does Trove provide?
• Database as a Service for OpenStack
• API’s for both development and operations
• Self service database provisioning
• Full database lifecycle management
• Multi-database support
– Both Relational and NoSQL
OpenStack Summit Barcelona, October 2016 6
Supported Databases
• Available today Avilable today
– MySQL 5.6,5.7 – Oracle MySQL Enterprise 5.6*
– Percona 5.6, 5.7 – EDB PostgreSQL Enterprise 9.4*
– Percona XtraDB Cluster 5.6, 5.7 – Couchbase Enterprise 4.1*
– MariaDB 10.1 – MongoDB Enterprise 3.2*
– MongoDB 3.2 – DataStax Enterprise 4.8*
– Cassandra 2.2, 3.0
– Oracle 12c*, 11g*
– Couchbase 3.0,4.0
– Couchdb 1.6.1
– Oracle RAC*
– Redis 3.0 Coming soon
– PostgreSQL 9.4 – MS SQL Server
– DB2 Express 10.5 *Tesora DBaaS Enterprise Edition only
– Vertica
OpenStack Summit Barcelona, October 2016 7
Complete Database Lifecycle Management
Provision Manage
• Wide array of databases • Databases
• One click away Provision Manage • Replica sets
• Single instances to clusters • Users and backups
Secure Secure Tune Tune
• Automated patching • Database images
• Granular permissions • Op?mized and tuned
• Restricted root access • APIs for custom configs
OpenStack Summit Barcelona, October 2016 8
Trove Terminology
• Guest Image
• Guest Agent
• Trove Instance
• Cluster
• Datastore
• Datastore Version
• Configuration Group
• Flavor
OpenStack Summit Barcelona, October 2016 9
Provisioning a Database Instance with Trove
• Database instances can be deployed using dashboard or CLI
• Trove API allows options to customize the database instance
– Flavor support
– Cinder volume support
– Create database(s)
– Create user(s)
– Manage configurations
– Replicate from another instance
– Restore from a backup
OpenStack Summit Barcelona, October 2016 10
Trove Demo
Trove in Action
In this demo we will…
• Create a MySQL instance through Horizon
• Create a backup of the instance
• Create a MongoDB cluster
OpenStack Summit Barcelona, October 2016 12
Trove Architecture and HA Deployment
Tesora DBaaS Platform Architecture
OpenStack Summit Barcelona, October 2016 14
Sample POC architecture
Tesora DBaaS Management Tenant 2 application network Tenant 1 application network Infra network 10.10.0.0/16
Network 10.20.0.0/16 192.168.20.0/24 192.168.20.0/24
Tenant 1 Tenant 1 Tenant 2
Tenant 1 Tenant 2
Tesora Tesora Tesora
DBaaS Nova Nova DBaaS DBaaS
Tesora Tesora Tesora ...
MySQL Instance Instance MongoDB MongoDB
MQ DB Services Instance Instance Instance
Nova Compute 1 Nova Compute 2 Nova Compute 3
...
An exis?ng
Openstack Openstack Openstack
services services services
Infra MQ Infra MQ Infra DB Infra DB Infra DB
OpenStack
1 2 3
Deployment Openstack
services
Openstack
services
Openstack
services
Infra MQ High Availability Infra DB High Availability
4 5 6
OpenStack Services High Availability
OpenStack Summit Barcelona, October 2016 15
Trove Deployment at Cisco
OpenStack Summit Barcelona, October 2016 16
High Availability Configuration
OpenStack Summit Barcelona, October 2016 17
What’s new in Newton?
• Upgrade support
• Usability improvements
• Clustering improvements
• Locality support in instance creation and replication
• Improved DB2 Express-C Support
• Improved PostgreSQL Support
• New quota management [admin] API for reviewing and changing
quota’s for specific tenants
OpenStack Summit Barcelona, October 2016 18
If you are interested in learning further:
Please attend the session on Thursday at
• 1:50 PM in P1 – Room 117
• What's New with OpenStack Trove in Newton, What's On Deck for
Ocata
OpenStack Summit Barcelona, October 2016 19
Questions?
If you are interested in deploying Trove
Contact Tesora for additional information
• http://www.tesora.com/contact-us/
OpenStack Summit Barcelona, October 2016 21
If you want additional information
• Sriram Kalyanasundaram
– sriram@tesora.com
– 978-273-0607
OpenStack Summit Barcelona, October 2016 22
Thank You
