Shulou(Shulou.com)06/03 Report--

Install dependency packages

Yum install-y centos-release-scl devtoolset-4-gcc-c++ devtoolset-4-gcc cmake openssl-devel bison git gmock ncurses ncurses-* autoconf

Create an account

Groupadd mysql & & useradd-r-g mysql mysql

Wget http://mirror.cnop.net/alisql/AliSQL-5.6.32.zip & & unzip AliSQL-5.6.32.zip & & cd AliSQL-master

Scl enable devtoolset-4 bash

Mkdir source_downloads & cd source_downloads & & wget http://mirror.cnop.net/gmock/gmock-1.6.0.zip & & cd.

Compile:

Cmake\

-DCMAKE_INSTALL_PREFIX=/usr/local/alisql\

-DMYSQL_UNIX_ADDR=/usr/local/alisql/mysql.sock\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_ARCHIVE_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DMYSQL_DATADIR=/usr/local/alisql/data\

-DMYSQL_TCP_PORT=3306\

-DENABLE_DOWNLOADS=1

Installation:

Make

Make install

Chown-R mysql.mysql / usr/local/alisql/

Echo never > / sys/kernel/mm/transparent_hugepage/enabled

Initialization data:

Chmod + x. / scripts/mysql_install_db

. / scripts/mysql_install_db-- user=mysql-- basedir=/usr/local/alisql-- datadir=/usr/local/alisql/data

Vi / etc/my.cnf # add the following

[client]

Port = 3306

Socket = / tmp/mysql.sock

[mysqld]

Port = 3306

Socket = / tmp/mysql.sock

Datadir = / usr/local/alisql/data

Skip-external-locking

Key_buffer_size = 16m

Max_allowed_packet = 10m

Table_open_cache = 64

Sort_buffer_size = 512K

Net_buffer_length = 8K

Read_buffer_size = 256K

Read_rnd_buffer_size = 512K

Myisam_sort_buffer_size = 8m

Thread_cache_size = 8

Query_cache_size = 8m

Tmp_table_size = 16m

Max_connections = 500,

Max_connect_errors = 100

Open_files_limit = 65535

Log-bin=mysql-bin

Binlog_format=mixed

Server-id = 1

Expire_logs_days = 10

Default_storage_engine = InnoDB

Innodb_file_per_table = 1

Innodb_data_home_dir = / usr/local/alisql/data

Innodb_data_file_path = ibdata1:10M:autoextend

Innodb_log_group_home_dir = / usr/local/alisql/data

Innodb_buffer_pool_size = 16m

Innodb_additional_mem_pool_size = 2m

Innodb_log_file_size = 5m

Innodb_log_buffer_size = 8m

Innodb_flush_log_at_trx_commit = 1

Innodb_lock_wait_timeout = 50

Copy the startup item:

Cp support-files/mysql.server / etc/init.d/mysqld

Environment variable configuration:

Vi / etc/profile # add the following

PATH=/usr/local/alisql/bin:/usr/local/alisql/lib:$PATH

Export PATH

Source / etc/profile

Soft links:

Ln-s / usr/local/alisql/bin/mysql / usr/bin

Start and set up boot:

Chmod + x / etc/init.d/mysqld

Service mysqld start

Chkconfig-level 35 mysqld on

Check to see if it starts:

Netstat-tulnp | grep 3306

Mysql-u root-p # default root password is empty

# authorize a new password

Mysqladmin-uroot-p password 123456

# enter the confirmation password once after running (here is 123456)

Mysql-uroot-p # sign in again

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.