Categories
Products
Technologies
Top Rated docs

March 25, 2020

Database Load Balancing on Google Cloud Platform (GCP) Using HAProxy

Using a Load Balancer is a good idea for any database technology, as you can redirect applications to the available or healthy database nodes and even distribute the traffic across multiple servers to improve performance....

March 24, 2020

How to Restore a Single Table Using Percona Xtrabackup?

Backups are the means of protecting from data loss - should something happen, you can easily restore it from the backup. You cannot predict what part of the data will have to be restored -...

March 20, 2020

Multi-DC PostgreSQL: Setting Up a Standby Node at a Different Geo-Location Over a VPN

Previously, we wrote about Setting Up a Geo-Distributed Database Cluster Using MySQL Replication. This time, it's about PostgreSQL. Setting up a geo-distributed cluster for PostgreSQL is not a new concept and the topology is quite...

March 16, 2020

How to Install and Configure MaxScale for MariaDB

There are different reasons for adding a load balancer between your application and your database. If you have high traffic (and you want to balance the traffic between different database nodes) or you want to...

March 9, 2020

How to Rebuild an Inconsistent MySQL Slave?

MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. Setting super_read_only and using row-based replication can help a lot, but no matter what you do, it is still possible...

March 6, 2020

How to Easy Manage Database Updates and Security Patches

Database security requires careful planning, but it is important to remember that security is not a state, it is a process. Once the database is in place, monitoring, alerting and reporting on changes are an...

March 5, 2020

Setting Up a Geo-Distributed Database Cluster Using MySQL Replication

A single point of failure (SPOF)  is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity...

March 3, 2020

How to Enable TimescaleDB on an Existing PostgreSQL Database

If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with time (like metrics collected from a system) you should consider using a time-series database that is designed to store...

March 2, 2020

How to Rebuild an Inconsistent PostgreSQL Slave

PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them. As with every replication, the idea is that the slave is a copy of the master...

February 27, 2020

What to Look for if Your PostgreSQL Replication is Lagging

PostgreSQL is designed to handle multiple threads, such as query parallelism, or deploying worker threads to handle specific tasks based on the assigned values in the configuration. But, sometimes replication lag  and other issues can...

February 21, 2020

What to Check if MySQL Memory Utilisation is High

MySQL Enterprise Monitor is dead, let us help you determine your next move! One of the key factors of a performant MySQL database server is having good memory allocation and utilization, especially when running it...

February 12, 2020

What to Look for if Your MySQL Replication is Lagging

A master/slave replication cluster setup is a common use case in most organizations. Using MySQL Replication enables your data to be replicated across different environments and guarantees that the information gets copied. It is asynchronous...

Subscribe below to be notified of fresh posts