The v3 Google patch now includes support for row-change logging. The code has a few bugs that we are fixing ASAP but it is ready for testing. There is a talk on the this at the regular conference. We can try it out at the MySQL Hackfest at the (free) MySQL Camp on Monday morning. Row-change logging generates one text line per changed row that describes the change. It is easy to parse and can be used to:
- Maintain a copy of the MySQL table in another RDBMS or in a scalable data structure such as HBase or Hypertable.
- Implement a change notification service.
- Maintain materialized views.