Add ability to only execute SELECT statements to keep slave servers warm
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MOVED - Percona Playback |
Triaged
|
Medium
|
Unassigned |
Bug Description
Im using percona-playback as per http://
To be sure the playback on the slave server is read-only, I have created a dedicated user with read-only access to the database (on top of using innodb_
This makes the UPDATE statements error, which as per mysql_client.cc:83, will disconnect and reconnect multiple times as it retries.
This then leaves 60000+ dangling TCP connections waiting to expire (im assuming SO_LINGER is not getting set anywhere), which then exhausts all local tcp sockets, making local connections fail.
It would be ideal to have an option to only execute select statements on the server. This would also be handy for people not running the percona server (innodb_
Related branches
- Percona core: Pending requested
-
Diff: 206 lines (+114/-3)4 files modifiedMakefile.am (+5/-0)
percona_playback/query_log/query_log.cc (+17/-3)
percona_playback/query_log/query_log.h (+15/-0)
percona_playback/test/basic-select-only.cc (+77/-0)
Changed in percona-playback: | |
milestone: | none → 0.8 |
status: | New → Triaged |
importance: | Undecided → Medium |