Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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. 

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?

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:

How to Make Your MySQL or MariaDB Database Highly Available on AWS and Google Cloud

Cloud environments are popular these days, and they come with a variety of tools to increase availability. In this blog post, we will show you how leverage these to build a highly available MySQL or MariaDB database. This blog post makes use of Amazon Web Services and Google Cloud Platform.

Capacity Planning for MySQL and MariaDB - Dimensioning Storage Size

How much storage should we allocate to the database depends on how fast the database is expected to grow. It sounds like a simple question to answer, but there are a number of factors to consider before we can come up with an accurate answer. This blog post gives you some tips on how to plan and dimension storage size for your MySQL and MariaDB servers in production.

Posted in:

Webinar Replay: How to Design Open Source Databases for High Availability

Watch this webinar replay on how to design open source databases for high availability. From discussing high availability concepts through to failover or switch over mechanisms, we cover all the need-to-know information when it comes to building highly available database infrastructures.

Posted in:

Pages