Debian 11 安装 MySQL 5.7

先去官网下载对应的包https://downloads.mysql.com/archives/community/选择了这个版本wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_5.7.42-1debian10_amd64.deb-bundle.tar 解压缩tar xvf mysql-server_5.7.4

- 阅读全文 -

MySQL 5.7 互为主从

【备注】master1 xx.104.242.89 master2 xx.182.126.76同步的数据库 ultrax同步的数据库 blog在master1上面配置vi /etc/my.cnf主从配置master1 xx.104.242.89user = mysql log_bin = mysql-bin relay_log=relay-bin binlog_format=mixed serve

- 阅读全文 -

MySQL 5.7 数据库主从

主服务器(source):vi /etc/my.cnf log_bin = mysql-bin # 这里是一个路径文件,名字自定义 server_id = 1 binlog-checksum = none expire-logs-days = 7 # 只保留7天的日志重启mysql,然后进入mysql执行:mysql> flush logs; mysql> show master st

- 阅读全文 -

CentOS安装MySQL5.7

CentOS6安装MySQL5.71、下载mysql的rpm包集合wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar tar -xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar2、安装前先删除自带的mysql-libs,因为版本太

- 阅读全文 -