I have a set of tables in MySQL 5.1.5. I pre join those tables and have another set of prejoined tables (bascially different views based on the source tables). I want to update the prejoined tables when ever the source table(s) gets changed.
Iam trying to use the binary log (server started with --binlog-format=row , row based replication) file generated by mysql 5.1.5. The binary log files captures the row level changes in some custom format. Is there any way to read this log file , decode it and know the changes that had been made to the table?
Is there any open API available in MySQL which does this binary log parsing? If yes can any one point me to the same.