CODEWITHSUNDEEP
mysqlsqlitesynchronization
fifty arashi
fifty arashi

Reputation: 541

How do I synchronize SQLite to MySQL?

Over a network how can I synchronize my MySQL and SQLite database so that changes in MySQL will be reflected in SQLite?

Upvotes: 5

Views: 10073

Answers (1)

joecascio
joecascio

Reputation: 189

I have a similar problem of 2-way syncing between an Android sqlite DB and a central MySql DB. The problem really comes when inserts are made, because it admits the possibility of replicated primary keys.

I did build a system a while back that used hardware and time-based GUID primary keys instead of simple, monotonically increasing primary keys. The theory is that if new records are inserted either on the handset using sqlite, or in the central server using mysql, the keys will never conflict because they are globally unique.

Unfortunately, this means you have get in the primary key management business instead of just taking the automatic one that comes with both DB engines. But in theory this approach allows data from many different handsets to be melded easily in the central database and redistributed back out to all the handsets. I am considering this approach for my Android problem although I'm still hoping to find a solution already crafted out there.

Upvotes: 2

Related Questions