mysql 自动化 安装_Mysql自动化安装

#!/bin/sh

# 安装mysql5.7.21 X64 二进制安装

# create by uug 201808

#mysql基础路径设置

mysql_port=$1

mysql_port=${mysql_port:-3306}

echo ${mysql_port}

#mysql_port=3306

filename="Percona-Server-5.7.26-29-Linux.x86_64.ssl101.tar.gz"

mysql_buffer=$2

mysql_buffer=${mysql_buffer:-5G}

echo ${mysql_buffer}

mysql_dir="/usr/local/mysql"

mysql_cmd="/data/mysql_${mysql_port}"

mysql_datadir="${mysql_cmd}/mydata"

mysql_binlog="${mysql_cmd}/binlog"

mysql_log="${mysql_cmd}/innodb_log"

mysql_ts="${mysql_cmd}/innodb_ts"

mysql_tmp="${mysql_cmd}/tmpdir"

mysql_passwd="admin"

function removemysql()

{

yum -y remove mysql*

}

#init set up Library

function init()

{

#依赖库和开发工具

#操作系统基础包

yum -y install gcc gcc-c++ \

autoconf \

libjpeg \

libjpeg-devel \

libpng \

libpng-devel \

freetype \

freetype-devel \

libxml2 \

libxml2-devel \

zlib \

zlib-devel \

glibc \

glibc-devel \

glib2 \

glib2-devel \

bzip2 \

bzip2-devel \

ncurses \

ncurses-devel \

curl \

curl-devel \

e2fsprogs \

e2fsprogs-devel \

krb5 \

krb5-devel \

libidn \

libidn-devel \

openssl \

openssl-devel \

openldap \

openldap-devel \

nss_ldap \

openldap-clients \

openldap-servers

yum -y install gcc

make

yum -y install libaio-devel

yum -y groupinstall 开发工具

yum -y install ncurses*

#Php

yum -y install gd-devel libjpeg-devel libpng-devel

freetype-devel libxml2-devel curl-devel freetype-devel

#Mysql数据库专用包

yum -y install bison gcc gcc-c++ autoconf automake zlib*

libxml* ncurses-devel libtool-ltdl-devel* libnuma*

yum -y install yum-fastestmirror yum-presto

yum -y install gcc gcc-c++ \

autoconf libjpeg \

libjpeg-devel libpng \

libpng-devel freetype \

freetype-devel libxml2 \

libxml2-devel zlib \

zlib-devel glibc \

glibc-devel glib2 \

glib2-devel bzip2 \

bzip2-devel ncurses \

ncurses-devel curl \

curl-devel e2fsprogs \

e2fsprogs-devel \

krb5-devel libidn \

libidn-devel openssl \

openssl-devel nss_ldap \

openldap openldap-devel

\

openldap-clients \

openldap-servers \

libxslt-devel ntp \

libtool-ltdl bison \

libtool vim-enhanced

}

function install_mysql()

{

cd ~

useradd mysql

useradd -g mysql -M -s /sbin/nologin

mysql

#安装目录初始化

mkdir -p $mysql_datadir

mkdir -p $mysql_binlog

mkdir -p $mysql_log

mkdir -p $mysql_ts

mkdir -p $mysql_tmp

chmod 750 $mysql_datadir

chmod 750 $mysql_binlog

chmod 750 $mysql_log

chmod 750 $mysql_ts

chmod 750 $mysql_tmp

chown mysql.mysql -R $mysql_datadir

chown mysql.mysql -R $mysql_binlog

chown mysql.mysql -R $mysql_log

chown mysql.mysql -R $mysql_ts

chown mysql.mysql -R $mysql_tmp

cd /usr/local

tar xvfz

Percona-Server-5.7.26-29-Linux.x86_64.ssl101.tar.gz

ln -s

Percona-Server-5.7.26-29-Linux.x86_64.ssl101 mysql

touch $mysql_cmd/my${mysql_port}.cnf

cat > $mysql_cmd/my${mysql_port}.cnf << EOF

[mysqldump]

quick

max_allowed_packet = 50M

default-character-set=utf8mb4

[client]

default-character-set=utf8mb4

[mysql]

prompt="\\u@\\h:\\p : \\d \\r:\\m:\\s> "

#pager="less -i -n -S"

#tee=/home/mysql_3306/query.log

no-auto-rehash

default-character-set=utf8mb4

show-warnings

[mysqld]

user = mysql

basedir = ${mysql_dir}

interactive_timeout = 3600

wait_timeout = 3600

character-set-server = utf8mb4

open_files_limit = 65535

max_connections = 1000

max_connect_errors = 100000

thread_pool_max_threads=1000

lower_case_table_names=0

default-storage-engine = InnoDB

skip-name-resolve = 1

log_warnings = 2

slave-skip-errors = 1032,1075,1396

optimizer_switch='mrr_cost_based=off,batched_key_access=on'

#logs

slow_query_log = 1

long_query_time = 2

#gtid

gtid_mode=on

enforce-gtid-consistency=on

binlog-gtid-simple-recovery=1

log_slave_updates=1

#binlog

binlog_format = row

binlog_cache_size = 20M

max_binlog_size = 1G

max_binlog_cache_size = 2G

expire_logs_days = 5

#relay log

skip_slave_start = 0

max_relay_log_size = 1G

relay_log_purge = 1

relay_log_recovery = 1

slave_net_timeout=60

master_info_repository = "TABLE"

relay_log_info_repository = "TABLE"

#buffers & cache

table_open_cache = 2048

table_definition_cache = 2048

sort_buffer_size = 1M

join_buffer_size = 1M

thread_cache_size = 256

query_cache_size = 0

query_cache_type = 0

query_cache_limit = 256K

query_cache_min_res_unit = 512

thread_stack = 192K

max_heap_table_size = 1G

tmp_table_size = 500M

key_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

bulk_insert_buffer_size = 4M

max_allowed_packet = 50M

#myisam

myisam_sort_buffer_size = 128M

myisam_max_sort_file_size = 1G

myisam_repair_threads = 1

#undo

innodb_undo_log_truncate=1

innodb_undo_tablespaces=6

innodb_undo_logs=128

innodb_max_undo_log_size=2G

#innodb

innodb_buffer_pool_instances =1

innodb_data_file_path = ibdata:1G:autoextend

innodb_flush_log_at_trx_commit = 0

innodb_log_buffer_size = 64M

innodb_log_file_size = 2G

innodb_log_files_in_group = 2

innodb_max_dirty_pages_pct = 50

innodb_file_per_table = 1

innodb_lock_wait_timeout = 10

innodb_rollback_on_timeout

innodb_status_file = 1

innodb_io_capacity = 2000

innodb_flush_method = O_DIRECT

innodb_open_files = 65535

innodb_file_format=Barracuda

innodb_file_format_check=1

innodb_strict_mode=1

#ssd上面设置这个参数

innodb_flush_neighbors=0

innodb_thread_concurrency = 0

innodb_purge_threads = 1

sql_mode=NO_ENGINE_SUBSTITUTION

innodb_numa_interleave = 1

#每个实例的配置参数

port = ${mysql_port}

server-id = 1923306

pid-file=/tmp/mysql${mysql_port}.pid

socket = /tmp/mysql${mysql_port}.sock

log-error=${mysql_cmd}/error.log

log-bin = ${mysql_binlog}/mysql-bin

tmpdir = ${mysql_tmp}

datadir= ${mysql_datadir}

innodb_data_home_dir= ${mysql_ts}

innodb_log_group_home_dir=${mysql_log}

transaction_isolation=READ-COMMITTED

innodb_buffer_pool_size = ${mysql_buffer}

slow_query_log_file = ${mysql_cmd}/slow.log

innodb_undo_directory=${mysql_datadir}

EOF

chown mysql.mysql -R $mysql_cmd

#初始化数据库

$mysql_dir/bin/mysqld

--defaults-file=$mysql_cmd/my$mysql_port.cnf --initialize-insecure

--user=mysql

#启动数据库

$mysql_dir/bin/mysqld_safe

--defaults-file=$mysql_cmd/my$mysql_port.cnf &

sleep 10

#写入参数文件

echo 'export PATH=$PATH:'$mysql_dir'/bin' >>

/etc/profile

source /etc/profile

}

function checkmysql()

{

MYSQLPORT2=$( netstat -ant | grep ${mysql_port} | awk '{print

$4}')

echo ${MYSQLPORT2}

if [ ! -z ${MYSQLPORT2} ];then

echo -e

"\033[31m mysql5.7.21 X64 is sucess !!

\033[0m"

else

echo -e

"\033[31m mysql5.7.21 X64 is failure !!

\033[0m"

fi

}

#begin install

# check the Mysql

MYSQLPORT=$( netstat -ant | grep ${mysql_port} | awk '{print

$4}')

if [ ! -z $MYSQLPORT ];then

echo -e "\033[31m mysql5.7

X64 ${mysql_port} is exist,please change the port !! \033[0m"

else

removemysql

init

install_mysql

#checkmysql

fi

#注意初始化完修改密码，初始密码在日志文件中

#set password=password('XXX');

#update user set host='%';

#flush privileges;

#centos7 需要卸载默认的maridb数据库

#skip-grant-tables

#update user set authentication_string=PASSWORD('xxx') where

User='root';

#mysql -uroot -p -P13307 -h127.0.0.1

安装案例：sh mysqlInstall2.sh

3306 2G