using continuent tungsten to survive mysql failures...using continuent tungsten to survive mysql...
TRANSCRIPT
![Page 1: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/1.jpg)
©Continuent 2013
Using Continuent Tungstento Survive MySQL Failures
Je! Mace, Director of Professional Services
![Page 2: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/2.jpg)
©Continuent 2013
Introduction
• Continuent Tungsten manages large and small MySQL deployments
• Automatic local failover
• Managed failover between datacenters
• Connectivity options for all applications
2
![Page 3: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/3.jpg)
©Continuent 2013 3
1
Our Customers
![Page 4: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/4.jpg)
©Continuent 2013
What’s Your Plan?
• Local failover
• Disaster recovery
• Multiple datacenters
• Erroneous SQL statements
4
![Page 5: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/5.jpg)
©Continuent 2013
Sources of Instability
• Network instability
• DNS outages
• Hardware degradation and failure
• Memory management
• System administration
5
![Page 6: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/6.jpg)
©Continuent 2013
Keeping It Local
6
![Page 7: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/7.jpg)
©Continuent 2013
What is a Dataservice?
7
• Encapsulate data availability as a service
• React to changes in system status with automatic failover
• Role based access to database servers
• Provide connectivity to the master
• Optionally connect to a slave for reads
![Page 8: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/8.jpg)
©Continuent 2013 8
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
![Page 9: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/9.jpg)
©Continuent 2013
Keeping It Local
9
![Page 10: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/10.jpg)
©Continuent 2013
Keeping It Local
10
![Page 11: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/11.jpg)
©Continuent 2013
Keeping It Local
11
![Page 12: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/12.jpg)
©Continuent 2013
Keeping It Local
12
• Di!erent connectivity options
• Limit writes to a single server at any time
• Splitting writes introduces inconsistency
• Continuent Tungsten automatically promotes a master and sends tra"c there
![Page 13: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/13.jpg)
©Continuent 2013
Data Overload
• Promote sharding to support extra large data sets
• Support parallel replication in Q4 2013
• Single customer is supporting ~300TB across 30 Continuent Tungsten dataservices
13
![Page 14: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/14.jpg)
©Continuent 2013
Going Global
14
![Page 15: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/15.jpg)
©Continuent 2013
Going Global
15
![Page 16: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/16.jpg)
©Continuent 2013
Going Global
16
![Page 17: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/17.jpg)
©Continuent 2013
Going Global
17
![Page 18: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/18.jpg)
©Continuent 2013
Going Global
18
![Page 19: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/19.jpg)
©Continuent 2013
Going Global
19
• Primary/DR replication allows for backup datacenter without application changes
• True multi-master replication allows for large distributed systems
• Must account for eventual consistency in the application
• Local failover can reduce the e!ects of a single server outage on the global system
![Page 20: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/20.jpg)
©Continuent 2013
When Replication Works Too Well
• Replication applies all events, even the ones you don’t want
• Delayed replication
• Filtered replication
• Point In Time Recovery (PITR)
20
![Page 21: Using Continuent Tungsten to Survive MySQL Failures...Using Continuent Tungsten to Survive MySQL Failures Je! Mace, Director of Professional Services ©Continuent 2013 Introduction](https://reader033.vdocuments.us/reader033/viewer/2022060602/605637377a5dd318c934a419/html5/thumbnails/21.jpg)
©Continuent 2013
Questions?
21