Skip to main content

MySQL Setup

Here is everything you need to do before creating a MySQL resource.

Environments#

We support the following MySQL environments:

The Meroxa Platform has been tested against the following MySQL versions:

  • 8.x

Setup#

To setup MySQL, follow these steps:

  1. Before you can add, the MySQL instance needs to be accessible by Meroxa. You may:

  2. Enable MySQL's Binary Log (Restart Required) :

In your MySQL Configuration, update the following options:

log_bin           = mysql-binbinlog_format     = ROWbinlog_row_image  = FULLexpire_logs_days  = 10
  1. (Optional) Create a user for Meroxa:

# Create User CREATE USER 'meroxa'@'localhost' IDENTIFIED BY 'supersecret!23';
# Grant PrivalagesGRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'meroxa' IDENTIFIED BY 'supersecret!23';
# FinalizeFLUSH PRIVILEGES;
  1. You are now ready to add your MySQL resource to Meroxa.