continuent webinar 02-19-2015
TRANSCRIPT
© 2015 VMware Inc. All rights reserved.
vCloud Air and Business-Critical MySQL Featuring VMware Continuent
Robert Hodges Matt Lang
February 2015
VMware Continuent Quick Introduction
2
History Products 2004 Continuent established in
USA 2009 3rd Generation
Continuent Tungsten (aka VMware Continuent) ships 2014 100+ customers running business-critical applications
Oct 2014 Acquisition by VMware: Now part of the vCloud Air Business Unit April 2015 Continuent solutions available through VMware sales
Industry-leading clustering and replication for open source DBMS
Clustering – Commercial-grade HA, performance scaling, and data management for MySQL
Replication– Flexible, high-performance data movement
VMware Continuent
Business-Critical Deployment Examples
High Availability for MySQL
Largest cluster deployment performs 800M+ transactions/day on 275 TB of relational data
Business Continuity Cross-site cluster topologies widely deployed including primary/DR and multi-master
High Performance Replication
Largest installations transfer billions of transactions daily using high speed, parallel replication
Heterogeneous Integration
Customers replicate from MySQL to Oracle, Hadoop, Redshift, Vertica, and others
Real-time Analytics Optimized data loading for data warehouses with deployments of up to 200 MySQL masters feeding to Hadoop
VMware Continuent Facts
3
For Every CIO: A Fundamental Choice
6
OR
Seamless Migration
“You can check in anytime… but you can
NEVER leave”
“Hotel California” Cloud
On-Premises ���Data Center
Compatible Public Cloud
Hybrid Cloud
vCloud Air: Extending To The Cloud
VMware vCloud Air
Your Data Center
Any Application… Easily Migrated
Software-Defined Data Center
VMware vSphere & vCloud Suite
Existing & New Apps
Advanced Networking
Common Management
One Support call
IaaS cloud owned and operated by VMware based on VMware software
Any Application, Any OS, Same Platform
vCloud Air is based on VMware vSphere - the most broadly deployed and trusted virtualization platform in the world
Supports a broad range of large-scale and mission-critical applications
SQL
Runs the largest number of guest operating systems: ▪ Generations of Windows and Linux distributions ▪ Both 32-bit and 64-bit editions ▪ Enterprise offering or free distribution
Failed Cluster
vCloud Air Dedicated Cloud Virtual Private Cloud
Compute Dedicated Server Cluster per Dedicated Cloud: • 30GHz vCPU • 120GB vRAM
Compute resource carved out of a “Dedicated Cloud”: • 5GHz Reserved vCPU • 5GHz Burstable vCPU
• 20GB vRAM
High Availability Based on VMware vSphere with vMotion, High Availability (HA) allows vCloud Air customers to:
▪ Minimize downtime from server cluster failures ▪ Increase protection across the deployed applications
Dedicated HA capacity is allocated for each Dedicated Cloud based on overall cluster size; shared HA capacity is allocated for each Virtual Private Cloud
In the event of physical server cluster failure, affected applications and virtual machines will be automatically restarted on the HA server cluster with spare capacity
Compute: Dedicated or VPC, All Highly Available
HA Cluster
Benefit: High Availability is part of the platform NO change to your legacy applications
Edge Gateway Secures the edge of the virtual data center and delivers network services: ▪ Firewall ▪ NAT ▪ Load Balancer ▪ Site-to-Site IPSec VPN ▪ Active/Standby High Availability ▪ Stateful Session Failover
vCloud Air Advanced Networking
INTERNET
Private (Corp) Network
DMZ Network
Test/Dev Network
Isolated Network
(Logging)
EDGE GATEWA
Y
z
Connectivity to vCloud Air
Connectivity Options: • Public or secure access to vCloud Air • Dedicated connection to cloud • High speed cross connect
Customer Data Center vCloud Air
Private WAN connectivity
IPSec Tunnel
Public
INTERNET
vCloud Air is portable, which enables a choice of service providers
VMware vCloud Air
VMware
VMware vCloud Air
Service Providers
MySQL is #2 DBMS overall and by leaps and bounds the most popular open source DBMS
1439.72 1272.45 1177.48
267.24 262.34 0
200 400 600 800
1000 1200 1400 1600
Source: db-engines.com, 2015
Rankings of Top Databases
Virtual data centers (vDCs) are the basic operational unit of vCloud Air
Virtual Data Center
Back End Tier Network (192.168.52.0/24)
Front End Tier Network (192.168.50.0/24)
EDGE GATEWAY
To run MySQL instantiate a virtual machine within a vDC
Virtual Data Center
Back End Tier Network (192.168.52.0/24)
Front End Tier Network (192.168.50.0/24)
EDGE GATEWAY
mySQL
Use a vApp Template to configure MySQL instances rapidly
(Local OVF)
Import
vCloud Director Catalog
Provision(Select vApp, add VMs,
configure network, start)
mySQL mySQL mySQL
(192.168.52.0/24)
Configure edge gateway services to enable access to MySQL from other networks as well as outside hosts
Virtual Data Center
Back End Tier Network (192.168.52.0/24)
EDGE GATEWAY
mySQL mySQL mySQL
Network address translationIPSec VPN serviceFirewall rules
Other Networks
Applications running within vCloud Air inherit basic resilience and performance scaling
Virtual Data Center
Back End Tier Network (192.168.52.0/24)
Front End Tier Network (192.168.50.0/24)
EDGE GATEWAY
mySQL mySQL mySQL
mySQL mySQL mySQL Resource aware VM placement
Automatic migration on host failure
Resource allocation models
24x7 data access
SQL load balancing
Simple management
Off-the-shelf MySQL
Continuent Clustering: HA, DR and Performance Scaling
db2 db1 db3
Slave Master Slave
Application Stack
Continuent Connector
Application Stack
Continuent Connector
Benefits
Manager
Replicator
Manager
Replicator
Manager
Replicator
Continuent clusters add replication, management, and connectivity to off-the-shelf MySQL/MariaDB
24
Slave Master Slave
Continuent Connector Continuent Connector
Continuent Connector operates as an intelligent proxy to the DBMS
• Any MySQL client can connect • Connector initiates connections on behalf of client to the DBMS
mySQL
Master
mySQL
Slave
mySQL
Slave
Application Connector
MySQL ProtocolCOM_QUERYCOM_INIT_DB
COM_DROP_DB…
Connector minimizes overhead from proxying
• Pass-through operation after connection • Full transparency and low overhead for clients
mySQL
Master
mySQL
Slave
mySQL
Slave
Application Connector
(Packet)COM_QUERY
SELECT * FROM foo
(Packet)OK
ResultSet Rows: 1
Continuent clusters provide HA for MySQL resident in vCloud Air
Continuent Connector
Master
SlaveSlave
Continuent clusters provide HA for MySQL resident in vCloud Air
Continuent Connector
Master
SlaveSlave
X1. Detect non-responsive node
2. Halt in-coming connections
3. Find and promote most up-to-date slave
Continuent clusters provide HA for MySQL resident in vCloud Air
Continuent Connector
New Master
Shunned nodeSlave
4. Administrator inspects and recovers old master X
Continuent enables online maintenance far beyond vMotion to cover software and DBMS upgrades
Slave upgrade
Slave upgrade Switch Master
upgrade
• Shun slave • Resize
journal, restart mysqld
• Return node to cluster
• Discard and reprovision on failure
• Repeat for remaining slave(s)
• Switch master to promote an upgraded slave
• Upgrade old master
• Maintenance is now done!
Continuent DR implements composite clusters that span sites and are ready for immediate failover
Public Internet, IPSec Tunnel, or VMware NSX Secure Gateway
vCLOUD AIR VIRTUAL DATA CENTER
ON-PREMISESDATA CENTER
DB2.CA
SLAVE
DB1.CA
MASTER
DB3.CA
SLAVE
Continuent Connector Continuent Connector
DB2.NJ
SLAVE
DB1.NJ
RELAY
DB3.NJ
SLAVE
Continuent Connector Continuent Connector
CROSS-REGIONREPLICATION
AsynchronousPrimary-DR
Continuent multi-master, cross-site cluster operate independent, active clusters on 2 or more remote sites
CROSS-REGIONREPLICATION
Public Internet, IPSec Tunnel, or VMware NSX Secure Gateway
vCLOUD AIR VIRTUAL DATA CENTER
ON-PREMISESDATA CENTER
DB2.CA
SLAVE
DB1.CA
MASTER
DB3.CA
SLAVE
Continuent Connector Continuent Connector
DB2.NJ
SLAVE
DB1.NJ
MASTER
DB3.NJ
SLAVE
Continuent Connector Continuent Connector
AsynchronousMulti-Master
AsynchronousPrimary-DR
Cluster replication model extends easily to loading data warehouses
CROSS-REGIONREPLICATION
Public Internet, IPSec Tunnel, or VMware NSX Secure Gateway
vCLOUD AIR VIRTUAL DATA CENTER
ON-PREMISESHADOOP CLUSTER
DB2.NJ
SLAVE
DB1.NJ
MASTER
DB3.NJ
SLAVE
Continuent Connector Continuent Connector
Asynchronous Heterogeneous
Replication
In the near future you will see rapid improvement of vCloud Air data services
• Documentation of best practices for operating MySQL • Efficient MySQL deployment tools • DBaaS for MS SQL Server • Baked-in cloud disaster recovery for databases (15 minute RPO
begone!)
Conclusion
• vCloud Air is an easy-to-use cloud that builds on robust vSphere/ESXi platform capabilities
• MySQL runs well in vCloud Air but needs additional capabilities for enterprise use
• VMware Continuent adds HA and DR to MySQL, building a pathway to run business-critical applications in vCloud Air
For more information, contact us: Robert Noyes Alliance Manager, USA & Canada [email protected] +1 (650) 575-0958 Philippe Bernard Alliance Manager, EMEA & APAC [email protected] +41 79 347 1385
Eero Teerikorpi Sr. Director, Strategic Alliances [email protected] +1 (408) 431-3305