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
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,
DELETE statements would be subject to a
wildly different set of SQL semantics than
Symbiosis mode is only suitable for development. It is likely to be extremely slow and inefficient on large data sets.