On Wed, Jul 12, 2017 at 3:58 PM, < mbsoftwaresoluti...@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. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CAJidMYLaOuLoLc7W+vbWj5VoK8a_bwobjMPoceE9Q65bbU00=g...@mail.gmail.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.
