Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
17 blog posts in 1 category

Understanding Deadlocks in MySQL & PostgreSQL

Anyone who has written applications on top of MySQL or PostgreSQL probably has had to deal with concurrency problems at some point. This blog focuses on issues around database deadlock, a situation in which two or more transactions are waiting for one another to give up locks.

Posted in:

My MySQL Database is Corrupted... What Do I Do Now?

Performing regular database backups is imperative for any production system. Usually when MySQL data gets corrupted, the recommendation is to restore it from the last backup, switch to DR server or take down the affected node down, if you have a cluster, to serve data immediately from other nodes. In some cases you can't - if the backup is not there, the cluster was never set up, your replication is down for a very long time, or the DR procedure was never tested.

How to Overcome Accidental Data Deletion in MySQL & MariaDB

Someone accidently deleted part of the database, or forgot to include a WHERE clause in a DELETE query, or dropped the wrong table. Things like that may and will happen, it is inevitable and human. But the impact can be disastrous. What can you do to guard yourself against such situations, and how can you recover your data?

How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl

Point-in-Time recovery of MySQL & MariaDB involves restoring the database from backups prior to the target time, then uses incremental backups and the binlog to roll the database forward to the target time. This blog provides an overview of this new ClusterControl feature.

Posted in:

Comparing Database Proxy Failover Times - ProxySQL, MaxScale and HAProxy

This blog describes the failover and switchover operations executed by ClusterControl, and compares failover times when using ProxySQL, MaxScale and HAProxy.

Migrating from MySQL to PostgreSQL - What You Should Know

This blog provides a high level overview of what you need to know if you are considering migrating your database from MySQL to PostgreSQL.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Posted in:

MySQL vs MariaDB vs Percona Server: Security Features Comparison

This blog post compares MySQL Community with Percona Server and MariaDB regarding their security features.

Posted in:

New Video - Ten Tips to Secure MySQL & MariaDB

This video details ten basic things you can do to ensure that your MySQL or MariaDB instances are secure.

Posted in:

MySQL on Docker - How to Containerize Your Database - New Whitepaper

This whitepaper covers the basics you need to understand when considering running a MySQL service on top of Docker container virtualization.

Pages