Learning

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 logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:

"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.

OurSQL Episode 27: To SQL or No[tto]SQL, that is the question

We talk about HandlerSocket with special guest Patrick Galbraith of Blue Gecko, have some Ear Candy and talk about OSCon and the Strata Conferences

The HandlerSocket announcement blog post from Yoshinori Matsunobu of DeNA: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

HandlerSocket in Percona's build: http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...

PBXT has had it for years: http://pbxt.blogspot.com/2010/12/handlersocket-why-did-out-version-did.html

sample MySQL settings using HandlerSocket from Patrick:
First you have to:

Fantastic VoltDB presentation (video and slides available) by Tim Callaghan at the Boston MySQL User Group

Special thanks to Tim Callaghan for giving a fantastic presentation of VoltDB at Monday's Boston MySQL User Group meeting. Even though the title was "for SQL developers" there was a lot of content for DBAs as well (how backups are done, what the data and server-level architecture is, etc). It was an EXCELLENT presentation on how VoltDB works, and what applications it is and is not appropriate for. The video is almost 2 hours long; there's a LOT of excellent information in it.

The slides can be downloaded (PPT format) from:
http://technocation.org/files/doc/2010_09_VoltDB.ppt

MySQL site down? Can't get MySQL Docs? Technocation has a mirror!

If the MySQL site (including documentation) isn't working for you, try a mirror site.

"But," you ask, "how do I know what the mirror sites are if I can't access the site?"

Great question! Technocation has a mirror site (updated daily) at http://technocation.org/mirror/mysql/.

Also, we have purchased www.mysqlmirrors.com which points to the official list of mirrors at http://technocation.org/mirror/mysql/downloads/mirrors.html.

MySQL User Group Videos

2009 Boston MySQL User Group Videos:

Dec 2009 - Time Zones in MySQL (Sheeri K. Cabral) - video - PDF presentation - Description

Nov 2009 - How InnoDB works: Exploring SHOW ENGINE INNODB STATUS (Sheeri K. Cabral) - video - PDF presentation - Description

Eric Day and Patrick Galbraith speak about Drizzle at the July 2009 Boston MySQL User Group

Eric Day and Patrick Galbraith spoke on Drizzle, Gearman and Narada at the July 2009 Boston MySQL User Group. This is part 1 of the video, which is about an hour long and is about Drizzle.

"We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at."

The slides can be downloaded from http://www.oddments.org/notes/DrizzleGearmanBoston2009.pdf

The User Group calendar item for this event is http://www.meetup.com/mysqlbos/calendar/10607736/

SPIDER Storage Engine: Database Sharding by Storage Engine

Video for the presentation at the 2009 MySQL Conference:
SPIDER Storage Engine: Database Sharding by Storage Engine
Kentoku SHIBA (ST Global.,Inc)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837

Download the slides (ZIP archive).

http://www.youtube.com/v/s

Video: Map/Reduce and Queues for MySQL Using Gearman

Video for the presentation at the 2009 MySQL Conference:
Map/Reduce and Queues for MySQL Using Gearman
Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/7346

Download the PDF slides.

http://www.youtube.com/v/xDRDu

Video: Grand Tour of the Information Schema and its Applications

Video for the presentation at the 2009 MySQL Camp:
Grand Tour of the Information Schema and its Applications
Roland Bouman

Description:
The following topics will be covered:
- Introduction of the information schema and it’s components
- How to generate WIKI documentation from the information schema
- Generating code (triggers, SPs) to maintain a rich history database
- Creating a stored procedure to check violated foreign key constraints
- Creating a stored procedure to create federated tables

http://www.youtube

Video: Beginner Guide to Website Performance with MySQL and memcached

Video for the presentation at the 2009 MySQL Conference:

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009

Pages


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32