Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

HAProxy: All the Severalnines Resources

This blog aggregates all the great resources we have created to help you understand, deploy, and maximize the potential of HAProxy load balancing technology.

HAProxy Connections vs MySQL Connections - What You Should Know

Max connections determines the maximum number of connections to the database server. This can be set on both the database server, or the proxy in front of it. In this blog post, we’ll dive into HAProxy and MySQL maximum connections variables, and see how to get the best of both worlds.

Posted in:

Webinar Replay and Q&A: how to deploy and manage ProxySQL, HAProxy and MaxScale

This blog provides details for the replay of our webinar on how to deploy and manage ProxySQL, HAProxy and MaxScale, as well as answers to the questions asked during this session.

Percona Live 2017 - Severalnines Recap

This blog contains a recap of Severalnines participation the Percona Live 2017 Open Source Database Conference including videos and slides from our sessions.

Schema changes in Galera cluster for MySQL and MariaDB - how to avoid RSU locks

This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.

Posted in:

ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or MaxScale.

All the Webinar Replays for the MySQL, MongoDB or PostgreSQL DBA

This blog provides an overview and links to our different webinar replays and blog series for the MySQL, MariaDB, Percona, MongoDB and PostgreSQL DBA.

Sign up for our free whitepaper: MySQL Replication Blueprint

This whitepaper includes all aspects of a MySQL replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

Posted in:

New Whitepaper: MySQL Replication Blueprint

MySQL Replication Blueprint whitepaper - this includes all aspects of a Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

Posted in:

Pages