Which database should I choose? MySQL or mongoDB?

Vote count:

0

I'm working on a project which is somewhat familiar to WhatApp, except that I'm not implementing the chatting function.

The only thing I need to store in the database is user's information, which won't be very large, and I also need an offline database in the mobile app which should be synced with the server database.

Currently I use MySQL for my server database, and I'm thinking of using JSON for the syncing between mobile app and the server, then I found that mongoDB has a natural support for JSON, which caused me wonder should I change to mongoDB.

So here are my questions:

1. 
   

   Should I change to mongoDB or should I still use MySQL? The data for each user won't be too large and it does have some requirement for data consistency. But mongoDB's JSON support is somewhat attractive.

   
   


2. 
   

   I'm not familiar with the syncing procedure, I did some digging and it appears that JSON is a good choice, but what data should I put into the JSON files?

   
   

asked 42 secs ago

fish748

1