Deploying an asynchronous slave to MySQL Galera Cluster
Due to its synchronous nature, Galera performance can be limited by the slowest node in the cluster. So running heavy reporting queries or making frequent backups on one node, or putting a node across a...
How to Cluster Atlassian Server Apps in Your Data Center – JIRA, Confluence, Stash with MySQL Galera Cluster
Atlassian apps are widely used by development teams to facilitate software development and collaboration. For larger teams who require enterprise-grade tools, you might want to host the applications in your own data center and cluster...
Monitoring Galera Cluster – Understanding and Optimizing CPU-Related InnoDB Metrics
The performance of a Galera cluster is strongly connected to the performance of MySQL. Galera only supports the InnoDB storage engine, it is therefore important to have an insight into how InnoDB operates – what metrics...
HowTo: Offline Upgrade of Galera Cluster to MySQL 5.6 or MariaDB 10
MySQL 5.6 has an extensive list of new features and changes, so upgrading from a previous version can be risky if not tested extensively. For this reason, we recommend our users to read and understand...
High Availability File Sync and Share – Deploying ownCloud with Galera Cluster for MySQL and GlusterFS
Cloud storage is hot. Dropbox, Apple iCloud, Google Drive, Microsoft SkyDrive and Amazon Cloud Drive all offer cloud sharing platforms where you can store documents in the cloud and access them from all your devices....
Webinar Replay: Galera Cluster for MySQL vs MySQL (NDB) Cluster: A High Level Comparison
Thanks to everyone who attended and participated in last week’s webinar on 'Galera Cluster for MySQL vs MySQL (NDB) Cluster: A High Level Comparison'. If you missed the sessions or would like to watch the...
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...
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...
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...
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,...