3 ms·
> "- Streaming Replication (keep a secondary instance for contingency or moving heavy queries away from the main database);" MariaDB/MySQL's replication is als
by daneel_w 4y ago
> "- Streaming Replication (keep a secondary instance for contingency or moving heavy queries away from the main database);"
MariaDB/MySQL's replication is also streamed. It's a continuous stream of replication data over an unbroken connection, for both statement-based and row-based methodologies. The only difference is that Postgres has since long been able to break transactions up into smaller pieces and apply them piecemeal, which is something that didn't show up in MariaDB/MySQL camp until a few years ago when introduced in Galera.