Creating Vagrant development machines for MariaDB
summary
Shows how Vagrant automates creation of MariaDB development machines with working examples on GitHub using bootstrap.sh and mariadb.yml (shell + Ansible). Recommends using the same MariaDB minor series (e.g. 10.5.x) and matching variables like sql_mode, charset/collation and query-affecting settings, enabling query and error logs, performance_schema and user statistics. Advises starting with a single VM, preferring VMs or containers to match production, setting memory/CPU in the Vagrantfile and using vagrant.required_version to avoid breakage.
AI-written summary · about
chapters (10)
- 0:00Introduction and speaker intro
- 1:51Good practices overview
- 3:28Virtual machines vs containers
- 4:58MariaDB version and settings
- 7:57Development tools and logs
- 8:24Vagrant file structure
- 11:18Configuring Vagrant providers
- 12:58Provisioners and automation
- 15:27Uploading files to VM
- 17:04Summary and GitHub repo
related talks
54mReproducible and Portable Development Environments with Vagrant
41mDeploying MySQL HA with Ansible and Vagrant
46mBuilding Virtual Development Envrionments with Vagrant
26mDevelopment with Ansible and VMs
50mDeveloping for Drupal 8 with Drupal VM
07mAdvantages of Development Environment Setup with Vagrant
24mTaming Your Inner Cowboy Coder - A Simple And Sane DevOps Workflow
21mSwitching from MySQL/Percona to MariaDB