Devops and Release Canaries with Linux, CloudStack and MySQL Cluster

James Briggs, Software Developer/DBA/Devops

http://jbriggs.com/blog/

James Briggs

Agenda

T-mobile HBS Project Goal

How Does CD Work?

Generic MySQL Cluster Architecture

T-mobile HBS Architecture for Continuous Deployment

What is Chef?

How Does Chef Work?

What is CloudStack?

More about CloudStack

Linux

What is Liquibase?

What is MySQL Cluster?

Why MySQL Cluster?

Why Not MySQL Cluster?

InnoDB vs. NDB

Getting Ready for MySQL Cluster

Managing MySQL Cluster

ndb_mgm show command

ndbtop

Query Tuning on MySQL Cluster

MySQL Cluster Security

Is MySQL Cluster HA?

MySQL Cluster Bugs Encountered

SeverityBug IDTitle7.3.37.3.47.3.5Workaround
P117591531ERROR ON DROP INDEX WHEN REFERENCING FOREIGN KEYSYFixed?Fixed?Be more organized
P318082045TESTFK CREATE DROP WITH DATA NEED HIGH MAXNOOFCONCURRENTSCANS AND MAXNOOFLOCALSCANSYYFixed?don't use FKs
P1SR3-8717994851 / #69008Drop database not working in presence of foreign key (regression) (30 panics)Y (Repro)??don't drop db/views
P1SR3-8764672731error 4547 'RecordSpecification has overlapping offsets' (1 panic)Y??don't use FKs?
P3SR3-8341340621 / SR3-8457669401cascading delete doesn'tWONTFIXWONTFIXWONTFIXprune cascading
P3SR3-8427228251excessive DNS lookups cause DoSY??use numeric IP addresses

Excessive DNS Traffic Between MySQL Cluster Nodes

Working with Oracle Support

Recommendations for Chef

Recommendations for CloudStack

Recommendations for Liquibase

Recommendations for MySQL Cluster

Project Review

Questions?