doris fe 高可用

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

不需要读写分离

问题记录

error to open replicated environment. | com.sleepycat.je.EnvironmentFailureException: (JE 18.3.12) Ids: 1 were equal. But names: xxx weren’t! UNEXPECTED_STATE: Unexpected internal state, may have side effects

fe follower 节点首次启动未添加 --helper xxx:9010 启动，删除元数据

proxysql user ‘admin’ can only connect locally

proxy 服务节点需要安装mysql

msg: failed to call frontend service

时钟不同步