mysql 5.6 二进制安装_MySQL.5.6的二进制安装

环境：

1 [root@node ~]# cat /etc/redhat-release2 CentOS Linux release 7.2.1511(Core)3 [root@node ~]# uname -a4 Linux node 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux5 [root@node ~]#

软件版本：

1 [root@node ~]# cd tools/

2 [root@node tools]# ls -l3 total 320864

4 -rw-r--r-- 1 root root 328563044 May 6 16:35 mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz5 [root@node tools]#

创建用于MySQL使用的用户和用户组及数据存放目录：

1 [root@node tools]# groupadd mysql2 [root@node tools]# useradd -g mysql mysql -s /sbin/nologin3 [root@node tools]# mkdir -p /data/mysql4 [root@node tools]# chown -R mysql.mysql mysql5 [root@node tools]# chown -R mysql.mysql /data/mysql/

解压MySQL二进制包，移到指定位置(/usr/local目录)，并创建软链接

1 [root@node local]# ln -s mysql-5.6.40-linux-glibc2.12-x86_64 mysql2 [root@node local]# chown -R mysql.mysql mysql3 [root@node local]# chown -R mysql.mysql /data/mysql/

4 [root@node local]#

调整配置文件my.cnf。

1 [client]2 port = 3306

3 socket = /tmp/mysql.sock4 default-character-set =utf85 [mysql]6 default-character-set =utf87 [mysqld]8 port = 3306

9 socket = /tmp/mysql.sock10 basedir = /usr/local/mysql11 datadir = /data/mysql12 open_files_limit = 65535

13 back_log = 103

14 max_connections = 512

15 max_connect_errors = 100000

16 table_open_cache = 512

17 external-locking =FALSE18 max_allowed_packet =128M19 sort_buffer_size =2M20 join_buffer_size =2M21 thread_cache_size = 51

22 query_cache_size =32M23 tmp_table_size =96M24 max_heap_table_size =96M25 slow_query_log = 1

26 slow_query_log_file = /data/mysql/slow.log27 log-error = /data/mysql/error.log28 long_query_time = 0.5

29 server-id = 2213306

30 log-bin = /data/mysql/mysql-bin31 sync_binlog = 1

32 binlog_cache_size =4M33 max_binlog_cache_size =128M34 max_binlog_size =1024M35 expire_logs_days = 7

36 key_buffer_size =32M37 read_buffer_size =1M38 read_rnd_buffer_size =16M39 bulk_insert_buffer_size =64M40 character-set-server =utf841 default-storage-engine =InnoDB42 binlog_format =row43 #gtid_mode =on44 #log_slave_updates = 1

45 interactive_timeout = 300

46 wait_timeout = 300

47 transaction_isolation = REPEATABLE-READ48 innodb_buffer_pool_size =143M49 innodb_data_file_path =ibdata1:1024M:autoextend50 innodb_flush_log_at_trx_commit = 1

51 innodb_log_buffer_size =16M52 innodb_log_file_size =256M53 innodb_log_files_in_group = 2

54 innodb_max_dirty_pages_pct = 50

55 innodb_file_per_table = 1

56 innodb_locks_unsafe_for_binlog = 0

57 [mysqldump]58 quick59 max_allowed_packet = 32M

MySQL5.7.x配置文件(仅供参考)：

1 [client]2 port = 3306

3 socket = /tmp/mysql.sock4

5 [mysql]6 prompt="\u@db \R:\m:\s [\d]>"

7 no-auto-rehash8

9 [mysqld]10 user =mysql11 port = 3306

12 basedir = /usr/local/mysql13 datadir = /data/mysql/

14 socket = /tmp/mysql.sock15 character-set-server =utf8mb416 skip_name_resolve = 1

17 open_files_lim