We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Painless MySQL HA, Scalability and Flexibility With Ansible, MHA and ProxySQL

Formal Metadata

Title
Painless MySQL HA, Scalability and Flexibility With Ansible, MHA and ProxySQL
Subtitle
Building a test environment from scratch in 5 minutes
Title of Series
Number of Parts
611
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2017

Content Metadata

Subject Area
Genre
Abstract
DAMP: Docker is the component that makes the whole environment portable (onlybash and Docker needed to set it up) Ansible is an agentless config managementsystem that makes the whole setup automated and painless ProxySQL is a risingstar on MySQL's horizon giving full control to DBAs over queries before theyhit the DBs. MHA is an proven MySQL HA solution that's easily customizable My aim with this demo/repo is to show people how easy to set up a testenvironment with to test a really good MySQL HA/Proxy solution. Attendees will gain insight into how to leverage Ansible plays to automatemany tasks for managing a highly available MySQL environment with the abilityof read/write split, load balancing, on-the-fly query rewrite(ProxySQL). We'regoing to demonstrate scenarios like: \- Building HA environment in 3 minutes\- ProxySQL auto dynamic config generation with Ansible \- failover withoutlosing a single SELECT A fully working Ansible playbook will be available for the attendees runningin Docker