How to setup web scalable architecture with MySQL Fabric
summary
MySQL Fabric is presented as a Python framework from MySQL Utilities 1.4 that adds automatic failover and sharding to MySQL using replication groups and a small Fabric store that holds routing metadata. Example: a 100 million row table can be shard 100M→10×10M across servers, splitting index size and read load. Connectors for Java PHP Python and .NET use a connector cache updated by Fabric. The hands‑on uses a seven MySQL instance VM and shows live failover and replication troubleshooting including needing blank transactions to resync replicas.
AI-written summary · about
chapters (21)
- 0:00Intro
- 6:48Functions of MySQL Fabric
- 13:12Data
- 16:33Replication
- 19:42Framework
- 21:22Failover
- 23:35High availability group
- 24:46Defining a group
- 25:31Scaling
- 27:26Summary
- 28:32Architecture
- 31:11Groups
- 31:43Sharding
- 32:25Installation
- 34:11Import
- 36:55Replication Troubleshooting
- 42:28Bootloader
- 44:31Instances
- 48:41Slave status
- 49:36Connect to MySQL
- 51:31Troubleshooting
related talks
26mScaling MySQL with Python
27mDistributed MySQL Architectures: Past, Present and Future
05mMySQL failover with orchestrator and ProxySQL
25mData in the Cloud
32mBest Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions
35mMySQL HA, Recovery and Load Balancing
14mThe State of the Art of MySQL Replication
01h 02mScaling One of the Largest On-prem Managed MySQL Fleets in India