Category Archives: Events

OurSQL Episode 4: Cluster From Down Under

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://technocation.org/content/oursql-episode-4%3A-cluster-down-under-0

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

Cluster changes in MySQL 5.1:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-5-1-changes.html

Cluster mailing list (for support, preferred):
http://lists.mysql.com/cluster

The cluster forum (with RSS feed):
http://forums.mysql.com/list.php?25

Acknowledgements

http://www.technocation.org

http://music.podshow.com

http://www.russellwolff.com

http://www.smallfishadventures.com/Home.html “The Thank you song” — Smallfish

Feedback

If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

podcast@technocation.org

You can also:

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 use the Technocation forums:
http://technocation.org/forum

OurSQL Episode 3: Your Database on ACID

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 podcast@sheeri.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://technocation.org/content/oursql-episode-3%3A-your-database-acid

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=196700062

Learning Resource

Artful Software’s list of common queries. They also have an interesting e-book available, called “Get it Done with MySQL 5.0”.

http://www.artfulsoftware.com/queries.php

DATEDIFF(), DAYOFWEEK() functions

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Promo

This week’s promotion comes from Geek Fu at http://www.geekfuactiongrip.com

Feature

Concurrency and Isolation Levels
http://sheeri.net/index.php?p=123

Acknowledgements

http://www.technocation.org

http://music.podshow.com

http://www.russellwolff.com

http://www.smallfishadventures.com/Home.html “The Thank you song” — Smallfish

Feedback

If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

podcast@technocation.org This email address is being protected from spam bots, you need Javascript enabled to view it

You can also:

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 use the Technocation forums:
http://technocation.org/forum



OurSQL Episode 2: Wild Performance Tips

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/content/oursql-episode-2%3A-wild-performance-tips

Please consider promoting the show — we have a 40 second promo ready for download at:

http://www.technocation.org/podcasts/oursql/OurSQLpromo1.mp3
Show Notes:
News

http://www.mysqlconf.com/

Free Survey, win a free pass

http://www.zoomerang.com/recipient/survey-intro.zgi?p=WEB225WZRG2XU7

You can now find this podcast, OurSQL, on many podcast sites including:

http://www.itunes.com

http://www.podcastalley.com

http://www.podfeed.net

http://www.podcastblaster.com

http://www.pod-planet.com

just search for “mysql” on any of those sites and you’ll find the podcast. You can also find it at:

http://feeds.feedburner.com/oursql

Learning Resource

Promo

http://www.tech-in-sight.com/

Feature

Peter Zaitsev’s blog post about count for InnoDB tables:
http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/

Acknowledgements/Sponsors

http://www.technocation.org

http://music.podshow.com

http://www.russellwolff.com

http://www.smallfishadventures.com/Home.html “The Thank you song” — Smallfish

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

If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

podcast@technocation.org

You can also:

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 use the Technocation forums:
http://technocation.org/forum

OurSQL Podcast Episode 1: Backups, Backups Everywhere

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/content/oursql-podcast-episode-1%3A-backups%2C-backups-everywhere

The podcast can be played directly at:
http://technocation.org/content/oursql-podcast-episode-1%3A-backups%2C-backups-everywhere

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

OurSQL: The MySQL Database Podcast for the Community, By the Community. See more info at www.technocation.org

MySQL Community Podcast

The inaugural MySQL Community podcast is up at:

http://technocation.org/content/oursql-episode-0%3A-mysql-community-podcast

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://technocation.org/forum

Or send an e-mail to podcast@sheeri.com