On 21-11-2011 07:25:52 +1100, Mark V wrote:
Do you, or don't you use a cluster in the end?
As indicated we don't have udp broadcast/multicast, so my understanding was this rules out remote clustering. However we will still be using multiple machines - just un-clustered. Sorry for being ambiguous.
Ok, cluster to me means: multiple machines (in a network).
If so, you probably can use rsync as well to sync the dbfarm/dbname directories of the ones you load new data into.
Interesting. Is there a reason I cannot use a rsync copy (after locking the DB of course) of the dbfarm/dbname directories onto each (unclustered) machine Would such a os-copy-update be identical to a mclient-copy-update, or does the mclient-copy create some required metadata?
Given identical hardware, you can just copy the dbfarm/dbname directories around. The only thing you need to keep in mind is that the files may not get altered, hence you probably need a lock + stop before you copy to ensure a consistent image being used.