上一篇博文mysql系列之多实例2—-基于多配置文件介绍了，如何部署基于多配置文件的mysql多实例，本篇博文将介绍基于mysql自带的mysqld_multi工具来如何实现mysql多实例的部署和管理！
环境：CentOS6.5x86_64位采用最小化安装，系统经过了基本优化selinux为关闭状态，iptables为无限制模式mysql版本：mysql-5.5.38源码包存放位置：/usr/local/src源码包编译安装位置：/usr/local/mysql数据库存放位置：/mydata
本方案仅以同一台服务器上跑2个实例为例，演示基于多配置文件的mysql多实例
一、安装mysql程序
1、准备软件环境
[root@nolinux~]#yuminstallwgetmakecmakegccgcc-c++ncursesncurses-develperl-y[root@nolinux~]#cd/usr/local/src/[root@nolinuxsrc]#lltotal21232-rw-r–r–.1rootroot21739681Jun320:39mysql-5.5.38.tar.gz[root@nolinuxsrc]#tarzxfmysql-5.5.38.tar.gz[root@nolinuxsrc]#lltotal21236drwxr-xr-x.317161wheel4096May1200:39mysql-5.5.38-rw-r–r–.1rootroot21739681Jun320:39mysql-5.5.38.tar.gz
3、建立mysql用户
[root@nolinux~]#useradd-r-u306mysql
4、mysql安装
[root@nolinuxsrc]#cdmysql-5.5.38[root@nolinuxmysql-5.5.38]#cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.38\-DMYSQL_DATADIR=/usr/local/mysql-5.5.38/data\-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.38/tmp/mysql.sock\-DDEFAULT_CHARSET=gbk\-DDEFAULT_COLLATION=gbk_chinese_ci\-DENABLED_LOCAL_INFILE=ON\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\-DWITHOUT_PARTITION_STORAGE_ENGINE=1[root@nolinuxmysql-5.5.38]#make[root@nolinuxmysql-5.5.38]#makeinstall
5、为mysql安装目录制作软链接
编译安装完成之后，我们需要为mysql安装目录做一个link
[root@nolinux~]#cd[root@nolinux~]#ln-s/usr/local/mysql-5.5.38/usr/local/mysql
6、配置 mysql 环境变量
[root@nolinux~]#echo’exportPATH=/usr/local/mysql/bin:$PATH’>>/etc/profile[root@nolinux~]#tail-1/etc/profileexportPATH=/usr/local/mysql/bin:$PATH[root@nolinux~]#source/etc/profile[root@nolinux~]#echo$PATH/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
二、mysql 多实例部署
1、建立各个实例的对应目录
[root@nolinux~]#mkdir/mydata/{3306,3307}/data-p[root@nolinux~]#chown-Rmysql.mysql/mydata/[root@nolinux~]#tree/mydata//mydata/├──3306#3306端口的mysql实例目录│└──data#3307端口的mysql数据目录└──3307#3307端口的mysql实例目录└──data#3307端口的mysql数据目录4directories,0files
2、单一配置文件部署
a、查看默认模板配置文件
[root@nolinux~]#ls/usr/local/mysql/support-files/my-*/usr/local/mysql/support-files/my-huge.cnf/usr/local/mysql/support-files/my-innodb-heavy-4G.cnf/usr/local/mysql/support-files/my-large.cnf/usr/local/mysql/support-files/my-medium.cnf/usr/local/mysql/support-files/my-small.cnf
[root@nolinux~]#cat/etc/my.cnf[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminuser=mysql#如果该地方不是root用户，下面则需要在数据库为该用户添加shutdown权限，不然mysqld_multi将无法关闭实例password=sunsky[mysqld1]port=3306server-id=1socket=/mydata/3306/mysql.sockpid-file=/mydata/3306/mysql.piddatadir=/mydata/3306/datauser=mysqlskip-name-resolvelower_case_table_names=1innodb_file_per_table=1back_log=50max_connections=300max_connect_errors=1000table_open_cache=2048max_allowed_packet=16Mbinlog_cache_size=2Mmax_heap_table_size=64Msort_buffer_size=2Mjoin_buffer_size=2Mthread_cache_size=64thread_concurrency=8query_cache_size=64Mquery_cache_limit=2Mft_min_word_len=4default-storage-engine=innodbthread_stack=192Ktransaction_isolation=REPEATABLE-READtmp_table_size=64Mlog-bin=mysql-binbinlog_format=mixedslow_query_loglong_query_time=1key_buffer_size=8Mread_buffer_size=2Mread_rnd_buffer_size=2Mbulk_insert_buffer_size=64Mmyisam_sort_buffer_size=128Mmyisam_max_sort_file_size=10Gmyisam_repair_threads=1myisam_recoverinnodb_additional_mem_pool_size=16Minnodb_buffer_pool_size=200Minnodb_data_file_path=ibdata1:10M:autoextendinnodb_file_io_threads=8innodb_thread_concurrency=16innodb_flush_log_at_trx_commit=1innodb_log_buffer_size=16Minnodb_log_file_size=512Minnodb_log_files_in_group=3innodb_max_dirty_pages_pct=60innodb_lock_wait_timeout=120[mysqld2]port=3307server-id=2socket=/mydata/3307/mysql.sockpid-file=/mydata/3307/mysql.piddatadir=/mydata/3307/datauser=mysqlskip-name-resolvelower_case_table_names=1innodb_file_per_table=1back_log=50max_connections=300max_connect_errors=1000table_open_cache=2048max_allowed_packet=16Mbinlog_cache_size=2Mmax_heap_table_size=64Msort_buffer_size=2Mjoin_buffer_size=2Mthread_cache_size=64thread_concurrency=8query_cache_size=64Mquery_cache_limit=2Mft_min_word_len=4default-storage-engine=innodbthread_stack=192Ktransaction_isolation=REPEATABLE-READtmp_table_size=64Mlog-bin=mysql-binbinlog_format=mixedslow_query_loglong_query_time=1key_buffer_size=8Mread_buffer_size=2Mread_rnd_buffer_size=2Mbulk_insert_buffer_size=64Mmyisam_sort_buffer_size=128Mmyisam_max_sort_file_size=10Gmyisam_repair_threads=1myisam_recoverinnodb_additional_mem_pool_size=16Minnodb_buffer_pool_size=200Minnodb_data_file_path=ibdata1:10M:autoextendinnodb_file_io_threads=8innodb_thread_concurrency=16innodb_flush_log_at_trx_commit=1innodb_log_buffer_size=16Minnodb_log_file_size=512Minnodb_log_files_in_group=3innodb_max_dirty_pages_pct=60innodb_lock_wait_timeout=120[mysqldump]quickmax_allowed_packet=256M[mysql]no-auto-rehashprompt=\\u@\\d\\R:\\m>[myisamchk]key_buffer_size=512Msort_buffer_size=512Mread_buffer=8Mwrite_buffer=8M[mysqlhotcopy]interactive-timeout[mysqld_safe]open-files-limit=8192
片的时光如浮云般流过，我们的青春单薄的穿梭在蓝天之上。
