doris fe 高可用

胖胖胖胖胖虎

已于 2025-07-29 11:39:18 修改

阅读量608

点赞数 1

CC 4.0 BY-SA版权

分类专栏： OLAP 引擎文章标签： doris

于 2022-11-18 15:31:27 首次发布

本文链接：https://blog.youkuaiyun.com/qq_15138049/article/details/127923213

OLAP 引擎专栏收录该内容

25 篇文章

订阅专栏

doris 高可用

follower

### 添加 follower 节点
alter system add follower "doris-fe-02:9010";
alter system add follower "doris-fe-03:9010";

注意：follower首次启动需要添加 --helper <fe_masater>:9010

### doris-fe-02 节点 fe 进程首次启动
start_fe.sh --helper doris-fe-01:9010 --daemon

### doris-fe-02 节点 fe 进程首次启动
start_fe.sh --helper doris-fe-01:9010 --daemon

show proc '/frontends'
在这里插入图片描述

尝试杀master节点，master 节点发生转移
在这里插入图片描述

ProxySQL 实现 doris 高可用

rpm 安装包：https://github.com/sysown/proxysql/releases

[root@doris-fe-01 module]# rpm -ivh proxysql-2.4.4-1-centos7.x86_64.rpm
warning: proxysql-2.4.4-1-centos7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID 8217c97e: NOKEY
error: Failed dependencies:
        gnutls is needed by proxysql-2.4.4-1.x86_64
        libgnutls.so.28()(64bit) is needed by proxysql-2.4.4-1.x86_64
        libgnutls.so.28(GNUTLS_1_4)(64bit) is needed by proxysql-2.4.4-1.x86_64
        libgnutls.so.28(GNUTLS_3_0_0)(64bit) is needed by proxysql-2.4.4-1.x86_64
        libgnutls.so.28(GNUTLS_3_1_0)(64bit) is needed by proxysql-2.4.4-1.x86_64
        perl(DBD::mysql) is needed by proxysql-2.4.4-1.x86_64
        perl(DBI) is needed by proxysql-2.4.4-1.x86_64

[root@doris-fe-01 module]# yum install -y gnutls

[root@doris-fe-01 module]# rpm -ivh proxysql-2.4.4-1-centos7.x86_64.rpm
warning: proxysql-2.4.4-1-centos7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID 8217c97e: NOKEY
error: Failed dependencies:
        perl(DBD::mysql) is needed by proxysql-2.4.4-1.x86_64
        perl(DBI) is needed by proxysql-2.4.4-1.x86_64

[root@doris-fe-01 module]# yum install -y perl-DBI perl-DBD-mysql

[root@doris-fe-01 module]# service  proxysql start
[root@doris-fe-01 module]# systemctl enable proxysql

proxysql user 'admin' can only connect locally

在这里插入图片描述
admin:admin

添加fe server

保存，否则退出客户端会丢失

在这里插入图片描述
查看 mysql_servers 节点监控信息

sql 请求用户配置

只有active=1 的用户才是有效用户，确保transaction_persistent=1，一定要执行后面的命令刷新权限才有效！load mysql users to runtime，save mysql users to disk

mysql> insert into mysql_users(username, password, default_hostgroup, transaction_persistent) values('root','123456',10,1);
Query OK, 1 row affected (0.00 sec)

mysql> load mysql users to runtime;
Query OK, 0 rows affected (0.00 sec)

mysql> save mysql users to disk;
Query OK, 0 rows affected (0.01 sec)