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.