Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
Does your company/department have a disaster recovery plan?
Submit
Yes
No
I don’t know
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 7):
  • Yes (43%, 3 Votes)

  • No (57%, 4 Votes)

  • I don’t know (0%, 0 Votes)

10 blog posts in 13 categories

Galera Cluster Recovery 101 - A Deep Dive into Network Partitioning

Galera automatic node provisioning and membership control simplifies database cluster operation and improves the reliability of its replication technology. In this blog post, we are diving into the Galera recovery process in events where network partitioning happens.

How to Recover MySQL Galera Cluster from an Asynchronous Slave?

What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?

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?

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.

Become a PostgreSQL DBA: Point-in-Time Database Restoration

In this blog post,  we describe how to perform point-in-time recovery in PostgreSQL

Several Ways to Intentionally Fail or Crash your MySQL Instances for Testing

This blog post features some ideas (with examples) on how to crash a MySQL server in a Linux environment.

Updated - How to Bootstrap MySQL or MariaDB Galera Cluster

Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL or MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. This process is known as cluster bootstrap. Bootstrapping is an initial step to introduce a database node as primary component, before others see it as a reference point to sync up data.

Posted in:

Become a MongoDB DBA: Recovering your Data

This is our sixth post in the “Become a MongoDB DBA” blog series - how do you recover MongoDB using a backup.

Webinar Replay & Slides: Repair & Recovery for Your MySQL, MariaDB & MongoDB / TokuMX Clusters

Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again and browse through the slides, they are now available online.

Posted in:

Point-in-time Recovery in MySQL Galera Cluster

Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day. Clustering and replication are techniques that provide protection against failures, but what if a user or DBA issues a detrimental command against one of the databases? A user might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway. How do we recover lost data?