Materialize v0.91 - Materialize

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
mzsql
```
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.

bash

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.