Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
Does your company/department have a disaster recovery plan?
Submit
Yes
No
I don’t know
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 9):
  • Yes (44%, 4 Votes)

  • No (56%, 5 Votes)

  • I don’t know (0%, 0 Votes)

543 blog posts in 13 categories

Top PostgreSQL Security Threats

This blog details some of the most recent security threats to PostgreSQL and some tips and resources to keep your data secure.

PostgreSQL Management and Automation with ClusterControl - New Whitepaper

This whitepaper provides an overview of what it takes to configure and manage a PostgreSQL production environment and shows how ClusterControl provides PostgreSQL automation in a centralized and user-friendly way.

Posted in:

Understanding Deadlocks in MySQL & PostgreSQL

Anyone who has written applications on top of MySQL or PostgreSQL probably has had to deal with concurrency problems at some point. This blog focuses on issues around database deadlock, a situation in which two or more transactions are waiting for one another to give up locks.

Cloud Disaster Recovery for MariaDB and MySQL

This blog is a handy survival guide for MySQL & MariaDB (cloud) disaster recovery and how to survive datacenter failures.

MongoDB Chain Replication Basics

This blog provides a high level introduction to chain replication for MongoDB.

Setting up HTTPS on the ClusterControl Server

SSL is an important part of securing your ClusterControl installation. This blog post discusses HTTPS settings for ClusterControl and how to utilize them.

Updated: Become a ClusterControl DBA: Safeguarding your Data

So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last case is already covered by ClusterControl. When you add a new (replica) node to your replication setup, ClusterControl will make a backup/snapshot of the master node and use it to build the replica. 

A Guide to PGpool Part Three - Hints & Observations

Pgpool is a useful piece of software for connection pooling and load balancing. This is part three of the blog, which provides additional hints & observations by its author Vladimir Svedov to round up this topic.

My MySQL Database is Corrupted... What Do I Do Now?

Performing regular database backups is imperative for any production system. Usually when MySQL data gets corrupted, the recommendation is to restore it from the last backup, switch to DR server or take down the affected node down, if you have a cluster, to serve data immediately from other nodes. In some cases you can't - if the backup is not there, the cluster was never set up, your replication is down for a very long time, or the DR procedure was never tested.

Deploying Cloud Databases with ClusterControl 1.6

ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. This blog post shows you how.