Yeah I will go in to the wikia site later and try to point direct links to the new wiki pages...
I'll look at that URL - I actually have a two-phase backup. A daily cronjob running out of /etc/cron.daily that does svndump, mysqldump, tarball of /etc and a few other configurations around the server and dumps it into /backup/$date. It removes the /backup/$date from 28 days ago (configurable) so it does not fill up - I figure a ~ month is good enough. Then I have a process that runs on the backup server (offsite) that does an rsync of the /backups/ dir and /home/ - it does a ZFS snapshot of the home backup. So ZFS snapshots are for /home (nothing setup to remove them yet, so they will be there forever until I decide to delete some snapshots, or auto-delete older ones) and the daily config/db backups are not snapshotted as they're already daily in their 20081117 directory for example. This gives me daily snapshots of both the /home data and all configs, dbs, svn repo, etc. I can if I need to diff two sql dumps, or even diff the /home filesystem since ZFS has records of it all... so I think I have taken care of what Brian was looking for, at least when I took a quick glance at his blog post. On Sun, Nov 16, 2008 at 8:41 PM, Sheeri K. Cabral <[EMAIL PROTECTED]> wrote: > that's awesome -- configs are great too! > > Brian has a neat way of doing remote backups at > http://krow.livejournal.com/593424.html > Can you add a nightly mysqldump of the drizzle wiki documentation to > launchpad bzr for (offline) revision history? > > I have created a header for some of the drizzle.wikia.com pages to redirect > to the new site, folks can continue to do the rest.... > > Thanks for all your hard work! > > -Sheeri > > > On 11/16/08, mike <[EMAIL PROTECTED]> wrote: >> >> ML said to make the drizzle.org/wiki/ the "real" one now. >> >> So wikia can be edited to point to the new one (anyone feel free to at >> their leisure) >> >> Drizzle.org is in my server backup process - it does a nightly >> differential snapshot to an offsite location and a full backup of the >> db/configs nightly as well. >> >> >> On Sun, Nov 16, 2008 at 7:22 PM, Sheeri K. Cabral <[EMAIL PROTECTED]> >> wrote: >> > Which wiki is the wiki? >> > >> > drizzle.org links to drizzle.org/wiki >> > >> > there's also >> > >> > http://drizzle.wikia.com/wiki/Drizzle_Wiki >> > >> > How are backups being done, and can we copy them remotely to a server >> > every >> > so often for sanity's sake? >> > >> > One of those wikis should be redirected (probably the wikia.com one). >> > >> > -Sheeri >> > >> > On 11/14/08, mike <[EMAIL PROTECTED]> wrote: >> >> >> >> time to update the wiki! :) >> >> >> >> >> >> >> >> On Fri, Nov 14, 2008 at 4:31 PM, Brian Aker <[EMAIL PROTECTED]> wrote: >> >> > Kill us supported. Wiki is wrong. >> >> > >> >> > Cheers, >> >> > --Brian >> >> > >> >> > On Nov 14, 2008, at 11:02 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> >> >> > wrote: >> >> > >> >> >> So now that the wiki is up, I see that the kill command was removed. >> >> >> >> >> >> Why? >> >> >> >> >> >> Is there a new way to nuke a bad long-running query? >> >> >> >> >> >> Jeremy >> >> >> _______________________________________________ >> >> >> Mailing list: https://launchpad.net/~drizzle-discuss >> >> >> Post to : [email protected] >> >> >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> >> >> More help : https://help.launchpad.net/ListHelp >> >> > >> >> > _______________________________________________ >> >> > Mailing list: https://launchpad.net/~drizzle-discuss >> >> > Post to : [email protected] >> >> > Unsubscribe : https://launchpad.net/~drizzle-discuss >> >> > More help : https://help.launchpad.net/ListHelp >> >> > >> >> >> >> _______________________________________________ >> >> Mailing list: https://launchpad.net/~drizzle-discuss >> >> Post to : [email protected] >> >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> >> More help : https://help.launchpad.net/ListHelp >> > >> > >> > >> > -- >> > - Sheeri K. Cabral >> > >> > Note: Currently I work for The Pythian Group (http://www.pythian.com/ >> > ), a >> > remote DBA firm, and consulting would constitute a conflict of >> > interest. However, I do recommend our work, and if you're looking for >> > DBA >> > work (I do MySQL work, but they have great Oracle and SQL Server DBAs >> > too) >> > right now, whether you need a few hours a week, or someone fulltime >> > while >> > you continue a job search. >> > >> > I have a webpage with tips on how to find a >> > DBA: http://sheeri.net/how-to-find-a-dba/ >> > I can recommend http://www.toomanyconnections.com as a good site to find >> > MySQL (and Oracle) DBAs. >> > If you're looking for web design, I recommend the small business my >> > husband >> > works for, http://www.digital-loom.com >> > I regret that I have no other information for any other type of >> > position, >> > including developer, programmer and systems administrator. > > > > -- > - Sheeri K. Cabral > > Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a > remote DBA firm, and consulting would constitute a conflict of > interest. However, I do recommend our work, and if you're looking for DBA > work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) > right now, whether you need a few hours a week, or someone fulltime while > you continue a job search. > > I have a webpage with tips on how to find a > DBA: http://sheeri.net/how-to-find-a-dba/ > I can recommend http://www.toomanyconnections.com as a good site to find > MySQL (and Oracle) DBAs. > If you're looking for web design, I recommend the small business my husband > works for, http://www.digital-loom.com > I regret that I have no other information for any other type of position, > including developer, programmer and systems administrator. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
