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....
Chef Cookbooks for ClusterControl – Management and Monitoring for Your Database Clusters
If you are automating your infrastructure deployments with Chef, then read on. We are glad to announce the availability of a Chef cookbook for ClusterControl. This cookbook replaces previous cookbooks we released for ClusterControl and...
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 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...
Severalnines ClusterControl Selected by Online Fashion Leader Spree to Support 500% eCommerce Growth
For an online shop, the website is the cash register and needs to be open 24/7. This new case study looks at how Spree migrated to a multi-server, highly available eCommerce platform to maintain high...
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...
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...
Database Automation – Private DBaaS for MySQL, MariaDB and MongoDB with ClusterControl
Installing, configuring, deploying databases and performing repetitive administrative tasks are all part of a DBA’s or sysadmin’s job. This can get pretty repetitive and overwhelming if you are part of a centralized IT team,...
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...