Linux超级详细部署MySQL环境

通过yum部署

输入yum search mysql 找到mysql-server.x86_64,
然后输入yum install + mysql-server.x86_64进行MySQL服务的安装
这种方法安装简单,缺点就是一般只能够自己学习

通过tar包部署

先要去下载一个tar包Linux的tar包下载地址
然后输入yum install lrzsz 命令安装完后就可以实现windows和linux互传文件的功能
然后我们cd /usr/local
接着我们输入lz 上传从官网下载的tar包,然后输入tar -xzvf + mysql的tar包名称解压
接着我们创建一个软连接指向源文件:ln -s + mysql的tar包解压完的名称 + 软连接名字(我一般用mysql,比较容易记)
接着我们就要来创建一个用户和组(我比较喜欢加上id):
组:groupadd -g 101 dba
用户:useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin
然后我们试着切换一下mysqladmin用户:su - mysqladmin
这时很有可能出现一个问题,就是用户的隐藏文件不存在,这是我们就要切换到root用户,然后输入
cp /etc/skel/.*/usr/local/mysql,这是我们要切换mysqladmin用户就跟普通的用户一模一样了

下面这里配置和命令请在root用户下配置

然后现在我们cd到/etc下面创建一个my.cnf文件,在里面输入

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

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  = 1
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 = MIXED
log_bin_trust_function_creators=1
log-error  = /usr/local/mysql/data/hostname.err
log-bin=/usr/local/mysql/arch/mysql-bin
#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
#log-slave-updates 
#sync_binlog = 1

#for innodb options 
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:500M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/arch
innodb_log_files_in_group = 2
innodb_log_file_size = 200M

innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 50M
innodb_log_buffer_size = 16M

innodb_lock_wait_timeout = 100
#innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 1
innodb_locks_unsafe_for_binlog=1

#innodb io features: add for mysql5.5.8
performance_schema
innodb_read_io_threads=4
innodb-write-io-threads=4
innodb-io-capacity=200
#purge threads change default(0) to 1 for purge
innodb_purge_threads=1
innodb_use_native_aio=on

#case-sensitive file names and separate tablespace
innodb_file_per_table = 1
lower_case_table_names=1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

然后保存退出

现在我们就要来修改权限了,这里我不讲解太多,因为懒得打字,我直接给命令

chown  mysqladmin:dba /etc/my.cnf
chmod  640 /etc/my.cnf
chown -R mysqladmin:dba /usr/local/mysql
chmod -R 755 /usr/local/mysql
chown -R mysqladmin:dba /usr/local/mysql/*

到这里我们要切换路径再输入命令:先cd /usr/local/ 然后输入

chown  mysqladmin:dba  mysql-5.6.23-linux-glibc2.5-x86_64

然后我们切换到mysqladmin用户

su - mysqladmin

在/usr/local/mysql路径下创建一个文件夹arch:mkdir arch
接着我们就执行真正的安装命令了

scripts/mysql_install_db  --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

接着要开始配置和开启服务了,这里我也是不做过多的解释,我太懒了,直接上代码,此处开始要切换到root用户下配置

cd /usr/local/mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
chkconfig --del mysql
chkconfig --add mysql
chkconfig --level 345 mysql on

然后我们打开一个文件vi /etc/rc.local
打开后把su - mysqladmin -c "/etc/init.d/mysql start"复制进去保存退出
接着我们切换到mysqladmin用户,cd /usr/local/mysql
然后执行以下命令

rm -rf my.cnf
mysqld_safe &

执行要按两下回车
接着我们重启mysql服务

service mysql restart

启动完此时就可以了,不过有人可能会遇到一个问题就是输入mysql启动后只有两个数据库
这是我们的解决办法就是不要直接输入mysql启动,输入mysql -uroot -p启动,然后密码直接回车此时登陆成功且有四个正常的数据库了,因为我们开始的时候并没有设置密码

tar包部署虽然比rpm难,但是是企业级开发