On Wed, Jul 12, 2017 at 3:58 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-07-12 14:30, Stephen Russell wrote:
Why put up the data off site then now that you know it is a kluge?
Ever considered this if you have to have two? http://www.techrepublic.com/article/how-to-set-up-database- replication-with-mariadb/
I would only have one single database server for the client myself and if they have such poor Internet then I'd do it local. All that extra spaghetti to keep it local and sync it sounds like a wart that will only grow over time.
From the article:
"The easiest means of database backup: You'd be hard pressed to find an easier method of getting a real-time database backup than replication. And with MariaDB, setting up replication is incredibly simple. Give this a try, and you can rest easier knowing you always have a backup database to use."
This works IF it means the Father and Son can each work on their local database (in their own homes/offices) and then have those changes echoed to the WEB database. (Now you see the challenge???) This is NOT for a simple 1-user-in-1-location scenario.
I have no MariaDB experience but doing this in SQL Server is not easy as this reads. They are more taking to the idea of local country DBs that interconnect but you are suggesting the same thing I beleive between a few locals and 1 Master.