Primary-Initiated Replication

[benbjohnson]

A comment on HN had an interesting idea of having the primary walled off from the other nodes and having the primary reach out to replicas instead of replicas connecting to the primary. It could provide security benefits as the primary node(s) could have tighter firewall controls.

[veramine]

I think this is a great idea! We want to give customers direct access to data and we do this today by sending json to kinesis/s3/syslog/etc, the usual places. Customers then parse the json and write into a database on their end. It would be cool to replicate a sqlite database to them directly but of course we can't let them connect into our prod network. It'd be slick to push a live replicated sqlite database to them. In this use case, the replicants never need to become the master and we wouldn't be using it for disaster recovery. It would just be a convenient way to push read-only data out to arbitrary places.