• ADADADADAD

    如何进行Mysql中的mysql-proxy读写分离[ mysql数据库 ]

    mysql数据库 时间:2024-11-26 22:09:56

    作者:文/会员上传

    简介:

    以配置文件的方式启动[root@host-192-168-1-56 mysql-proxy]# lsbin include lib libexec licenses mysql-proxy.conf mysql-proxy.log mysql-proxy.pid share[root@host-19

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。


    以配置文件的方式启动

      [root@host-192-168-1-56 mysql-proxy]# ls

      bin include lib libexec licenses mysql-proxy.conf mysql-proxy.log mysql-proxy.pid share

    [root@host-192-168-1-56 mysql-proxy]# more mysql-proxy.conf
    [mysql-proxy]
    daemon=true


    pid-file=/usr/local/mysql-proxy/mysql-proxy.pid
    log-file=/usr/local/mysql-proxy/mysql-proxy.log
    log-level=debug


    LUA_PATH=/usr/local/mysql-proxy/share/doc/mysql-proxy
    proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
    proxy-address=127.0.0.1:4040
    proxy-read-only-backend-addresses=192.168.1.56:3307,192.168.1.6.3307
    proxy-backend-addresses=192.168.1.6:3307
    keepalive=true
    proxy-skip-profiling=true
    admin-address=:4042
    admin-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/admin-sql.lua
    admin-username=admin
    admin-password=admin


    plugins=proxy,admin


    [root@host-192-168-1-56 mysql-proxy]# /usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.conf

    如何进行Mysql中的mysql-proxy读写分离.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysqlproxy