SELECT ... FROM db.tbl WHERE id=?
and "preparing" it...
All backend servers are hit, even though it should be able to see that `db` is desired.
Worse:
INSERT INTO db.tbl VALUES 
leads to sending the INSERT to all backends.
[MXS-409] prepare should not hit all servers Created: 2015-10-16 Updated: 2015-10-30 Resolved: 2015-10-20 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | readwritesplit |
| Affects Version/s: | 1.2.1 |
| Fix Version/s: | 1.3.0 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Rick James (Inactive) | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Ubuntu |
||
| Description |
|
SELECT ... FROM db.tbl WHERE id=? Worse: |
| Comments |
| Comment by Dipti Joshi (Inactive) [ 2015-10-30 ] |
|
markus makelaHow was this fixed ? |
| Comment by markus makela [ 2015-10-30 ] |
|
When a statement is being prepared, it is no longer sent to all servers and is sent to the master only. This does not affect functionality in any negative way since all prepared statement executions were sent to the master. |