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: [email protected]
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/[email protected]
** 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.
