文字
分享

Mysqlnd 主从复制和负载均衡插件

  • 简介
  • 快速入门与例子
    • Setup
    • Running statements
    • 连接状态
    • SQL Hints (SQL 优化器)
    • 事务
    • XA/Distributed Transactions
    • 服务级别和一致性
    • Global transaction IDs (GTID)
    • Cache integration
    • 故障转移
    • 分区和分片
    • MySQL Fabric
  • 概念
    • Architecture
    • 连接池与切换
    • 事务控制
    • 错误处理
    • 短错误
    • 错误处理
    • 负载均衡
    • Read-write splitting
    • Filter
    • Service level and consistency
    • Global transaction IDs
    • Cache integration
    • Supported clusters
    • XA/Distributed transactions
  • 安装/配置
    • 需求
    • 安装
    • 运行时配置
    • Plugin configuration file (>=1.1.x)
  • 预定义常量
  • Mysqlnd_ms 函数
    • mysqlnd_ms_dump_servers — Returns a list of currently configured servers
    • mysqlnd_ms_fabric_select_global — Switch to global sharding server for a given table
    • mysqlnd_ms_fabric_select_shard — Switch to shard
    • mysqlnd_ms_get_last_gtid — 返回最后的全局同步 ID (GTID)
    • mysqlnd_ms_get_last_used_connection — Returns an array which describes the last used connection
    • mysqlnd_ms_get_stats — Returns query distribution and connection statistics
    • mysqlnd_ms_match_wild — Finds whether a table name matches a wildcard pattern or not
    • mysqlnd_ms_query_is_select — 查询给定的 SQL 会发送给 master、slave 还是最后使用的 MySQL server 执行。
    • mysqlnd_ms_set_qos — Sets the quality of service needed from the cluster
    • mysqlnd_ms_set_user_pick_server — Sets a callback for user-defined read/write splitting
    • mysqlnd_ms_xa_begin — Starts a distributed/XA transaction among MySQL servers
    • mysqlnd_ms_xa_commit — Commits a distributed/XA transaction among MySQL servers
    • mysqlnd_ms_xa_gc — Garbage collects unfinished XA transactions after severe errors
    • mysqlnd_ms_xa_rollback — Rolls back a distributed/XA transaction among MySQL servers
  • Change History
    • PECL/mysqlnd_ms 1.6 series
    • PECL/mysqlnd_ms 1.5 series
    • PECL/mysqlnd_ms 1.4 series
    • PECL/mysqlnd_ms 1.3 series
    • PECL/mysqlnd_ms 1.2 series
    • PECL/mysqlnd_ms 1.1 series
    • PECL/mysqlnd_ms 1.0 series