mysql读写分离高可用架构图

+-------------------+       +-------------------+       +-------------------+
|   应用服务器      | <---> |   负载均衡器      | <---> |   主数据库 (写)   |
+-------------------+       +-------------------+       +-------------------+
                                                              |
                                                              |
                                                              v
                                                      +-------------------+
                                                      |   从数据库 (读)   |
                                                      +-------------------+

# MySQL Proxy配置文件
mysql-proxy --proxy-backend-addresses=master_ip:3306 --proxy-read-only-backend-addresses=slave1_ip:3306,slave2_ip:3306 --proxy-lua-script=/path/to/read-write-splitting.lua

-- read-write-splitting.lua脚本示例
function read_query(packet)
    if string.byte(packet) == proxy.COM_QUERY then
        local query = string.sub(packet, 2)
        if string.match(query, "^select") then
            proxy.queries:append(1, packet, { resultset_is_needed = true })
            proxy.queries:append(2, packet, { resultset_is_needed = true })
            return proxy.PROXY_SEND_RESULT
        end
    end
    proxy.queries:append(2, packet, { resultset_is_needed = true })
    return proxy.PROXY_SEND_QUERY
end