Data sync examples between databases

I would be interested in a topic that demonstrate how to sync database between databases, particularly between sqlite and mysql.

While I do realise there are some tools that facilitate that, I would like to see something that can explain that in good detail especially when it comes to ensuring that data is pulled through correctly.

Any ideas would be great.