Categories
Products
Technologies
Top Rated docs

December 1, 2014

Multi-Source Replication with MariaDB Galera Cluster

MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So it is possible to use a MariaDB Cluster as an aggregator for many single-instance MariaDB...

November 20, 2014

Multi-Source Replication with Galera Cluster for MySQL

Multi-source replication means that one server can have multiple masters from which it replicates. Why multi-source? One good reason is to consolidate databases (e.g. merge your shards) for analytical reporting or as a centralized backup...

November 19, 2014

New ClusterControl User Guide for MySQL-Based Clusters

Following the release of ClusterControl 1.2.8 with a range of cool new features, we have now also published a new ClusterControl User Guide that provides all the steps, tips & tricks to follow in order...

November 14, 2014

Webinar Replay: 9 DevOps Tips for Going in Production with Galera Cluster for MySQL

Thanks to everyone who attended and participated in this week's webinar on '9 DevOps Tips for Going in Production with Galera Cluster for MySQL'. If you missed the sessions or would like to watch the...

November 7, 2014

How to Setup High Availability PrestaShop on Multiple Servers with MariaDB Galera Cluster

PrestaShop is a popular open source e-commerce software powering over 200,000 online stores, according to the company. We’ve seen a bit of interest into high availability PrestaShop setups, so this post will show you how...

October 31, 2014

Benchmark of Load Balancers for MySQL/MariaDB Galera Cluster

When running a MariaDB Cluster or Percona XtraDB Cluster, it is common to use a load balancer to distribute client requests across multiple database nodes. Load balancing SQL requests aims to optimize the usage of the database...

September 25, 2014

mysqldump or Percona XtraBackup? Backup Strategies for MySQL Galera Cluster

Coming up with a backup strategy that does not affect database performance or lock your tables can be tricky. How do you backup your production database cluster without affecting your applications? Should you use mysqldump...

September 18, 2014

Tweaking MySQL Galera Cluster to Handle Large Databases – open_files_limit

  Galera Cluster is a popular choice for achieving high availability using synchronous replication. Though if you are planning to run huge sites with many DB objects (tables), a few tweaks are necessary.  Yes, you...

September 3, 2014

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,...

August 25, 2014

9 Tips for Going in Production with Galera Cluster for MySQL

Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster)....

August 7, 2014

How-To and Performance Impacts of SSL-Encrypted Replication Traffic in Galera Cluster for MySQL

Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping...

May 23, 2014

How to Deploy Percona XtraDB Cluster Without an Internet Connection

If you need to deploy a database cluster behind your corporate firewall, on servers with no internet access, then this blog is for you. Most of the installation tutorials out there require servers to have...

Subscribe below to be notified of fresh posts