DZone Database Zone
Differences in PREPARE Statement Error Handling With Binary and Text Protocol
In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols.
Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads, one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire the workload through a PREPARE statement, there are differences between using the MySQL connector API (with binary protocol) and the MySQL client (with text protocol). Let’s look at these differences with the help of an example.
No comments:
Post a Comment