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

Formale Metadaten

Titel
Painless MySQL HA, Scalability and Flexibility With Ansible, MHA and ProxySQL
Untertitel
Building a test environment from scratch in 5 minutes
Serientitel
Anzahl der Teile
611
Autor
Lizenz
CC-Namensnennung 2.0 Belgien:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache
Produktionsjahr2017

Inhaltliche Metadaten

Fachgebiet
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