Java application for bk and data synchronization of two DB 10.1.28-MariaDB.

Hello, the application must have a very simple interface with the ability to enter the URLs of the two MariaDb db to download and update, preconfigured in a configuration file from a location outside the application. There will be two buttons, the first "Update DB Client" which allows you to restore all the tables on the db client previously downloaded from the db server The second button is "Send new data to the Server" which unlike the first functionality works from the client to the server and only on the different individual records and between the two db. The list of tables must therefore be customizable on an external configuration file dedicated to the tables of both the db server and the local db. "Update DB Client": The initial bk weighs about 100mb zipped, 900mb the uncompressed db and increases with time, therefore the new software will have to use the shell commands of mariadb / mysql or any other fast utility to do the bk from the server in zip format and restore the db locally in the shortest possible time. The db .zip bk file may already be available on a shared directory, if you check the shared folder option then the functionality will only have to restore the dz .zip. if present, otherwise return an error message. The file name must also be configurable from the external file. "Send new data to the Server": For synchronization it must be borne in mind that there are more than 2 clients working off-line at the same time and that at the end of the day they must send the new data to the central office. So you cannot work for differences on the PK or other ID of the single table but each table has the UUID field inside which guarantees the uniqueness of the record generated by mariadb / mysql. The synchronization will act only on one client at a time and will have to read from the local client db every single table listed in the configuration file and take only the records of the table with the new UUIDs and create them on the server without altering the informative content. Both during the backup and restore of the db, and the subsequent synchronization of data from the client to the server, a log window is required to verify the execution of the procedures. An image of the very simple window you want to create is shown. We also evaluate proposals that can improve the application. I remain available for more information, thanks