4 ms·
Continue to enjoy the write ups here by the citus team. Your articles are good primers as well young engineers who may not know how basic database management lo
by wjossey 10y ago
Continue to enjoy the write ups here by the citus team. Your articles are good primers as well young engineers who may not know how basic database management looks like in a production environment.
I have a follow up question from the article. You mention that your HA functionality includes health checks which then trigger auto failover to the replica in the event of six consecutive failures on the master. What's the client experience during that time frame? Would the database cluster be totally unresponsive, or would it be totally transparent so long as it's only a certain number of nodes experiencing issues?
- craigkerstiens 10y agoSo it depends a bit on the failure. If it's the coordinator node you're connected to then everything would be un-responsive. If it's a single distributed node, then only queries targetting that node would fail. Most application frameworks and Postgres drivers do try to reconnect so there wouldn't be a change to application logic, but things during that time would fail as you might expect when a database is down.