BigDBA – Database,Devops,Big Data,Cloud & Oracle Blog

Maintaining uninterrupted database services requires seamless communication between load balancers, health checks, and clustering engines. In enterprise environments running PostgreSQL with Patroni, any breakdown in node discovery or thread execution can bring down read/write operations within seconds. A real-world outage involving HAProxy 2.8 and Keepalived highlights the cr...

If you have ever built a mobile app on Firebase, you already know the appeal: a few SDK calls, and you get authentication, a document database, file storage, and security rules without standing up your own backend. It’s fast, and it feels good while you’re building the first version of your product.

The catch shows up later. Once your company already runs on Oracle ...

Prerequisites
Create an Oracle 19c Container Database named PRIMARYDB running in ARCHIVELOG mode. The database uses both filesystem and ASM storage.

Example layout:

In 1970, E. F. Codd published a paper that asked a quiet but radical question: what if shared data could be organised without depending on the physical tricks of one machine?

Most people who work with databases today never read the original paper. That is understandable. “A Relational Model of Data for Large Shared Data Banks” is not a b...