OurSQL: MySQL Database Podcast

OurSQL Episode 24: The Sun is Shining

technocation — Thu, 17 Jan 2008 08:49:29 -0800

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 podcasttechnocation.org">podcasttechnocation.org

OurSQL Episode 23: Back To School

sheeri — Wed, 03 Oct 2007 20:52:59 -0700

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 20: The Pythian Group

sheeri — Thu, 02 Aug 2007 19:04:28 -0700

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 podcasttechnocation.org">podcasttechnocation.org

OurSQL Episode 21: The Rise of the MySQL DBA

sheeri — Wed, 08 Aug 2007 19:04:33 -0700

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 22: Things To Avoid With MySQL Querie

sheeri — Thu, 16 Aug 2007 19:04:36 -0700

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 podcasttechnocation.org">podcasttechnocation.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 18: De-myth-tifying Indexes

sheeri — Thu, 12 Jul 2007 19:04:16 -0700

Feedback:

Email podcasttechnocation.org">podcasttechnocation.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:

OurSQL Episode 19: MySQL Proxy

sheeri — Tue, 24 Jul 2007 19:04:20 -0700

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

Call the comment line at +1 617-674-2369.
E-mail podcasttechnocation.org">podcasttechnocation.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 15: Eben Moglen's Keynote at the 2007 MySQL Conference

sheeri — Sat, 05 May 2007 19:03:46 -0700

"Freedom Businesses Protect Privacy"
Eben Moglen, director of the Software Freedom Law Center, discusses why Free Beer isn't so good if your data are getting drunk! The keynote looks at how "Free as in Freedom" businesses help prevent the ultimate privacy catastrophe.

This speech is not to be missed!

Direct play this episode at:
http://www.technocation.org/content/eben-moglen-keynote-2007-mysql-conference

Download all podcasts at:http://technocation.org/podcasts/oursql/

OurSQL Episode 16: The Art of Innovation, Guy Kawasaki

sheeri — Thu, 10 May 2007 19:04:08 -0700

I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.

Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.

The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!

Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/

Direct play this episode at:
http://tinyurl.com/2h2d7j

Download all podcasts at:
http://technocation.org/podcasts/oursql/

OurSQL Episode 17: Hashing it out

sheeri — Wed, 30 May 2007 19:04:14 -0700

May 30th, 2007
In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.

Show Notes:
Direct play this episode at:
http://tinyurl.com/33wuff

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax

Download the new Connector/NET version:
http://dev.mysql.com/downloads/connector/net/5.1.html

OurSQL Episode 11: Catching Up

sheeri — Mon, 09 Apr 2007 19:03:59 -0700

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

News:
MySQL signs a 1 million Euro deal with an unnamed European Telco.
http://www.pythian.com/blogs/408/mysql-inks-1m-deal-anyone-know-more-det...

MySQL 5.0.37 is out – it’s an odd release, so it’s a community release, and it’s a full release with binaries and source. This release isa big milestone, as it includes the first patches submitted by the MySQL Community.
http://www.planetmysql.org/kaj/?p=90

Proven Scaling’s Free Ride Winners

Prepared statements will be cached by the query cache in a future MySQL 5.1 release:

OurSQL Episode 12: Interview with Kaj Arno About the Google Summer of Code

sheeri — Fri, 13 Apr 2007 19:04:01 -0700

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

Google Summer of Code Home Page:
http://code.google.com/soc

MySQL Summer of Code Ideas:
http://forge.mysql.com/wiki/SummerOfCode

MySQL Summer of Code Accepted Projects:
http://code.google.com/soc/mysql/about.html

Feedback:

email
podcasttechnocation.org">podcasttechnocation.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:
h

OurSQL Episode 13: The Nitty Gritty of Indexes

sheeri — Sat, 21 Apr 2007 19:04:04 -0700

In this episode, we go through how a B-tree works. The next episode will use what we learn in this episode to explain why MySQL indexes work the way they do.

Direct play this episode at:
http://tinyurl.com/36gt7f

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

Quiz to receive a free certification voucher from Proven Scaling:
http://www.provenscaling.com/freecert

MySQL Full Reference Cards:
http://www.visibone.com/sql

About B-Trees:

OurSQL Episode 14: The MySQL Conference & Expo

sheeri — Thu, 26 Apr 2007 19:04:05 -0700

In this episode, we take a walk through the Expo part of the MySQL Conference and Expo. We spoke with 3 companies about their solutions for backup and reporting.

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

Download all podcasts at:
http://technocation.org/podcasts/oursql/

R1 Soft
http://r1soft.com

Actuate
http://www.actuate.com/birt
or
http://www.eclipse.org/birt

FiveRuns
http://www.fiveruns.com

Feedback:

Email podcasttechnocation.org">podcasttechnocation.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

OurSQL Episode 10: How About Some Cache?

sheeri — Fri, 09 Mar 2007 18:03:57 -0800

Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=2068063...

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Show notes:

Listener Feedback:
http://dev.mysql.com/doc/refman/4.1/en/mysql-commands.html

News:
Daylight Savings Time and how to check your system:
http://sheeri.net/archives/188

There’s not much more time left to register for the MySQL Users Conference & Expo before the $200 early bird discount disappears!
http://www.mysqlconf.com

Learning Resource:

Check out the 2006 MySQL conference presentation slides by the speakers! http://mysqlconf.com/pub/w/45/presentations.html

OurSQL Episode 9: Jay Speaks About the MySQL Conference

sheeri — Tue, 27 Feb 2007 23:00:00 -0800

This week I spoke with Jay Pipes about the upcoming MySQL Conference, April 23-26 in Santa Clara, California, USA.

Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=2068063...

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

I had a setting wrong in my recording program and ended up having a very different sound quality than what I had wanted. I played with it as much as I could, but I apologize for the bad quality audio, especially the breathing that you can hear, the mouse clicks, and when you can hear me swallow and such. (It’s probably not as bad as it sounds, but I shudder at it all, because I want to provide y’all with the best quality possible).

OurSQL Episode 8: Basic MySQL Security

sheeri — Sun, 11 Feb 2007 18:32:18 -0800

Listener feedback:
MySQL will go public. Would you buy stock if you had the money? Why or why not?
Call the comment line at +1 617-674-2369 (US phone number)
Use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Leave a message at the Technocation forums:
http://tinyurl.com/sc6qw
Send an e-mail to podcasttechnocation.org">podcasttechnocation.org
Episode 8 Show Notes:
This episode’s feature is basic MySQL Security. Not only will we discuss what the basic security is, but we’ll discuss the *why*s, not just the how’s.

OurSQL Episode 4: Cluster From Down Under

sheeri — Wed, 03 Jan 2007 18:04:44 -0800

This week’s podcast is an interview with MySQL’s Stewart Smith, software engineer for MySQL Cluster. Straight from the warm southern hemisphere, Stewart talks about Cluster. Because we gabbed on and on for 19 minutes, we’ve stripped the format down a bit, having the feature as pretty much the only segment.

You can download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Direct play this edition at:

http://tinyurl.com/yd2ccc

Feature

Main cluster website:
http://www.mysql.com/cluster

Cluster documentation (in the manual):
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster.html

OurSQL Episode 5: Falcon, Part 1

sheeri — Sun, 14 Jan 2007 18:04:48 -0800

Finally, episode 5 is here. In this episode, the first part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when you query a Falcon table, going over and explaining MVCC and the record cache. Next episode will go over the serial logs and indexes.
Direct play episode 5 at:
http://tinyurl.com/y68ewn
Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=206806301

OurSQL Episode 6: Falcon, Part 2

sheeri — Mon, 15 Jan 2007 18:04:51 -0800

In this episode, the second part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when commit, going over and explaining the serial log and indexes.
Direct play episode 6 at:
http://tinyurl.com/yympcn
Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=206806301
You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

OurSQL Episode 7: What's it Like To Be Normal?

sheeri — Tue, 30 Jan 2007 18:04:54 -0800

In this episode, I go over database normalization in general and explain 1st Normal Form (1NF) in depth.
Direct play episode 7 at:
http://tinyurl.com/2fbhy2
Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=206806301
You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/
Links:
MySQL binaries centralized repository: http://tinyurl.com/3anjfa

OurSQL Podcast Episode 1: Backups, Backups Everywhere

sheeri — Tue, 05 Dec 2006 18:03:53 -0800

Well, it’s later than I’d wanted, but it’s here! Be sure to download it right away, as the news is time-sensitive (the rest of the segments are relatively timeless).

The feature of this podcast is “Backups, Backups Everywhere”. The show notes can be seen at:

Check out the show notes at:
http://technocation.org/index.php?option=com_content&task=view&id=18&Ite...

The podcast can be played directly at:
http://technocation.org/index.php?option=com_content&task=view&id=19&Ite...

Subscribe to the podcast at:
pcast://technocation.org/index2.php?option=com_podcast&feed=RSS2.0&no_html=1

OurSQL Episode 3: Your Database on ACID

sheeri — Tue, 19 Dec 2006 18:04:39 -0800

This week’s feature talks about ACID compliance, what it is, and how MySQL achieves it.

If folks have ideas or suggestions for content, please let me know by e-mailing podcastsheeri.com">podcastsheeri.com or by leaving a comment.

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Direct play this edition at:
http://tinyurl.com/yy7pgz

News
Download MySQL Turbo Manager Free Edition at: http://www.mentattech.com/themes/mentat/download.html

Wireless providers prefer MySQL over Oracle, Microsoft SQL Server over both:

http://www.crn.com/sections/breakingnews/breakingnews.jhtml?articleId=19...

OurSQL Episode 2: Wild Performance Tips

sheeri — Thu, 14 Dec 2006 18:04:23 -0800

Episode 2 of OurSQL: The MySQL Database Podcast is here! It’s a bit late due to a computer crash and the fact that I sprained my ankle, but I think it’s worth waiting for. Particularly since this week’s feature is everyone’s favorite — performance tips!

It’s best to subscribe to the podcast by clicking the “podcast” graphic at http://www.technocation.org , or searching for “mysql” in your favorite podcast directory (including iTunes). But if you want to play episode 2 in your browser, visit http://technocation.org/index.php?option=com_content&task=view&id=22&Ite...

OurSQL Episode 0: MySQL Community Podcast

sheeri — Mon, 27 Nov 2006 18:03:50 -0800

Let me know what you think — leave a comment, suggestion, question or other feedback. We’re also looking for guest speakers, so if you’re willing to produce a piece, let me know…or just produce one and send it!

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

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

Or leave a message at the Technocation forums:

http://tinyurl.com/sc6qw

Or send an e-mail to podcasttechnocation.org">podcasttechnocation.org