Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
293 blog posts in 1 category

How to Easily Deploy TimescaleDB

TimescaleDB is based on PostgreSQL, and therefore, supports streaming replication as the primary method of replication. However, PostgreSQL does not come with automatic failover. This can be a problem in a high availability production environment, as manual failover implies prolonged downtime.

The good news is that failover in TimescaleDB can be completely automated in ClusterControl 1.7.2. This blog shows us how to deploy such a setup.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

Announcing ClusterControl 1.7.2: Improved PostgreSQL Backup & Support for TimescaleDB & MySQL 8.0

ClusterControl 1.7.2 includes support for TimescaleDB, MySQL 8.0 and Maxscale 2.2 as well as improved support for PostgreSQL monitoring & backups. It also launches two new features, CC Spotlight (a new search tool) and CMON HA (distributed fault-tolerant controllers).

How to Deploy Open Source Databases - New Whitepaper

Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. In this whitepaper we’ll show you how to install, configure and secure some of the most popular open source DB engines.

Master High Availability Manager (MHA) Has Crashed! What Do I Do Now?

How do I ensure that MHA (Master High Availability Manager) will always perform the failover for me? What would happen if it crashes? This blog post will answer your questions.

High-Performance Telecommunication Projects Driven by ClusterControl

This blog provides a high-level look at databases and the telecommunications industry as well as provides examples of the challenges of three ClusterControl users who are in the space.

MySQL Replication for High Availability - New Whitepaper

This whitepaper covers information about MySQL Replication, with information about the latest features introduced in 5.6, 5.7 and 8.0. There is also a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

Powering Global eCommerce with ClusterControl

eCommerce is a continually growing market, but with the explosive growth comes challenges when managing the databases.  In this blog we look at three of our ClusterControl users and how they have tackled some of these challenges.

How to Deploy Highly Available PostgreSQL with Single Endpoint for WordPress

In this blog, we will learn how to setup Postgres in high availability mode, with a single endpoint for your WordPress service. We’ll also see how ClusterControl can help us manage the failover processes across database and load balancers.

Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN

MySQL Replication is still favored by some organization as it's simple to implement and run. However, in a multi-cloud setup like Google Cloud Platform <–> Amazon Web Services, things can get tedious without proper cluster management, monitoring and observability tools. This blog showcases how to create a secure implementation of cloud <–> cloud replication and how ClusterControl can be used to resolve these impediments.