sharding

Table of contents

• Overview
• Preparation of the shards (MariaDB database instances)
• Create test data
• Creating roles and users
• MaxScale Monitor User
• MaxScale Admin User
• Create application role and accounts

Inhaltsverzeichnis

• Übersicht
• Vorbereitung der Shards (MariaDB Datenbank Instanzen)
• Testdaten erstellen
• Rollen und User erstellen
• MaxScale Monitor User
• MaxScale Admin User
• Applikationsrolle und Accounts erstellen

As already mentioned earlier, we roughly have a hand full of customers which are playing with the though of sharding solutions. They typically have many different customers (clients, tenants) and the number of customers becomes so huge (thousands to millions) that one machine cannot cope with the load any more.