[MDEV-7663] MariaDB 10.0 statement-based events cannot be executed in parallel by MySQL 5.6 Created: 2015-03-04 Updated: 2015-06-10 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.0.16 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Kolbe Kegel (Inactive) | Assignee: | Kristian Nielsen |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | verified | ||
| Description |
|
MySQL 5.6 parallel slave execution "doesn't work" on statement-based events from a MariaDB 10.0 master. Row-based events are correctly parallelized. Perhaps there is some difference in log format between MariaDB 10.0 and MySQL 5.6 that allows a MySQL 5.6 slave to identify the database(s) written to by a statement-based event when the event comes from a MySQL master, but that information is missing from the log written by a MariaDB 10.0 master? |
| Comments |
| Comment by Elena Stepanova [ 2015-03-05 ] |
|
The lack of parallellism can be reproduced easily. I don't see anything obvious in the binlog (as parsed by mysqlbinlog). The only suspicious thing in the slave error log is the complaint about missing SERVER_UUID on master. It might be or be not the reason. Assigning to knielsen who might be able to shed some light on it. |
| Comment by Kristian Nielsen [ 2015-06-10 ] |
|
One reason might be that the BEGIN query event that is sent to the MySQL 5.6 slave by the MariaDB 10.0 master does not contain the current schema/database. Nor is there any logical clock information sent. |