Hello, again A new doubt
Could we sync temporal table with binary log? I’m thinking something about stream, example: A client request, please sendme your table and the position of binarylog, and i will be in sync reading binary log The idea is execute an select with a known fixed position of binary log, and send the result of select as a “snapshot” of initial data and the position of binary log as a point to the client sync “incremental” data Could this be possible? I’m thinking id this could be possible without temporal table too, like an “atomic” (serialized transaction?) select of table and binlog position? Em seg, 8 de jun de 2020 às 19:38, Roberto Spadim <[email protected]> escreveu: > Ops, sorry, this was on my face > thanks sergei > > Em seg., 8 de jun. de 2020 às 17:29, Sergei Golubchik <[email protected]> > escreveu: > >> Hi, Roberto! >> >> On Jun 08, Roberto Spadim wrote: >> > Hi folks >> > >> > Could be possible query temporal tables but instead of use a timestamp, >> use >> > a “commit” id? >> > >> > For example query first commit, second, third, ... and the last commit = >> > current table? >> >> Yes. >> See >> https://mariadb.com/kb/en/temporal-data-tables/#transaction-precise-history-in-innodb >> >> Regards, >> Sergei >> VP of MariaDB Server Engineering >> and [email protected] >> > > > -- > Roberto Spadim > SPAEmpresarial - Software ERP/Scada > Eng. Automação e Controle, Eng. Financeira > -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
