In my opinion this is the best database concept you can have:
With the help of Patroni you can create a PostgreSQL Cluster that gives high availability. 1/4
#PostgreSQL#Patroni#Database
@BeeKamens@JoeBiden Don't know about you, but you should consider (for your own safety) to censor the address header. Leaking your address on the internet is not the yellow from the egg
🚨 | Theo Pourchaire was asked if he could match Piastri in the same car:
"He's an exceptional racing driver... But I believe I am on his level."
"I just need an opportunity to get into F1."
https://t.co/gm0pYIB18l
@AbhilashShuklaa@stats_feed Vienna almost no traffic? Are you kidding, from where do you pull those statistics? If someone ever was in Vienna driving with the car, they know it's gonna be a shit show
@FanaticsFerrari This dude is running F1 and doesn't know anything about the sport on reality. Free practice is a must for drivers and engineers. Without that safety (what FIA & F1 really like) will be in danger. How come someone like him is running F1?
I am pleased to present the new #Patroni@PostgreSQL#HA release 2.1.5 Noticable changes: fully compatible with @PostgreSQL v15 and declares Etcd v3 support as production ready. Thanks to all users and contributors🐘🐘🐘
cc @hugh_capet@AntsAasma
https://t.co/piVIdHB6oR
@BonesMoses I mean, you can still use vip-manager. If you lay over the floating IP a dns-record with a domain. You could easily use it for the replication to the standby node. Also with VPN it would work
In my opinion this is the best database concept you can have:
With the help of Patroni you can create a PostgreSQL Cluster that gives high availability. 1/4
#PostgreSQL#Patroni#Database
With the cherry on top we monitor all 3 Cluster Nodes in pgwatch2 (made by @PostgresSupport more info: https://t.co/ZVeXr5DDpz) Also I set up 2 Alarms:
- If filesystem is over 90% used
- CPU utilization is over 90%
If one of those alarms occure, i will get notified in Telegram
We also created a single node Patroni cluster in a different datacenter. This one is connected over a replication slot from the Leader in our Main-Cluster. This one is declared as Standby Leader. Basically also only read-only to prevent a split brain. 4/4