To replicate your hosted MySQL tables Alooma needs row-based replication to be set up to be able to read your MySQL events.
- Verify that your binlog is configured by running the statement below - the value returned should be
mysql> SHOW GLOBAL VARIABLES LIKE 'binlog_format';
- Verify that your binlog row format is set to
mysql> SHOW GLOBAL VARIABLES LIKE 'binlog_row_image';
- Verify that your log slave updates option is set to
mysql> SHOW GLOBAL VARIABLES LIKE 'log_slave_updates';
If your MySQL is not currently set to row based replication, you'll need to set it up.
- Include the following lines in your
/etc/mysql/). The sample below is for a "vanilla" MySQL 5.6 installation:
[mysqld] log-bin=mysql-bin server-id=1 binlog_format = ROW log-slave-updates=true
- Make sure to restart your MySQL server to pick up the changes.
- Create an Alooma user, similar to the MySQL slave user:
mysql> CREATE USER 'alooma'@'%' IDENTIFIED BY 'YOUR_PASSWORD'; mysql> GRANT REPLICATION SLAVE, SELECT, RELOAD, REPLICATION CLIENT,
LOCK TABLES, EXECUTE ON *.* TO 'alooma'@'%'; mysql> FLUSH PRIVILEGES;
That's it, you're ready to continue to connecting to MySQL.