Syncing the local database content to a remote mySQL database
Posted: Thu Apr 06, 2023 9:58 am
Hi,
is there a possibility to sync the local database to a remote mySQL database? I do not mean the usual push functionality where one basically builds a SQL statement that puts selected data into the remote database but a real "replication" of the local database.
Ideally such a replication keeps track of the last record successfully synced and catches up as soon as the remote database is online again (should it be offline some time). By the way, which database is actually used locally?
Thanks,
Marko
is there a possibility to sync the local database to a remote mySQL database? I do not mean the usual push functionality where one basically builds a SQL statement that puts selected data into the remote database but a real "replication" of the local database.
Ideally such a replication keeps track of the last record successfully synced and catches up as soon as the remote database is online again (should it be offline some time). By the way, which database is actually used locally?
Thanks,
Marko