Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

How to Get Started with Open Source Database Management - Tips & Tricks from an Expert

This blog post presents tips & tricks helpful for getting started with and managing an open source database.

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:

ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts with global access rights, or accounts without password. Using ClusterControl, you can at any time perform a security audit.

Ten Tips on How to Achieve MySQL and MariaDB Security

This blog gives you 10 suggestions on how to improve the security of your MySQL or MariaDB installations.

PostgreSQL Load Balancing Using HAProxy & Keepalived

Promoting a new master server and failing over slaves sounds good, but your applications will need an easy way to keep track of the new master. That’s where HAProxy comes in. This blog post describes how to deploy HAProxy on top of your PostgreSQL replication setup.

Performing Replication Topology Changes for PostgreSQL

Database replication setups are rarely static. Servers can fail, the operating system or the database software might need to be upgraded. This means reshuffling server roles and moving replication links, while maintaining data consistency across all databases. This post explains how to perform these topology changes in PostgreSQL, while ensuring data consistency.

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

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

Deploying & Managing MySQL NDB Cluster with ClusterControl

This blog details ClusterControl support for MySQL NDB Cluster and its recent support for version 7.5.

Pages