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

最新推荐文章于 2024-06-11 21:29:27 发布
最新推荐文章于 2024-06-11 21:29:27 发布
阅读量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)
公子欧夏
关注
  • 30
    点赞
  • 踩
  • 11
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mysql集群之mysql双主双活+keepalived实现高可用_mysql+keepalived搭建教程
a360284634的博客
11-24 1万+
史上最全mysql+keepalived教程。 本文介绍在linux服务下安装mysql并实现mysql主从配置，双主双活+keepalive实现mysql高可用的详细部署流程
mysql mha keepalived_Mysql MHA 主从配置+Keepalived测试使用说明
weixin_32532145的博客
01-27 557
Mysql MHA使用说明一、 MHA 简介MHA，即Master High Availability Manager and Tools for MySQL，是日本的一位MySQL专家采用Perl语言编写的一个脚本管理工具，该工具仅适用于MySQL Replication(二层)环境，目的在于维持Master主库的高可用性。MHA(Master High Availability...
MySQL双主一从 + keepalived高可用 + NFS 部署
SinG_Lala的博客
10-15 307
本文主要讲述了MySQL双主一从 + keepalived高可用 + NFS 部署
基于keepalived实现MySQL主从高可用架构具体步骤及配置文件示例
学亮编程手记
02-24 432
请根据实际情况调整上述配置中的IP地址、用户名、密码以及接口名等信息。同时，健康检查脚本应能准确反映MySQL实例的状态，并且要有权限连接到数据库进行检查。
Mysql主从之keepalive+MySQL高可用
完颜振江
03-22 925
Keepalived是一个开源的高可用性解决方案，它可以在多个服务器之间实现负载均衡和故障切换。虚拟IP（VIP）：Keepalived可以配置一个虚拟IP地址，该IP地址会在多个服务器之间进行漂移，从而实现负载均衡和故障切换。健康检查：Keepalived会定期检查服务器的健康状态，如果服务器出现故障或不可用，会自动进行切换。VRRP协议：Keepalived使用虚拟路由冗余协议（VRRP）来管理虚拟IP地址，确保只有一个服务器在处理流量。
MySQL+KeepAlived实现双主高可用方案实践
长沙老码农
02-18 3646
目录 1、什么叫双主高可用（双机热备） 2、搭建主主同步 3、配置MySQL+Keepalived故障转移的高可用环境 4、测试 5、MyCAT双主高可用 5.1 架构图 5.2 准备环境 5.3 高可用配置 1、什么叫双主高可用（双机热备） 我们通常说的双机热备是指两台机器都在运行，但并不是两台机器都同时在提供服务。当提供服务的一台出现故障的时候，另外一台会马上自动接管并且提供服务，而且切换的时间非常短。MySQL双主复制，即互为Master-Slave(只有一个Master提供.
mysql keepalived主从_Keepalived与MySQL互为主从自动切换配置
weixin_35067558的博客
01-19 416
为解决Mysql数据库单点问题，实现两台MySQL数据库互为主备，双向replication。当一Master出现问题，则将Slave切换为Master继续工作.环境说明系统版本：CentOS Linux release 7.6.1810 (Core)MySQL版本：mysql Ver 14.14 Distrib 5.7.27keepalived版本：Keepalived v1.2.13序号 　...
MySQL主从复制+lvs与keepalived实现负载高可用
02-24
1. 高可用性：通过 MySQL 主从复制和 LVS 与 Keepalived 的组合，可以实现数据库的高可用性。 2. 负载均衡：LVS 可以将来自客户端的请求分配到多个服务器上，以提高系统的整体性能和可用性。 3. 读写分离：W-VIP ...
使用keepalived实现对mysql主从复制的主备自动切换.docx
01-09
"使用keepalived实现对mysql主从复制的主备自动切换" 本文主要讲解如何使用keepalived实现对mysql主从复制的主备自动切换。keepalived是一款高可用性解决方案，可以实现虚拟IP的管理和服务监控，在mysql主从复制...
使用keepalived实现对MySQL主从复制的主备自动切换
03-27
使用MySQL+keepalived是一种非常好的解决方案，在MySQL-HA环境中，MySQL互为主从关系，这样就保证了两台 MySQL数据的一致性，然后用keepalived实现虚拟IP，通过keepalived自带的服务监控功能来实现MySQL故障时自动...
使用keepalived实现对mysql主从复制的主备自动切换.doc
08-18
mysql主从复制+lvs与keepalived实现负载高可用
03-18
mysql主从复制+lvs与keepalived实现负载高可用
MySQL 高级 - 第十一章 | 索引优化与查询优化
xhmico的博客
06-07 1358
上篇：第十章、性能分析工具的使用本文内容主要源于：bilibili-尚硅谷-MySQL高级篇都有哪些纬度可以进行数据库调优？简言之：关于数据库调优的知识点非常分散，不同 ，不同的公司，不同的职位，不同的项目遇到的问题都不尽相同。虽然 查询优化的技术很多，但是大体方向上完全可以分为 和 两大块。学员表插 万条， 班级表插 万条步骤1：建表 步骤2：设置参数命令开启：允许创建函数设置 步骤3：创建函数随机产生字符串，保证每条数据都不同 随机产生班级编号 步骤4：创建存储过程创建往 表中插入数据的存储
【MySQL】服务器配置和管理
p_fly的博客
06-09 750
MySQL服务器通常说的是mysqld程序。mysqld 是 MySQL 数据库服务器的核心程序，负责处理客户端的请求、管理数据库和执行数据库操作。管理员可以通过配置文件和各种工具来管理和监控 mysqld 服务器的运行本文将介绍下面三个内容：服务器启动选项：可以在命令行和配置文件中指定，用于配置服务器的行为和特性。服务器系统变量：反映了启动选项的当前状态和值，其中一些变量可以在服务器运行时修改。服务器状态变量：包含了关于运行时操作的计数器和统计信息。
Mysql--基础知识点--86--慢查询
Chasing__Dreams的博客
06-11 756
mysql 慢查询
【MySQL】索引（上）
最新发布
开心星人的博客
06-11 746
索引是一种用于快速查询和检索数据的数据结构，排序好的数据结构。 优点：加快检索速度；通过创建唯一性索引，可以保证行数据的唯一性；通过索引列对数据进行排序，降低数据排序的成本，降低CPU的消耗 缺点：创建和维护索引需要耗费时间，本身存储也要耗费一定空间不同引擎对索引的支持情况 哈希表、有序数组、B+树、B树、红黑树，二叉树哈希表：只适用于等值查询的场景，用这种索引做不了范围查询，必须全表扫描。查询效率高有序数组：有序数组在等值查询和范围查询场景中的性能就都非常优秀，但是一旦更新数据就得挪动后面的元素，成本太高
Mysql的 存储过程（procedure）
shark1978的专栏
06-09 733
存储过程（Stored Procedure）是一组为了完成特定功能的SQL语句集合，经编译后存储在数据库中，用户通过指定存储过程的名字和参数（如果有）来执行它。存储过程可以在很多数据库管理系统（DBMS）中找到，如SQL Server、Oracle、MySQL等。
mysql主从部署keepalived
08-19
在mysql主从部署中，keepalived可以用来实现高可用。首先，需要完成主从同步的配置。然后，安装和部署keepalived。keepalived可以保证在主数据库宕机时，自动将从数据库切换为主数据库，以实现无缝的切换并保证服务...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值