The most common source of database syncing problems is leaving auto-sync turned off and then not syncing manually. For syncing to work correctly, you need to perform a sync before you make any changes to your database and again after you finish making changes. The auto-sync option does this for you.
Some people turn the option off because they think it allows them to control which direction the data is pushed (e.g., "I want my changes to always overwrite my bandmates' changes"), but that's not what it does. The read only option does that.
So I'm considering removing the auto-sync setting and permanently activating it for all databases. The only reason I can think of for wanting to turn off auto-sync is if you have a poor network connection and you keep getting timeout errors every time the app tries to auto-sync. In that case, you could turn on Airplane Mode until you're on a better network. Is there any other reason for turning off auto-sync?