Lessons learned while automating MySQL deployments in the AWS Cloud скачать в хорошем качестве

Lessons learned while automating MySQL deployments in the AWS Cloud

Stephane Combaudon (Slice Technologies) delivers his talk, "Lessons learned while automating MySQL deployments in the AWS Cloud", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA. Automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud. But as often, while automation is not too difficult for application code, it is much harder for databases. When we started automating our MySQL servers at Slice, we chose simple and production-proven components: Chef to deploy files, MHA for high availability, Percona XtraBackup for backups. But we faced several problems very quickly: How do you maintain an updated list of MySQL servers in the MHA configuration when servers can be automatically stopped or started? How can you coordinate your servers for them to know that they need to be configured as a master or as a replica? How do you write complex logic with Chef without being trapped with Chef's two pass model? How can you handle clusters with different MySQL versions, or a single cluster where all members do not use the same MySQL version? How can you get reasonable backup and restore time when the dataset is over 1TB and the backups are stored on S3? This session is all about the errors we made and the solutions we found while tackling MySQL automation. Come and share your own war stories!