Categories
Products
Technologies
Top Rated docs

July 15, 2015

How to Avoid SST When Adding a New Node to MySQL Galera Cluster

State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is...

July 7, 2015

MySQL Database Management Common Operations – Replication Topology Changes

MySQL replication has been available for years, and even though a number of new clustering technologies showed up recently, replication is still very common among MySQL users. It is understandable as replication is a reliable...

June 29, 2015

Deploying MySQL Galera Cluster Using Vagrant

Please note: The content of this blog is outdated. Please refer to our other blogs or resources on related topics. Or contact us via our online chat if you have any questions. Setting up environments, starting...

June 15, 2015

An Overview of MySQL Database High Availability

There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and...

June 8, 2015

MySQL Backup and Restore Best Practices

It is not uncommon for developers, network/system administrators, or DevOps folks with general backgrounds to find themselves in a DBA role at some point in their careers. So, what does a DBA do? In the...

April 24, 2015

Webinar Replay: How to Monitor MySQL Galera Cluster, MariaDB Cluster & Percona XtraDB Cluster

Thanks to everyone who attended and participated in this week’s webinar on 'How to Monitor Galera Cluster'. If you missed the sessions or would like to watch the webinar again & browse through the slides,...

April 21, 2015

SQL Load Balancing Benchmark – Comparing Performance of MaxScale vs HAProxy

In a previous post, we gave you a quick overview of the MaxScale load balancer and walked through installation and configuration. We did some quick benchmarks using sysbench, a system performance benchmark that supports testing...

April 16, 2015

Database Security – How to Fully SSL-Encrypt Your MySQL Galera Cluster

Data security is a hot topic for many companies these days. But for those who need to adhere to security standards like PCI DSS or HIPAA, security is not an option. We showed you sometime...

April 7, 2015

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

March 25, 2015

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

February 20, 2015

Webinar Replay: A DevOps Guide to Database Infrastructure Automation for eCommerce

Thanks to everyone who attended and participated in last week’s webinar on ‘A DevOps Guide to Database Infrastructure Automation for eCommerce’. If you missed the sessions or would like to watch the webinar again &...

January 20, 2015

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

Subscribe below to be notified of fresh posts