Deploying MySQL HA with Ansible and Vagrant
summary
A repeatable lab deploys a two‑node MySQL master/slave setup using Vagrant + VirtualBox and Ansible playbooks; inventory groups, roles and templated configs install Percona Server, add repos and packages, and generate unique server IDs. The demo boots two VMs (master and slave) from a local box, runs plays for OS and MySQL setup, then uses streaming xtrabackup initialization to seed the slave and start replication automatically.
AI-written summary · about
chapters (9)
- 0:00MySQL HA introduction
- 2:11Setting up the virtual machine environment
- 10:19Vagrant and VirtualBox config
- 14:12Prerequisites for Ansible
- 21:16Ansible concepts
- 27:47Ansible tasks and roles
- 33:23Ansible modules and templating
- 36:55Deploying MySQL
- 40:48HA setup and Q&A
related talks
26mDevelopment with Ansible and VMs
19mCreating Vagrant development machines for MariaDB
29mGood Practices and Security for your Ansible Automation Platform 2
46mBuilding Virtual Development Envrionments with Vagrant
39mAnsible - Your First Step Into Server Provisioning
36mMake your environment sane with Ansible Automation
23mRunning MySQL on K8s. Deployment, Scaling, Backups and advanced configuration
01h 34mAnsible 101