最新Ubuntu搭建Mysql+Keepalived高可用(双主热备)，springcloud面试题最全

感受：

其实我投简历的时候，都不太敢投递阿里。因为在阿里一面前已经过了字节的三次面试，投阿里的简历一直没被捞，所以以为简历就挂了。

特别感谢一面的面试官捞了我，给了我机会，同时也认可我的努力和态度。对比我的面经和其他大佬的面经，自己真的是运气好。别人8成实力，我可能8成运气。所以对我而言，我要继续加倍努力，弥补自己技术上的不足，以及与科班大佬们基础上的差距。希望自己能继续保持学习的热情，继续努力走下去。

也祝愿各位同学，都能找到自己心动的offer。

分享我在这次面试前所做的准备（刷题复习资料以及一些大佬们的学习笔记和学习路线），都已经整理成了电子文档

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

安装两台Mysql

安装Mysql5.5

sudo apt-get update

apt-get install aptitude

aptitude install mysql-server-5.5

或

sudo apt-cache search mariadb-server

apt-get install -y mariadb-server-5.5

卸载

sudo apt-get remove mysql-*

dpkg -l |grep ^rc|awk ‘{print $2}’ |sudo xargs dpkg -P

配置权限

vim /etc/mysql/my.cnf

#bind-address = 127.0.0.1

mysql -u root -p

grant all on . to root@‘%’ identified by ‘root’ with grant option;

flush privileges;

配置两台Mysql主主同步

配置节点1

vim /etc/mysql/my.cnf

server-id = 1 #节点ID

log_bin = mysql-bin.log #日志

binlog_format = “ROW” #日志格式

auto_increment_increment = 2 #自增ID间隔(=节点数，防止ID冲突)

auto_increment_offset = 1 #自增ID起始值(节点ID)

binlog_ignore_db=mysql #不同步的数据库

binlog_ignore_db=information_schema

binlog_ignore_db=performance_schema

重启mysql

service mysql restart

mysql -u root -p

记录节点1的binlog日志位置

show master status;

mysql-bin.000001 245 mysql,information_schema,performance_schema

配置节点2

vim /etc/mysql/my.cnf

server-id = 2

log_bin = mysql-bin.log

relay_log = mysql-relay-bin.log #中继日志

log_slave_updates = ON #中继日志执行后，变化计入日志

read_only = 0

binlog_format = “ROW”

auto_increment_increment = 2

auto_increment_offset = 2

binlog_ignore_db=mysql

binlog_ignore_db=information_schema

binlog_ignore_db=performance_schema

replicate_ignore_db=mysql

replicate_ignore_db=information_schema

replicate_ignore_db=performance_schema

配置主从

mysql -u root -p

CHANGE MASTER TO

MASTER_HOST=‘192.168.1.21’,

MASTER_USER=‘root’,

MASTER_PASSWORD=‘root’,

MASTER_LOG_FILE=‘mysql-bin.000001’,

MASTER_LOG_POS=245;

#开启同步

start slave

#查看同步状态 Slave_IO_Running和Slave_SQL_Running需要均为Yes

show slave status;

记录节点2的binlog日志位置

show master status;

mysql-bin.000001 1029 mysql,information_schema,performance_schema

配置主主（节点1）

vim /etc/mysql/my.cnf

relay_log = mysql-relay-bin.log

log_slave_updates = ON

read_only = 0

replicate_ignore_db=mysql

replicate_ignore_db=information_schema

replicate_ignore_db=performance_schema

开启同步

mysql -u root -p

CHANGE MASTER TO

MASTER_HOST=‘192.168.1.20’,

MASTER_USER=‘root’,

MASTER_PASSWORD=‘root’,

MASTER_LOG_FILE=‘mysql-bin.000001’,

MASTER_LOG_POS=1029;

#开启同步

start slave

#查看同步状态 Slave_IO_Running和Slave_SQL_Running需要均为Yes

show slave status;

异常处理

Could not initialize master info structure, more error messages can be found in the MySQL error log

解决：reset slave

安装配置Keepalived

安装Keepalived

#依赖

sudo apt-get install -y libssl-dev

sudo apt-get install -y openssl

sudo apt-get install -y libpopt-dev

sudo apt-get install -y libnl-dev libnl-3-dev libnl-genl-3.dev

apt-get install daemon

apt-get install libc-dev

apt-get install libnfnetlink-dev

apt-get install libnl-genl-3.dev

#安装

apt-get install keepalived

#编译安装

cd /usr/local

wget https://www.keepalived.org/software/keepalived-2.2.2.tar.gz

tar -zxvf keepalived-2.2.2.tar.gz

mv keepalived-2.2.2 keepalived

./configure --prefix=/usr/local/keepalived

sudo make && make install

#开启日志

sudo vim /etc/rsyslog.d/50-default.conf

.=info;.=notice;*.=warn;\

auth,authpriv.none;\

cron,daemon.none;\

mail,news.none -/var/log/messages

sudo service rsyslog restart

tail -f /var/log/messages

sudo mkdir /etc/sysconfig

sudo cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/

sudo cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/

sudo cp /usr/local/keepalived/sbin/keepalived /sbin/

sudo mkdir /etc/keepalived

sudo cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

配置节点信息

---

节点1 192.168.1.21

vim /etc/keepalived/keepalived.conf

global_defs {

router_id MYSQL_HA　　#当前节点名

}

vrrp_instance VI_1 {

state BACKUP #两台配置节点均为BACKUP

interface eth0 #绑定虚拟IP的网络接口

virtual_router_id 51 #VRRP组名，两个节点的设置必须一样，以指明各个节点属于同一VRRP组

priority 101 #节点的优先级,另一台优先级改低一点

advert_int 1 #组播信息发送间隔，两个节点设置必须一样

nopreempt #不抢占，只在优先级高的机器上设置即可，优先级低的机器不设置

authentication { #设置验证信息，两个节点必须一致

auth_type PASS

auth_pass 123456

}

virtual_ipaddress { #指定虚拟IP,两个节点设置必须一样

192.168.1.111

1200页Java架构面试专题及答案

小编整理不易，对这份1200页Java架构面试专题及答案感兴趣劳烦帮忙转发/点赞

百度、字节、美团等大厂常见面试题

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

irtual_ipaddress { #指定虚拟IP,两个节点设置必须一样

192.168.1.111

1200页Java架构面试专题及答案

小编整理不易，对这份1200页Java架构面试专题及答案感兴趣劳烦帮忙转发/点赞

[外链图片转存中…(img-5RAJMKtZ-1715651224526)]

[外链图片转存中…(img-1inCepnE-1715651224526)]

百度、字节、美团等大厂常见面试题

[外链图片转存中…(img-VJrClvss-1715651224526)]

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取