Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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: Adding Additional Nodes To a Replication Setup

Master-slave replication setups can be very useful, as they provide multiple copies of the data for high availability or for scale out purposes. Master slave replication setups can be ver useful as they provide multiple copies of the data from a redundancy perspective., We will show you how to add nodes to an existing PostgreSQL replication setup using ClusterControl.

What’s New With MySQL Replication in MySQL 8.0

This blog will introduce you to the changes that are occurring in MySQL replication in the newest edition of MySQL 8.0.

Posted in:

What's New with ProxySQL in ClusterControl v1.4.2

We showcased some of the significant changes around ProxySQL on ClusterControl 1.4.2.

Posted in:

MySQL Tutorial - Troubleshooting MySQL Replication Part 2

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.

MySQL Tutorial - Troubleshooting MySQL Replication Part 1

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.

Video: 9 Tips to Building a Stable MySQL Replication Environment

This video walks you through nine tips you should consider when deploying and managing a MySQL Replication environment and how utilizing ClusterControl can help make deploying, managing, monitoring, and scaling MySQL easy.

Posted in:

MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.

Video: MySQL Replication & ClusterControl Product Demonstration

This video gives you a walkthrough of the features and functions available to you in ClusterControl for MySQL Replication

Posted in:

How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4

MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment.  ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.

Posted in:

Pages