mysql high availability power and usability
DESCRIPTION
Solving MySQL high availability issues with Continuent TungstenTRANSCRIPT
©Continuent 2012.
MySQL High AvailabilityPower and Usability
Giuseppe MaxiaQA Director - Continuent, Inc
1Wednesday, December 05, 12
About me• Giuseppe Maxia, a.k.a. The Data Charmer
• Worked in the MySQL team (2006-2010)
• Now QA Director, Continuent, Inc
• Using MySQL since 2001
• Creator and maintainer of MySQL Sandbox
• Community Contributor of the year (2006, 2011)
• Oracle ACE (2011)
• Oracle ACE Director (2012)
• BLOG: http://datacharmer.blogspot.com
A
2Wednesday, December 05, 12
©Continuent 2012
ToC
• What a demanding database user wants
• easy switch
• easy and automated failover
• easy recovery
• disaster recovery stand-by site
• easy site switch and failover
• easy site recovery
• What Continuent Tungsten does
• all of the above
3
3Wednesday, December 05, 12
©Continuent 2012
What's an EASY failover
• A failover or switch is EASY if:
• I can promote a slave easily
• I can tell easily the other slaves who is new master
• I can get a failover to happen automatically
• Applications keep working without changes
• Failovers only happen when the server is truly dead
4
4Wednesday, December 05, 12
©Continuent 2012
Translation: What a DB user wants is:
• Transparency
Or
• the ability of using a RESILIENT database system without need to know what's going on
5
5Wednesday, December 05, 12
©Continuent 2012
How a non-HA system works
6
App Logic
MySQL Client API
master
slaveslave
load balancer
RR
W
6Wednesday, December 05, 12
©Continuent 2012
How a non-HA system works (after a switch)
7
App Logic
MySQL Client API
master
slaveslave
load balancer
switch
?
?RR
W
7Wednesday, December 05, 12
©Continuent 2012
MasterSlave Slave
App Logic
Tungsten Connector
Replicator Replicator Replicator
App Logic
Tungsten Connector
Manager Manager Manager
Monitoring and control
Monitoring and control
db2 db1 db3
Data Service: sj
8
8Wednesday, December 05, 12
©Continuent 2012
How a Tungsten HA system works
9
App Logic
MySQL Client API
load balancerR
R
W
9Wednesday, December 05, 12
©Continuent 2012
How a Tungsten HA system works
10
App Logic
MySQL Client API
load balancer
switch
W
R
R
10Wednesday, December 05, 12
©Continuent 2012
Multiple site demo
11
11Wednesday, December 05, 12
©Continuent 2012
Installation principles
• Install from one location only
• Remote installation of all services
• No partial installations: Either all servers are OK, or none will be installed
• Parallel installation
12
12Wednesday, December 05, 12
©Continuent 2012.
What does the installation do
host4
1: Validate all servers
host1 host2 host3
Report all errors
13
13Wednesday, December 05, 12
©Continuent 2012.
What does the installation do
host4
1: (again) Validate all servers
host1 host2 host3
14
14Wednesday, December 05, 12
©Continuent 2012.
What does the installation do
2: install Tungsten in all servers
host3
$CONTINUENT_HOME/ config/ releases/ backups/ thl/ tungsten/
host4host1
host2
15
15Wednesday, December 05, 12
©Continuent 2012.
Installation demo
16
16Wednesday, December 05, 12
©Continuent 2012
Standard HA system demo
17
17Wednesday, December 05, 12
©Continuent 2012
How a "smart scale" Tungsten HA system works
18
App Logic MySQL Client APIWRR
18Wednesday, December 05, 12
©Continuent 2012
Standard HA "smart scale" system demo
19
19Wednesday, December 05, 12
©Continuent 2012
How a multi site (non HA) system works
20
App Logic
MySQL Client API
master
slaveslave
load balancer
RR
W
relay
slaveslave
20Wednesday, December 05, 12
©Continuent 2012
How a multi site (non HA) system works
21
App Logic
MySQL Client API
master
slaveslave
load balancer
RR
W
relay
slaveslave
21Wednesday, December 05, 12
©Continuent 2012
How a multi site (non HA) system works
22
master
slaveslave
load balancer
RR
relay
slaveslave
App Logic
MySQL Client API
W
22Wednesday, December 05, 12
©Continuent 2012
How a multi-site Tungsten system works
23
App Logic
MySQL Client API
W
load balancer
RR
23Wednesday, December 05, 12
©Continuent 2012
How a multi-site Tungsten system works
24
App Logic
MySQL Client API
W
load balancer
RR
24Wednesday, December 05, 12
©Continuent 2012
How a multi-site Tungsten system works
25
App Logic
MySQL Client API
W
load balancer
RR
25Wednesday, December 05, 12
©Continuent 2012.
Parting thoughts
• The key elements of HA are:
• transparency
• ease of use
• Continuent Tungsten
• makes cluster usage transparent
• o!ers automatic failover
• makes cluster management easy
• deals with multiple sites with great ease
26
26Wednesday, December 05, 12
©Continuent 2012 27
Continuent Website:http://www.continuent.com
Tungsten Replicator 2.0:http://code.google.com/p/tungsten-replicator
Our Blogs:http://scale-out-blog.blogspot.comhttp://datacharmer.blogspot.comhttp://flyingclusters.blogspot.com
560 S. Winchester Blvd., Suite 500 San Jose, CA 95128 Tel +1 (866) 998-3642 Fax +1 (408) 668-1009e-mail: [email protected]
27Wednesday, December 05, 12