Webinar Replay & Slides: Become a MySQL DBA - Designing High Availability for MySQL

Twitter icon
Facebook icon

Thanks to everyone who joined us yesterday for this live session on designing HA for MySQL led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.

Become a MySQL DBA blog series - Database upgrades

Twitter icon
Facebook icon

In this blog post, we will cover one of the most basic tasks of the DBA - minor and major database upgrades. This is the sixth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include Replication Topology Changes, Schema Changes, High Availability, Backup & Restore, Monitoring & Trending.

How to Avoid SST when adding a new node to Galera Cluster for MySQL or MariaDB

Twitter icon
Facebook icon

SST can be painful in some occasions, as it can block the donor node (with SST methods like mysqldump or rsync) and burden it when backing up the data and feeding it to the joiner. For a dataset of a few hundred gigabytes or more, the syncing process can take hours to complete - even if you have a fast network. It might be advisable to avoid e.g. when running in WAN environments with slower connects and limited bandwidth, or if you just want a very fast way of introducing a new node in your cluster.

s9s Tools and Resources: The 'Become a MySQL DBA' Series, ClusterControl 1.2.10, Advisors and More!

Twitter icon
Facebook icon

Check Out Our Latest Technical Resources for MySQL, MariaDB, Postgres and MongoDB. This blog is packed with all the latest resources and tools we’ve recently published! Please do check it out and let us know if you have any comments or feedback.

Become a MySQL DBA - Webinar series: Which High Availability Solution?

Twitter icon
Facebook icon

There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and DBAs almost always have to choose a trade-off between high-availability and cost. In this webinar, we will look at some of the most widely used HA alternatives in the MySQL world and discuss their pros and cons.

Webinar Replay & Slides: Become a MySQL DBA - Deciding on a relevant backup solution

Twitter icon
Facebook icon

Thanks to everyone who joined us last week for this live session on backup strategies for MySQL and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online via the links below.

Watch the replay

Become a MySQL DBA blog series - Common operations - Replication Topology Changes

Twitter icon
Facebook icon

This is the fifth installment in the ‘Become a MySQL DBA’ blog series, and discusses one of the most common operations a DBA has to handle - replication topology changes and planned failover. Our previous posts in the DBA series include Schema Changes, High Availability, Backup & Restore, Monitoring & Trending.

Deploying Galera Cluster for MySQL using Vagrant

Twitter icon
Facebook icon

Vagrant is a system that allows you to easily create and move development environments from one machine to another. Simply define what type of VM you want in a file called Vagrantfile and then fire them up with a single command. It integrates well with virtual machine providers like VirtualBox, VMware and AWS. In this blog, we’ll show you how to expedite the deployment of your development environment using some Vagrant boxes we’ve put together.

Become a MySQL DBA blog series - Common operations - Schema Changes

Twitter icon
Facebook icon

This is the fourth installment in the 'Become a MySQL DBA' series, and discusses the different approaches to schema changes in MySQL. Our previous posts in the DBA series include High Availability, Backup & Restore and Monitoring & Trending.

Become a MySQL DBA - webinar series: deciding on a relevant backup solution

Twitter icon
Facebook icon

Backup and restore is one of the most important aspects of database administration. If a database crashed and there was no way to recover it, any resulting data loss might lead to devastating results to a business. As the DBA operating a MySQL or Galera cluster in production, you need to ensure your backups are scheduled, executed and regularly tested.

There are multiple ways to take backups, but which method fits your specific needs? How do I implement point in time recovery? 

Pages