hhmx.de

Esk 🐌⚡💜

Esk 🐌⚡💜
@esk@hachyderm.io

· Föderation EN Do 14.11.2024 18:14:22

@renchap awesome! my main hesitation was that our initial replication config was quite slow -- with up to 50 second lag time. after some changes, we've got it down to sub-second which seems much more friendly for a read replica.

we may try flipping to use the REPLICA_* settings as soon as this weekend!

docs.joinmastodon.org/admin/sc

0x   1   0x

Emelia 👸🏻

Emelia 👸🏻
@thisismissem@hachyderm.io

Föderation EN Do 14.11.2024 18:18:28

@esk @renchap iirc, read replica is most useful for Mastodon Web and Streaming, right?

(Though Streaming will soon need write)

0x   1   0x

Renaud Chaput

Renaud Chaput
@renchap@oisaur.com

Föderation EN Do 14.11.2024 18:38:55

@thisismissem @esk Some things in sidekiq also use the replica. We looked at the most expensive and frequent SQL queries that do not *require* the latest data, and manually flagged them to run on the replica.
Also iirc Rails disables the replica if the lag is greater than something like 10 seconds

0x   0   0x