On 9/6/2011 11:06 PM, Anthony Acquanita wrote:
I'm sure that would work but it's a lot of work and time and doesn't help me the next time I ( or someone else ) has to do this.
I've found that just about any solution for this type of problem is going to be a lot of work. :-)
There are lots of "silver bullet" solutions for duplicating data, and all of the ones I've run into have odd little quirks or hidden setup costs that it turns out not be as simple as it seems[or it is as simple for 80% of the cases, and then 20% have odd problems and my luck is to be in that 20%].
I looked into a number of different options in terms of running a system in the cloud and setting up hot backups.
There are specialized database engines/plugins for MySQL which can allow you to take all the input and pipe it to a remote system. Some of them turn out to require both saves to succeed before continuing, giving you a performance hit, while others will queue up the updates which can lead to a gap in data.
In addition to DRDB[which I had not seen until today, so thanks!] - there where a number of advanced file system formats for linux which allow for duplication, live snapshots of databases, and other solutions.
There is also the ability to offload your hard drive entirely to a network storage device, and then have high end network storage devices that either duplicate the data for you...or allow 2 systems to access the data simultaneously.
In the end, my feeling is that the solution to go with is not the one that is "best" based on reading the specs. The solution to go with is the one that plays to your particular strengths and knowledge. IE when things go all to heck, you don't want to spend a lot of time learning all the intricacies of some new technology and discover hidden pitfalls that were not documented. It's better to have a subpar solution which you completely understand.
On the other hand, at times where your time is very very valuable, it can make more sense to use a custom blackbox solution that you pay somebody else to support and let them troubleshoot any problems that occur. :-)
_______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) MHVLS Auditorium Sep 7 - DIY 3D Printing and the Makerbot Thing-o-Matic Oct 5 - Distributed Authentication Systems Nov 2 - Nov 2011
