Sync MySQL with mobile applications with ease.

MySQLSync allows mobile apps to have a local SQLite synchronized in both directions with a remote MySQL database

MySQLSync is a complete solution for synchronizing data between MySQL or MariaDB databases and SQLite.

There’s no need to modify your existing MySQL database schema or the applications that already use it. With MySQLSync you can define which tables should be synchronized, then you have to run the server component to expose the DB and use the Android and iOS client side libraries that will perform the synchronization in your mobile applications. Synchronization will runs seamlessly in the background, syncing data in both directions between your MySQL backend and mobile devices. Everything happens automatically, so your mobile users always have the latest data, and your backend DB stays up-to-date without any extra effort.

Why use MySQLSync, when I can build my own REST API ?

The simplest solution for synchronizing with mobile apps could be a REST API that exposes the MySQL server to the outside world. But mobile phones may not always have network coverage or Internet access, in which case you have to save the made changes for another call. You also have to handle merge conflicts when two people have changed the same data at different times.

Here comes the solution provided by MySQLSync. Instead of directly accessing the central MySQL database, mobile apps read and write to a local SQLite database. When needed they can synchronized their local data copies with the central MySQL DB with a simple sync method.

Speed

Crafting your own REST solution will require your app to stop working during your REST synchronization calls. With MySQLSync there is no such delay, as the sync can be done in the background at the same time when the end user operates with the app.

Hosting the Server component

The role of the MySQLSync server component is to expose the MySQL database to the mobile apps, so they can synchronize over the Internet. You can host it on your own servers, or deploy it to the cloud with platforms like AWS Elastic Beanstalk Tomcat.

Auto Increment primary keys and Foreign keys

Other solutions require either GUID’s as primary keys or additional columns for update status, that require modification of your relational structure. MySQLSync works with auto increment primary keys out of the box. Cascade Update and Cascade Delete operations and Foreign keys are also replicated on the mobile devices local SQLite database, so you can have the same business constraints there too.