Planet MySQL HA Blog
Build Real-Time Data Analytics and Visualization Using Kafka, S3, HeatWave on AWS, and QuickSight
Automating Machine Learning with MySQL HeatWave Service: A Guide for DBAs & Developers
GitOps Journey: Part 4 – Observability and Monitoring with Coroot in Kubernetes
Our PostgreSQL cluster is running, and the demo app is generating traffic — but we have no visibility into the health of the Kubernetes cluster, services, or applications.
What happens when disk space runs out? What if the database is under heavy load and needs scaling? What if errors are buried in application logs? How busy are the network and storage layers? What’s the actual cost of the infrastructure?
This is where Coroot comes in.
GitOps Journey: Part 3 – Deploying a Load Generator and Connecting to PostgreSQL
We’ll deploy a demo application into the Kubernetes cluster using ArgoCD to simulate load on the PostgreSQL cluster.
This is a series of articles, in previous parts we:
- Part 1 - Prepared the environment and installed ArgoCD and GitHub repository.
- Part 2 - Installed Percona Operator for Postgres and created a Postgres cluster.
The application is a custom Go-based service that generates traffic for PostgreSQL, MongoDB, or MySQL.
It uses a dataset of GitHub repositories and pull requests, and mimics real-world operations like…
GitOps Journey: Part 2 – Deploying PostgreSQL with GitOps and ArgoCD
We’re now ready to deploy PostgreSQL 17 using GitOps — with ArgoCD, GitHub, and the Percona Operator for PostgreSQL.
If you’re a DBA, developer, DevOps engineer, or engineering manager, this part focuses on GitOps in action: deploying and managing a real database cluster using declarative infrastructure.
In Part 1, we set up the Kubernetes environment and installed ArgoCD.
Now it’s time to define and launch the PostgreSQL cluster — fully versioned and synced through Git.
GitOps Journey: Part 1 – Getting Started with ArgoCD and GitHub
Welcome to GitOps Journey — a hands-on guide to setting up infrastructure in Kubernetes using Git and automation.
GitOps has gained traction alongside Kubernetes, CI/CD, and declarative provisioning.
You’ve probably seen it mentioned in blog posts, tech talks, or conference slides — but what does it actually look like in practice?
We’ll start from scratch: prepare a cluster, deploy a PostgreSQL database, run a demo app, and set up observability — all managed via Git and GitHub using ArgoCD.
Using replicaSetHorizons in MongoDB
When running MongoDB replica sets in containerized environments like Docker or Kubernetes, making nodes reachable from inside the cluster as well as from external clients can be a challenge. To solve this problem, this post is going to explain the horizons feature of Percona Server for MongoDB.
Let’s start by looking at what happens behind the scenes when you connect to a replicaset URI.
Node auto-discoveryAfter connecting with a replset URI, the driver discovers the list of actual members by running the db.hello() command:
Active-active replication - the hidden costs and complexities
In Part 1 of this series, we discussed what active-active databases are and identified some “good” reasons for considering them, primarily centered around extreme high availability and critical write availability during regional outages. Now, let’s turn our attention to the less compelling justifications and the substantial challenges that come with implementing such a setup.
What are “bad” reasons? 1. Scaling write throughputTrying to scale your write capacity by deploying active-active across regions may sound like a clean horizontal solution, but it is rarely that simple…
New Monitoring Capabilities for MySQL in OCI Database Management
HeatWave MySQL Database Audit
HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats, and maintain detailed records for regulatory requirements. The audit system is easy to set up, supports granular activity tracking, and provides actionable insights directly through the…