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.

Thanks for the link, Steve! As for why not doing it local? These folks

will be accessing the app and their data from various locations, so

hosting it on a database they can all share is key. I'm guessing I

could setup the database locally on each, and setup the replication on

each to communicate to the common web database? This system uses GUIDs

as the PKs for nearly all tables.

_______________________________________________

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/f45acb1266862246549727bf70f4a4f2@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.