Best Practices for Deploying OpenStack Trove: An Inside look at - PowerPoint PPT Presentation

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 Avilable today Available today • – Oracle MySQL Enterprise 5.6* MySQL 5.6,5.7 – – EDB PostgreSQL Enterprise 9.4* Percona 5.6, 5.7 – 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 – – Oracle RAC* Couchdb 1.6.1 – Coming soon Redis 3.0 – – MS SQL Server PostgreSQL 9.4 – 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 • Replica sets Provision Manage • Single instances to clusters • Users and backups Secure Tune Secure 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 Nova Nova DBaaS DBaaS DBaaS Tesora Tesora Tesora ... Instance Instance MySQL 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 Openstack Openstack services services 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