Performing Database System Backups
Finally, we must address the issue of backups. It’s a fact of life that hardware suffers failures, usually when least convenient or welcome. It’s also a fact that running software written with the best of intentions can result in unintended consequences. All the most seasoned database veterans have war stories of times when they froze, stared dumbfounded at the screen, and then sank their heads into their hands, sobbing at the sight of an irretrievably dropped database.
MySQL and PostgreSQL don’t have the “live” backup mechanisms that high-end commercial databases such as Oracle and DB2 do. (Many third-party backup software makers have applications that interact with the database, lock it piece by piece, and ...
Get FreeBSD6 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
