I have some tables in mysql in production. I want to move the data as well update/create tables metadata to another schema (archival) having same columns,datatypes and indexes through scheduler. Both schemas are at same end point. I need to have both the production and archival schema remain in sync. What is the best way to do this?
RDBMS is MYSQL 8.0.14 and hosted on AWS