Percona Server 5.6 Install （基于RPM包）

       MySQL的安装方式一般分三种：基于RPM包安装，基于二进制包安装，基于源代码安装。不同的安装方式，

所有的知识面不一样。其实基于RPM包安装方便快捷，目录结构固定。因此，对于一般使用来说已足够。

1.安装RPM包

[ root@localhost PerconaServerRPM]# rpm -ivh Percona-Server-shared-56-5.6.28-rel76.1.el6.x86_64.rpm 

[ root@localhost PerconaServerRPM]# rpm -ivh Percona-Server-client-56-5.6.28-rel76.1.el6.x86_64.rpm 

[ root@localhost  PerconaServerRPM]# rpm -ivh Percona-Server-server-56-5.6.28-rel76.1.el6.x86_64.rpm

2.安装路径布局

Directory	Contents of Directory
/usr/bin	Client programs and scripts
/usr/sbin	The mysqld server
/var/lib/mysql	Log files, databases
/usr/share/info	MySQL manual in Info format
/usr/share/man	Unix manual pages
/usr/include/mysql	Include (header) files
/usr/lib/mysql	Libraries
/usr/share/mysql	Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench	Benchmarks

• 数据库目录  /var/lib/mysql/
• 配置文件     /usr/share/mysql （mysql.server命令及配置文件）
• 相关命令    /usr/bin             (mysql,mysqladmin mysqldump等命令)
• 启动脚本     /etc/rc.d/init.d/（启动脚本文件mysql的目录）

3.创建数据MySQL的数据目录

  #cd /arp

  #mkdir data

4.迁移数据库的数据目录至/data目录中，输入如下命令

  # mv /var/lib/mysql/ /arp/data/

  如新建，可删除上述数据目录

  #rm -rf /arp/data/*

5.拷贝完后还需要修改/etc/rc.d/init.d/mysql的datadir目录值，我修改如下：

----------------修改内容----------------

  basedir=

  datadir=/arp/data/3306

# Set some defaults

  mysqld_pid_file_path=/arp/data/3306/mysql.pid

----------------------------------------------

6.建立所需的数据目录

#cd /arp/data/

#mkdir -p /arp/data/{3306/{data,tmp,binlog,innodb_ts,innodb_log},backup,scripts}

#chown -R mysql:mysql 3306

#su - mysql

7.编辑配置my.cnf文件

#vim  /etc/my.cnf

[client]

port = 3306

socket = /arp/data/3306/mysql.sock

# The MySQL server

[mysqld]

port = 3306

user = mysql

socket = /arp/data/3306/mysql.sock

pid-file = /arp/data/3306/mysql.pid

datadir = /arp/data/3306/data

tmpdir = /arp/data/3306/tmp

explicit_defaults_for_timestamp

server-id = 1143306

lower_case_table_names = 1

character-set-server = utf8

federated

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,oracle

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,oracle

skip-name-resolve

max_connect_errors = 100000

interactive_timeout = 86400

wait_timeout = 86400

sync_binlog=0

#back_log=100

default-storage-engine = InnoDB

log_slave_updates = 1

#*********** Logs related settings ***********

log-bin = /arp/data/3306/binlog/mysql-bin

binlog_format= mixed

binlog_cache_size=32m

max_binlog_cache_size=64m

max_binlog_size=512m

long_query_time = 3

log_output = FILE

log-error = /arp/data/3306/mysql-error.log

slow_query_log = 1

slow_query_log_file = /arp/data/3306/slow_statement.log

#log_queries_not_using_indexes

general_log = 0

general_log_file = /arp/data/3306/general_statement.log

expire-logs-days = 14

relay-log = /arp/data/3306/binlog/relay-bin

relay-log-index = /arp/data/3306/binlog/relay-bin.index

#****** MySQL Replication 5.6 New Feature*********

master-info-repository=TABLE

relay-log-info-repository=TABLE

relay-log-recovery

#*********** INNODB Specific options ***********

innodb_buffer_pool_size = 2048M

#transaction-isolation=REPEATABLE-READ

#innodb_buffer_pool_instances = 8

innodb_data_home_dir = /arp/data/3306/innodb_ts

innodb_data_file_path = ibdata1:2048M:autoextend

innodb_thread_concurrency = 8

innodb_log_buffer_size = 256M

innodb_log_file_size = 2G

innodb_log_files_in_group = 3

innodb_log_group_home_dir = /arp/data/3306/innodb_log

innodb_max_dirty_pages_pct = 70

#innodb_flush_method=O_DIRECT

#*********** percona_server_command_parameters***********

innodb_lru_scan_depth=4000

innodb_flush_neighbors=0

innodb_io_capacity=25000

innodb_io_capacity_max=50000

innodb_flush_log_at_trx_commit=1

innodb_buffer_pool_instances=15

innodb_file_format=Barracuda

innodb_checksum_algorithm=crc32

innodb_file_per_table=true

innodb_doublewrite=1

innodb_flush_method=O_DIRECT_NO_FSYNC

innodb_purge_threads=4

table_open_cache=15000

open_files_limit=15000

max_connections=15000

innodb_read_io_threads=8

innodb_write_io_threads=8

innodb_change_buffering=all

loose-innodb_sync_array_size=16

query_cache_type=OFF

thread_cache_size=1000

back_log=2000

connect_timeout=15

loose-metadata_locks_hash_instances=256

max_prepared_stmt_count=1048560

loose-performance_schema=0

# --- below is Percona Server Specific ---

innodb_sched_priority_cleaner=39  

innodb_log_block_size=4096

innodb_adaptive_hash_index_partitions=65

[mysql]

no-auto-rehash

default-character-set=gbk

prompt = (\u@\h) [\d]>\_

保存my.cnf文件。

8.初始化MySQL数据库 
#mysql_install_db --user=mysql --datadir=/arp/data/3306/data

9.启动MySQL数据库(两种方式)

#service mysql start

#mysqld_safe --defaults-file=/etc/my.cnf & 

10.关闭MySQL数据库

#service mysql stop

# mysqladmin -u${MYSQL_USER} -p${MYSQL_PASS} shutdown 

Note:***************************************如遇下列报错场景******************************************

[ root@localhost 3306]# service mysql start

Starting MySQL (Percona Server)...The server quit without u[FAILED]PID file (/arp/data/3306/tmp/mysql.pid).

解决方式：

*关闭selinux

#setenforce 0

# sed -i 's/SELINUX=.*/SELINUX=disabled/' /etc/selinux/config