Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
8 blog posts in 12 categories

Benchmarking Managed PostgreSQL Cloud Solutions - Part One: Amazon Aurora

A multi-part series of articles on PostgreSQL benchmarking in the cloud. Part one is an overview of available benchmarking tools for PostgreSQL followed by testing Amazon Aurora PostgreSQL based on the Amazon Guide for Benchmarking PostgreSQL.

How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime

Database migrations are a pain. They often require maintenance windows and can be a cause of downtime. In this blog, we will see how we can migrate a MySQL database from Amazon EC2 to an on-premise datacenter without any downtime whatsoever.

An Overview of Amazon RDS & Aurora Offerings for PostgreSQL

This provides an overview and tips & tricks for running PostgreSQL on Amazon RDS and Aurora.

MySQL in the Cloud - Online Migration from Amazon RDS to your own server (part 2)

It's challenging to move data out of RDS for MySQL. We will show you how to do the actual migration of data to your own server, and redirect your applications to the new database without downtime.

MySQL in the Cloud - Online Migration from Amazon RDS to EC2 instance (part 1)

RDS for MySQL is easy to get started. It's a convenient way to deploy and use MySQL, without having to worry about any operational overhead. The tradeoff though is reduced control.

MySQL in the Cloud - Pros and Cons of Amazon RDS

Moving your data into a public cloud service is a big decision. All the major cloud vendors offer cloud database services, with Amazon RDS for MySQL being probably the most popular. In this blog, we’ll have a close look at what it is, how it works, and compare its pros and cons.

Infrastructure Automation - Deploying ClusterControl and MySQL-based systems on AWS using Ansible

This blog post has the latest updates to our ClusterControl Ansible Role. It now supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster).

Data Warehouse in the Cloud - How to Upload MySQL data into Amazon Redshift for reporting and analytics

The term data warehousing often brings to mind things like large complex projects, big businesses, proprietary hardware and expensive software licenses. With Hadoop came open source data analysis software that ran on commodity hardware, this helped address at least some of the cost aspects. We had previously blogged about MongoDB and MySQL to Hadoop. But setting up and maintaining a Hadoop infrastructure might still be out of reach for small businesses or small projects with limited budgets. Well, perhaps then you might want to have a look at Redshift.