Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
323 blog posts in 13 categories

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:

Cloud Disaster Recovery for MariaDB and MySQL

This blog is a handy survival guide for MySQL & MariaDB (cloud) disaster recovery and how to survive datacenter failures.

Posted in:

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

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.

Deploying Cloud Databases with ClusterControl 1.6

ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. This blog post shows you how.

Posted in:

New Webinar on How to Migrate to Galera Cluster for MySQL & MariaDB

Join us May 29th for this webinar on how to migrate to Galera Cluster for MySQL & MariaDB. In this webinar, Severalnines Support Engineer Bart Oles will walk you through what you need to know in order to migrate from standalone or a master-slave MySQL/MariaDB setup to Galera Cluster.

Posted in:

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?

Cloud Database Features Comparison - Amazon RDS vs Google Cloud SQL

As more companies run their workloads in the cloud, cloud database services are increasingly being used manage data. Database services from the leading vendors share many similarities, but they have their own characteristics that may make them well-, or ill-suited to your workload. In this article, we are going to compare the database services from two of the leading cloud vendors - Google Cloud SQL and Amazon RDS for MySQL.

Posted in:

Watch the Webinar Replay: How to Measure Database Availability

Watch Part 2 of our database high availability webinar special. In this session we focus on how to measure database availability. It is notoriously hard to measure and report on, although it is an important KPI in any SLA between you and your customers. We discuss the different factors that affect database availability and see how one can measure database availability in a realistic way.

Posted in:

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:

Pages