当前位置：Gxlcms > 数据库问题 > 02.mysql多实例安装实战

02.mysql多实例安装实战

时间：2021-07-01 10:21:17 帮助过：5人阅读

yum install ncurses-devel libaio-devel –y [root@mysql ~]# rpm -qa ncurses-devel libaio-devel libaio-devel-0.3.107-10.el6.x86_64 ncurses-devel-5.7-4.20090207.el6.x86_64?

2.3.2  安装编译 mysql 需要的软件

  1. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> pwd /home/tools</span>
  2. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> ls cmake-2.8.8.tar.zip</span>
  3. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> unzip cmake-2.8.8.tar.zip Archive: cmake-2.8.8.tar.zip inflating: cmake-2.8.8.tar.gz</span>
  4. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> ls cmake-2.8.8.tar.gz cmake-2.8.8.tar.zip</span>
  5. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> tar xfv cmake-2.8.8.tar.gz</span>
  6. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> ls cmake-2.8.8 cmake-2.8.8.tar.gz cmake-2.8.8.tar.zip</span>
  7. [root@mysql tools]<span style="color: #008000;">#</span><span style="color: #008000;"> cd cmake-2.8.8</span>
  8. [root@mysql cmake-2.8.8]<span style="color: #008000;">#</span><span style="color: #008000;"> ./configure </span>
  9. [root@mysql cmake-2.8.8]<span style="color: #008000;">#</span><span style="color: #008000;"> gmake </span>
  10. [root@mysql cmake-2.8.8]<span style="color: #008000;">#</span><span style="color: #008000;"> gmake install</span>

 

关于 cmake 软件也可以直接 yum 安装

  1. yum install -y cmake

 

2.3.3 安装 mysql 软件

  1. 1<span style="color: #000000;">、创建安装 mysql 软件的用户 mysql
  2. [root@mysql </span>~]<span style="color: #008000;">#</span><span style="color: #008000;"> useradd mysql -s /sbin/nologin –M</span>
  3. 2、解压 mysql-5.5.27<span style="color: #000000;"> 的软件包
  4. [root@mysql tools]</span><span style="color: #008000;">#</span><span style="color: #008000;"> ls</span>
  5. cmake-2.8.8 cmake-2.8.8.tar.gz cmake-2.8.8.tar.zip mysql-5.5.27 mysql-5.5.27<span style="color: #000000;">.tar.gz
  6. </span>3<span style="color: #000000;">、编译安装 mysql（下面是编译参数）
  7. </span>/usr/local/bin/cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.27<span style="color: #000000;">     </span>-DMYSQL_DATADIR=/application/mysql-5.5.27/<span style="color: #000000;">data     </span>-DMYSQL_UNIX_ADDR=/application/mysql-5.5.27/tmp/<span style="color: #000000;">mysql.sock     </span>-DDEFAULT_CHARSET=<span style="color: #000000;">utf8     </span>-DDEFAULT_COLLATION=<span style="color: #000000;">utf8_general_ci     </span>-DEXTRA_CHARSETS=<span style="color: #000000;">gbk,gb2312,utf8,ascii     </span>-DENABLED_LOCAL_INFILE=<span style="color: #000000;">ON     </span>-DWITH_INNOBASE_STORAGE_ENGINE=1<span style="color: #000000;">     </span>-DWITH_FEDERATED_STORAGE_ENGINE=1<span style="color: #000000;">     </span>-DWITH_BLACKHOLE_STORAGE_ENGINE=1<span style="color: #000000;">     </span>-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1<span style="color: #000000;">     </span>-DWITHOUT_PARTITION_STORAGE_ENGINE=1<span style="color: #000000;">     </span>-DWITH_FAST_MUTEXES=1<span style="color: #000000;">     </span>-DWITH_ZLIB=<span style="color: #000000;">bundled     </span>-DENABLED_LOCAL_INFILE=1<span style="color: #000000;">     </span>-DWITH_READLINE=1<span style="color: #000000;">     </span>-DWITH_EMBEDDED_SERVER=1<span style="color: #000000;">     </span>-DWITH_DEBUG=<span style="color: #000000;">0
  8. [root@mysql mysql</span>-5.5.27]<span style="color: #008000;">#</span><span style="color: #008000;"> make && make install</span>
  9. [root@mysql mysql-5.5.27]<span style="color: #008000;">#</span><span style="color: #008000;"> ln -s /application/mysql-5.5.27 /application/mysql</span>
  10. [root@mysql ~]<span style="color: #008000;">#</span><span style="color: #008000;"> echo "PATH=/application/mysql/bin:$PATH" >>/etc/profile 把 mysql 的命令放</span>
  11. <span style="color: #000000;">入至全局环境变量之中
  12. [root@mysql </span>~]<span style="color: #008000;">#</span><span style="color: #008000;"> . /etc/profile</span>
  13. [root@mysql mysql-5.5.27]<span style="color: #008000;">#</span><span style="color: #008000;"> cd /application/mysql</span>
  14. [root@mysql mysql]<span style="color: #008000;">#</span><span style="color: #008000;"> ls</span>
  15. bin data include lib mysql-test scripts sql-<span style="color: #000000;">bench
  16. COPYING docs INSTALL</span>-BINARY man README share support-files

2.3.4  创建存放两个 mysql 实例的数据目录

  1. [root@mysql ~]<span style="color: #008000;">#</span><span style="color: #008000;"> mkdir /mysqldata/{3306,3307}/data -p</span>
  2. [root@mysql ~]<span style="color: #008000;">#</span><span style="color: #008000;"> tree /mysqldata</span>
  3. /<span style="color: #000000;">mysqldata
  4. ├── </span>3306<span style="color: #000000;">
  5.     │ └── data
  6. └── </span>3307<span style="color: #000000;">
  7.     └── data </span>4 directories, 0 files?

2.3.5 创建两个 mysql 多实例的配置文件

2.3.5.1  3306 的实例

  1. <span style="color: #008000;">#</span><span style="color: #008000;">实例1：3306配置文件</span>
  2. [root@mysql 3306]<span style="color: #008000;">#</span><span style="color: #008000;"> ls</span>
  3. data my.cnf（配置文件） mysql（程序启动文件） mysql-bin.000001 mysql-<span style="color: #000000;">bin.index
  4. mysqld.pid mysql_oldboy3306.err mysql.sock
  5. [root@mysql </span>3306]<span style="color: #008000;">#</span><span style="color: #008000;"> cat my.cnf</span>
  6. <span style="color: #000000;">[client]
  7. port </span>= 3306<span style="color: #000000;">
  8. socket </span>= /mysqldata/3306/<span style="color: #000000;">mysql.sock
  9. [mysql]
  10. no</span>-auto-<span style="color: #000000;">rehash
  11. [mysqld]
  12. user </span>=<span style="color: #000000;"> mysql
  13. port </span>= 3306<span style="color: #000000;">
  14. socket </span>= /mysqldata/3306/<span style="color: #000000;">mysql.sock
  15. basedir </span>= /application/<span style="color: #000000;">mysql
  16. datadir </span>= /mysqldata/3306/<span style="color: #000000;">data
  17. open_files_limit </span>= 1024<span style="color: #000000;">
  18. back_log </span>= 600<span style="color: #000000;">
  19. max_connections </span>= 800<span style="color: #000000;">
  20. max_connect_errors </span>= 3000<span style="color: #000000;">
  21. table_cache </span>= 614<span style="color: #000000;">
  22. external</span>-locking =<span style="color: #000000;"> FALSE
  23. max_allowed_packet </span>=<span style="color: #000000;">8M
  24. sort_buffer_size </span>=<span style="color: #000000;"> 1M
  25. join_buffer_size </span>=<span style="color: #000000;"> 1M
  26. thread_cache_size </span>= 100<span style="color: #000000;">
  27. thread_concurrency </span>= 2<span style="color: #000000;">
  28. query_cache_size </span>=<span style="color: #000000;"> 2M
  29. query_cache_limit </span>=<span style="color: #000000;"> 1M
  30. query_cache_min_res_unit </span>=<span style="color: #000000;"> 2k
  31. </span><span style="color: #008000;">#</span><span style="color: #008000;">default_table_type = InnoDB</span>
  32. thread_stack =<span style="color: #000000;"> 192K
  33. </span><span style="color: #008000;">#</span><span style="color: #008000;">transaction_isolation = READ-COMMITTED</span>
  34. tmp_table_size =<span style="color: #000000;"> 2M
  35. max_heap_table_size </span>=<span style="color: #000000;"> 2M?
  36. long_query_time </span>= 1
  37. <span style="color: #008000;">#</span><span style="color: #008000;">log_long_format</span><span style="color: #008000;">
  38. #</span><span style="color: #008000;">log-error = /data/3306/error.log</span><span style="color: #008000;">
  39. #</span><span style="color: #008000;">log-slow-queries = /data/3306/slow.log</span>
  40. pid-file = /mysqldata/3306/<span style="color: #000000;">mysql.pid
  41. log</span>-bin = /mysqldata/3306/mysql-<span style="color: #000000;">bin
  42. relay</span>-log = /mysqldata/3306/relay-<span style="color: #000000;">bin
  43. relay</span>-log-info-file = /mysqldata/3306/relay-<span style="color: #000000;">log.info
  44. binlog_cache_size </span>=<span style="color: #000000;"> 1M
  45. max_binlog_cache_size </span>=<span style="color: #000000;"> 1M
  46. max_binlog_size </span>=<span style="color: #000000;"> 2M
  47. expire_logs_days </span>= 7<span style="color: #000000;">
  48. key_buffer_size </span>=<span style="color: #000000;"> 16M
  49. read_buffer_size </span>=<span style="color: #000000;"> 1M
  50. read_rnd_buffer_size </span>=<span style="color: #000000;"> 1M
  51. bulk_insert_buffer_size </span>=<span style="color: #000000;"> 1M
  52. </span><span style="color: #008000;">#</span><span style="color: #008000;">myisam_sort_buffer_size = 1M</span><span style="color: #008000;">
  53. #</span><span style="color: #008000;">myisam_max_sort_file_size = 10G</span><span style="color: #008000;">
  54. #</span><span style="color: #008000;">myisam_max_extra_sort_file_size = 10G</span><span style="color: #008000;">
  55. #</span><span style="color: #008000;">myisam_repair_threads = 1</span><span style="color: #008000;">
  56. #</span><span style="color: #008000;">myisam_recover</span>
  57. lower_case_table_names = 1<span style="color: #000000;">
  58. skip</span>-name-<span style="color: #000000;">resolve
  59. slave</span>-skip-errors = 1032,1062<span style="color: #000000;">
  60. replicate</span>-ignore-db=<span style="color: #000000;">mysql
  61. server</span>-id = 1<span style="color: #000000;">
  62. innodb_additional_mem_pool_size </span>=<span style="color: #000000;"> 4M
  63. innodb_buffer_pool_size </span>=<span style="color: #000000;"> 32M
  64. innodb_data_file_path </span>=<span style="color: #000000;"> ibdata1:128M:autoextend
  65. innodb_file_io_threads </span>= 4<span style="color: #000000;">
  66. innodb_thread_concurrency </span>= 8<span style="color: #000000;">
  67. innodb_flush_log_at_trx_commit </span>= 2<span style="color: #000000;">
  68. innodb_log_buffer_size </span>=<span style="color: #000000;"> 2M
  69. innodb_log_file_size </span>=<span style="color: #000000;"> 4M
  70. innodb_log_files_in_group </span>= 3<span style="color: #000000;">
  71. innodb_max_dirty_pages_pct </span>= 90<span style="color: #000000;">
  72. innodb_lock_wait_timeout </span>= 120<span style="color: #000000;">
  73. innodb_file_per_table </span>=<span style="color: #000000;"> 0
  74. [mysqldump]
  75. quick
  76. max_allowed_packet </span>=<span style="color: #000000;"> 2M
  77. [mysqld_safe]
  78. log</span>-error=/mysqldata/3306/<span style="color: #000000;">mysql_oldboy3306.err
  79. pid</span>-file=/mysqldata/3306/<span style="color: #000000;">mysqld.pid
  80.  
  81. 实例 </span>1、3306<span style="color: #000000;"> 的启动文件，并授权执行的权限
  82. [root@mysql </span>3306]<span style="color: #008000;">#</span><span style="color: #008000;"> chmod +x /mysqldata/3306/mysql</span>
  83. [root@mysql 3306]<span style="color: #008000;">#</span><span style="color: #008000;"> cat mysql</span><span style="color: #008000;">
  84. #</span><span style="color: #008000;">!/bin/sh</span><span style="color: #008000;">
  85. #</span><span style="color: #008000;">###############################################</span><span style="color: #008000;">
  86. #</span><span style="color: #008000;">this scripts is created by oldboy at 2007-06-09</span><span style="color: #008000;">
  87. #</span><span style="color: #008000;">###############################################</span><span style="color: #008000;">
  88. #</span><span style="color: #008000;">init</span>
  89. port=3306<span style="color: #000000;">
  90. mysql_user</span>=<span style="color: #800000;">"</span><span style="color: #800000;">root</span><span style="color: #800000;">"</span><span style="color: #000000;">
  91. mysql_pwd</span>=<span style="color: #800000;">"</span><span style="color: #800000;">oldboy</span><span style="color: #800000;">"</span><span style="color: #000000;">
  92. CmdPath</span>=<span style="color: #800000;">"</span><span style="color: #800000;">/application/mysql/bin</span><span style="color: #800000;">"</span><span style="color: #000000;">
  93. mysql_sock</span>=<span style="color: #800000;">"</span><span style="color: #800000;">/mysqldata/${port}/mysql.sock</span><span style="color: #800000;">"</span>
  94. <span style="color: #008000;">#</span><span style="color: #008000;">startup function</span>
  95. <span style="color: #000000;">function_start_mysql()
  96. {
  97.  </span><span style="color: #0000ff;">if</span> [ ! -e <span style="color: #800000;">"</span><span style="color: #800000;">$mysql_sock</span><span style="color: #800000;">"</span><span style="color: #000000;"> ];then
  98.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Starting MySQL...\n</span><span style="color: #800000;">"</span>
  99.  /bin/sh ${CmdPath}/mysqld_safe --defaults-file=/mysqldata/${port}/my.cnf 2>&1 >
  100. /dev/null &
  101.  <span style="color: #0000ff;">else</span><span style="color: #000000;">
  102.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">MySQL is running...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  103.  exit
  104.  fi
  105. }
  106. </span><span style="color: #008000;">#</span><span style="color: #008000;">stop function</span>
  107. <span style="color: #000000;">function_stop_mysql()
  108. {
  109.  </span><span style="color: #0000ff;">if</span> [ ! -e <span style="color: #800000;">"</span><span style="color: #800000;">$mysql_sock</span><span style="color: #800000;">"</span><span style="color: #000000;"> ];then
  110.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">MySQL is stopped...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  111.  exit
  112.  </span><span style="color: #0000ff;">else</span><span style="color: #000000;">
  113.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Stoping MySQL...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  114.  ${CmdPath}</span>/mysqladmin -u ${mysql_user} -p${mysql_pwd} -<span style="color: #000000;">S
  115. </span>/mysqldata/${port}/<span style="color: #000000;">mysql.sock shutdown
  116.  fi
  117. }
  118. </span><span style="color: #008000;">#</span><span style="color: #008000;">restart function</span>
  119. <span style="color: #000000;">function_restart_mysql()
  120. {
  121.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Restarting MySQL...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  122.  function_stop_mysql
  123.  sleep </span>2<span style="color: #000000;">
  124.  function_start_mysql
  125. }
  126. case $</span>1 <span style="color: #0000ff;">in</span><span style="color: #000000;">
  127. start)
  128.  function_start_mysql
  129. ;;
  130. stop)
  131.  function_stop_mysql
  132. ;;
  133. restart)
  134.  function_restart_mysql
  135. ;;
  136. </span>*<span style="color: #000000;">)
  137.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Usage: /mysqldata/${port}/mysql {start|stop|restart}\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  138. esac
  139.  
  140. 更改 </span>3306<span style="color: #000000;"> 实例目录的属主和属组权限，初始化数据库
  141. [root@mysql </span>3306]<span style="color: #008000;">#</span><span style="color: #008000;"> chown -R mysql.mysql /mysqldata/3306</span>
  142. [root@mysql mysql]<span style="color: #008000;">#</span><span style="color: #008000;"> ./scripts/mysql_install_db --datadir=/mysqldata/3306/data --</span>
  143. basedir=/application/mysql --user=<span style="color: #000000;">mysql
  144. Installing MySQL system tables...
  145. OK
  146. Filling help tables...
  147. OK
  148. To start mysqld at boot time you have to copy
  149. support</span>-files/mysql.server to the right place <span style="color: #0000ff;">for</span><span style="color: #000000;"> your system
  150. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  151. To do so, start the server, then issue the following commands:
  152. </span>/application/mysql/bin/mysqladmin -u root password <span style="color: #800000;">‘</span><span style="color: #800000;">new-password</span><span style="color: #800000;">‘</span>
  153. /application/mysql/bin/mysqladmin -u root -h mysql password <span style="color: #800000;">‘</span><span style="color: #800000;">new-password</span><span style="color: #800000;">‘</span><span style="color: #000000;">
  154. Alternatively you can run:
  155. </span>/application/mysql/bin/<span style="color: #000000;">mysql_secure_installation
  156. which will also give you the option of removing the test
  157.  
  158. databases </span><span style="color: #0000ff;">and</span> anonymous user created by default. This <span style="color: #0000ff;">is</span><span style="color: #000000;">
  159. strongly recommended </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> production servers.
  160. See the manual </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> more instructions.
  161. You can start the MySQL daemon with:
  162. cd </span>/application/mysql ; /application/mysql/bin/mysqld_safe &<span style="color: #000000;">
  163. You can test the MySQL daemon with mysql</span>-test-<span style="color: #000000;">run.pl
  164. cd </span>/application/mysql/mysql-test ; perl mysql-test-<span style="color: #000000;">run.pl
  165. Please report any problems with the </span>/application/mysql/scripts/<span style="color: #000000;">mysqlbug script!
  166.  
  167. 启动 </span>3306<span style="color: #000000;"> 实例
  168. [root@mysql </span>3306]<span style="color: #008000;">#</span><span style="color: #008000;"> /mysqldata/3306/mysql start</span>
  169. [root@mysql 3306]<span style="color: #008000;">#</span><span style="color: #008000;"> lsof -i :3306</span>
  170. COMMAND PID USER FD TYPE DEVICE SIZE/<span style="color: #000000;">OFF NODE NAME
  171. mysqld </span>31375 mysql 12u IPv4 98252 0t0 TCP *:mysql (LISTEN)

 

2.3.5.2  3307 的实例

  1. 3307<span style="color: #000000;"> 实例配置文件
  2. [root@mysql </span>3307]<span style="color: #008000;">#</span><span style="color: #008000;"> ls</span>
  3. <span style="color: #000000;">data my.cnf（配置文件） mysql（程序启动文件） mysqld.pid mysql_oldboy3307.err
  4. mysql.sock
  5. [root@mysql </span>3307]<span style="color: #008000;">#</span><span style="color: #008000;"> cat my.cnf</span>
  6. <span style="color: #000000;">[client]
  7. port </span>= 3307<span style="color: #000000;">
  8. socket </span>= /mysqldata/3307/<span style="color: #000000;">mysql.sock
  9. [mysql]
  10. no</span>-auto-<span style="color: #000000;">rehash
  11. [mysqld]
  12. user </span>=<span style="color: #000000;"> mysql
  13. port </span>= 3307<span style="color: #000000;">
  14. socket </span>= /mysqldata/3307/<span style="color: #000000;">mysql.sock
  15. basedir </span>= /application/<span style="color: #000000;">mysql
  16. datadir </span>= /mysqldata/3307/<span style="color: #000000;">data
  17. open_files_limit </span>= 1024<span style="color: #000000;">
  18. back_log </span>= 600<span style="color: #000000;">
  19. max_connections </span>= 800<span style="color: #000000;">
  20. max_connect_errors </span>= 3000<span style="color: #000000;">
  21. table_cache </span>= 614<span style="color: #000000;">
  22. external</span>-locking =<span style="color: #000000;"> FALSE
  23. max_allowed_packet </span>=<span style="color: #000000;">8M
  24. sort_buffer_size </span>=<span style="color: #000000;"> 1M
  25.  
  26. join_buffer_size </span>=<span style="color: #000000;"> 1M
  27. thread_cache_size </span>= 100<span style="color: #000000;">
  28. thread_concurrency </span>= 2<span style="color: #000000;">
  29. query_cache_size </span>=<span style="color: #000000;"> 2M
  30. query_cache_limit </span>=<span style="color: #000000;"> 1M
  31. query_cache_min_res_unit </span>=<span style="color: #000000;"> 2k
  32. </span><span style="color: #008000;">#</span><span style="color: #008000;">default_table_type = InnoDB</span>
  33. thread_stack =<span style="color: #000000;"> 192K
  34. </span><span style="color: #008000;">#</span><span style="color: #008000;">transaction_isolation = READ-COMMITTED</span>
  35. tmp_table_size =<span style="color: #000000;"> 2M
  36. max_heap_table_size </span>=<span style="color: #000000;"> 2M
  37. </span><span style="color: #008000;">#</span><span style="color: #008000;">long_query_time = 1</span><span style="color: #008000;">
  38. #</span><span style="color: #008000;">log_long_format</span><span style="color: #008000;">
  39. #</span><span style="color: #008000;">log-error = /data/3307/error.log</span><span style="color: #008000;">
  40. #</span><span style="color: #008000;">log-slow-queries = /data/3307/slow.log</span>
  41. pid-file = /mysqldata/3307/<span style="color: #000000;">mysql.pid
  42. </span><span style="color: #008000;">#</span><span style="color: #008000;">log-bin = /data/3307/mysql-bin</span>
  43. relay-log = /mysqldata/3307/relay-<span style="color: #000000;">bin
  44. relay</span>-log-info-file = /mysqldata/3307/relay-<span style="color: #000000;">log.info
  45. binlog_cache_size </span>=<span style="color: #000000;"> 1M
  46. max_binlog_cache_size </span>=<span style="color: #000000;"> 1M
  47. max_binlog_size </span>=<span style="color: #000000;"> 2M
  48. expire_logs_days </span>= 7<span style="color: #000000;">
  49. key_buffer_size </span>=<span style="color: #000000;"> 16M
  50. read_buffer_size </span>=<span style="color: #000000;"> 1M
  51. read_rnd_buffer_size </span>=<span style="color: #000000;"> 1M
  52. bulk_insert_buffer_size </span>=<span style="color: #000000;"> 1M
  53. </span><span style="color: #008000;">#</span><span style="color: #008000;">myisam_sort_buffer_size = 1M</span><span style="color: #008000;">
  54. #</span><span style="color: #008000;">myisam_max_sort_file_size = 10G</span><span style="color: #008000;">
  55. #</span><span style="color: #008000;">myisam_max_extra_sort_file_size = 10G</span><span style="color: #008000;">
  56. #</span><span style="color: #008000;">myisam_repair_threads = 1</span><span style="color: #008000;">
  57. #</span><span style="color: #008000;">myisam_recover</span>
  58. lower_case_table_names = 1<span style="color: #000000;">
  59. skip</span>-name-<span style="color: #000000;">resolve
  60. slave</span>-skip-errors = 1032,1062<span style="color: #000000;">
  61. replicate</span>-ignore-db=<span style="color: #000000;">mysql
  62. server</span>-id = 3<span style="color: #000000;">
  63. innodb_additional_mem_pool_size </span>=<span style="color: #000000;"> 4M
  64. innodb_buffer_pool_size </span>=<span style="color: #000000;"> 32M
  65. innodb_data_file_path </span>=<span style="color: #000000;"> ibdata1:128M:autoextend
  66. innodb_file_io_threads </span>= 4<span style="color: #000000;">
  67.  
  68. innodb_thread_concurrency </span>= 8<span style="color: #000000;">
  69. innodb_flush_log_at_trx_commit </span>= 2<span style="color: #000000;">
  70. innodb_log_buffer_size </span>=<span style="color: #000000;"> 2M
  71. innodb_log_file_size </span>=<span style="color: #000000;"> 4M
  72. innodb_log_files_in_group </span>= 3<span style="color: #000000;">
  73. innodb_max_dirty_pages_pct </span>= 90<span style="color: #000000;">
  74. innodb_lock_wait_timeout </span>= 120<span style="color: #000000;">
  75. innodb_file_per_table </span>=<span style="color: #000000;"> 0
  76. [mysqldump]
  77. quick
  78. max_allowed_packet </span>=<span style="color: #000000;"> 2M
  79. `
  80. [mysqld_safe]
  81. log</span>-error=/mysqldata/3307/<span style="color: #000000;">mysql_oldboy3307.err
  82. pid</span>-file=/mysqldata/3307/<span style="color: #000000;">mysqld.pid
  83.  
  84. </span>3307<span style="color: #000000;"> 实例的启动配置文件
  85. [root@mysql </span>3307]<span style="color: #008000;">#</span><span style="color: #008000;"> cat /mysqldata/3307/mysql</span><span style="color: #008000;">
  86. #</span><span style="color: #008000;">!/bin/sh</span><span style="color: #008000;">
  87. #</span><span style="color: #008000;">###############################################</span><span style="color: #008000;">
  88. #</span><span style="color: #008000;">this scripts is created by oldboy at 2007-06-09</span><span style="color: #008000;">
  89. #</span><span style="color: #008000;">oldboy QQ:31333741</span><span style="color: #008000;">
  90. #</span><span style="color: #008000;">site:http://www.etiantian.org</span><span style="color: #008000;">
  91. #</span><span style="color: #008000;">blog:http://oldboy.blog.51cto.com</span><span style="color: #008000;">
  92. #</span><span style="color: #008000;">oldboy trainning QQ group: 208160987 226199307 44246017</span><span style="color: #008000;">
  93. #</span><span style="color: #008000;">###############################################</span><span style="color: #008000;">
  94. #</span><span style="color: #008000;">init</span>
  95. port=3307<span style="color: #000000;">
  96. mysql_user</span>=<span style="color: #800000;">"</span><span style="color: #800000;">root</span><span style="color: #800000;">"</span><span style="color: #000000;">
  97. mysql_pwd</span>=<span style="color: #800000;">"</span><span style="color: #800000;">oldboy</span><span style="color: #800000;">"</span><span style="color: #000000;">
  98. CmdPath</span>=<span style="color: #800000;">"</span><span style="color: #800000;">/application/mysql/bin</span><span style="color: #800000;">"</span><span style="color: #000000;">
  99. mysql_sock</span>=<span style="color: #800000;">"</span><span style="color: #800000;">/mysqldata/${port}/mysql.sock</span><span style="color: #800000;">"</span>
  100. <span style="color: #008000;">#</span><span style="color: #008000;">startup function</span>
  101. <span style="color: #000000;">function_start_mysql()
  102. {
  103.  </span><span style="color: #0000ff;">if</span> [ ! -e <span style="color: #800000;">"</span><span style="color: #800000;">$mysql_sock</span><span style="color: #800000;">"</span><span style="color: #000000;"> ];then
  104.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Starting MySQL...\n</span><span style="color: #800000;">"</span>
  105.  /bin/sh ${CmdPath}/mysqld_safe --defaults-file=/mysqldata/${port}/my.cnf 2>&1 >
  106. /dev/null &
  107.  <span style="color: #0000ff;">else</span><span style="color: #000000;">
  108.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">MySQL is running...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  109.  exit
  110.  fi
  111. }
  112. </span><span style="color: #008000;">#</span><span style="color: #008000;">stop function</span>
  113. <span style="color: #000000;">function_stop_mysql()
  114. {
  115.  </span><span style="color: #0000ff;">if</span> [ ! -e <span style="color: #800000;">"</span><span style="color: #800000;">$mysql_sock</span><span style="color: #800000;">"</span><span style="color: #000000;"> ];then
  116.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">MySQL is stopped...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  117.  exit
  118.  </span><span style="color: #0000ff;">else</span><span style="color: #000000;">
  119.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Stoping MySQL...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  120.  ${CmdPath}</span>/mysqladmin -u ${mysql_user} -p${mysql_pwd} -<span style="color: #000000;">S
  121. </span>/mysqldata/${port}/<span style="color: #000000;">mysql.sock shutdown
  122.  fi
  123. }
  124. </span><span style="color: #008000;">#</span><span style="color: #008000;">restart function</span>
  125. <span style="color: #000000;">function_restart_mysql()
  126. {
  127.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Restarting MySQL...\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  128.  function_stop_mysql
  129.  sleep </span>2<span style="color: #000000;">
  130.  function_start_mysql
  131. }
  132. case $</span>1 <span style="color: #0000ff;">in</span><span style="color: #000000;">
  133. start)
  134.  function_start_mysql
  135. ;;
  136. stop)
  137.  function_stop_mysql
  138. ;;
  139. restart)
  140.  function_restart_mysql
  141. ;;
  142. </span>*<span style="color: #000000;">)
  143.  printf </span><span style="color: #800000;">"</span><span style="color: #800000;">Usage: /mysqldata/${port}/mysql {start|stop|restart}\n</span><span style="color: #800000;">"</span><span style="color: #000000;">
  144. esac
  145.  
  146.  
  147. 更改 </span>3307<span style="color: #000000;"> 实例的目录权限，初始化数据库
  148. [root@mysql </span>3307]<span style="color: #008000;">#</span><span style="color: #008000;"> chown -R mysql.root /mysqldata/3307</span>
  149. [root@mysql mysql]<span style="color: #008000;">#</span><span style="color: #008000;"> ./scripts/mysql_install_db --datadir=/mysqldata/3307/data --</span>
  150. basedir=/application/mysql --user=<span style="color: #000000;">mysql
  151. Installing MySQL system tables...
  152. OK
  153. Filling help tables...
  154. OK
  155.  
  156. To start mysqld at boot time you have to copy
  157. support</span>-files/mysql.server to the right place <span style="color: #0000ff;">for</span><span style="color: #000000;"> your system
  158. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  159. To do so, start the server, then issue the following commands:
  160. </span>/application/mysql/bin/mysqladmin -u root password <span style="color: #800000;">‘</span><span style="color: #800000;">new-password</span><span style="color: #800000;">‘</span>
  161. /application/mysql/bin/mysqladmin -u root -h mysql password <span style="color: #800000;">‘</span><span style="color: #800000;">new-password</span><span style="color: #800000;">‘</span><span style="color: #000000;">
  162. Alternatively you can run:
  163. </span>/application/mysql/bin/<span style="color: #000000;">mysql_secure_installation
  164. which will also give you the option of removing the test
  165. databases </span><span style="color: #0000ff;">and</span> anonymous user created by default. This <span style="color: #0000ff;">is</span><span style="color: #000000;">
  166. strongly recommended </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> production servers.
  167. See the manual </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> more instructions.
  168. You can start the MySQL daemon with:
  169. cd </span>/application/mysql ; /application/mysql/bin/mysqld_safe &<span style="color: #000000;">
  170. You can test the MySQL daemon with mysql</span>-test-<span style="color: #000000;">run.pl
  171. cd </span>/application/mysql/mysql-test ; perl mysql-test-<span style="color: #000000;">run.pl
  172. Please report any problems with the </span>/application/mysql/scripts/<span style="color: #000000;">mysqlbug script!
  173. 启动 </span>3307<span style="color: #000000;"> 实例
  174. [root@mysql mysql]</span><span style="color: #008000;">#</span><span style="color: #008000;"> /mysqldata/3307/mysql start</span>
  175. <span style="color: #000000;">Starting MySQL...
  176. [root@mysql mysql]</span><span style="color: #008000;">#</span><span style="color: #008000;"> lsof -i :3307</span>
  177. COMMAND PID USER FD TYPE DEVICE SIZE/<span style="color: #000000;">OFF NODE NAME
  178. mysqld </span>32195 mysql 11u IPv4 99276 0t0 TCP *:opsession-prxy (LISTEN)

 

2.3.6 多实例通过本地登录

    多实例本地登录一般是通过 socket 文件来指定具体到那个实例的，此文件的具体位置是在 mysql 编译过程或者 my.cnf 文件里指定的，在本地登录数据库时，登录程序会通过socket 文件来判断登录的是哪个数据库实例例如：通过 mysql –uroot –ppcwangjixuan –S /mysqldata/3307/mysql.sock 可知，登录的是 3307 这个实例，mysql.sock 文件是 mysql 服务端与本地 mysql 客户端进行通信的 unix 套接字文件。

2.3.7  远程连接登录 mysql 多实例  

        远程登录 mysql 多实例中的一个实例中，通过 TCP 端口（port）来指定所要登录的mysql 实例，此端口的配置是在 mysql 配置文件 my.cnf 中指定的例如：在 mysql –oldboy –ppcwangjixuan –h 10.0.0.171 –P 3307 中，-P 为端口参数，后面接具体的实例端口，端口是一种逻辑连接位置，是客户端程序被分派到计算机上特殊服务程序的一种方式，强调提前在 10.0.0.171 上对 oldboy 用户做了授权。

02.mysql多实例安装实战

标签：password   daemon   ops   计算   session   div   chmod   逻辑   read   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！