Sharding: Sharding means scale out. Each node runs MySQL instance. Data is partitioned across all nodes. Sharding key is used to distribute data across nodes. Example of sharding: Each customer store data in their own schema MySQL instance per customer OS instance / container per customer Environment per customer includes database server Application server and required components Ref: MySQL Proxy SQL - http://www.proxysql.com/blog MariaDB MaxScale - https://mariadb.com/products/technology/maxscale ScaleArc - http://www.scalearc.com/how-it-works/performance-features/query-routing MySQL Router - https://www.mysql.com/products/enterprise/router.html MySQL Fabric - https://www.percona.com/blog/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/ https://downloads.mysql.com/docs/fabric-1.5-en.pdf Explore Sharding and commonly used solution for MySQL sharding: https://severalnines.com/blog/database-sharding-how-does-it-work https://www.clustrix.com/bettersql/challenges-shardin...
Welcome to explore technology about Kubernetes, MySQL, Machine Learning | Deep Learning - Shrenik Parekh