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