Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a server’s binary log and usually writes “changelogs” that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote data source, or to any other place of your liking.  You can find out more about FlexCDC basics in a previous blog post.

Please note that FlexCDC still needs to have source and destination instances defined in the configuration, even when using plugins.  This is because the FlexCDC state (how much into …

Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a server’s binary log and usually writes “changelogs” that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote data source, or to any other place of your liking.  You can find out more about FlexCDC basics in a previous blog post.

Please note that FlexCDC still needs to have source and destination instances defined in the configuration, even when using plugins.  This is because the FlexCDC state (how much into which …

I am happy to announce the GA release of Flexviews. I've numbered the release 1.7.0 GA.
There are a small number of bug fixes and enhancements:

• 
  
• Fixes for views which have aggregate functions but no GROUP BY expressions could have had problems during incremental update.
  
• GA support for all aggregate functions except GROUP_CONCAT and AVG(distinct).
  
• The PERCENTILE_XX (ie PERCENTILE_90 for a 90th percentile calculation) is now stable too
  

FlexCDC got a number of fixes and improvements:

• 
  
• TIMESTAMP columns are now properly supported
  
• Now mysqlbinlog errors are detected, and the program exits gracefully
  
• FlexCDC now logs to a log file instead of writing to STDOUT/STDERR
  
• There are new PHP scripts for adding and removing table changelogs …

I am happy to announce the GA release of Flexviews. I've numbered the release 1.7.0 GA.
There are a small number of bug fixes and enhancements:

• 
  
• Fixes for views which have aggregate functions but no GROUP BY expressions could have had problems during incremental update.
  
• GA support for all aggregate functions except GROUP_CONCAT and AVG(distinct).
  
• The PERCENTILE_XX (ie PERCENTILE_90 for a 90th percentile calculation) is now stable too
  

FlexCDC got a number of fixes and improvements:

• 
  
• TIMESTAMP columns are now properly supported
  
• Now mysqlbinlog errors are detected, and the program exits gracefully
  
• FlexCDC now logs to a log file instead of writing to STDOUT/STDERR
  
• There are new PHP scripts for adding and removing table changelogs …

Available immediately Flexviews 1.6.0-RC2.

This release is a bugfix release.  This is the second Flexviews release candidate.  If no major bugs are discovered the next release will be the GA release.

Flexviews is a stored procedure managed materialized view system for MySQL 5.1 or greater. 

What is fixed in Flexviews 1.6.0-RC2?

• Numerous performance fixes. 
  • Flexviews uses fewer temporary tables and subqueries
  • A full table scan of the view is no longer required (only changed GB keys are scanned)
  • Dead code has been removed
• Bug fixes
  • Removing tables and adding them to a view again could result in the WHERE clause being generated in the wrong order
  • Fix a problem with applying deltas to views which use PERCENTILE …

Whats new in Flexviews 1.6.0RC1

• This is the first release candidate before the final release.  If no major bugs are uncovered, then the next release will be the first GA release. 
• Flexviews now has a test suite for all major features.  The creation of these tests uncovered a number of issues which have been resolved in this release. 
• All MySQL aggregate functions except GROUP_CONCAT are now supported. 
• A special aggregate function called PERCENTILE is now also supported.  The calculation uses a modified version of the GROUP_CONCAT based solution suggested by Roland Bouman for percentiles.  This function should be considered experimental.  Please report bugs if you find any.
• You can add indexes to enabled materialized views using SQL_API/add_expr
• Adding PRIMARY KEY indexes is no longer …