Detailed tutorial on configuring a MySQL cluster on ubuntu9.0

I can find all the RedHat systems on the Internet. I have not introduced any articles about the MySQL cluster of the Ubuntu system. Now I am writing the MySQL cluster method of Ubuntu. Don't scold me for being a newbie.

Introduction to the network environment:

Test environment:

Server1: ndbd 192.168.245.11

Server2: ndbd 192.168.245.12

Server3: mysqld-ndb-cluster 192.168.245.13

Ndbd: Database node.

Mysqld-ndb-cluster: MySQL server node. The IP address of this machine is directly accessed by the program. The default port number is 3306.

Ndbd_mgm ndbd_mgmd: Management node. Manage/view the status of each database node and server node.

Ii. Cluster Solution

1. Management node: server3 (192.168.245.13)

2. storage nodes: server1 (192.168.245.11), server2 (192.168.245.12)

3. SQL nodes: server1 (192.168.245.11), server2 (192.168.245.12), and server3 (192.168.245.13)

Iii. mysql installation and configuration

1. install sudo apt-get install mysql-server

2. Configure my. cnf on the three servers.

 

 
 

  
  
Vim/etc/mysql/my. cnf
  
  
-------------- My. cnf start ---------------
  
  
Ubuntu @ ubuntu :~ $ Cat/etc/mysql/my. cnf
  
  
#
  
  
# The MySQL database server configuration file.
  
  
#
  
  
# You can copy this to one:
  
  
#-"/Etc/mysql/my. cnf" to set global options,
  
  
#-"~ /. My. cnf "to set user-specific options.
  
  
#
  
  
# One can use all long options that the program supports.
  
  
# Run program with-help to get a list of available options and
  
  
#-Print-defaults to see which it wocould actually understand use.
  
  
#
  
  
# For explanations see # http://dev.mysql.com/doc/mysql/en/serve... ables.html
  
  
# This will be passed to all mysql clients
  
  
# It has been reported that passwords shoshould be enclosed with ticks/quotes
  
  
# Escpecially if they contain "#" chars...
  
  
# Remember to edit/etc/mysql/debian. cnf when changing the socket location. [client] port = 3306 socket =/var/run/mysqld. sock
  
  
# Here is entries for some specific programs
  
  
# The following values assume you have at least 32 M ram
  
  
# This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket =/var/run/mysqld. sock nice = 0 [mysqld]
  
  
#
  
  
# * Basic Settings
  
  
#
  
  
#
  
  
# * IMPORTANT
  
  
# If you make changes to these settings and your system uses apparmor, you may
  
  
# Also need to also adjust/etc/apparmor. d/usr. sbin. mysqld.
  
  
# User = mysql pid-file =/var/run/mysqld. pid socket =/var/run/mysqld. sock port = 3306 basedir =/usr datadir =/var/lib/mysql tmpdir =/tmp language =/usr/share/mysql/english skip-external-locking
  
  
#
  
  
# Instead of skip-networking the default is now to listen only on
  
  
# Localhost which is more compatible and is not less secure.
  
  
# Bind-address = 127.0.0.1
  
  
#
  
  
# * Fine Tuning
  
  
# Key_buffer = 16 M max_allowed_packet = 16 M thread_stack = 128 K thread_cache_size = 8
  
  
# Max_connections = 100 # table_cache = 64 # thread_concurrency = 10
  
  
#
  
  
# * Query Cache Configuration
  
  
# Query_cache_limit = 1 M query_cache_size =