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