Re: Syncing data locally from a remote database

Author: mbsoftwaresolutions@mbsoftwaresolutions.com

Posted: 2017-07-12 at 15:58:44

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.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/2940450e612e0825c7dd9d0a98ed02dc@mbsoftwaresolutions.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2017 mbsoftwaresolutions@mbsoftwaresolutions.com