[MXS-85] MariaDB 10 compatilbity with bin log router Created: 2015-04-02 Updated: 2015-07-21 Resolved: 2015-07-21 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | binlogrouter |
| Affects Version/s: | 1.1.0 |
| Fix Version/s: | 1.2.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Dipti Joshi (Inactive) | Assignee: | Massimiliano Pinto (Inactive) |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Comments |
| Comment by Massimiliano Pinto (Inactive) [ 2015-04-04 ] |
|
MariaDB10 compatibility with BinLog router currently has such issues so far:
MaxScale Binlog Router seems working with MariaDB slaves (i.e insert into the master MariaDB 10 are passed to the slaves via MaxScale) As customer tests start with mysqlbinlog (before adding any slaves), the compatibily with mysqbinog should be fixed as first step. |
| Comment by Massimiliano Pinto (Inactive) [ 2015-05-07 ] |
|
Current proposed solution is solution is: 1) addition of mariadb10-compatibility roputer option (default = 0) 2) binlogrouter stops on error is event_type > MAX_EVENT_TYPE based on router->mariadb10_compat (set by mariadb10-compatibility option) 3) binlog router to master registration phase depends on mariadb10-compatibility. 4) mariadb10 slave registering itself to binlogrouter with mariadb/mysql 5.5, 5.6 master sends SET @mariadb_slave_capability=4 and gets an ok packet 5) If master is mariadb10 and slave is version 5 is not possible to allow replication as currently binlogrouter cannot skip stored GTID events in binlog files, so the replication is denied: MySQL> SHOW SLAVE STATUS\G Slave_IO_Running: Connecting |