Common issues/questions while operating VReplication workflows.
What mysql permissions are needed by VReplication
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'vt_filtered'@'localhost';
Why am I seeing io.EOF errors in my workflow
io.EOFerrors can be difficult to track down. These are usually caused by an issue at the mysql server. Here are some possible reasons
- GTID is not enabled on the server. VReplication requires
permissibleis not supported)
- Permissions are not setup correctly for the vreplication mysql user
- Row-based replication (RBR)
binlog_format=rowis not enabled. Statement-based replication (SBR) is not supported by VReplication
- The mysql server is down or not reachable
What GTID-related options do I need to set in my my.cnf?
log_bin=1 binlog_format=ROW binlog_row_image=full