2主1从MYSQL部署keepalived与MySQL主从配置

最新推荐文章于 2024-11-01 14:31:36 发布
最新推荐文章于 2024-11-01 14:31:36 发布
阅读量1k 收藏 11
点赞数 30
文章标签： mysql 数据库 adb linux 运维 centos
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_70780888/article/details/136495814
版权

文章目录

环境
系统主机名IP部署服务
Rocky-9.3mysql-master192.168.117.10MYSQL主
Rocky-9.3mysql-backup192.168.117.11MYSQL备
Rocky-9.3mysql-subordinate192.168.117.12MYSQL从
Rocky-9.3nfs192.168.117.13NFS服务器

注:1.关闭所有系统的防火墙和selinux
2.keepalived的vip是192.168.117.200

部署NFS服务器
192.168.117.13
[root@nfs ~]# yum -y install nfs-utils  //安装nfs软件包
[root@nfs ~]# systemctl start nfs-server  //启动nfs服务
[root@nfs ~]# systemctl enable nfs-server //设置nfs开机自启
[root@nfs ~]# mkdir /data  //创建/data共享目录
[root@nfs ~]# vim /etc/exports  //修改系统文件,配置共享目录
/data
[root@nfs ~]# systemctl restart nfs-server  //更改配置需要重启服务

配置将客户端所有用户映射为一个用户 
[root@nfs ~]# useradd -r -M -s /sbin/nologin -u 978 -g 977 mysql //主和备和nfs的mysql用户的uid,gid需要一样
[root@nfs ~]# chown -R mysql.mysql /data
[root@nfs ~]# id mysql 
uid=978(mysql) gid=977(mysql) groups=977(mysql)
[root@nfs ~]# vim /etc/exports //给予客户端网络权限
/data 192.168.117.10(rw,anonuid=978,anongid=977,all_squash)
/data 192.168.117.11(rw,anonuid=978,anongid=977,all_squash)
[root@nfs ~]# systemctl restart nfs-server 
[root@nfs ~]# setfacl -m u:mysql:rwx /data  //给与客户端本地权限,客户端的root用户会映射为mysql用户
[root@nfs ~]# exportfs -r   //使配置立刻生效

[root@nfs ~]# setfacl -m u:mysql:rwx /data
192.168.117.10
[root@mysql-master ~]# yum -y install nfs-utils  //安装nfs软件包
[root@mysql-master ~]# mkdir /opt/data
[root@mysql-master ~]# vim /etc/fstab 
/dev/mapper/rl-root     /                       xfs     defaults        0 0
UUID=1e4d1c93-64d0-4217-b231-3110487340fe /boot                   xfs     defaults        0 0
/dev/mapper/rl-home     /home                   xfs     defaults        0 0
/dev/mapper/rl-swap     none                    swap    defaults        0 0
192.168.117.13:/data /opt/data nfs defaults,_netdev 0 0 //添加此行defaults,_netdev为识别为网络设备
[root@mysql-master ~]# systemctl daemon-reload  //使配置生效
[root@mysql-master ~]# mount -a   //立刻挂载
192.168.117.11
[root@mysql-backup ~]# yum -y install nfs-utils  //安装nfs软件包
[root@mysql-backup ~]# mkdir /nfs
[root@mysql-backup ~]# vim /etc/fstab 
/dev/mapper/rl-root     /                       xfs     defaults        0 0
UUID=1e4d1c93-64d0-4217-b231-3110487340fe /boot                   xfs     defaults        0 0
/dev/mapper/rl-home     /home                   xfs     defaults        0 0
/dev/mapper/rl-swap     none                    swap    defaults        0 0
192.168.117.13:/data /opt/data nfs defaults,_netdev 0 0 //添加此行defaults,_netdev为识别为网络设备
[root@mysql-backup ~]# systemctl daemon-reload  //使配置生效
[root@mysql-backup ~]# mount -a   //立刻挂载
部署mysql
192.168.117.10
[root@mysql-master ~]# tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz -C /usr/local/
[root@mysql-master ~]# cd /usr/local/
[root@mysql-master local]# mv mysql-8.0.35-linux-glibc2.28-x86_64 mysql

创建mysql用户
[root@mysql-master local]# useradd -r -M -s /sbin/nologin mysql
[root@mysql-master local]# chown -R mysql.mysql /usr/local/mysql
[root@mysql-master local]# id mysql //主和备和nfs的mysql用户的uid,gid需要一样
uid=978(mysql) gid=977(mysql) groups=977(mysql)

添加环境变量
[root@mysql-master local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@mysql-master local]# source /etc/profile.d/mysql.sh

软连接
[root@mysql-master local]# ln -s /usr/local/mysql/include /usr/include/mysql

编辑mysql.conf
[root@mysql-master local]# vi /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib

编辑mysql.server
[root@mysql-master ~]# vi /usr/local/mysql/support-files/mysql.server
basedir=/usr/local/mysql
datadir=/opt/data

编写my.cnf配置文件
[root@mysql-master ~]# vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/opt/data
pid-file=/opt/data/mysql.pid
port=3306
skip-name-resolve
user=mysql
socket = /tmp/mysql.sock

初始化mysql
[root@mysql-master local]# mysqld --initialize --user mysql --datadir /opt/data
root@localhost: /LSz2EOjtvuy

编辑mysqld.service
[root@mysql-master ~]# cp /usr/lib/systemd/system/sshd.service /usr/lib/systemd/system/mysqld.service
[root@mysql-master ~]# vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=mysqld server daemon
After=network.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecStop=/usr/local/mysql/support-files/mysql.server stop
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target

开机自启mysql
[root@mysql-master ~]# systemctl daemon-reload
[root@mysql-master ~]# systemctl enable --now mysqld
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.

设置mysql密码
[root@mysql-master ~]# mysql -uroot -p'/LSz2EOjtvuy'

mysql> alter user root@'localhost' identified with mysql_native_password by 'xia123!';
Query OK, 0 rows affected (0.01 sec)
192.168.117.11
[root@mysql-backup ~]# tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz -C /usr/local/
[root@mysql-backup ~]# cd /usr/local/
[root@masmysql-backupter local]# mv mysql-8.0.35-linux-glibc2.28-x86_64 mysql

创建mysql用户
[root@mysql-backup local]# useradd -r -M -s /sbin/nologin mysql
[root@mysql-backup local]# chown -R mysql.mysql /usr/local/mysql
[root@mysql-backup local]# id mysql 
uid=978(mysql) gid=977(mysql) groups=977(mysql)

添加环境变量
[root@mysql-backup local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@mysql-backup local]# source /etc/profile.d/mysql.sh

软连接
[root@mysql-backup local]# ln -s /usr/local/mysql/include /usr/include/mysql

编辑mysql.conf
[root@mysql-backup local]# vi /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib

编辑mysql.server
[root@mysql-backup ~]# vi /usr/local/mysql/support-files/mysql.server
basedir=/usr/local/mysql
datadir=/opt/data

备数据库不需要初始化和设置密码

编写my.cnf配置文件
[root@mysql-backup ~]# vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/opt/data
pid-file=/opt/data/mysql.pid
port=3306
skip-name-resolve
user=mysql
socket = /tmp/mysql.sock

编辑mysqld.service
[root@mysql-backup ~]# cp /usr/lib/systemd/system/sshd.service /usr/lib/systemd/system/mysqld.service
[root@mysql-backup ~]# vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=mysqld server daemon
After=network.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecStop=/usr/local/mysql/support-files/mysql.server stop
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target

开机自启mysql
[root@mysql-backup ~]# systemctl daemon-reload
[root@mysql-backup ~]# systemctl enable --now mysqld
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.
192.168.117.12
[root@mysql-subordinate ~]# tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz -C /usr/local/
[root@mysql-subordinate ~]# cd /usr/local/
[root@mysql-subordinate local]# mv mysql-8.0.35-linux-glibc2.28-x86_64 mysql

创建mysql用户
[root@mysql-subordinate local]# useradd -r -M -s /sbin/nologin mysql
[root@mysql-subordinate local]# chown -R mysql.mysql /usr/local/mysql
[root@mysql-subordinate local]# id mysql //从数据库用户不需要一样
uid=978(mysql) gid=977(mysql) groups=977(mysql)

添加环境变量
[root@mysql-subordinate local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@mysql-subordinate local]# source /etc/profile.d/mysql.sh

软连接
[root@mysql-subordinate local]# ln -s /usr/local/mysql/include /usr/include/mysql

编辑mysql.conf
[root@mysql-subordinate local]# vi /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib

编辑mysql.server
[root@mysql-subordinate ~]# vi /usr/local/mysql/support-files/mysql.server
basedir=/usr/local/mysql
datadir=/opt/data

编写my.cnf配置文件
[root@mysql-subordinate ~]# vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/opt/data
pid-file=/opt/data/mysql.pid
port=3306
skip-name-resolve
user=mysql
socket = /tmp/mysql.sock

建立数据目录
[root@mysql-subordinate ~]# mkdir /opt/data
[root@mysql-subordinate ~]# chown -R mysql.mysql /opt/data

初始化mysql
[root@mysql-subordinate local]# mysqld --initialize --user mysql --datadir /opt/data
root@localhost: )gti3jVdqefy

编辑mysqld.service
[root@mysql-subordinate ~]# cp /usr/lib/systemd/system/sshd.service /usr/lib/systemd/system/mysqld.service
[root@mysql-subordinate ~]# vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=mysqld server daemon
After=network.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecStop=/usr/local/mysql/support-files/mysql.server stop
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target

开机自启mysql
[root@mysql-subordinate ~]# systemctl daemon-reload
[root@mysql-subordinate ~]# systemctl enable --now mysqld
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.

查看端口号
[root@mysql-subordinate ~]# ss -antl
State  Recv-Q Send-Q  Local Address:Port    Peer Address:Port Process 
LISTEN 0      128           0.0.0.0:22           0.0.0.0:*            
LISTEN 0      32                  *:21                 *:*            
LISTEN 0      128              [::]:22              [::]:*            
LISTEN 0      70                  *:33060              *:*            
LISTEN 0      151                 *:3306               *:*   

设置mysql密码
[root@mysql-subordinate ~]# mysql -uroot -p')gti3jVdqefy'

mysql> alter user root@'localhost' identified with mysql_native_password by 'xia123!';
Query OK, 0 rows affected (0.01 sec)
配置keepalived
192.168.117.10
[root@mysql-master ~]# yum -y install keepalived

创建监控脚本
[root@mysql-master local]# cd /etc/keepalived/
[root@mysql-master keepalived]#  mkdir /scripts
[root@mysql-master keepalived]# vim /scripts/check_mysql.sh
#!/bin/bash
mysql_status=$(ps -ef|grep -Ev "grep|$0"|grep '\bmysql\b'|wc -l)
if [ $mysql_status -lt 1 ];then
        systemctl stop keepalived
fi

配置keeepalived.conf
[root@mysql-master keepalived]# mv keepalived.conf{,.bak}  //备份
[root@mysql-master keepalived]# vim keepalived.conf
! Configuration File for keepalived

global_defs {
   router_id mysql
}

vrrp_script mysql_check {
    script "/scripts/check_mysql.sh"
    interval 1
    weight -20
}

vrrp_instance VI_1 {
    state MASTER
    interface ens160
    virtual_router_id 33
    priority 110
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 000000
}
    virtual_ipaddress {
        192.168.117.200
  }
    track_script {
        mysql_check
  }
}

virtual_server 192.168.117.200 3306 {
    delay_loop 6
    lb_algo rr
    lb_kind DR
    persistence_timeout 50
    protocol TCP

real_server 192.168.117.10 3306 {
    weight 1
    TCP_CHECK {
    connect_port 3306
    connect_timeout 3
    nb_get_retry 3
    delay_before_retry 3
  }
}

real_server 192.168.117.11 3306 {
    weight 1
    TCP_CHECK {
        connect_port 3306
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
    }
  }
}
[root@mysql-master keepalived]# systemctl enable --now keepalived
Created symlink /etc/systemd/system/multi-user.target.wants/keepalived.service → /usr/lib/systemd/system/keepalived.service.

mysql授权网段
[root@mysql-master ~]# mysql -uroot -p'xia123!'
mysql> create user repl@'192.168.117.%' identified with mysql_native_password by 'xia123!';
Query OK, 0 rows affected (0.25 sec)
192.168.117.11
[root@mysql-backup ~]# yum -y install keepalived

创建监控脚本
[root@mysql-backup ~]# cd /etc/keepalived/
[root@mysql-backup keepalived]# mkdir /scripts
[root@mysql-backup keepalived]# vim /scripts/notify.sh
case "$1" in
  master)
        mysql_status=$(ps -ef|grep -Ev "grep|$0"|grep '\bmysql\b'|wc -l)
        if [ $mysql_status -lt 1 ];then
            systemctl start mysql
        fi
  ;;
backup)
        mysql_status=$(ps -ef|grep -Ev "grep|$0"|grep '\bmysql\b'|wc -l)
        if [ $mysql_status -gt 0 ];then
            systemctl stop mysql
        fi
  ;;
  *)
        echo "Usage:$0 master|backup"
  ;;
esac
[root@mysql-backup scripts]# chmod +x notify.sh

配置keepalived
[root@mysql-backup keepalived]# mv keepalived.conf{,.bak}
[root@mysql-backup keepalived]# vim keepalived.conf
! Configuration File for keepalived

global_defs {
   router_id mysql
}

vrrp_instance VI_1 {
    state BACKUP
    interface ens160
    virtual_router_id 33
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 000000
}   
    virtual_ipaddress {
        192.168.117.200
  }
    notify_master "/scripts/notify.sh master"
    notify_backup "/scripts/notify.sh backup"
}

virtual_server 192.168.117.200 3306 {
    delay_loop 6
    lb_algo rr
    lb_kind DR
    persistence_timeout 50
    protocol TCP

real_server 192.168.117.10 3306 {
    weight 1
    TCP_CHECK {
    connect_port 3306
    connect_timeout 3
    nb_get_retry 3
    delay_before_retry 3
  }
}

real_server 192.168.117.11 3306 {
    weight 1
    TCP_CHECK {
        connect_port 3306
        connect_timeout 3
        nb_get_retry 3
        delay_before_retry 3
    }
  }
}
[root@mysql-backup ~]# systemctl restart keepalived

测试数据库连接
[root@mysql-backup ~]# mysql -uroot -p'xia123!' -h192.168.117.200
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 8.0.35 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
配mysql主从

查看数据库是否一致

[root@mysql-master ~]# mysql -uroot -pxia123! -e 'show databases;'

mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+


[root@mysql-backup ~]# mysql -uroot -pxia123! -e 'show databases;'

mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
192.168.117.10
[root@mysql-master ~]# mysql -uroot -pxia123!
mysql> create user repl@192.168.117.12 identified with mysql_native_password by 'xia123!';
Query OK, 0 rows affected (0.01 sec)

mysql> grant replication slave on *.* to repl@192.168.117.12;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

[root@mysql-master ~]# vim /etc/my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
pid-file = /opt/data/mysql.pid
port=3306
skip-name-resolve
user=mysql
socket = /tmp/mysql.sock
log-bin = mysql-bin
server-id = 10

重启mysql服务
[root@mysql-master ~]# systemctl restart mysqld

查看主库的状态
[root@mysql-master ~]# mysql -uroot -pxia123!
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |      157 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
192.168.117.12
[root@mysql-backup ~]# vi /etc/my.cnf 
[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
pid-file = /opt/data/mysql.pid
port = 3306
skip-name-resolve
user = mysql
socket = /tmp/mysql.sock

server-id = 20
relay-log = my_relay

重启mysql服务
[root@mysql-backup ~]# systemctl restart mysqld

配置并启动主从复制
[root@mysql-backup ~]# mysql -uroot -pxia123!
mysql> change master to
    -> master_host='192.168.117.10',
    -> master_user='repl',
    -> master_port=3306,
    -> master_password='xia123!',
    -> master_log_file='mysql-bin.000001',
    -> master_log_pos=157;
Query OK, 0 rows affected, 9 warnings (0.02 sec)

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.01 sec)

查看从服务器状态
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.117.10
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 156
               Relay_Log_File: my_relay.000001
                Relay_Log_Pos: 326
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

测试

主库：
mysql> create database school;
Query OK, 1 row affected (0.04 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| school             |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

查看从库：
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| school             |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

在主库中创建表
mysql> use school;
Database changed
mysql> create table student(id int not null,name varchar(20));
Query OK, 0 rows affected (0.02 sec)

mysql> show tables;
+------------------+
| Tables_in_school |
+------------------+
| student          |
+------------------+
1 row in set (0.01 sec)

查看从库：
mysql> use school;
mysql> show tables;
+------------------+
| Tables_in_school |
+------------------+
| student          |
+------------------+
1 row in set (0.00 sec)

在主库创建表中插入数据
mysql> insert student values(1,'tom'),(2,'jerry');
Query OK, 2 rows affected (0.14 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from student;
+----+-------+
| id | name  |
+----+-------+
|  1 | tom   |
|  2 | jerry |
+----+-------+
2 rows in set (0.00 sec)

查看从库：
mysql> select * from student;
+----+-------+
| id | name  |
+----+-------+
|  1 | tom   |
|  2 | jerry |
+----+-------+
2 rows in set (0.00 sec)
公子欧夏
关注
使用keepalived实现对mysql主从复制的主备自动切换.docx
01-09
"使用keepalived实现对mysql主从复制的主备自动切换" 本文主要讲解如何使用keepalived实现对mysql主从复制的主备自动切换。keepalived是一款高可用性解决方案，可以实现虚拟IP的管理和服务监控，在mysql主从复制...
MySQL双主一从 + keepalived高可用 + NFS 部署
SinG_Lala的博客
10-15 363
本文主要讲述了MySQL双主一从 + keepalived高可用 + NFS 部署
mysql实战——Mysql8.0高可用之双主+keepalived
zyjzyjjyzjyz的博客
05-22 2504
1、 采用keepalived作为高可用方案时，两个节点最好都设置成BACKUP模式，避免因为意外情况下相互抢占导致两个节点内写入相同的数据而引发冲突；2、 把两个节点的auto_increment_increment（自增步长）和auto_increment_offset（字增起始值）设置成不同值，其目的是为了避免master节点意外宕机时，可能会有部分binlog未能及时复制到slave上被应用，从而会导致slave新写入数据的自增值和原master上冲突，因此一开始就错开；
Mysql集群之mysql双主双活+keepalived实现高可用_mysql+keepalived搭建教程
热门推荐
a360284634的博客
11-24 1万+
史上最全mysql+keepalived教程。 本文介绍在linux服务下安装mysql并实现mysql主从配置，双主双活+keepalive实现mysql高可用的详细部署流程
Mysql主从之keepalive+MySQL高可用
完颜振江
03-22 1449
Keepalived是一个开源的高可用性解决方案，它可以在多个服务器之间实现负载均衡和故障切换。虚拟IP（VIP）：Keepalived可以配置一个虚拟IP地址，该IP地址会在多个服务器之间进行漂移，从而实现负载均衡和故障切换。健康检查：Keepalived会定期检查服务器的健康状态，如果服务器出现故障或不可用，会自动进行切换。VRRP协议：Keepalived使用虚拟路由冗余协议（VRRP）来管理虚拟IP地址，确保只有一个服务器在处理流量。
基于keepalived实现MySQL主从高可用架构具体步骤及配置文件示例
学亮编程手记
02-24 478
请根据实际情况调整上述配置中的IP地址、用户名、密码以及接口名等信息。同时，健康检查脚本应能准确反映MySQL实例的状态，并且要有权限连接到数据库进行检查。
使用keepalived实现对MySQL主从复制的主备自动切换
03-27
使用MySQL+keepalived是一种非常好的解决方案，在MySQL-HA环境中，MySQL互为主从关系，这样就保证了两台 MySQL数据的一致性，然后用keepalived实现虚拟IP，通过keepalived自带的服务监控功能来实现MySQL故障时自动...
mysql5.7.29双主 keepalived HA部署方案.pdf
10-03
1. 安装Keepalived 1.3.5，确保版本与MySQL兼容。 2. 配置Keepalived的`/etc/keepalived/keepalived.conf`文件，定义虚拟IP地址、检查脚本、主从服务器状态检测等。 3. 设置VRRP（虚拟路由冗余协议）组，确保当主...
keepalived+redis&mysql主备高可用配置文件和脚本
07-28
1. **主从复制**：MySQL主从复制通过binlog日志实现，主节点将所有改变写入binlog，从节点读取并应用这些日志。配置文件`my.cnf`中的`server-id`、`log-bin`等选项用于设置复制。 2. **GTID（Global Transaction ...
MySQL+KeepAlived实现双主高可用方案实践
长沙老码农
02-18 4722
目录 1、什么叫双主高可用（双机热备） 2、搭建主主同步 3、配置MySQL+Keepalived故障转移的高可用环境 4、测试 5、MyCAT双主高可用 5.1 架构图 5.2 准备环境 5.3 高可用配置 1、什么叫双主高可用（双机热备） 我们通常说的双机热备是指两台机器都在运行，但并不是两台机器都同时在提供服务。当提供服务的一台出现故障的时候，另外一台会马上自动接管并且提供服务，而且切换的时间非常短。MySQL双主复制，即互为Master-Slave(只有一个Master提供.
mysql主从如何配置havip_mysql传统主从、双主复制+keepalived配置步骤
weixin_40004659的博客
02-03 305
mysql主从、主主复制(双主复制)配置步骤一：MySQL复制：MySQL复制简介：将master服务器中主数据库的ddl和dml操作通过二进制日志传到slaves服务器上，然后在master服务器上将这些日志文件重新执行，从而使得slave服务器和master服务器上的数据信息保持同步。Mysql复制的原理：将数据分布到多个系统上去，是通过将Mysql的某一台master主机的数据复制到其它(s...
keepalived+LVS+Mycat+MySQL双主及主从高可用负载均衡集群
云深海阔专栏
06-22 2199
系统集群架构图如下：一、部署90主机和77主机的MySQL主主配置和90主机和89主机的MySQL主从配置详情请见（MySQL主主同步：https://blog.csdn.net/baidu_38432732/article/details/80773634MySQL主从同步：https://blog.csdn.net/baidu_38432732/article/details/80653873...
mysql到doris的DDL整库转换工具
fengjian的博客
11-01 488
适用于常规的mysql-ddl到doris-ddl的整库转换，附全部代码
【Linux】MySQLMGR主从复制
Stringzhua的博客
10-30 896
MySQL是⽬前最流⾏的开源关系型数据库，国内⾦融⾏业也开始全⾯使⽤，其中MySQL5.7.17提出的 MGR(MySQL Group Replication)既可以很好的保证数据⼀致性⼜可以⾃动切换，具备故障检测功能、 ⽀持多节点写⼊，MGR是⼀项被普遍看好的技术。MGR(MySQL Group Replication)是MVSQL⾃带的⼀个插件，可以灵活部署。
Windows 命令提示符（cmd）中输入 mysql 并收到错误消息“MySQL不是内部或外部命令，也不是可运行的程序或批处理文件？
weixin_59272777的博客
11-01 447
属性描述名称PATH环境变量定义可执行文件搜索路径列表作用让系统快速找到并运行程序使用输入命令名（无需完整路径）分隔符Windows用;，Linux/macOS用配置编辑系统或用户环境变量设置。
【重学 MySQL】七十九、深入探索用户变量
CSDN全栈领域优秀博主，阿里云博客专家，工信部权威认证物联网技术开发工程师，曾30分钟高分通过C语言二级，两天手撸代码完成EasyX飞机大战，靠接软件私活一个月换苹果电脑
10-30 925
定义：用户变量以“@”符号开头，后面跟着变量名。变量名可以是任何随机的、复合的标量表达式，只要其中没有列指定。赋值可以使用SET语句来定义和赋值用户变量，如。也可以使用SELECT语句来为用户变量赋值，但必须使用“:=”赋值运算符，因为在SELECT语句中，MySQL将“=”运算符视为等于运算符。例如，。作用域：会话用户变量的作用域是当前会话，而局部变量的作用域是其定义的BEGIN/END语句块。命名：会话用户变量以“@”符号开头，而局部变量不需要。使用场景。
【MySql】第五章（存储函数与存储过程）习题
最新发布
她是不会无条件的！！
11-01 555
【MySql】第五章（存储函数与存储过程）习题
MYSQL--完整性约束
2301_76890677的博客
10-31 1284
左侧的emp表是员工表，里面存储员工的基本信息，包含员工的ID、姓名、年龄、职位、薪资、入职日期、上级主管ID、部门ID，在员工的信息中存储的是部门的ID dept_id，而这个部门的ID是关联的部门表dept的主键id，那emp表的dept_id就是外键,关联的是另一张表的主键。外键是另一张表的主键！例如员工表与部门表之间就存在关联关系，其中员工表中的部门编号字段就是外键，是相对部门表的外键。创建学生表：id（唯一 不能为空），name（非空），sex（默认值 男），age，email（唯一）
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值