Refresh MaterializedMySQL

[kompetenzlandkarte]

Hi,

I just stumbled upon MaterializedMySQL. After the table got successfully created all data up to this point are accessible.

Is it normal that the tables do not get new data if there are rows inserted in the remote database after the MaterializedMySQL database is created?

If so, is it possible to update the data on a regular basis (like every 5 minutes)?

Clickhouse Server v21.10.2.15

Thank you.

[kompetenzlandkarte]

I had to activate replication on the mysql server to make it work as described in the docs