Category Archives: backup

OurSQL Episode 160: More Free Hot Backup

This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.
Events
DB Hangops – every other Wednesay at noon Pacific time
Upcoming MySQL events
Percona L… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 160: More Free Hot Backup

OurSQL Episode 159: Free Hot Backup

This week, we talk about Percona’s Xtrabackup. Ear Candy talks about .frm files and how many fields an InnoDB table can have, and At the Movies is a talk about indexes.
Xtrabackup
Episode 38 where we previously talked about Xtrabackup
Installing Percon… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 159: Free Hot Backup

OurSQL Episode 41: Zmanda [backup series #6]

Previously in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Expo… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 41: Zmanda [backup series #6]

OurSQL Episode 38: Xtrabackup (Backup Series #5)

Previous podcasts in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logic… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 38: Xtrabackup (Backup Series #5)

OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)

This week, we discuss advanced mysqldump options, ear candy comparing NOW() vs. SYSDATE(), and the Manga Guide to Databases.
Previous podcasts in the series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcop… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)

OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)

Previous podcasts in the backup series:
Backup Series #1: Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Show Notes:
This week we have Lenz Grimmer with us to speak about snapshot backups in general, MySQL backu… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)

OurSQL Episode 32: Backup tools you already have [Backup series #2]

This week we continue our series on backup tools, we talk about the backup tools that ship with MySQL.
Show notes:
Previous backup series podcast:
Backup glossary [Backup series #1]
Feedback:
In the backup glossary we asked if anyone knew how to get lo… Continue reading

Posted in backup, Conferences, Learning, Podcasts, Presentations/Videos | Comments Off on OurSQL Episode 32: Backup tools you already have [Backup series #2]

OurSQL Episode 30: Backup Glossary (Backup Series #1)

This week, we start a series on backups by talking about backup concepts.
[note: about 11 minutes in, Sarah’s audio gets a little noisier, and our audio engineer simply could not get rid of all the noise]
A slave is not a backup, although a slave can b… Continue reading

Posted in backup, Podcasts | Comments Off on OurSQL Episode 30: Backup Glossary (Backup Series #1)