Johan
- Total activity 435
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 1
- Subscriptions 103
Articles
Recent activity by Johan Sort by recent activity-
Creating Slave Cluster ( Cluster 2 Cluster replication)
Note: Cluster 2 cluster replication using PXC requires that server_id and binlog settings are identical on all nodes of the slave cluster. You can achieve this by creating a slave config template:...
Older ClusterControl Releases
Changes in ClusterControl v1.5.1 2018-04-09 clustercontrol-controller-1.5.1-2467 Monitoring: SSH Optimizations to reduce the number of SSH connections on remote nodes. Monitoring: CPU temperature...
Host already in another Cluster
A host can only exist in one Cluster at a time. If an "Add Existing Cluster"-job fails, and a subsequent retry throws the error: "Host 1.2.3.4:nnnn is already in an other cluster." Then you can ...
Minimal GRANTs for MySQL Based Clusters (Galera, Replication, NDB/MySQL Cluster)
The following article shows what are the minimal privileges required for monitoring only. The follow functionality WILL NOT WORK with the minimal privileges: add node (granting is needed) creat...
http_proxy - setting up
If you are using http_proxy then you have to do on all nodes (including the controller): Redhat/Centos EDIT /etc/bashrc# add as the last line:export http_proxy=http://proxy_address:proxy_port# ch...
Nagios Plugin
Please refer to this article how to install and integrate Nagios with ClusterControl: http://www.severalnines.com/blog/nagios-plugin-clustercontrol
Add Existing Cluster
This article to describes how to add an existing cluster into ClusterControl. Supported clusters are: Galera Clusters Collection of MySQL Servers Mongodb/Tokumx Assumptions: Dedicated ...
Restore Controller to Default Settings
This article describes how to restore a Controller to default settings. It can be if for some reason the CMON DB has been corrupted and you quickly want to get it up again. Pre-requisites: a de...
Migrate MyISAM tables to INNODB using mysqldump
In this article you will find information how to convert MyISAM tables to INNODB. The procedure here is an offline procedure, i.e, you cannot have changes on the SOURCE database, while you do thi...
Change SSH Port and OS User
Scenario: You installed as os user= 'root' and using ssh port 22. Now you want to change this to: SSH port = 2222 OS user = johan Requirements The OS user must be able to ssh without passwor...