feat: add mark to transaction for OceanBase

whhe commented 11 months ago

Our team is going to open source a new version of oblogproxy, named "Binlog Service"， it serves like a mysql server and support the mysql dump protocol. But there is an issue that the output of show master status from it exists a certain delay, which means we can't filter out the binlog event by the log position.

Here is my solution: add a table to mark the start and end of one transaction at the source database, the table is like below:

CREATE TABLE `$_$Inception$_$`.`transaction_mark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mark_type` int(11) DEFAULT NULL,
  `thread_id` int(10) unsigned DEFAULT NULL,
  `log_file` varchar(40) DEFAULT NULL,
  `log_position` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)