Materialize v0.91

v0.91

Sources and sinks

• Private preview. Add a new MySQL source, which allows propagating change data from MySQL (5.7+) databases in real-time using GTID-based binlog replication.

  Syntax

  CREATE SECRET mysqlpass AS '<MYSQL_PASSWORD>';
  
  CREATE CONNECTION mysql_connection TO MYSQL (
      HOST 'instance.foo000.us-west-1.rds.amazonaws.com',
      PORT 3306,
      USER 'materialize',
      PASSWORD SECRET mysqlpass
  );
  
  CREATE SOURCE mz_source
    FROM MYSQL CONNECTION mysql_connection
    FOR ALL TABLES;
  

  This source is compatible with MySQL managed services like Amazon RDS for MySQL, Amazon Aurora MySQL, Azure DB for MySQL, and Google Cloud SQL for MySQL.

SQL

• Emit a notice if the cluster specified in the connection string used to connect to Materialize does not exist and the specified role does not have a default cluster set.

  NOTICE:  default cluster "quickstart" does not exist
  HINT:  Set a default cluster for the current role with ALTER ROLE <role> SET cluster TO <cluster>.
  psql (15.5 (Homebrew), server 9.5.0)
  Type "help" for help.
  
  materialize=>
  

Bug fixes and other improvements

• Bump the max_connections connection limit to 5000, and enforce it for all users (including superusers).

• Correctly initialize source statistics in mz_internal.mz_sources_statistics when subsources are dropped and recreated using the ALTER SOURCE...{ ADD | DROP } SUBSOURCE command.