Jeff Smelser wrote:
On Wednesday 02 November 2005 05:47 pm, kashani wrote:So yes, if your db is 20 GB or less, what I mentioned will probably work without too much trouble. If your db is 100 GB or larger, you're likely spending enough on hardware and software to solve your issues that some vendor will offer to buy you flaming Tiki drinks so it's not all bad.I hope you didnt take you all night to think of this, its really not that good.
I'm not sure how to take that and am a bit confused since you're the one responding six hours later. :) Or one of us is having mail issues. :(
Attempts to flame each other aside though I will continue the thread hijack in progress, what are your options for incremental backups with any RDBM? My understanding is that you're pretty much dependent on some sort of snapshotting from either your expensive hardware (EMC), or expensive filesystem (Veritas) if you don't have a third party package or your db isn't fancy enough. Oracle seems to have made good progress with their RMAN stuff, but I couldn't say how robust that is or how it compares to the former. I'm sadly out of date with Oracle as I haven't been involved in any reasonably sized systems newer than 8i. I guess the question is what sort of functionality would you want out of Mysql? And as a followup, everyone and their mother with reasonably sized Mysql databases appears to use replication to do their backups, psuedo-incremental or otherwise. Is it just the extra hardware and disk that you don't like or something else?
kashani -- [email protected] mailing list
