Installing ClusterControl Standby Server

Follow

Comments

4 comments

  • Avatar
    DG & CO. Jewellery

    Thanks for sharing a useful information. kindly keep update regularly.

    0
    Comment actions Permalink
  • Avatar
    Santino Freeplayer

    Installing a ClusterControl Standby Server is an essential step for enhancing the high availability and disaster recovery capabilities of your database infrastructure. The standby server acts as a backup that can automatically take over in case of a failure in the primary server, minimizing downtime professional teeth whitening stoke on trent and ensuring business continuity. To set up a standby server, the process involves deploying the ClusterControl tool, which orchestrates the replication and monitoring of the standby instance. 

    0
    Comment actions Permalink
  • Avatar
    Maciejewson Collin

    Installing a ClusterControl Standby Server is an essential step for enhancing the high availability and disaster recovery capabilities of your database infrastructure. The standby server acts as a backup that can automatically take over in case of a failure in the primary server, minimizing downtime and ensuring business continuity like register2park. To set up a standby server, the process involves deploying the ClusterControl tool, which orchestrates the replication and monitoring of the standby instance. 

     
    0
    Comment actions Permalink
  • Avatar
    Emily Hayes

    Installing ClusterControl Standby Server

    1. Install Controller

      • Download and install the cmon controller package.
      • For Debian/Ubuntu:
        wget http://www.severalnines.com/downloads/cmon/cmon-1.2.5-152-64bit-glibc23-mc70.tar.gz
        tar -xzf cmon-1.2.5-152-64bit-glibc23-mc70.tar.gz -C /usr/local
        ln -sf /usr/local/cmon-1.2.5-152-64bit-glibc23-mc70/ /usr/local/cmon
        cp /usr/local/cmon/bin/s9s* /usr/bin
        cp /usr/local/cmon/etc/cmon.cnf.controller /etc/cmon.cnf
        cp /usr/local/cmon/etc/init.d/cmon /etc/init.d/
        
      • For RHEL/CentOS/Fedora/Amazon Linux:
        wget http://www.severalnines.com/downloads/cmon/cmon-controller-1.2.5-152-1.x86_64.rpm
        yum localinstall cmon-controller-1.2.5-152-1.x86_64.rpm vegan breakfast ideas
        
    2. Import CMON Database

      • Install MySQL:
        apt-get install mysql-server mysql-client  # Debian/Ubuntu
        yum install mysql mysql-server  # RHEL/CentOS/Fedora benefits of anti-oxidants
        
      • Create and import the CMON database:
        mysql -uroot -p -e 'create schema cmon'
        mysql -uroot -p cmon < /usr/local/cmon/share/cmon/cmon_db.sql
        mysql -uroot -p cmon < /usr/local/cmon/share/cmon/cmon_data.sql
        
    3. Configure Controller

      • Edit /etc/cmon.cnf, update hostname and mysql_hostname.
      • Add enable_autorecovery=0 to disable auto-recovery.
    4. Grant Privileges

      • Run in MySQL:
        GRANT ALL ON *.* TO 'cmon'@'127.0.0.1' IDENTIFIED BY '<cmon password>' WITH GRANT OPTION;
        GRANT ALL ON *.* TO 'cmon'@'<Standby ClusterControl IP>' IDENTIFIED BY '<cmon password>' WITH GRANT OPTION;
        
    5. Install ClusterControl UI

      wget http://www.severalnines.com/downloads/cmon/setup-cc-ui.sh
      chmod 755 setup-cc-ui.sh
      ./setup-cc-ui.sh
      
      • Open http://<standby_ClusterControl_IP>/install to finalize setup.
    6. Configure Database Hosts

      • On each agent, grant access to the standby host:
        GRANT ALL PRIVILEGES ON *.* TO 'cmon'@'<Standby ClusterControl IP>' IDENTIFIED BY '<cmon password>' WITH GRANT OPTION;
        
    7. Start CMON

      /etc/init.d/cmon start
      
      • Access the UI at https://<standby_ClusterControl_IP>/clustercontrol.

    Alternatively, use the bootstrap script with --install-standby option.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk