Here is everything you need to do before creating a MySQL resource.
We support the following MySQL environments:
The Meroxa Platform has been tested against the following MySQL versions:
To setup MySQL, follow these steps:
Before you can add, the MySQL instance needs to be accessible by Meroxa. You may:
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
- (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;
- You are now ready to add your MySQL resource to Meroxa.