cdh部署

此次cdh是部署在阿里云上

部署的版本是以下

centeros 7.2
cdh 5.12.0 （收费版本有自动回滚功能，不过不需要）
MySQL 5.7.11
Jdk 1.8u121
python 2.7

mysql部署

上传安装包

yum install -y lrzsz
 传到另外两台机。
[root@hadoop002 ~]# scp mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz root@172.26.165.129:/root
[root@hadoop002 ~]# scp mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz root@172.26.165.130:/root

1.看看是否安装过了mysql

 ps -ef|grep mysqld
           root      2159  2140  0 07:02 pts/0    00:00:00 grep --color=auto mysqld
 rpm -qa|grep -i mysql

2.给mysql专门创建个用户和用户组进行管理

创建组和组id

groupadd -g 101 dba
-u 用户id，-d主组，-G副组，-d用户主目录，最后是用户名
useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin
id mysqladmin
         uid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root)

3.解压mysql

 mv mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz /usr/local
tar -xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.11-linux-glibc2.5-x86_64 mysql

4.环境变量

copy 环境变量配置文件至mysqladmin用户的home目录中,为了以下步骤配置个人环境变量

 cp /etc/skel/.* /usr/local/mysql  

配置环境变量

vi mysql/.bash_profile

 User specific environment and startup programs

export MYSQL_BASE=/usr/local/mysql
PATH=$MYSQL_BASE/bin:$PATH:$HOME/.local/bin:$HOME/bin

export PATH

5.修改my.cnf

在root用户 /etc目录下

vi my.cnf

[client]
port            = 3306
socket          = /usr/local/mysql/data/mysql.sock
default-character-set=utf8mb4

[mysqld]
port            = 3306
socket          = /usr/local/mysql/data/mysql.sock


skip-slave-start


skip-external-locking
key_buffer_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
query_cache_size= 32M
max_allowed_packet = 16M
myisam_sort_buffer_size=128M
tmp_table_size=32M

table_open_cache = 512
thread_cache_size = 8
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 600

Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 32 

#isolation level and default engine 
default-storage-engine = INNODB
transaction-isolation = READ-COMMITTED

server-id  = 1739
basedir     = /usr/local/mysql
datadir     = /usr/local/mysql/data
pid-file     = /usr/local/mysql/data/hostname.pid

#open performance schema
log-warnings
sysdate-is-now

binlog_format = ROW
log_bin_trust_function_creators=1
log-error  = /usr/local/mysql/data/hostname.err
log-bin = /usr/local/mysql/arch/mysql-bin
expire_logs_days = 7

innodb_write_io_threads=16

relay-log  = /usr/local/mysql/relay_log/relay-log
relay-log-index = /usr/local/mysql/relay_log/relay-log.index
relay_log_info_file= /usr/local/mysql/relay_log/relay-log.info

#need to sync tables
replicate-wild-do-table=omsprd.%
replicate_wild_do_table=wmsb01.%
replicate_wild_do_table=wmsb02.%
replicate_wild_do_table=wmsb03.%
replicate_wild_do_table=wmsb04.%
replicate_wild_do_table=wmsb05.%
replicate_wild_do_table=wmsb06.%
replicate_wild_do_table=wmsb07.%
replicate_wild_do_table=wmsb08.%
replicate_wild_do_table=wmsb08.%
replicate_wild_do_table=wmsb09.%
replicate_wild_do_table=wmsb10.%
replicate_wild_do_table=wmsb11.%
replicate_wild_do_table=wmsb27.%
replicate_wild_do_table=wmsb31.%
replicate_wild_do_table=wmsb32.%
replicate_wild_do_table=wmsb33.%
replicate_wild_do_table=wmsb34.%
replicate_wild_do_table=wmsb35.%


log_slave_updates=1
gtid_mode=OFF
enforce_gtid_consistency=OFF


#slave
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=4
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON




#other logs
#general_log =1
#general_log_file  = /usr/local/mysql/data/general_log.err
#slow_query_log=1
#slow_query_log_file=/usr/local/mysql/data/slow_log.err

#for replication slave
sync_binlog = 500


#for innodb option