搭建mysql

    主节点
    1、进入项目—>应用负载—>服务—>创建服务
    选中有状态服务
    image.png
    添加镜像mysql:5.7

    [client]
    default-character-set=utf8

    [mysql]
    default-character-set=utf8

    [mysqld]
    init_connect=’SET collation_connection=uft8_unicode_ci’
    init_connect=’SET NAMES utf8’
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve

    server_id=1
    log-bin=mysql-bin
    read-only=0
    binlog-do-db=gulimall_ums
    binlog-do-db=gulimall_pms
    binlog-do-db=gulimall_oms
    binlog-do-db=gulimall_sms
    binlog-do-db=gulimall_wms
    binlog-do-db=gulimall_admin

    replicate-ignore-db=mysql
    replicate-ignore-db=sys
    replicate-ignore-db=infomation_schema
    replicate-ignore-db=performance_schema

    image.png

    从节点

    [client]
    default-character-set=utf8
    [mysql]
    default-character-set=utf8
    [mysqld]
    init_connect=’SET collation_connection=uft8_unicode_ci’
    init_connect=’SET NAMES utf8’
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve

    server_id=2
    log-bin=mysql-bin
    read-only=1
    binlog-do-db=gulimall_ums
    binlog-do-db=gulimall_pms
    binlog-do-db=gulimall_oms
    binlog-do-db=gulimall_sms
    binlog-do-db=gulimall_wms
    binlog-do-db=gulimall_admin
    replicate-ignore-db=mysql
    replicate-ignore-db=sys
    replicate-ignore-db=infomation_schema
    replicate-ignore-db=performance_schema

    主从链接

    GRANT REPLICATION SLAVE ON . TO ‘backup’@’%’ IDENTIFIED BY ‘123456’;
    show master status;

    mysql-bin.000003
    mysql-master.cjxmall

    change master to master_host=’mysql-master.cjxmall’,master_user=’backup’,master_password=’123456’,master_log_file=’mysql-bin.000003’,master_log_pos=0,master_port=3306;

    start slave;
    show slave status;