你的位置:首页 > 软件开发 > 操作系统 > MySQL多实例安装

MySQL多实例安装

发布时间:2016-04-08 22:00:10
1.安装MySQL需要的依赖的包和编译软件 (1)安装MySQL需要的依赖包安装MySQL之前,最好先安装MySQL需要的依赖包,不然后面会出现报错,还得回来安装MySQL的依赖包。[root@Mysql-server tools]# yum install -y ncurs ...

MySQL多实例安装

 

1.安装MySQL需要的依赖的包和编译软件(2)安装编译MySQL需要的软件2.1 创建用户mysql
  1. tar zxf mysql-5.5.32.tar.gz cd mysql-5.5.32
    1. [root@mysql mysql-5.5.32]# rm CMakeCache.txt ###删除这个文件,重新cmake
     
    1. [root@mysql /]# unzip data.zip ##上传到根下,加压会替换上面创建的/data目录
    2. Archive: data.zip
    3. inflating: data/3306/my.cnf
    4. inflating: data/3306/mysql
    5. inflating: data/3307/my.cnf
    6. inflating: data/3307/mysql
    7. [root@mysql /]# tree /data
    8. data/ data.zip
    9. [root@mysql /]# tree data
    10. data/ data.zip
    11. [root@mysql /]# tree data/
    12. data/
    13. ├──3306
    14. │??├── data
    15. │??├── my.cnf ##实例的配置文件
    16. │??└── mysql ##实例的启动文件
    17. ├──3307
    18. │??├── data
    19. │??├── my.cnf ##实例的配置文件
    20. │??└── mysql ##实例的启动文件
    21. └── test
    1. [root@mysql /]# cat /data/3306/my.cnf
    2. [client]
    3. port =3306
    4. socket =/data/3306/mysql.sock
    5. [mysql]
    6. no-auto-rehash
    7. [mysqld]
    8. user = mysql
    9. port =3306
    10. socket =/data/3306/mysql.sock
    11. basedir =/application/mysql
    12. datadir =/data/3306/data
    13. open_files_limit =1024
    14. back_log =600
    15. max_connections =800
    16. max_connect_errors =3000
    17. table_cache =614
    18. external-locking = FALSE
    19. max_allowed_packet =8M
    20. sort_buffer_size =1M
    21. join_buffer_size =1M
    22. thread_cache_size =100
    23. thread_concurrency =2
    24. query_cache_size =2M
    25. query_cache_limit =1M
    26. query_cache_min_res_unit =2k
    27. #default_table_type = InnoDB
    28. thread_stack =192K
    29. #transaction_isolation = READ-COMMITTED
    30. tmp_table_size =2M
    31. max_heap_table_size =2M
    32. long_query_time =1
    33. #log_long_format
    34. #log-error = /data/3306/error.log
    35. #log-slow-queries = /data/3306/slow.log
    36. pid-file =/data/3306/mysql.pid
    37. log-bin =/data/3306/mysql-bin
    38. relay-log =/data/3306/relay-bin
    39. relay-log-info-file =/data/3306/relay-log.info
    40. binlog_cache_size =1M
    41. max_binlog_cache_size =1M
    42. max_binlog_size =2M
    43. expire_logs_days =7
    44. key_buffer_size =16M
    45. read_buffer_size =1M
    46. read_rnd_buffer_size =1M
    47. bulk_insert_buffer_size =1M
    48. #myisam_sort_buffer_size = 1M
    49. #myisam_max_sort_file_size = 10G
    50. #myisam_max_extra_sort_file_size = 10G
    51. #myisam_repair_threads = 1
    52. #myisam_recover
    53. lower_case_table_names =1
    54. skip-name-resolve
    55. slave-skip-errors =1032,1062
    56. replicate-ignore-db=mysql
    57. server-id =1
    58. innodb_additional_mem_pool_size =4M
    59. innodb_buffer_pool_size =32M
    60. innodb_data_file_path = ibdata1:128M:autoextend
    61. innodb_file_io_threads =4
    62. innodb_thread_concurrency =8
    63. innodb_flush_log_at_trx_commit =2
    64. innodb_log_buffer_size =2M
    65. innodb_log_file_size =4M
    66. innodb_log_files_in_group =3
    67. innodb_max_dirty_pages_pct =90
    68. innodb_lock_wait_timeout =120
    69. innodb_file_per_table =0
    70. [mysqldump]
    71. quick
    72. max_allowed_packet =2M
    73. [mysqld_safe]
    74. log-error=/data/3306/mysql_oldboy3306.err
    75. pid-file=/data/3306/mysqld.pid
    1. [root@mysql /]# cat /data/3307/my.cnf
    2. [client]
    3. port =3307
    4. socket =/data/3307/mysql.sock
    5. [mysql]
    6. no-auto-rehash
    7. [mysqld]
    8. user = mysql
    9. port =3307
    10. socket =/data/3307/mysql.sock
    11. basedir =/application/mysql
    12. datadir =/data/3307/data
    13. open_files_limit =1024
    14. back_log =600
    15. max_connections =800
    16. max_connect_errors =3000
    17. table_cache =614
    18. external-locking = FALSE
    19. max_allowed_packet =8M
    20. sort_buffer_size =1M
    21. join_buffer_size =1M
    22. thread_cache_size =100
    23. thread_concurrency =2
    24. query_cache_size =2M
    25. query_cache_limit =1M
    26. query_cache_min_res_unit =2k
    27. #default_table_type = InnoDB
    28. thread_stack =192K
    29. #transaction_isolation = READ-COMMITTED
    30. tmp_table_size =2M
    31. max_heap_table_size =2M
    32. #long_query_time = 1
    33. #log_long_format
    34. #log-error = /data/3307/error.log
    35. #log-slow-queries = /data/3307/slow.log
    36. pid-file =/data/3307/mysql.pid
    37. #log-bin = /data/3307/mysql-bin
    38. relay-log =/data/3307/relay-bin
    39. relay-log-info-file =/data/3307/relay-log.info
    40. binlog_cache_size =1M
    41. max_binlog_cache_size =1M
    42. max_binlog_size =2M
    43. expire_logs_days =7
    44. key_buffer_size =16M
    45. read_buffer_size =1M
    46. read_rnd_buffer_size =1M
    47. bulk_insert_buffer_size =1M
    48. #myisam_sort_buffer_size = 1M
    49. #myisam_max_sort_file_size = 10G
    50. #myisam_max_extra_sort_file_size = 10G
    51. #myisam_repair_threads = 1
    52. #myisam_recover
    53. lower_case_table_names =1
    54. skip-name-resolve
    55. slave-skip-errors =1032,1062
    56. replicate-ignore-db=mysql
    57. server-id =3
    58. innodb_additional_mem_pool_size =4M
    59. innodb_buffer_pool_size =32M
    60. innodb_data_file_path = ibdata1:128M:autoextend
    61. innodb_file_io_threads =4
    62. innodb_thread_concurrency =8
    63. innodb_flush_log_at_trx_commit =2
    64. innodb_log_buffer_size =2M
    65. innodb_log_file_size =4M
    66. innodb_log_files_in_group =3
    67. innodb_max_dirty_pages_pct =90
    68. innodb_lock_wait_timeout =120
    69. innodb_file_per_table =0
    70. [mysqldump]
    71. quick
    72. max_allowed_packet =2M
    73. [mysqld_safe]
    74. log-error=/data/3307/mysql_oldboy3307.err
    75. pid-file=/data/3307/mysqld.pid
    特别说明: mysqladmin -u root -p123456 -S /data/3306/mysql.sock shutdown     如果不为MySQL的命令配置全局路径,就无法直接在命令行输入mysql,这样只能用全路径/application/msyq/bin/mysql 这样带着路径输出会比较麻烦
    1. [root@mysql /]# tail -1/etc/profile
    2. export PATH=/application/mysql/bin:$PATH ##添加如下行
    3. [root@mysql /]# source /etc/profile ##让其生效
    1. [root@mysql /]# echo $PATH
    2. /application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
    1. cd /application/mysql/scripts/##注意和MySQL 5.1的路径不同,MySQL 5.1 不在mysql/bin下
    2. ./mysql_install_db --basedir=/application/mysql --datadir=/data/3306/data/--user=mysql
    3. ./mysql_install_db --basedir=/application/mysql --datadir=/data/3307/data/--user=mysql
    当初始化的过程中出现两个OK时,表示初始化成功MySQL多实例安装
    1. [root@mysql scripts]# sed -i '13 s#oldboy#123456#g'/data/3306/mysql
    2. [root@mysql scripts]# sed -n '13p'/data/3306/mysql
    3. mysql_pwd="123456"
    4. [root@mysql scripts]# sed -i '13 s#oldboy#123456#g' /data/3307/mysql[root@mysql scripts]# sed -n '13p' /data/3307/mysql mysql_pwd="123456"[root@mysql scripts]#
      1. [root@mysql scripts]#/data/3306/mysql stop
      2. StopingMySQL...
      3. [root@mysql scripts]#/data/3307/mysql stop
      4. StopingMySQL...
      5. [root@mysql scripts]#
      新增一个多实例库3308,操作命令如下 

       

      附件列表


      原标题:MySQL多实例安装

      关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

可能感兴趣文章

我的浏览记录