Podcasts

OurSQL Episode 28: Conferential Integrity

This week, we talk about the many conferences in the MySQL world - O'Reilly's MySQL Conference, Collaborate and Kaleidoscope

Some feedback from previous podcasts:
Percona *is* releasing a 5.5 version - http://www.mysqlperformanceblog.com/2010/12/20/mysql-5-5-8-and-percona-s...
Also, the performance schema is persistent (stored on disk) according to Giuseppe Maxia, the Datacharmer.
* Update 1/6/2011 14:17 Eastern time - according to Mark Leith, only the setup_ tables are persistent, so only some of the data makes it to disk and is persistent.

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:

OurSQL Episode 26: Zombies!

This week, we revive the podcast and talk about MySQL 5.5 features.

Question:
We wondered: Is enterprise backup still using myisamhotcopy for myisam tables?

From MySQL Product Manager Mike Frank, who is in charge of MySQL Enterprise Backup:
"As of today, there is a new mysqlbackup.exe that replaces the perl script innobackup and the myisamhotcopy from InnoDB Hot Backup. This is needed so we can do proper streaming and other media manager integration. Perl doesn't lend itself to that and is a problem on Windows in general as well. We kept the arguments compatible so it is easy to move over and the innobackup perl script is still included -- only for the sake of making transition more seamless."

OurSQL Episode 24: The Sun is Shining

Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.

Tell us what you think of Sun buying MySQL by calling the comment line or sending your voice through Odeo!

Links:
Register for the MySQL Users Conference Today!
www.mysqlconf.com

A special thank you to our sponsor, The Pythian Group, www.pythian.com.

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

OurSQL Episode 23: Back To School

Current MySQL Webinars:
http://mysql.com/news-and-events/web-seminars/

Archived MySQL Webinars:
http://mysql.com/news-and-events/on-demand-webinars/

MySQL University:
http://forge.mysql.com/wiki/MySQL_University
Classes for October 2007:
Architecture of NBD
Following a Query Back and Forth in the Server
How to Create a Test Case

Previous University Classes:
http://forge.mysql.com/wiki/MySQL_University#Previous_Sessions

Skoll -- Community-Based Testing Framework
Demo video:
http://technocation.org/node/111

Download the testing client for MySQL:
http://www.cs.umd.edu/projects/skoll/contribute/

OurSQL Episode 22: Things To Avoid With MySQL Querie

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

or use the Technocation forums:
http://www.technocation.org/forum

OurSQL Episode 21: The Rise of the MySQL DBA

Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.

News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393

Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123

Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org

Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NY
http://www.mysqlcamp.org

http://www.poly.edu

Feature:
The Pythian Group’s Paul Vallee

OurSQL Episode 20: The Pythian Group

In this less technical episode we interview Paul Vallee, where he explains in depth about the Pythian Group.

Special thanks to folks who have linked to the podcast:
WebDevRadio
http://www.webdevradio.com

Episode 34, July 9th, in which Michael mentions OurSQL and hopes I haven’t “gone dark”. Nope! http://www.webdevradio.com/index.php?id=50

Kristina Hadges, a web designer, linked to the podcast
http://www.nineofnine.com/resources

Feature:

The Pythian Group
http://www.pythian.com

Feedback:
Direct play this episode at:
http://tinyurl.com/3bt3xo

Feedback:

Email podcast@technocation.org

OurSQL Episode 19: MySQL Proxy

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcast@technocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group’s Carnival of the Vanities for the DBA community, published weekly on Fridays.
http://www.pythian.com/blogs/category/log-buffer/

Feature:
MySQL Proxy
Giuseppe Maxia’s Blog:
http://datacharmer.blogspot.com

Getting Started with MySQL Proxy article plus tutorials:

OurSQL Episode 18: De-myth-tifying Indexes

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

Or use the Technocation forums:
http://tinyurl.com/sc6qw

Episode 18: De-Myth-tifying Indexes

Where I have been:
Wedding video (short) and photos:
http://www.sheeri.com/wedding

Honeymoon (and wedding) photos:
http://www.sheeri.com/photos

News:
FREE training for Oracle DBAs who want to learn MySQL
http://www.planetmysql.org/robin/?p=51
http://www.mysql.com/oracle/

mysqlnd (PHP native driver) needs testers and benchmarkers:

Pages