meituan / ptubes

Ptubes is a database disaster recovery product based on the PITR (Point In Time Recovery) method, which can be used to restore the entire database to a specific point in time to help users improve the reliability and security of the database
Other
54 stars 11 forks source link

[Feature]Hope ptubes can support transaction sending data, support ACID #8

Open myksl opened 2 years ago

myksl commented 2 years ago

Describe the feature

At present, ptubes does not support transaction sending data. All binlog events strip the transaction concept and are all delivered in the form of Events, resulting in the loss of ACID attributes.

When the industry observes the downstream library, half of the upstream operations in the same transaction may be observed: for example, the order placement process, the intra-transaction operation to create an order, and the deduction of the balance. It was originally an intra-transaction operation, with atomicity and synchronization through ptubes When going downstream, the business may observe that the balance has not changed, an order has been added / the balance has decreased, and there is no corresponding order

So we expect that ptubes can assemble the binlog into a transaction and restore the ACID attribute. Some of our functions require this ability