you can't do multi-region failover with mysql either.
btw. multi-region postgres is also not that easy either.
i think the easiest solution would probably to maintain multiple clusters and put something in front of them, like pgpool and write to them simulatiously.
if one write fails rollback all clusters. and hope the read replica of cluster x will take over.
probably something like pgpool + postgres cluster on k8s(zalando, crunchy).
at the moment there is no ledger that can span multiple regions. so your on your own for that.
if people really need multi-region they should probably just buy citus data.
i think the easiest solution would probably to maintain multiple clusters and put something in front of them, like pgpool and write to them simulatiously.
if one write fails rollback all clusters. and hope the read replica of cluster x will take over. probably something like pgpool + postgres cluster on k8s(zalando, crunchy).
at the moment there is no ledger that can span multiple regions. so your on your own for that.
if people really need multi-region they should probably just buy citus data.