MySQL University: Backing up MySQL using file system snapshots
By Stefanhinz-Oracle on Feb 23, 2009
This Thursday (February 26th, 14:00 UTC), Lenz Grimmer will give a MySQL University session on Backing up MySQL using file system snapshots. Lenz is a member of the MySQL Community team and the maintainer of the mylvmbackup tool. mylvmbackup is a tool for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.
For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL University sessions are recorded, that is, slides and voice can be viewed as a Flash movie (.flv). You can find those recordings on the respective MySQL University session pages which are listed on the MySQL University home page.
MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.
Here's the schedule for the upcoming weeks:
|February 26, 2009||14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)||Backing up MySQL using file system snapshots||Lenz Grimmer|
|March 5, 2009||14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)||Good Coding Style||Konstantin Osipov|
|March 12, 2009||14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)||MySQL and ZFS||MC Brown|
|March 19, 2009
||14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)||How to Use Charsets and Collations Properly||Susanne Ebrecht