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

In this issue, the editor will bring you about how to configure the MySQL server cluster. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1. First find out if you should use MySQL clustering.

Reduce the data center node pressure and large amount of data processing, using the distribution of MySQL, one or more application corresponding to a MySQL. Make shared data from several MySQL databases, such as shopping carts, user objects, etc., and store them in the data nodes. Other unshared data is maintained in their respective distributed MySQL databases themselves.

two。 The concept of name in cluster MySQL. (as pictured above)

1) Sql node (the figure above SQL node-- corresponds to MySQLd): distributed database. Including its own data and query center node data.

2) data node (Data node-ndbd): cluster shared data (in memory).

3) Management server (Management Server-ndb_mgmd): cluster management SQL node,Data node.

3. Configuration

MySQL-max version, of course, now MySQL cluster system windonws platform is not supported.

Install MySQL not to say much, a lot of online, concise and to the point.

Avut 192.168.1.251-Data node and Management Server.

BRV 192.168.1.254-SQL node.

Of course, you can also make a machine three at the same time.

A my.inf B add:

MySQLD]

Ndbcluster # run NDB engine

Ndb-connectstring=192.168.1.251 # location of MGM node

# Options for ndbd process: [MySQL_CLUSTER]

Ndb-connectstring=192.168.1.251 # location of MGM node

A: / var/lib/MySQL-cluster/config.ini [NDBD DEFAULT]

NoOfReplicas=1

# Number of replicas DataMemory=80M

# How much memory to allocate for data storage IndexMemory=18M

# How much memory to allocate for index storage

# For DataMemory and IndexMemory, we have used the

# default values. Since the "world" database takes up

# only about 500KB, this should be more than enough for

# this example Cluster setup. # TCP/IP options: [TCP DEFAULT]

Portnumber=2202 # This the default; however, you can use any

# port that is free for all the hosts in cluster

# Note: It is recommended beginning with MySQL 5.0 that

# you do not specify the portnumber at all and simply allow

# the default value to be used instead # Management process options: [NDB_MGMD] hostname=192.168.1.251

# Hostname or IP address of MGM node datadir=/var/lib/MySQL-cluster # Directory for MGM node logfiles # Options for data node "A": [NDBD]

# (one [NDBD] section per data node) hostname=192.168.1.251

# Hostname or IP address datadir=/usr/local/MySQL/data

# Directory for this data nodes datafiles

# SQL node options: [MySQLD] hostname=192.168.1.254

# [MySQ

The above is the editor for you to share how to configure the MySQL server cluster, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are 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.