Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Announcing ClusterControl 1.7.3: Improved Support PostgreSQL & New Cloud Deployment Options

ClusterControl 1.7.3 includes improvements to PostgreSQL support including the ability to run multiple instances on a single host. It also includes support for new point-and-click cloud deployments to the top three cloud providers.

An Introduction to Data Lakes

This blog provides an overview of the Data Lake concept. We’ll go through some of the changes in storing and processing unstructured data and available solutions either on-prem and in the cloud.

Leveraging AWS Tools to Speed up the Management of Galera Cluster on Amazon Cloud

We previously covered basic tuning and configuration best practices for MyQL Galera Cluster on AWS. In this blog post, we’ll go over some AWS features/tools that you may find useful when managing Galera on Amazon Cloud. This won’t be a detailed how-to guide as each tool described below would warrant its own blog post. But this should be a good overview of how you can use the AWS tools at your disposal.

5 Performance Tips for Running Galera Cluster on AWS Cloud

Amazon Web Services is one of the most popular cloud environments. Galera Cluster is one of the most popular MySQL clustering solutions. This is exactly why you’ll see many Galera clusters running on EC2 instances. In this blog post, we’ll go over five performance tips that you need to take under consideration while deploying and running Galera Cluster on EC2.

How to Deploy High Availability CloudStack/CloudPlatform with MariaDB Galera Cluster

Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key requirement. Just as for OpenStack, it is possible to deploy the CloudStack management server in a multi-node installation. Since the management server uses a MySQL database to store the state of all its objects, the database could become a single point of failure. The CloudStack manual recommends MySQL replication with manual failover in the event of database loss. We believe there is a better way.

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.

How to Change AWS Instance Sizes for Your Galera Cluster and Optimize Performance

Running your database cluster on AWS is a great way to adapt to changing workloads by adding/removing instances, or by scaling up/down each instance. At Severalnines, we talk much more about scale-out than scale up, but there are cases where you might want to scale up an instance instead of scaling out.