Jump to Navigation
Home

Languages

  • Deutsch
  • English

Search form

  • About us
  • Services
  • Software
  • Resources
  • image

Schemarouter

Sharding with MariaDB MaxScale

Tue, 2024-03-19 17:02 — Shinguz

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
    • Proxy protocol
  • MaxScale SchemaRouter configuration
  • Starting and stopping the MaxScale Load Balancer
  • Application tests
    • Simple application tests
    • New command show shards
    • More general test
    • Less simple tests
    • More complex application tests
    • Cross-shard tests
  • Operation of a MaxScale sharding system …
tags: 
sharding
maxscale
schemarouter
load balancer
multi-tenant
  • Read more about Sharding with MariaDB MaxScale
Subscribe to RSS - Schemarouter

  • About us

    • News
    • About FromDual
    • Contact
    • Partner
    • References
    • Newsletter
    • Press

  • Services

    • Consulting
    • Support
      • MySQL
      • DB Development
    • Remote-DBA
    • Training
      • Training Modules
      • Class Schedule
      • for Developer
      • for Administrators
      • Galera Cluster

  • Software

    • Performance Monitor
    • Ops Center
    • Backup and Recovery Manager
    • MyEnv
    • Download

  • Resources

    • Blog
    • Forum
    • Presentations
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.