Big environment MySQL5.6 source code Installation Practice step by step teach you CentOS6.5 _ 64bit under the compilation and installation of MySQL-5.6.23 @ guoyJoe

Big environment MySQL5.6 source code Installation Practice step by step teach you CentOS6.5 _ 64bit under the compilation and installation of MySQL-5.6.23 @ guoyJoe

 

1. Disable the Firewall

 

chkconfig iptables off service iptables stop 

 

 

3. Delete MyQL (the mysql-libs that comes with the redhat6.3 Server is a mysql-libs-5.1.61-4.el6.x86_64 and may conflict with the mysql-libs of a later version)

Groupadd mysql # Add User Group useradd-d/home/mysql-g mysql

 

 

8. Create a directory and grant permissions

 

mkdir -p /u01/my3306/datamkdir -p /u01/my3306/log/iblogmkdir -p /u01/my3306/log/binlogmkdir -p /u01/my3306/log/relaylogmkdir -p /u01/my3306/runmkdir -p /u01/my3306/tmpchown -R mysql:mysql /u01/my3306chmod -R 777 /u01/my3306

 

 

10. Compile and install

 

cmake \-DCMAKE_INSTALL_PREFIX=/u01/my3306 \-DINSTALL_DATADIR=/u01/my3306/data  \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DWITH_SSL=yes \-DWITH_EMBEDDED_SERVER=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DENABLED_LOCAL_INFILE=1 \-DSYSCONFDIR=/etc \-DWITH_READLINE=onmakemake install

 

 

[client]port=3306socket=/u01/my3306/mysql.sock[mysql]pid_file=/u01/my3306/run/mysqld.pid[mysqld]# disable autocommitautocommit=0general_log=offexplicit_defaults_for_timestamp=truesha256_password_private_key_path=/u01/my3306/mykey.pemsha256_password_public_key_path=/u01/my3306/mykey.pub# systembasedir=/u01/my3306datadir=/u01/my3306/datamax_allowed_packet=134217728max_connections=8192max_user_connections=8000open_files_limit=65535pid_file=/u01/my3306/run/mysqld.pidport=3306server_id=101skip_name_resolve=ONsocket=/u01/my3306/run/mysql.socktmpdir=/u01/my3306/tmp#binlog#log-bin=/u01/my3306/log/binloglog_bin=/u01/my3306/log/binlog/binlogbinlog_cache_size=32768binlog_format=rowexpire_logs_days=7log_slave_updates=ONmax_binlog_cache_size=2147483648max_binlog_size=524288000sync_binlog=100#logginglog_error=/u01/my3306/log/alert.logslow_query_log_file=/u01/my3306/log/slow.loglog_queries_not_using_indexes=1slow_query_log=1log_slave_updates=ONlog_slow_admin_statements=1long_query_time=1#relayrelay_log=/u01/my3306/log/relaylogrelay_log_index=/u01/my3306/log/relay.indexrelay_log_info_file=/u01/my3306/log/relay-log.info#slaveslave_load_tmpdir=/u01/my3306/tmpslave_skip_errors=OFF#innodbinnodb_data_home_dir=/u01/my3306/log/ibloginnodb_log_group_home_dir=/u01/my3306/log/ibloginnodb_adaptive_flushing=ONinnodb_adaptive_hash_index=ONinnodb_autoinc_lock_mode=1innodb_buffer_pool_instances=8#defaultinnodb_change_buffering=insertsinnodb_checksums=ONinnodb_buffer_pool_size= 128Minnodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextendinnodb_doublewrite=ONinnodb_file_format=Barracudainnodb_file_per_table=ONinnodb_flush_log_at_trx_commit=1innodb_flush_method=O_DIRECTinnodb_io_capacity=1000innodb_lock_wait_timeout=10innodb_log_buffer_size=67108864innodb_log_file_size=1048576000innodb_log_files_in_group=4innodb_max_dirty_pages_pct=60innodb_open_files=60000innodb_purge_threads=1innodb_read_io_threads=4innodb_stats_on_metadata=OFFinnodb_support_xa=ONinnodb_use_native_aio=OFFinnodb_write_io_threads=10[mysqld_safe]datadir=/u01/my3306/data

 

 

rm -rf /u01/my3306/data/*rm -rf /u01/my3306/log/iblog/*rm -rf /u01/my3306/log/binlog/*chmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/chmod 755 /u01/my3306/my.cnf./scripts/mysql_install_db  --defaults-file=/u01/my3306/my.cnf --datadir=/u01/my3306/data --user=mysqlchmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/

Defaults-file indicates to specify the default configuration file. If this parameter is not specified, the default priority of the system is to use/etc/my first. cnf is used as the mysql configuration file, and those parameters of make are set in whitelist.

 

 

 

13. Start mysql

Vi. bash_profile --- add PATH = $ PATH: $ HOME/bin:/u01/my3306/binmysqld_safe -- defaults-file =/u01/my3306/my under the root user. cnf -- user = mysql &

 

 

[root@uubee8 ~]# mysql -h127.0.0.1 -urootWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.23-log Source distributionCopyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show variables like '%log-bin%';Empty set (0.00 sec)mysql> show variables like '%bin%';+-----------------------------------------+------------------------------+| Variable_name                           | Value                        |+-----------------------------------------+------------------------------+| bind_address                            | *                            || binlog_cache_size                       | 32768                        || binlog_checksum                         | CRC32                        || binlog_direct_non_transactional_updates | OFF                          || binlog_error_action                     | IGNORE_ERROR                 || binlog_format                           | ROW                          || binlog_gtid_simple_recovery             | OFF                          || binlog_max_flush_queue_time             | 0                            || binlog_order_commits                    | ON                           || binlog_row_image                        | FULL                         || binlog_rows_query_log_events            | OFF                          || binlog_stmt_cache_size                  | 32768                        || binlogging_impossible_mode              | IGNORE_ERROR                 || innodb_api_enable_binlog                | OFF                          || innodb_locks_unsafe_for_binlog          | OFF                          || log_bin                                 | ON                           || log_bin_basename                        | /u01/my3306/log/binlog       || log_bin_index                           | /u01/my3306/log/binlog.index || log_bin_trust_function_creators         | OFF                          || log_bin_use_v1_row_events               | OFF                          || max_binlog_cache_size                   | 2147483648                   || max_binlog_size                         | 524288000                    || max_binlog_stmt_cache_size              | 18446744073709547520         || simplified_binlog_gtid_recovery         | OFF                          || sql_log_bin                             | ON                           || sync_binlog                             | 100                          |+-----------------------------------------+------------------------------+26 rows in set (0.00 sec)

######################################## ######################################## ######################################## ##########

 

 

1. initialize the MySQL script: sh init3306.shrm-rf/u01/my3306/data/* rm-rf/u01/my3306/log/iblog/* rm-rf/u01/my3306/log/binlog/* chmod- R 777/u01/my3306/data/chmod-R 777/u01/my3306/log/iblog/chmod-R 777/u01/my3306/log/binlog/chmod 755/u01/ my3306/my. cnf. /scripts/mysql_install_db -- defaults-file =/u01/my3306/my. cnf -- datadir =/u01/my3306/data -- user = mysqlchmod-R 777/u01/my3306/data/chmod-R 777/u01/my3306/log/iblog/chmod-R 777/u01/my3306/log/binlog/2. start MySQL script sh start3306.shmysqld _ safe -- defaults-file =/u01/my3306/my. cnf -- user = mysql & 3. log on to the MySQL script sh logon3306.shmysql-h127.0.0.1-uroot.