Crate symbiosis[][src]

Expand description

Symbiosis mode.

In symbiosis mode, Materialize will conjoin with an OLTP database to masquerade as a HTAP system. All DDL statements and writes will be routed to the OLTP database (like CREATE TABLE, INSERT, etc.), while reads will be routed through Materialize. Changes to the tables in the OLTP database are automatically streamed through Materialize.

The only supported OLTP database at the moment is PostgreSQL. Supporting other databases is complicated by the fact that we roughly followe Postgres’s SQL semantics; using, say, MySQL, would be rather confusing, because INSERT, UPDATE, and DELETE statements would be subject to a wildly different set of SQL semantics than SELECT statements.

Symbiosis mode is only suitable for development. It is likely to be extremely slow and inefficient on large data sets.