Johan
- Total activity 435
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 1
- Subscriptions 103
Posts
Recent activity by Johan Sort by recent activity-
Restore Xtrabackup on Galera Cluster
This article describes how to restore a backup on a Galera Cluster. It applies to backups that have been taken using s9s_backup (either from command line or from GUI) and that is using Xtrabackup a...
-
Upgrading the cluster with apt-get update/upgrade or yum
This article describes the procedure for running apt-get / yum to upgrade a node manually (e.g if you want to update the OS) or if you use the Community version of ClusterControl. General Update ...
-
Top reasons node recovery using SST fails
Reasons why node recovery may fail: Wrong file ownerall files in the mysql datadir must be owned by the mysql user Synching large data files files (big tables)If you use wsrep_sst_rsync, then yo...
-
garbd installation - Arbitrator for Galera
This article describes how to install garbd. You should not have an even number of nodes in the Galera cluster, this can lead to split-brain/network partitioning, see more below. To protect from sp...
-
Avoid 'service mysql <start|restart>' with Galera
If you e.g have changed a parameter in my.cnf, and subsequently do: service mysql stop && service mysql start or service mysql restart the Galera node in question, will not rejoin the Cluster immed...
-
Change from rsync to xtrabackup - avoid read-only Donor during SST
This article describes how to change wsrep_sst_method=rsync to wsrep_sst_method=xtrabackup. THIS ONLY WORKS WITH VERSION LATER OR EQUAL TO: Galera 2.2.0 (mysql 5.5.28, wsrep 23.7) Make sure you hav...
-
Node and Cluster Recovery
This article describes how ClusterControl manages Node and Cluster Recovery Node Recovery One more more nodes fails, but the majority of nodes (atleast one node is in SYNCHED) are still up. Cluster...
-
How MySQL Cluster Uses RAM
You may sometimes see that you have a RAM Alarm (CRITICAL or WARNING). If it is on the data node, it is generally nothing to worry about, but a SWAP alarm on the other hand is very severe. The rea...
-
Post install - Access rights to MySQL Cluster
After you have installed deployed MySQL Cluster you should add GRANTs so your applications and users can connect to the database cluster: The easiest is if you do: cd mysqlcluster-72/cluster/script...
-
Interpreting the Status of Galera Cluster for MySQL
In the main screen, viewing the nodes part of the Galera Cluster, there are few status variables to keep an eye on, in order to find out which is the slowest node or nodes with potential network p...