top | item 29114696

(no title)

earless1 | 4 years ago

> The pattern also puts an additional burden on the database. Therefore, we should consider the potential performance hit on the database

Massive understatement, one of the downsides that we've found with this pattern is the increase increase in binlog size for our database replication topology. One must be very careful with this pattern as to not create downstream issues with replication delay and such.

If taking advantage of this pattern in MySQL land, you should look into filtered replication to avoid this outbox table from being copied to every single replica. https://dev.mysql.com/doc/refman/5.7/en/change-replication-f...

discuss

order

No comments yet.