MySQL Router tutorial

The MySQL Router Operator delivers automated operations management from day 0 to day 2 on the MySQL Router Community Edition lightweight middleware that provides transparent routing between your application and back-end MySQL Servers. It is an open source, end-to-end, production-ready data platform component on top of Juju. As a first step this tutorial shows you how to get MySQL Router up and running, but the tutorial does not stop there. Through this tutorial you will learn a variety of operations, everything from adding replicas to advanced operations such as enabling Transport Layer Security (TLS). In this tutorial we will walk through how to:

• Set up an environment using Multipass with LXD and Juju.
• Deploy MySQL Router using a single command.
• Configure TLS certificate in one command.

While this tutorial intends to guide and teach you as you deploy MySQL Router, it will be most beneficial if you already have a familiarity with:

• Basic terminal commands.
• MySQL and MySQL Router concepts.
• Charmed MySQL operator

Step-by-step guide

Here’s an overview of the steps required with links to our separate tutorials that deal with each individual step:

• Set up the environment
• Deploy MySQL Router
• Managing your units
• Enable security
• Cleanup your environment