Deploy multiple MySQL instances on a [DELL R720] Server
Deploy multiple MySQL instances on a [DELL R720] Server
I. Prepare for installing mysql
1.1 download the mysql package
Mkdir-p/home/xuekun/mysql
Cd/home/xuekun/tools/mysql
Wgethttp: // dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.10.tar.gz
1.2 install mysql software
Yum-y install make gcc-c ++ cmake bison-devel ncurses-devel
Tarxvf mysql-5.6.16.tar.gz
Cdmysql-5.6.16
Cmake \
-DCMAKE_INSTALL_PREFIX =/usr/local/mysql \
-DMYSQL_DATADIR =/data \
-DSYSCONFDIR =/etc \
-DWITH_MYISAM_STORAGE_ENGINE = 1 \
-DWITH_INNOBASE_STORAGE_ENGINE = 1 \
-DWITH_MEMORY_STORAGE_ENGINE = 1 \
-DWITH_READLINE = 1 \
-DMYSQL_UNIX_ADDR =/var/lib/mysql. sock \
-DMYSQL_TCP_PORT = 3306 \
-DENABLED_LOCAL_INFILE = 1 \
-DWITH_PARTITION_STORAGE_ENGINE = 1 \
-DEXTRA_CHARSETS = all \
-DDEFAULT_CHARSET = utf8 \
-DDEFAULT_COLLATION = utf8_general_ci
Make & make install
1.3 create a mysql user
Groupadd mysql
Useradd-g mysql-M-s/sbin/nologin mysql
1.4 create a mysql data file directory
Mkdir-p/data/3306/data
Mkdir-p/data/3307/data
Tree/data/
/Data/
| -- 3306.
| '-- Data
'-- 3307
'-- Data
4 directories, 0 files
1.5 authorize mysql users and groups to access the data file directory
Chown-Rmysql: mysql/data/3306
Chown-Rmysql: mysql/data/3307
1.6 create the 3306,330 7my. cnf configuration file
Vim/data/3306/my. cnf
Vim/data/3307/my. cnf
For the content of my. cnf to be added, see Appendix B: or the my. cnf file in the directory of this document.
# Authorize mysql users and groups to access my. cnf
Chown-Rmysql: mysql/data/3306/my. cnf
Chown-Rmysql: mysql/data/3307/my. cnf
1.7 create a mysql Startup Script
Vim/data/3306/mysql
Vim/data/3307/mysql
For details about the mysql to be added, see Appendix C: or the mysql file in the directory of this document.
Chmod 700/data/3306/mysql
Chmod 700/data/3307/mysql
1.8 initialize the database
Vim/etc/profile
PATH =/usr/local/mysql/bin: $ PATH
ExportPATH
# Close the file and run the following command to make the configuration take effect immediately
Source/etc/profile
Cd/usr/local/mysql
Scripts/mysql_install_db -- datadir =/data/3306/data
InstallingMySQL system tables...
OK
Filling helptables...
OK
To start mysqldat boot time you have to copy
Support-files/mysql. serverto the right place for your system
Please rememberto set a password for the MySQL root USER!
To do so, startthe server, then issue the following commands:
/Usr/local/mysql/bin/mysqladmin-u root password 'new-password'
/Usr/local/mysql/bin/mysqladmin-u root-h A password 'new-password'
Alternativelyyou can run:
/Usr/local/mysql/bin/mysql_secure_installation
Which will alsogive you the option of removing the test
Databases andanonymous user created by default. This is
Stronglyrecommended for production servers.
See the manualfor more instructions.
You can startthe MySQL daemon:
Cd/usr/local/mysql;/usr/local/mysql/bin/mysqld_safe &
You can testthe MySQL daemon with mysql-test-run.pl
Cd/usr/local/mysql-test; perl mysql-test-run.pl
Please reportany problems with the/usr/local/mysql/bin/mysqlbug script!
Scripts/mysql_install_db -- datadir =/data/3307/data
InstallingMySQL system tables...
OK
Filling helptables...
OK
The content above 3306 is omitted here.
Chown-Rmysql: mysql/data
1.9 start the database
The command to start a mysql instance is
/Data/3306/mysqlstart
StartingMySQL...
/Data/3307/mysqlstart
StartingMySQL...
Check the startup status:
Netstat-lnt | grep 330 [6-7]
Tcp 0 00.0.0.0: 3306 0.0.0.0: * LISTEN
Tcp 0 00.0.0.0: 3307 0.0.0.0: * LISTEN
Add/etc/rc. local and set it to boot automatically
Echo "/data/3306/mysql start">/etc/rc. local
Echo "/data/3307/mysql start">/etc/rc. local
Cat/etc/rc. local
#! /Bin/sh
#
# This scriptwill be executed * after * all the other init scripts.
# You can putyour own initialization stuff in here if you don't
# Want to dothe full Sys V style init stuff.
Touch/var/lock/subsys/local
/Data/3306/mysqlstart
/Data/3307/mysql start
Tip: if the database in this step cannot be started, please wait a moment. If not, check the error log. The path is at the bottom of my. cnf.
-------------------------------------- Split line --------------------------------------
Install MySQL in Ubuntu 14.04
MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF
Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL
Build a MySQL Master/Slave server in Ubuntu 14.04
Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS
Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04
MySQL-5.5.38 universal binary Installation
-------------------------------------- Split line --------------------------------------
For more details, please continue to read the highlights on the next page: