We have some tables in an operational and busy MySQL database (AWS RDS) for which we require system versioning for some of the tables. (point-in-time queries)
Is it possible to somehow replicate the data in to AWS RDS for MariaDB in order to leverage its temporal table capabilities? (Adding note: replication between MySQL and MariaDB is indeed supported, as explained here)
This may also be problematic as the temporal table should be created via the "WITH SYSTEM VERSIONING" option, which adds extra columns to the table.. (so table schema will not be identical) Any assistance or other ideas would be appreciated!