Avatar

Johan

  • Total activity 435
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 1 user
  • Votes 1
  • Subscriptions 103

Articles

Votes on activity by Johan Sort by votes Recent activity Votes
  • Firewall - ports

    This article describes the ports that needs to be opened in the firewall for Galera, MySQL Cluster, Replication, and HAProxy. ClusterControl Server The ClusterControl server should open: ICMP (pin...

  • Server Requirements (on-premise, AMIs, other images)

    This article describes the requirements on a server that is part of ClusterControl. The following is described below: Resolving Hostnames and IP addresses Sudo / root - Operating System user ...

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

  • Error reporting

    You can use the s9s_error_reporter tool to generate error reports, and then attach the error report to the Support Ticket.Syntax: s9s_error_reporter -i <CLUSTER_ID> Where <CLUSTER_ID> is the ID of ...

  • JPGraph installation

    Some graphs requires JPGraph to be installed. Download JPGraph here: http://jpgraph.net/download/ Put the jpgraph-3.5.0b1.tar.gz file on the ClusterControl server and do Centos/Redhat sudo tar ...

  • Benchmark Galera or MySQL Cluster using Sysbench

    After you have installed your cluster you may want to bench it quickly to see that everything is working. Here is an example how to run sysbench from the ClusterControl server, but of course using...

  • Installing on Amazon EC2

    In this article we will describe how to create a couple of EC2 instances and how to deploy ClusterControl on EC2. We will use MySQL Cluster here, but the same steps are applicable to Galera and My...

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

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