Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Ten Tips for Going into Production with PostgreSQL

This blog provides tips & tricks for going into production with PostgreSQL.

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.

How to Achieve GDPR Compliance: Documenting Our Experience (II)

The journey to compliance continues with Severalnines & the European Union’s General Data Protection Regulation (GDPR).

Posted in:

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore, study, learn, or otherwise manipulate data sets.

Capacity Planning for MySQL and MariaDB - Dimensioning Storage Size

How much storage should we allocate to the database depends on how fast the database is expected to grow. It sounds like a simple question to answer, but there are a number of factors to consider before we can come up with an accurate answer. This blog post gives you some tips on how to plan and dimension storage size for your MySQL and MariaDB servers in production.

Posted in:

New Whitepaper: How to Design Highly Available Open Source Database Environments

Download our new whitepaper on how to design highly available open source database environments. It discusses the requirements for high availability in database setups, and how to design the system from the ground up.

Posted in:

New Webinar: How to Measure Database Availability

Join us on April 24th for Part 2 of our database high availability webinar special. In this session we will focus on how to measure database availability. It is notoriously hard to measure and report on, although it is an important KPI in any SLA between you and your customers. We will discuss the different factors that affect database availability and see how you can measure your database availability in a realistic way.

Posted in:

PostgreSQL Privileges and Security - Locking Down the Public Schema

This blog details schema privileges and locking down the public schema for PostgreSQL.

Comparing Replication Solutions from Oracle and MySQL

In this post, we are going to compare Oracle 12c logical replication with MySQL 5.7. Both technologies offer reliable standby systems to offload production workload and help in case of disaster. We will take a look at their architectures, analyze pros and cons and go through the steps on how to set them up.

Posted in:

Webinar Replay: How to Design Open Source Databases for High Availability

Watch this webinar replay on how to design open source databases for high availability. From discussing high availability concepts through to failover or switch over mechanisms, we cover all the need-to-know information when it comes to building highly available database infrastructures.

Posted in: