pecl:mysqlnd_ms
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
pecl:mysqlnd_ms [2012/04/23 12:02] – [Development steps (release planning)] uw | pecl:mysqlnd_ms [2017/09/22 13:28] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 157: | Line 157: | ||
=== 1.4 - Tweaking based on user feedback | === 1.4 - Tweaking based on user feedback | ||
+ | |||
+ | == Coding/ | ||
+ | |||
+ | * [done] More fail over options | ||
+ | * [done] Automatic on-connect fail over, if activated, shall be done in a loop until a connection can be opened. Currently we stop after the first attempt. If automatic fail over is on, we try " | ||
+ | * [done] Remember failed hosts for the duration of a web request (the plugins' | ||
+ | |||
+ | * [done] Refine QoS session consistency server selection policy | ||
+ | * [done] Support "wait for GTID". Currently we loop over all servers until we find a matching one. MySQL 5.6 allows SQL users either to fetch the latest GTID or SQL users can ask for a GTID and their request will block until the GTID has been replicated on the server. We should support the latter logic as well. | ||
+ | |||
+ | * [done] Improve load balancing | ||
+ | * [done] Allow users to set a ratio/ | ||
+ | |||
+ | == QA == | ||
+ | |||
+ | * [done] 85-90% code coverage through tests | ||
+ | |||
+ | == Documentation, | ||
+ | |||
+ | * [done] Update documentation | ||
+ | * [done] Assorted blog postings | ||
+ | |||
+ | === 1.5 - Tweaking based on user feedback | ||
+ | |||
+ | Work has not started yet. | ||
== Coding/ | == Coding/ | ||
Line 163: | Line 188: | ||
* [open] Silent and automatic connection fail over if server returns configured error code | * [open] Silent and automatic connection fail over if server returns configured error code | ||
* NOTE: this may require refactoring of four filters. | * NOTE: this may require refactoring of four filters. | ||
- | * [open] Automatic on-connect fail over, if activated, shall be done in a loop until a connection can be opened. Currently we stop after the first attempt. If automatic fail over is on, we try " | ||
- | * [open] Remember failed hosts for the duration of a web request (the plugins' | ||
* [open] Add failover timeout and failover (maximum) attempts limits/ | * [open] Add failover timeout and failover (maximum) attempts limits/ | ||
* [open] Support directing statements manually to a group of nodes for more efficient server cache usage | * [open] Support directing statements manually to a group of nodes for more efficient server cache usage | ||
- | * [open] Refine QoS session consistency server selection policy | ||
- | * [open] Support "wait for GTID". Currently we loop over all servers until we find a matching one. MySQL 5.6 allows SQL users either to fetch the latest GTID or SQL users can ask for a GTID and their request will block until the GTID has been replicated on the server. We should support the latter logic as well. | ||
* [open] Remember the most current server and test this one first when searching for a GTID (a synchronous server). Use of cached information is possible for the duration of a read-only request sequence. The cache must be flushed and refreshed for every write. | * [open] Remember the most current server and test this one first when searching for a GTID (a synchronous server). Use of cached information is possible for the duration of a read-only request sequence. The cache must be flushed and refreshed for every write. | ||
- | |||
- | * [open] Improve load balancing | ||
- | * [open] Allow users to set a ratio/ | ||
- | |||
- | * [in progress] Improve lazy connection charset handling | ||
* [open] Work with php.net Windows team to provide PECL/ | * [open] Work with php.net Windows team to provide PECL/ | ||
Line 190: | Line 206: | ||
* [open] Update documentation | * [open] Update documentation | ||
* [open] Assorted blog postings | * [open] Assorted blog postings | ||
- | |||
- | === Open and delayed tasks === | ||
- | |||
- | == Coding/ | ||
- | |||
- | * [incomplete - 1.2] make load balancer schemata aware | ||
- | * for each statement detect database/ | ||
- | * follow schemata based partitioning rules | ||
- | * basic idea: http:// | ||
- | * cancelled/ | ||
- | * [cancelled] improve trx_stickiness using MYSQL*/ | ||
- | * cancelled: http:// | ||
- | * [open] bail on unknown config settings. For example, bail if someone uses round_robin instead of roundrobin | ||
- | |||
- | == QA == | ||
- | |||
- | * [open] >= 90% code coverage through tests | ||
- | * [open] write report on parsing overhead, goal: <5% in worst case micro benchmarks | ||
- | |||
- | == Documentation, | ||
- | |||
- | * [done] impact of connection limits such as allow_persistent, | ||
pecl/mysqlnd_ms.txt · Last modified: 2017/09/22 13:28 by 127.0.0.1