Find the answer to your Linux question:
Results 1 to 3 of 3
please anyone help me to configure mysql clustering in centos. I have done all configuration correctly using following data node1 and node 2 : i have added my.cnf configuration in ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Nov 2008
    Posts
    6

    configure mysql clustering in centos


    please anyone help me to configure mysql clustering in centos.

    I have done all configuration correctly using following

    data node1 and node 2:

    i have added my.cnf configuration in data node1 and node 2

    [mysqld]
    ndbcluster
    ndb-connectstring='host=192.168.0.32' # IP address of the management server
    [mysql_cluster]
    ndb-connectstring='host=192.168.0.32' # IP address of the management server


    The file config.ini contains configuration information for the cluster mgm server:

    [NDBD DEFAULT]
    NoOfReplicas=2
    [MYSQLD DEFAULT]
    [NDB_MGMD DEFAULT]
    [TCP DEFAULT]
    # Management Server
    [NDB_MGMD]
    HostName=192.168.0.32 # IP address of this server
    # Storage Nodes
    [NDBD]
    HostName=192.168.0.33 # IP address of storage-node-1
    DataDir= /var/lib/mysql-cluster
    [NDBD]
    HostName=192.168.0.34 # IP address of storage-node-2
    DataDir=/var/lib/mysql-cluster
    # Setup node IDs for mySQL API-servers (clients of the cluster)
    [MYSQLD]
    HostName=192.168.0.35

    Mysql Api node my.cnf:


    [mysqld]
    ndbcluster
    ndb-connectstring='host=192.168.0.32' # IP address of the management server
    [mysql_cluster]
    ndb-connectstring='host=192.168.0.32' # IP address of the management server


    mgmt# ndb_mgm
    -- NDB Cluster -- Management Client --
    ndb_mgm> show
    Connected to Management Server at: localhost:1186
    Cluster Configuration
    ---------------------
    [ndbd(NDB)] 2 node(s)
    id=2 @192.168.0.33 (Version: 4.1.9, starting, Nodegroup: 0, Master)
    id=3 @192.168.0.34 (Version: 4.1.9, starting, Nodegroup: 0)

    [ndb_mgmd(MGM)] 1 node(s)
    id=1 @192.168.0.32 (Version: 4.1.9)

    [mysqld(API)] 4 node(s)
    id=4 @192.168.0.35 (Version: 4.1.9)




    But i unable to check whether is working or not and also i unable fetch data form data node using mysql API(mysql server).

    Can you give any solution? please

    Thanks,
    Praba

  2. #2
    Linux Newbie
    Join Date
    Jan 2012
    Location
    Ohio
    Posts
    175
    Do you have a load balancer set up? From what I have read, this is a necessary step for making it easier to access the cluster. Take a look at this walkthrough:
    How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 | HowtoForge - Linux Howtos and Tutorials

  3. #3
    Just Joined!
    Join Date
    Nov 2008
    Posts
    6
    thanks for your replay,

    But i have used this doc link- lod.com/whitepapers/mysql-cluster-howto.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •