Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to install a cluster server in mysql", which is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn how to install a server in cluster in mysql.

Environment:

An OS

Redhat linux 5.1

RAM 2G hard disk space: 2G

First create mysql groups and mysql users:

Groupadd mysql

Useradd-g mysql mysql

Download software: http://www.mysql.com/downloads/cluster/

Installation:

[user1@ws2 ~] $tar xvf Downloads/mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23.tar.gz

[user1@ws2] $ln-s mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23 mysqlc

Put ~ / mysqlc/bin under your path environment variable.

Configuration:

[user1@ws2 ~] $mkdir my_cluster my_cluster/ndb_data my_cluster/mysqld_data my_cluster/conf

Under the conf directory you just created, create two files, my.cnf and config.ini, with the following contents:

My.cnf:

[mysqld]

Ndbcluster

Datadir=/home/user1/my_cluster/mysqld_data

Basedir=/home/user1/mysqlc

Port=5000

Config.ini:

[ndb_mgmd]

Hostname=localhost

Datadir=/home/user1/my_cluster/ndb_data

Id=1

[ndbd default]

Noofreplicas=2

Datadir=/home/user1/my_cluster/ndb_data

[ndbd]

Hostname=localhost

Id=3

[ndbd]

Hostname=localhost

Id=4

[mysqld]

Id=50

Initialization

[user1@ws2 ~] $cd mysqlc

[user1@ws2 mysqlc] $scripts/mysql_install_db-- no-defaults-- datadir=$HOME/my_cluster/mysqld_data/

Start:

[user1@ws2 mysqlc] $cd. / my_cluster/

[user1@ws2 my_cluster] $HOME/mysqlc/bin/ndb_mgmd-f conf/config.ini-- initial-

Configdir=$HOME/my_cluster/conf/

[user1@ws2 my_cluster] $$HOME/mysqlc/bin/ndbd-c localhost:1186

[user1@ws2 my_cluster] $$HOME/mysqlc/bin/ndbd-c localhost:1186

View the status of each node and data node through mysql's manager:

[user1@ws2 my_cluster] $$HOME/mysqlc/bin/ndb_mgm-e show

Connected to Management Server at: localhost:1186

Cluster Configuration

-

[ndbd (NDB)] 2 node (s)

Id=3 @ 127.0.0.1 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0, Master)

Id=4 @ 127.0.0.1 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0)

[ndb_mgmd (MGM)] 1 node (s)

Id=1 @ 127.0.0.1 (mysql-5.1.44 ndb-7.1.3)

[mysqld (API)] 1 node (s)

Id=50 (not connected, accepting connect from any host)

Start the mysql database:

[user1@ws2 my_cluster] $$HOME/mysqlc/bin/mysqld-- defaults-file=conf/my.cnf &

Start the mysql database securely:

Mysqld_safe-defaults-file=conf/my.cnf-ledir=/mysql/mysqlc/bin

Test:

[user1@ws2 my_cluster] $HOME/mysqlc/bin/mysql-h 127.0.0.1-P 5000-u root

Mysql > create database clusterdb;use clusterdb

Mysql > create table simples (id int not null primary key) engine=ndb

Mysql > insert into simples values (1), (2), (3), (4)

Mysql > select * from simples

+-- +

| | id |

+-- +

| | 3 |

| | 1 |

| | 2 |

| | 4 |

+-- +

Secure shutdown:

[user1@ws2 my_cluster] $HOME/mysqlc/bin/mysqladmin-u root-h 127.0.0.1-P 5000 shutdown

[user1@ws2 my_cluster] $$HOME/mysqlc/bin/ndb_mgm-e shutdown

Problem record:

After installation, you may not be able to access MySQL in other IP breakers. When you visit, you will report:

[Warning] IP address' 10.11.32.185' could not be resolved: getnameinfo () returned error (code:-3).

This is because MySQL does DNS parsing for external connections

Add: in the conf/my.cnf file:

[mysqld]

Skip-name-resolve

# prohibit MySQL from parsing DNS for external connections. Use this option to eliminate the time for MySQL to parse DNS. But you need to note.

If this option is turned on, all remote host connection authorizations must use IP address, otherwise MySQL will not be able to handle connection # requests properly!

# 1: remove the skip-name-resolve from the mysql startup parameters, and then use both the ip address and the host name for the jdbc connection string.

# 2: if you keep the startup parameter skip-name-resolve, you can only use IP address to connect to the database in the jdbc connection string.

Add the above parameters, and then grant permissions to the user:

Grant all privileges on *. * to root@ "%" identified by 'qinqiang' with grant option

Logging in again in this way will be OK.

The above is all the contents of the article "how to install a cluster server in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.