This week we talk about what's new in MySQL 5.6 and the return of labs.mysql.com. We also feature people's reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).
Show notes:
If you want to see it for youreslf, there is a video
from the O'Reilly Conference of Tomas Ulin's Keynote, "State
of the Dolphin".
Olav Sandstå's blog post on index condition pushdown optimization.
…
[Read more]This week we conclude the interview with Tokutek's co-founder and Chief Scientist, Martin Farach-Colton. Part 1 of the interview. TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.
TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.
We spoke with Martin Farach-Colton, co-founder and Chief Scientist of Tokutek about the TokuDB storage engine, including the new features in TokuDB 5.0, which was announced on Tuesday.
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.
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.h...
sample MySQL settings using HandlerSocket from Patrick:
First you …
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
I found I never published this post as it was sitting in my drafts few months now — it was written in 13th February, 2010. I’m publishing it without any changes.
I learn therefore I am!
I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Chen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.
There are two aspects…
Today I’ve read the following email on the mailing list of Sydney Oracle Meetup. I thought that this question is asked many times in attempt to find a silver bullet to learning Oracle so I wanted to publish my reply here on the blog, especially, that I’m a firm believer in one silver bullet that exists — there are no silver bullets.
Hi everybody,
My name is Sebastian and I’m new in the group. Yesterday I arrived late because I had a problem at work at the very last minute. However I found the meeting super interesting.
I’d like to see if someone could give me some piece of advise… I have ZERO experience with Oracle. I’m a Software Engineer and I’ve been working for more than 7 years in development (open source technologies basically). When it comes to DBs, I …
[Read more]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.
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