Mysql安装配置canal，搭建binglog实时消费系统(1)--mysql安装

mysql安装

mysql版本 5.6.23 linux :CentOS Linux release 7.7.1908 (Core)

0、 rpm -qa | grep mysql lsb_release -a (查看linux版本)

安装步骤

1、创建mysql用户组合用户

groupadd mysql
useradd -r -g mysql mysql
#卸载mariadb  centos 7自带的数据库，有冲突
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps

2、下载安装 ( https://downloads.mysql.com/archives/community/ )

wget https://downloads.mysql.com/archives/get/p/23/file/MySQL-5.6.23-1.el7.x86_64.rpm-bundle.tar


tar -xvf MySQL-5.6.23-1.el7.x86_64.rpm-bundle.tar
#安装server、client
rpm -ivh MySQL-server-5.6.23-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.23-1.el7.x86_64.rpm 
#默认随机密码
cat /root/.mysql_secret
#默认配置
cat /usr/my.cnf
#初始化
/usr/bin/mysql_install_db
#启动服务
service mysql status
service mysql start
mysql –uroot –p “随机密码”
set password=password('root');
#授权其他机器访问
grant all privileges on *.* to root@'%' identified by 'root' WITH GRANT OPTION;
flush privileges;


#主从配置相关(建议单独创建账户)
1、在master的my.cnf文件加入，从重启
log-bin=mysql-bin 
server-id=1
2、连接master，查看状态
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |    49774 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
记录下File，Position，配置从时需要使用
3、配置slave，在my.cnf加入
server-id=2
4、连接slave
change master to  master_host='**.**.**.**',  master_user='root', master_password='root',  master_port=3306, master_log_file='mysql-bin.000001', master_log_pos=49774;
start slave ;
show slave status \G;

#导出结构和数据
mysqldump -uroot -proot nmxtest（库） --table employee > employee.sql
#导入数据
source /**/**.sql