centos mysql 5.5 5.6_Centos7.x Mysql5.5-5.6主从安装配置

叁歲伎倆 2023-01-12 04:07 150阅读 0赞

一、MySQL安装

1、安装依赖

\#yum -y install make gcc-c++ cmake bison-devel  ncurses-devel

\# yum groupinstall -y "Development tools"

2、编译安装

\#mkdir -pv /app/mysql

\#mkdir -pv /data/mysql

\#mkdir/root/src

\#wgethttps://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.5/mysql-5.5.60.tar.gz

\#tar -axvf mysql-5.5.60.tar.gz

\#cd mysql-5.5.60

\#cmake -DCMAKE\_INSTALL\_PREFIX=/app/mysql -DMYSQL\_DATADIR=/data/mysql/ -DMYSQL\_UNIX\_ADDR=/var/lib/mysql/mysql.sock -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DEXTRA\_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED\_LOCAL\_INFILE=ON -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_FEDERATED\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DWITHOUT\_EXAMPLE\_STORAGE\_ENGINE=1 -DWITHOUT\_PARTITION\_STORAGE\_ENGINE=1 -DWITH\_FAST\_MUTEXES=1 -DWITH\_ZLIB=bundled -DENABLED\_LOCAL\_INFILE=1 -DWITH\_READLINE=1 -DWITH\_EMBEDDED\_SERVER=1 -DWITH\_DEBUG=0

\#make

\#make install

3、创建mysql用户组

\#groupadd -r mysql

\#useradd -g mysql -r -s /sbin/nologin mysql

\#chown -R mysql.mysql /app/mysql/

\#chown -R mysql.mysql /data/mysql/

\#mkdir /var/lib/mysql

\#chown -R mysql.mysql /var/lib/mysql

4、配置mysql

\#/app/mysql/scripts/mysql\_install\_db –basedir=/app/mysql –datadir=/data/mysql –user=mysql

\#echo "export PATH=/app/mysql/bin:$PATH" > /etc/profile.d/mysql.sh

\#source /etc/profile.d/mysql.sh

\#cp /app/mysql/support-files/my-medium.cnf /etc/my.cnf

添加下列两行指定安装路径和数据库存放路径

basedir = /app/mysql

datadir = /data/mysql

\#cp /app/mysql/support-files/mysql.server /etc/init.d/mysqld \#添加启动脚本

\#chkconfig –add mysqld  \#设置开机启动

\#echo "/app/mysql/lib" > /etc/ld.so.conf.d/mysql.conf  \#导出库文件

\#ldconfig -v     \#建立库文件缓存

\#ln -sv /usr/local/mysql/include/ /usr/include/mysql\#导出头文件

\#/etc/init.d/mysqld start

\#/app/mysql/bin/mysqladmin -u root password 'cdae123456'

>create user 'cdae'@'%' identified by '7qKv1zse+rw=';  \#创建cdae账号

> create database cdae character set utf8;  \#创建cdae库

> grant all privileges on cdae.\* to 'cdae'@'%';  \#授权cdae账号最大权限访问cdae库

> drop user ''@'localhost.domain';

> drop user ''@'localhost';

> drop user 'root'@'::1';

>flush privileges;

>set GLOBAL max\_connections=5000;  \#调整查询连接数

>show variables like 'max\_connections';  \#查询连接数

二、主从配置

1、mater配置

\#vim /etc/my.cnf 插入

\[mysqld\]

log-bin=mysql-bin \#开启二进制日志

server-id=1 \#设置server-id

binlog-do-db =cdae \#只同步cdae库

2、创建同步账号

\# mysql -uroot -p

> create user 'slaveuser'@'192.168.10.82' identified by 'EfY0Gz/IMks=';

> grant replication slave on \*.\* to'slaveuser'@'192.168.10.82';

> flush privileges;

> show master status;

![af1d87bc4f2213bbe48b9e8b49e49b44.png][]

3、slave配置

\#vim /etc/my.cnf 插入

\[mysqld\]

server-id=2\#设置server-id

打开mysql会话，执行同步SQL语句(需要主服务器主机名，登陆凭据，二进制文件的名称和位置)

>mysql -uroot -p

>change master to master\_host='192.168.10.81',master\_user='slaveuser',master\_password='EfY0Gz/IMks=',master\_log\_file='mysql-bin.000007',master\_log\_pos=445;

>start slave;  \#启动slave进程

> show slave status\\G;

喜欢 (0)or分享 (0)

[af1d87bc4f2213bbe48b9e8b49e49b44.png]: /images/20221119/e052b2c138aa4f0699ec322ef925df34.png