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 <roberto@spadim.com.br> escreveu:
Ops, sorry, this was on my face
thanks sergei

Em seg., 8 de jun. de 2020 às 17:29, Sergei Golubchik <serg@mariadb.org> 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 security@mariadb.org


--
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