MYSQL教程CentOS 6.5编译安装Percona 5.6.15(步骤)

rpm -qa | grep mysql 

rpm -e mysql   #普通删除模式 
rpm -e --nodeps mysql    #强行删除模式,如果使用上面命令删除时,提示有依赖的其它文件,则用该命令可以对其强行删除. 

yum -y install make gcc-c++ cmake bison-devel  ncurses-devel 

./bootstrap  
#检查无误后安装 
make && make install 

groupadd dba 
useradd mysql -g dba 

#为保证数据平安,将数据单独存盘于/data目录下 
mkdir /app/mysql 
mkdir /data/mysql 
cd /data/mysql 
mkdir run data tmp logs 
chown -R mysql:dba /app/mysql 
chown -R mysql:dba /data/mysql 
 

tar zxvf Percona-Server-5.6.15-rel63.0.tar.gz 
cd Percona-Server-5.6.15 
cmake . -LH 
cmake .   
-DCMAKE_INSTALL_PREFIX=/app/mysql #设置程序安装路径 
-DMYSQL_DATADIR=/data/mysql/data #设置数据存放路径 
-DSYSCONFDIR=/etc   
-DWITH_MYISAM_STORAGE_ENGINE=1 #启用MYISAM存储引擎 
-DWITH_INNOBASE_STORAGE_ENGINE=1  
-DWITH_ARCHIVE_STORAGE_ENGINE=1  
-DWITH_BLACKHOLE_STORAGE_ENGINE=1  
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1  
-DWITH_FEDERATED_STORAGE_ENGINE=1   
-DWITH_READLINE=1 #启用MySQL快捷键 
-DMYSQL_UNIX_ADDR=/data/mysql/run/mysqld.sock #设置套接字存放位置 
-DMYSQL_TCP_PORT=3306  #设置开放端口 
-DENABLED_LOCAL_INFILE=1  #设置读取当地文件 
-DWITH_PARTITION_STORAGE_ENGINE=1  
-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 #默认字符串 
-DDEFAULT_COLLATION=utf8_general_ci #默认检验规则 
#以上代码为方便查看,若直接执行,可使用下面代码 
cmake .  -DCMAKE_INSTALL_PREFIX=/app/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1  -DWITH_READLINE=1  -DMYSQL_UNIX_ADDR=/data/mysql/run/mysqld.sock -DMYSQL_TCP_PORT=3306  -DENABLED_LOCAL_INFILE=1  -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci 
make -j 4 && make install 

chown mysql:dba /etc/my.cnf 
vim /etc/my.cnf 
[client] 
#password   = your_password 
port        = 3306 
socket      = /data/mysql/run/mysql.sock 
default-character-set=utf8 
 
[mysqld] 
port        = 3306 
socket      = /data/mysql/run/mysql.sock 
baserdir    = /app/mysql 
datadir     = /data/mysql/data 
 
skip-external-locking 
key_buffer_size = 16M 
max_allowed_packet = 1M 
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 
 
default-storage-engine = InnoDB 
character_set_server = utf8 
tmpdir      = /data/mysql/tmp/ 
log-bin=/data/mysql/logs/mysql-bin 
expire_logs_days= 14 
binlog_format=mixed 
log-error = /data/mysql/logs/error.log 
slow-query-log = 1 
long_query_time= 3 
slow_query_log_file = /data/mysql/logs/slow.log 
server-id   = 1 
innodb_data_home_dir = /data/mysql/data 
innodb_data_file_path = ibdata1:10M:autoextend 
innodb_log_group_home_dir = /data/mysql/logs 
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 
innodb_file_per_table = 1 
[mysqldump] 
quick 
max_allowed_packet = 16M 
 
[mysql] 
no-auto-rehash 
 
[myisamchk] 
key_buffer_size = 20M 
sort_buffer_size = 20M 
read_buffer = 2M 
write_buffer = 2M 
 
[mysqlhotcopy] 
interactive-timeout 

./scripts/mysql_install_db  --basedir=/app/mysql --datadir=/data/mysql/data --user=mysql --force 

su - 
cp /app/mysql/support-files/mysql.server /etc/init.d/mysql 
chmod +x /etc/init.d/mysql 
chkconfig -add mysql 
chkconfig --level 345 mysql on 

PATH=/app/mysql/bin:$PATH 
export PATH 
 

. /etc/profile 
#or 
source /etc/profile 

service mysql start 
mysqladmin -uroot password '******'