③拳两脚▼ 2015▼ nginx mysql centos 安装 手册

042.CentOS装Tengine和Percona

Ucloud(CentOS6.5)安装Tengine2.1.0和Percona5.6,
过程比较简单,重点是mysql的配置文件。

@史荣久 / 2015-06-10 / CC-BY-SA-3.0

系统环境 Ucloud

$ uname -a
Linux 10-4-18-185 2.6.32-431.11.7.el6.ucloud.x86_64 #1 
SMP Wed Jan 7 23:42:27 CST 2015 x86_64 x86_64 x86_64 
GNU/Linux

$ cat /etc/issue
CentOS release 6.5 (Final)
Kernel \r on an \m

$ free -m
             total       used       free
Mem:         15887      14094       1792
-/+ buffers/cache:       9148       6738
Swap:          511          0        511

$ cat /proc/cpuinfo | grep 'model name' | cut -f2 -d: | uniq -c 
#     4  Intel(R) Xeon(R) CPU E5-2640 0 @ 2.50GHz
      8  QEMU Virtual CPU version (cpu64-rhel6)

安装 Tengine2.1.0

# http://tengine.taobao.org
wget http://tengine.taobao.org/download/tengine-2.1.0.tar.gz
tar -xzf tengine-2.1.0.tar.gz
cd tengine-2.1.0/

# requires the PCRE library
yum install -y pcre pcre-devel

# require the OpenSSL library
yum install openssl openssl-devel

#已经安装过了,所有此步骤不需要。
#yum install zlib zlib-devel

./configure
make
sudo make install

# 把以下加入环境变量
cat /etc/profile.d/nginx.sh 
export PATH=$PATH:/usr/local/nginx/sbin/

# 查看安装模块
nginx -m

安装 Percona5.6

wget https://www.percona.com/downloads/Percona-Server-5.6/\
Percona-Server-5.6.24-72.2/binary/redhat/6/x86_64/\
Percona-Server-5.6.24-72.2-r8d0f85b-el6-x86_64-bundle.tar

tar -xf Percona-Server-*.tar 

# 解包后有很多rpm,只需要安装以下3个即可。
rpm -ivh \
Percona-Server-client-56-5.6.24-rel72.2.el6.x86_64.rpm \
Percona-Server-shared-56-5.6.24-rel72.2.el6.x86_64.rpm \
Percona-Server-server-56-5.6.24-rel72.2.el6.x86_64.rpm

# 标准rpm安装,标准启动和配置,或通过以下命令查看。
# rpm -qa|grep Percona
# rpm -ql Percona-Server-server-56-5.6.24-rel72.2.el6.x86_64
service mysql start
/usr/bin/mysqladmin -u root password 'www.moilioncircle.com'

# 查看启动情况
chkconfig --list mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

# 把数据库,装到200g的磁盘上
df -h 
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1        20G  2.2G   17G  12% /
tmpfs           7.8G     0  7.8G   0% /dev/shm
/dev/vdb        197G  188M  187G   1% /data

# 移动数据库和改权限
service mysql stop
mkdir -p /data/mysql/{tmp,log}
chown mysql.mysql -R /data/mysql
mv /var/lib/mysql /data/mysql/data

#配置文件在这里
cat /etc/my.cnf

看懂就牛了

[mysqld]
############ 创建function+view  ############
log_bin_trust_function_creators=1 
############ performance_schema ############
#performance_schema
############ common parameter ############
# 默认innodb存储引擎, 默认utf8字符集,默认不忽略大小写
default-storage-engine = INNODB
character-set-server=utf8
collation = utf8_bin
sql_mode="STRICT_TRANS_TABLES"

#old:loose_character_set_server =  utf8

#### Baes dir ####
#basedir = /opt/mysql
datadir = /data/mysql/data
tmpdir = /data/mysql/tmp
#socket = /opt/mysql/run/mysql.sock

#### Base configure info ####
#default-character-set = gbk
port = 3306
#skip-locking
skip-name-resolve
old_passwords = 0
lower_case_table_names = 1
open_files_limit = 135582
read_rnd_buffer_size = 5M
max_allowed_packet = 12M
max_connect_errors = 65536
max_connections = 1500
max_user_connections = 450
thread_cache_size=256
table_definition_cache=65536
thread_stack=262144
wait_timeout=864000
table_open_cache=2000
#table_open_cache=65536

# 避免再次回表获得数据,使用优化过的排序算法
max_length_for_sort_data = 16k


#### Log info ####
log-error = /data/mysql/log/alert.log
#log_slow_queries = /data/mysql/log/slow.log
slow_query_log=1
slow_query_log_file= /data/mysql/log/slow.log
log-slow-admin-statements
#log-queries-not-using-indexes
long_query_time = 0.001
slow_launch_time=1

#### Binary log && Relay log ####
binlog_format='MIXED'
log-bin = /data/mysql/log/mysql-bin
log-slave-updates = 1
relay-log = /data/mysql/log/mysqld-relay-bin
relay-log-index = /data/mysql/log/mysqld-relay-bin.index
master-info-file = /data/mysql/log/master.info
relay-log-info-file = /data/mysql/log/relay-log.info
#expire_logs_days=1
max_binlog_size = 500M
max_binlog_cache_size = 1000M
sync_binlog=1000
####slow log输出格式
log_slow_verbosity='innodb'
# 取消query_cache
query_cache_type        = 0
query_cache_size        = 0


############  per thread memory ############ 
thread_stack            = 512k
net_buffer_length       = 8K
sort_buffer_size        = 2M
join_buffer_size        = 4M
read_buffer_size        = 2M
read_rnd_buffer_size    = 512k
# 最大内存临时表大小
tmp_table_size          = 8M
binlog_cache_size       = 2M

#myisam
concurrent_insert = 2
key_buffer = 50M
myisam_sort_buffer_size = 50M

#innodb plugin

#innodb
default-storage-engine = INNODB
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_open_files=60000
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 100
innodb_buffer_pool_size = 1G
innodb_log_buffer_size= 100M
innodb_log_file_size = 100M
innodb_log_files_in_group = 4
innodb_file_io_threads = 4
innodb_thread_concurrency = 32
innodb_max_dirty_pages_pct = 50
transaction-isolation = READ-COMMITTED
innodb_data_file_path = ibdata1:12M:autoextend
innodb_io_capacity=1000
innodb_read_io_threads=8
innodb_write_io_threads=8

innodb_buffer_pool_instances=4
innodb_thread_concurrency=32

# 在innodb lru list 先呆一秒再放到lru头
innodb_old_blocks_time=1000
# 取消二阶段事务
innodb_support_xa = OFF

 
### Server id ####
log_bin_trust_function_creators=1
read_only=0
server_id=239
《042.CentOS装Tengine和Percona》 Ucloud(CentOS6.5)安装Tengine2.1.0和Percona5.6,过程比较简单,重点是mysql的配置文件。
题图:Percona为MySQL数据库服务器进行了改进,在功能和性能上较MySQL有着很显著的提升。