OurSQL: MySQL Database Community Podcast
By Unknown
To listen to an audio podcast, mouse over the title and click Play. Open iTunes to download and subscribe to podcasts.
Podcast Description
OurSQL Podcast
| Name | Description | Released | Price | ||
|---|---|---|---|---|---|
|
1 |
CleanOurSQL Episode 92: It's Not Our Type, Part 2 | We talk about numeric data types. Ear candy is an audio clip of Jim Starkey talking about blobs at the July 2006 Boston MySQL User Group. At the Movies is | 5/24/12 | Free | View In iTunes |
|
2 |
CleanOurSQL Episode 91: It's Not Our Type, Part 1 | In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard. | 5/18/12 | Free | View In iTunes |
|
3 |
CleanOurSQL Episode 90: Handle With Care | This week we present how to use pt-archiver and pt-find, two Percona Toolkit tools. We focus on the common usage of the tools and the gotchas we ran into using them. | 5/11/12 | Free | View In iTunes |
|
4 |
CleanOurSQL Episode 89: Seal of Approval | This week we talk about MariaDB - explaining features, and comparing to Percona's patched MySQL and Oracle's MySQL. MariaDB is touted as "a better MySQL, not a different MySQL". MariaDB is the 2nd most popular open source database, even more popular than Postgres. | 5/4/12 | Free | View In iTunes |
|
5 |
CleanOurSQL Episode 88: MySQL Founders | We hear MySQL Founders David Axmark and Monty Widenius talk about the MySQL Ecosystem, and their next plans, including "Crazy Monty", an open source restaurant. | 4/27/12 | Free | View In iTunes |
|
6 |
CleanOurSQL Episode 87: A Shift in the Cloud | This week we talk with Mark Atwood of RedHat about OpenShift, a free, auto-scaling Platform as a Service (PaaS) for applications. | 4/20/12 | Free | View In iTunes |
|
7 |
CleanOurSQL Episode 86: Speed Demon | This week we talk with Martin Farach-Colton of Tokutek about what's new with TokuDB. | 4/9/12 | Free | View In iTunes |
|
8 |
CleanOurSQL Episode 85: Keep it Under Control | We talk about configuration management in MySQL. Ear Candy is why binary logs might be greater than max_binlog_size, and At the Movies is Configuration management for Development Environments, using Puppet. | 3/30/12 | Free | View In iTunes |
|
9 |
CleanOurSQL Episode 84: Going to the Big Show | Percona Live: MySQL Conference & Expo preview! | 3/23/12 | Free | View In iTunes |
|
10 |
CleanOurSQL Episode 83: The NewSQL World | We interview Ori Herrnstadt of Akiban Technologies, Ear Candy is cssh, At the Movies is Managing Databases in a DevOps Environment | 3/16/12 | Free | View In iTunes |
|
11 |
CleanOurSQL Episode 82: Cloudy With a Chance of Data | Cloud Computing with Amazon AWS. Ear Candy: mdadm. At the Movies: "The Right Tool for the Right Job: Choosing the Best Data Storage Option" | 3/9/12 | Free | View In iTunes |
|
12 |
CleanOurSQL Episode 81: From the Tool Bench | We talk about benchmarking. Ear Candy is custom locking, At the Movies is "How to Stop Hating MySQL - Fixing Common Mistakes and Myths". | 3/2/12 | Free | View In iTunes |
|
13 |
CleanOurSQL Episode 80: Lesser Known Percona Tools | We talk about several lesser-known but very useful tools from the Percona Toolkit for MySQL, and have some fun audio feedback from friend-of-the-show Patrick Hurley. Ear Candy is about Percona Toolkit commonality, including DSN, and At the Movies is Tim Callaghan of Tokutek talking about Fractal Tree Indexes. | 2/24/12 | Free | View In iTunes |
|
14 |
CleanOurSQL Episode 79: Removing Evil Queries, part 3 | There are a lot of events scheduled for the next few months, we are excited about the international scope and the mix of big and small, paid and free events. This week we finish explaining the output of EXPLAIN. Ear candy is sshfs, at the movies is a presentation on joins and subqueries and how to optimize them. | 2/17/12 | Free | View In iTunes |
|
15 |
CleanOurSQL Episode 78: Removing Evil Queries, part 2 | We talk about EXPLAIN, ear candy is about freeing up swap, at the movies is about preventing MySQL downtime | 2/10/12 | Free | View In iTunes |
|
16 |
CleanOurSQL Episode 77: Removing Evil Queries, part 1 | This week we explain where to find queries in the logs, and how to analyze them with mysqldumpslow and pt-query-digest | 2/4/12 | Free | View In iTunes |
|
17 |
CleanOurSQL Episode 76: Off the Charts, part 3 | This week, former OurSQL podcast co-host Sarah Novotny joins us for our 3rd part of our monitoring series. This week we present monitoring tools that don't need a lot of installation/configuration to get data. | 1/28/12 | Free | View In iTunes |
|
18 |
CleanOurSQL Episode 75: Off the Charts, part 2 | In the news we have a free OTN MySQL developer day and a discount code for the Percona Live conference (code is PL-pod). The main content talks about monitoring, specifically SNMP, RRDtool, Cacti, Nagios, OpenNMS, and Zabbix. Ear candy is an access denied error. At the movies is a presentation about a nagios plugin. | 1/20/12 | Free | View In iTunes |
|
19 |
CleanOurSQL Episode 74: Off the Charts, part 1 | This week we kick off a multi-part series on monitoring. In this episode we discuss the MySQL Enterprise Monitor offering from Oracle and the MONyog offering from Webyog. Ear Candy is innotop, At the Movies is part 2 of measuring scalability and performance with TCP | 1/13/12 | Free | View In iTunes |
|
20 |
CleanOurSQL Episode 73: What happened? | This week we present a year in review for the MySQL Ecosystem, including updates from Oracle's MySQL, SkySQL, Percona and MariaDB. | 1/6/12 | Free | View In iTunes |
|
21 |
CleanOurSQL Episode 72: Blooper Retrospective | This week we play a bunch of bloopers, some you have heard, some you haven't, as our year-end gift to you. We hope these make you laugh! | 12/31/11 | Free | View In iTunes |
|
22 |
CleanOurSQL Episode 71: Table Manners, part 2 | This week, we continue our discussion about MySQL and its forks. We discuss the Percona servr and MariaDB | 12/26/11 | Free | View In iTunes |
|
23 |
CleanOurSQL Episode 70: Table Manners, part 1 | We called this podcast table manners because we are often asked what MySQL fork to use. This is part 1 of a 2-part series. This week we delve into Oracle's MySQL and Drizzle. | 12/16/11 | Free | View In iTunes |
|
24 |
CleanOurSQL Episode 69: Replication Secret Agent | In this episode we talk about the MySQL Master High Availability Agent, aka MHA. | 12/9/11 | Free | View In iTunes |
|
25 |
CleanOurSQL Episode 68: Scaling, or Sailing? | This week Sheeri visits the Schooner offices and inteviews Dr John Busch, the CTO, Founder, and Chairman of the Board for Schooner. Schooner is able to fully use multi-core processors and do fully synchronous replication without losing performance. The new 5.1 release offers parallel synchronous replication with automated failover between remote data centers. | 12/2/11 | Free | View In iTunes |
|
26 |
OurSQL Episode 67: HA and Replication | -- | 11/27/11 | Free | View In iTunes |
|
27 |
CleanOurSQL Episode 66: Breaking the News Reels | In this podcast we talk about how to keep up with the MySQL ecosystem, and introduce a new segment. We invite you to let us know how you keep up, too. And we've updated our theme song! | 11/18/11 | Free | View In iTunes |
|
28 |
CleanOurSQL Episode 65: Security Blanket - The Missing Link | This week we have a big announcement about Sarah, 3 hosts and an extra special guest. We go on to talk about using SSL with MySQL. Ear Candy - a gotcha when mixing GRANT and SSL requirements, where what is semantically possible does not necessarily follow logic. | 11/11/11 | Free | View In iTunes |
|
29 |
CleanOurSQL Episode 64: Are We Normal Yet? | Explanations of 2NF and 3NF, and a discussion about denormalization. Ear candy: use_global_long_query_time. | 11/7/11 | Free | View In iTunes |
|
30 |
CleanOurSQL Episode 63: Snowing Already? | This week, Gerry Narvaja guest hosts and we talk about star and snowflake schemas, as a follow-up to last week's podcast on Data Warehousing 101. | 10/29/11 | Free | View In iTunes |
|
31 |
CleanOurSQL Episode 62: Data Warehousing 101 | Josh Berkus of PostgreSQL Experts spoke at Open Source Brige this summer on Data Warehousing 101: Everything you never wanted to know about big databases but were forced to find out anyway. Ear Candy: test and test_% database access and how to get rid of it. | 10/21/11 | Free | View In iTunes |
|
32 |
CleanOurSQL Episode 61: Security Blankets, Part 2 | We go over the open calls for papers, upcoming conferences, conversations with Oracle, and finish up our 2-part series on MySQL security. | 10/14/11 | Free | View In iTunes |
|
33 |
CleanOurSQL Episode 60: Charming Data | This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news. | 10/12/11 | Free | View In iTunes |
|
34 |
CleanOurSQL Episode 59: Security Blankets, Part 1 | Collaborate call for papers, Percona Live call for papers, CouchConf is coming up. Main content: MySQL Security. Ear Candy - change in STOP SLAVE in MySQL 5.1.56, 5.5.10, 5.6.2. | 10/4/11 | Free | View In iTunes |
|
35 |
CleanOurSQL Episode 58: Opening up Oracle's World | In news and feedback, the call for papers is open for Percona Live: MySQL Conference & Expo 2012, we talk about CouchConf NYC, and of course the big news - Oracle's commercial extensions to MySQL Enterprise. In the main section we talk about the MySQL sessions at Oracle OpenWorld. This week's ear candy is MySQL 5.5 improvements to background I/O threads. | 9/23/11 | Free | View In iTunes |
|
36 |
CleanOurSQL Episode 57: Eventual Discovery part 2 | Feedback: Gazzang uses ecryptfs underlying, and the 2nd in the Event series: - What events log and where the event logs are - How errors show up in the error log - How events and their actions get logged to the binary logs (aka events and replication) - Event timing - Privileges needed for events - Runtime behavior for events - Event limitations This week's ear candy notes how the description of the buffer for the InnoDB log files on disk has changed in MySQL 5.5. | 9/19/11 | Free | View In iTunes |
|
37 |
CleanOurSQL Episode 56: Eventual Discovery part 1 | We talk about MySQL events, stored code that acts like "temporal triggers". And we talk about various MySQL conference calls for papers. Ear Candy: MySQL 5.5's new and improved way to log failed connection attempts. | 9/9/11 | Free | View In iTunes |
|
38 |
CleanOurSQL Episode 55: MySQL Data Encryption | This week we speak with Mike Frank of Gazzang about data encryption, answer a question about stored procedures and triggers in scalebase, and link to over 100 videos from OSCon, OSCon Data and OSCon Java. | 9/2/11 | Free | View In iTunes |
|
39 |
CleanOurSQL Episode 54: Scaling MySQL | We talk about the April 2012 Percona MySQL Conference and interview Doron Levari of ScaleBase about how to transparently shard your MySQL databases. | 8/19/11 | Free | View In iTunes |
|
40 |
CleanOurSQL Episode 53: MySQL 5.6 at OSCon Data | We grabbed Calvin Sun, the Development Manager of the InnoDB Team, at OSCon Data, where Oracle announced the new features of MySQL 5.6 in the MySQL labs. We talk about the new features in the MySQL 5.6 labs, some on the InnoDB fulltext search and other features that improve MySQL 5.6 performance. | 8/9/11 | Free | View In iTunes |
|
41 |
CleanOurSQL Episode 52: Database Theory ABC | At this year's Open Source Bridge in Portland last month, Eric Redmond presented 'A Dozen Databases in 45 minutes'. It’s really about 20 minutes of theory and 25 minutes of the dozen databases, so for this first of a 2-part series, we present the theoretical side of things, including ACID, BASE and the CAP theorem. | 7/24/11 | Free | View In iTunes |
|
42 |
CleanOurSQL Episode 51: Data Infrastructure at OSCon Data | This week we talk about OSCon Data, the data conference co-located with OSCon in Portland, Oregon from Monday July 25th through Friday July 29th. | 7/8/11 | Free | View In iTunes |
|
43 |
CleanOurSQL Episode 50: MySQL at Facebook, Current and Future | This week we post the audio from the closing keynote of Percona Live by Harrison Fisk of Facebook, "MySQL at Facebook, Current and Future". | 6/28/11 | Free | View In iTunes |
|
44 |
CleanOurSQL Episode 49: Stalking MySQL | This week we talk about a monitoring plugin from PalominoDB that uses caching (like the cacti templates) and allow for arbitrary calculations of thresholds based on status and system variables. Ear candy is how to use SSL in replication. | 6/12/11 | Free | View In iTunes |
|
45 |
CleanOurSQL Episode 48: Percona Live NYC 2011 | Sheeri Cabral interviews Chander Kant, Barry Leung, Patrick Galbraith and Stewart Smith at Percona Live in NYC, and Baron Schwartz also makes an appearance. Topics include backups, a new maatkit tool, Drizzle and more. | 6/3/11 | Free | View In iTunes |
|
46 |
CleanOurSQL Episode 47: Replication logs and objects | This week we discuss replication logs and how MySQL objects replicate (in some expected and unexpected ways). | 5/30/11 | Free | View In iTunes |
|
47 |
CleanOurSQL Episode 46: It's About Time | This week we talk about time formats and time zones in MySQL - including how changing the system time changes TIMESTAMP values but not DATETIME values. We also give discount codes for Percona Live on May 26th, the Velocity conference in June, and OSCon in July. | 5/21/11 | Free | View In iTunes |
|
48 |
CleanOurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication) | At Open Database Camp in Sardinia last week, there was a hackfest to try to get replication working from MySQL to MongoDB. In only 2 hours and 45 minutes, a small group of hackers did it! This week I interview Flavio Percoco, the MongoDB guru on the team, who talked about getting replication from MySQL to MongoDB working via Tungsten Replicator (which we talked about on last week's podcast). | 5/13/11 | Free | View In iTunes |
|
49 |
CleanOurSQL Episode 44: Elemental Replication (Tungsten, that is) | This week we have Robert Hodges, CEO of Continuent, talking about the Tungsten replicator, which has an open source component with global transaction id's and can be used for many features, including high availability and replication to systems other than MySQL. The three biggest issues that Continuent is working on right now are: - heterogeneous replication - parallel replication - multi-master replication (using star replication instead of a ring) | 5/6/11 | Free | View In iTunes |
|
50 |
CleanOurSQL Episode 43: Repli-cans and repli-can'ts | Note: We said this was episode 44, but it's really episode 43! In this episode we give the basics of how replication works, giving knowledge about the fundamentals about replication to better understand why it has certain limitations and benefits. | 5/2/11 | Free | View In iTunes |
|
51 |
CleanOurSQL Episode 42: The Buzz about MySQL 5.6 | 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. | 4/22/11 | Free | View In iTunes |
|
52 |
CleanOurSQL Episode 41: Zmanda [backup series #6] | This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and restores!) are made simpler with the community (free) version and with the enterprise (commercial) version. | 4/7/11 | Free | View In iTunes |
|
53 |
CleanOurSQL Episode 40: TokuDB 5.0 part 2 | Part 2 of our interview 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. 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. | 4/1/11 | Free | View In iTunes |
|
54 |
CleanOurSQL Episode 39: TokuDB 5.0 part 1 | 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. 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. | 3/25/11 | Free | View In iTunes |
|
55 |
CleanOurSQL Episode 38: Xtrabackup (Backup Series #5) | In the 5th installment of the backup series we talk to Percona's Valentine Gostev about Xtrabackup, the open source tool for online, consistent, physical backups of InnoDB tables. | 3/18/11 | Free | View In iTunes |
|
56 |
CleanOurSQL Episode 37: It's Still Not Our (De)fault! Part 2 | This week, Giuseppe Maxia gives us feedback and we complete our 2-part series on what we always put in our configuration files, and why. | 3/11/11 | Free | View In iTunes |
|
57 |
CleanOurSQL Episode 36: It's Not Our (De)fault! Part 1 | In this first of a 2-part series, we talk about the configuration file itself, including location and precedence of files and the layout of the file. Then we talk about variables related to directories, overall server settings, MyISAM variables and InnoDB variables. | 3/4/11 | Free | View In iTunes |
|
58 |
CleanOurSQL Episode 35: Advanced Logical Export Features (Backup Series #4) | This 4th podcast in the backup series goes through advanced mysqldump options. Ear candy compares NOW() vs. SYSDATE(). Also discussed: how to syntax check my.cnf (see show notes for link) and the Manga Guide to Databases, how to get swag from us. | 2/25/11 | Free | View In iTunes |
|
59 |
CleanOurSQL Episode 34: Collaborating | We talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference. | 2/17/11 | Free | View In iTunes |
|
60 |
CleanOurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup) | Special guest Lenz Grimmer talks about mylvmbackup in this 3rd podcast in the backup series. Previous podcasts in the backup series: Backup Series #1: Glossary Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump) | 2/11/11 | Free | View In iTunes |
|
61 |
CleanOurSQL Episode 32: Backup tools you already have [Backup series #2] | We talk about mysqlhotcopy and mysqlbackup in this 2nd installment of the backup series. We also welcome new Oracle ACEs and explain the Oracle ACE and ACE Director program, get feedback on how to get logical data out of InnoDB physical files, talk about several upcoming events, and in Ear Candy we explain how to use different pagers in the mysql commandline client. | 2/3/11 | Free | View In iTunes |
|
62 |
CleanOurSQL Episode 31: The MySQL Ecosystem | This week, Sarah's off, and Sheeri interviews Brian Aker of Data Differential, mostly about the MySQL Ecosystem. Among the topics discussed are whether the MySQL Ecosystem has peaked yet, the exciting talks coming up at the O'Reilly MySQL Conference including the state of the community keynote, and when the Drizzle software is going GA. | 1/27/11 | Free | View In iTunes |
|
63 |
CleanOurSQL Episode 30: Backup Glossary (Backup Series #1) | This is the first in a series of podcasts about backups, and future backups will go in depth into different backup solutions and how they can be used to get the backups you want. We define: logical vs. physical backups, cold vs. hot vs. warm backups, consistent vs. inconsistent backups. [note: about 11 minutes in, Sarah's audio gets a little noisier, and our audio engineer simply could not get rid of all the noise] | 1/20/11 | Free | View In iTunes |
|
64 |
CleanOurSQL Episode 29: Subpar Subqueries | Sarah and Sheeri talk about subqueries, why they are suboptimal, and how to optimize into a join | 1/14/11 | Free | View In iTunes |
|
65 |
CleanOurSQL Episode 28: Conferential Integrity | We talk about O'Reilly's MySQL Conference, Collaborate and Kaleidoscope | 1/6/11 | Free | View In iTunes |
|
66 |
CleanOurSQL Episode 27: To SQL or No[tto]SQL, that is the question | In the last podcast for 2010 Sheeri & Sarah bring in Patrick Galbraith to talk about how HandlerSocket can make MySQL into a NoSQL solution. Show notes at http://www.oursqlcast.com | 12/22/10 | Free | View In iTunes |
|
67 |
CleanOurSQL Episode 26: Zombies! | Show notes for Episode 26: Zombies! 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." MySQL 5.5 release is GA - http://dev.mysql.com/tech-resources/interviews/thomas-ulin-mysql-55.html InnoDB improvements Multiple InnoDB buffer pools - http://dev.mysql.com/doc/innodb/1.1/en/innodb-multiple-buffer-pools.html InnoDB I/O improvements (innodb_io_capacity, innodb_io_read_threads, innodb_io_write_threads) - http://dev.mysql.com/doc/refman/5.5/en/innodb-io-changes.html InnoDB speed improvements due to mutex removals - part of Thomas Anderson‘s Oracle OpenWorld presentation “Performance and Scalability Enhancements in MySQL 5.5”. Slides can be downloaded from http://downloads.mysql.com/presentations/mysql-sunday/InnoDB_Enhancements_OOW_2010_4.pdf InnoDB recovery improvements - These improvements fixed two existing issues. First, the issue of an available memory check eating up too much CPU during recovery and the second was algorithm changes to how InnoDB inserts into the flush_list during recovery (adding an additional datastruct during recovery). http://blogs.innodb.com/wp/2010/04/innodb-performance-recovery/ Replication improvements http://blogs.oracle.com/mysql/2010/11/mysql_55_whats_new_in_replication.html Replication server filtering - IGNORE_SERVER_IDS=(123,456) in CHANGE MASTER - p10-12 of http://forge.mysql.com/w/images/2/2f/090507.NewReplicationFeatures.pdf Semi-synchronous replication - http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html Other MySQL 5.5 features/notes Pluggable authentication - http://dev.mysql.com/doc/refman/5.5/en/pluggable-authentication.html Proxy users (mostly used to give permissions to externally authorized users) - http://dev.mysql.com/doc/refman/5.5/en/proxy-users.html Performance_schema - http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html Partitioning improvements - http://dev.mysql.com/doc/refman/5.5/en/partitioning-columns.html Individual log flushing - http://dev.mysql.com/doc/refman/5.5/en/flush.html Audit plugin - http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html - again, like external auth plugin, not too excited, let’s see what plugins ppl write first. Deprecated things that are now removed - http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html#id2463830 Misc links http://bit.ly/ey6F8C Boston MySQL User group Dec 12th 2010 presentation (video + slides) from Bill Papp about MySQL Cluster, including the new features in version 7.1 How to Upgrade to MySQL 5.5 by Gerry Narvaja - http://mmatemate.blogspot.com/2010/12/mysql-55-upgrading-from-previous.html “All the things” cartoon - It’s called “This is Why I’ll Never Be an Adult” http://hyperboleandahalf.blogspot.com/2010/06/this-is-why-ill-never-be-adult.html Send us feedback e-mail: podcast at technocation.org voicemail using phone/Skype: +1-617-674-2369 twitter: @oursqlcast | 12/16/10 | Free | View In iTunes |
|
68 |
CleanDrizzle Podcast #1 | In this first Drizzle Podcast, Sheeri K. Cabral and Jay Pipes talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint. The main web page for Drizzle is http://drizzle.org/. The main project page for Drizzle is at Launchpad: https://launchpad.net/drizzle. The Drizzle mailing list is at https://launchpad.net/~drizzle-discuss. The Drizzle wiki, including documentation, is at http://drizzle.org/wiki/ The Drizzle blueprints are at: https://blueprints.launchpad.net/drizzle | 2/25/09 | Free | View In iTunes |
|
69 |
CleanOurSQL Episode 24: The Sun is Shining | -- | 1/17/08 | Free | View In iTunes |
|
70 |
CleanOurSQL 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/ See what others are saying about the testing client at: http://technocation.org/category/forums/skoll-community-based-testing MySQL Magazine -- Fall 2007 edition now available! http://www.mysqlzine.net 2008 MySQL Conference and Expo seeking proposals: http://www.mysqlconf.com Job site for database professionals -- developers, architects, analysts, consultants, administrators. http://www.toomanyconnections.com 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 | 10/3/07 | Free | View In iTunes |
|
71 |
CleanOurSQL 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://tinyurl.com/sc6qw Direct play this episode at: http://tinyurl.com/ywr6nt | 8/16/07 | Free | View In iTunes |
|
72 |
CleanOurSQL 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 NYhttp://www.mysqlcamp.org http://www.poly.edu Feature: The Pythian Group’s Paul Vallee http://www.pythian.com 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 | 8/8/07 | Free | View In iTunes |
|
73 |
CleanOurSQL 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 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 | 8/2/07 | Free | View In iTunes |
|
74 |
CleanOurSQL 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: http://www.oreillynet.com/pub/a/databases/2007/07/12/getting-started-with-mysql-proxy.html public Subversion tree: http://forge.mysql.com/wiki/mysql_proxy Tutorials: Intercept and dump queries (part 1): http://forge.mysql.com/snippets/view.php?id=75 Make macros to map “cd” to “use” and “ls” to “show tables” (part 2): http://forge.mysql.com/snippets/view.php?id=76 Injection Queries (part 3): http://forge.mysql.com/snippets/view.php?id=77 Lua interpreted language: http://www.lua.org/ | 7/24/07 | Free | View In iTunes |
|
75 |
CleanOurSQL Episode 18: De-myth-tifying Indexes | -- | 7/12/07 | Free | View In iTunes |
|
76 |
CleanOurSQL Episode 17: Hashing it out | 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 MySQL 5.0.x security vulnerability: http://bugs.mysql.com/bug.php?id=27513 Solution: upgrade to 5.0.40. This bug is not known to affect major versions 3 or 4. Learning Resource: http://onlinesolutionsmysql.blogspot.com/ The dates for the all the sessions: * 27th March: Part 1 - High Availability and Scalability Architectures * 19th April: Part 2 - Advanced Scalability Solutions * 2nd May: Part 3 - MySQL Enterprise To Control Mission Critical Online Services * 23rd May: Part 4 - 99.999% High Availability solutions * 13th June: Part 5 - MySQL Enterprise performance and benchmarking * 27th June: Part 6 - Advanced HA solutions Find all the material and documentation for past webinars at: http://onlinesolutionsmysql.blogspot.com/2007/03/links-to-material-and-documentation.html Feature: Hash tables explained. http://www.sparknotes.com/cs/searching/hashtables/section1.html http://www.cs.sunysb.edu/~algorith/lectures-good/node7.html (search for “Hash Tables” on the page) 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 | 5/30/07 | Free | View In iTunes |
|
77 |
CleanOurSQL Episode 16: The Art of Innovation, Guy Kawasaki | 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/ Subscribe to the podcast at: http://feeds.feedburner.com/oursql 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 | 5/10/07 | Free | View In iTunes |
|
78 |
CleanOurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conference | "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/ Subscribe to the podcast at: http://feeds.feedburner.com/oursql Feedback: Email info@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 | 5/5/07 | Free | View In iTunes |
|
79 |
CleanOurSQL Episode 14: The MySQL Conference & Expo | 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 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 | 4/26/07 | Free | View In iTunes |
|
80 |
CleanOurSQL Episode 13: The Nitty Gritty of Indexes | 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 Register for the MySQL Conference now!: http://www.mysqlconf.com 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: http://www.semaphorecorp.com/btp/algo.html http://perl.plover.com/BTree/article.txt 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 | 4/21/07 | Free | View In iTunes |
|
81 |
CleanOurSQL Episode 12: Interview with Kaj Arno About the Google Summer of Code | 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 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 | 4/13/07 | Free | View In iTunes |
|
82 |
CleanOurSQL Episode 11: Catching Up | 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-details 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: http://kostja-osipov.livejournal.com/24718.html Eric Bergen’s -auto-vertical-output patch: http://ebergen.net/wordpress/2007/03/07/client-auto-vertical-output/#comments Tim O’Reilly talks about why he joined the MySQL Board of Directors: http://radar.oreilly.com/archives/2007/03/why_i_joined_th_1.html Microsoft’s Port 25 has a MySQL plugin for Visual Studio http://port25.technet.com/archive/2007/03/08/mysql-user-conference.aspx Also how to install MySQL on Windows: http://port25.technet.com/archive/2007/03/16/mysql-on-windows-configuration-install.aspx Learning Resource: How to efficiently write a MySQL Stored Procedure http://www.ruturaj.net/tutorials/mysql/efficient-stored-procedure-editing Download MySQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html Feature: Book Review: Learning MySQL http://desicritics.org/2007/04/02/004728.php MySQL Cookbook http://desicritics.org/2007/04/03/003334.php 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 | 4/9/07 | Free | View In iTunes |
|
83 |
CleanOurSQL Episode 10: How About Some Cache? | 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/ 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 Feature: How about some cache? The MySQL Manual has a short, very readable chapter on the Query Cache, which starts here: http://dev.mysql.com/doc/refman/5.0/en/query-cache.html | 3/9/07 | Free | View In iTunes |
|
84 |
CleanOurSQL Episode 9: Jay Speaks About the MySQL Conference | 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=206806301 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). On with the show notes! Tutorials are 3 hours long (and there are two that have two parts each). The tutorial links and descriptions are here. Tutorials in bold are ones that were mentioned in the podcast: http://www.mysqlconf.com/pub/w/54/tutorials.html MySQL Cluster: The Complete Tutorial, Part I MySQL Cluster: The Complete Tutorial, Part II MySQL Replication: The Complete Tutorial, Part I MySQL Replication, The Complete Tutorial, Part II MySQL 5.0 DBA I Certification Primer MySQL 5.0 DBA II Certification Primer Managing Hierarchical Data in MySQL: The Extended Director’s Cut Vital Rails: An Introduction to the Ruby on Rails Framework Scaling and High Availability Architectures MySQL Cluster Certification Primer MySQL 5.1 In-depth Writing Your Own Storage Engine Wikipedia: Site Internals, Configuration and Code Examples, and Management Issues Real-World MySQL Performance Tuning MySQL Network Monitoring and Advisory Services: from Soup to Nuts Registration (and information about discounts, including the $200 discount if you register by March 14th) http://www.mysqlconf.com/pub/w/54/register.html There are too many sessions to list, however the conference home page at http://www.mysqlconf.com (scroll to the bottom), and the links take you to a page with all the sessions in that track. We spoke on the podcast about serving three audiences: DBA’s, Developers, and the General Audience. I’ve taken the liberty of grouping the tracks: DBA: Architecture and Technology Performance Tuning and Benchmarks Data Warehousing and Business Intelligence Migration MySQL Cluster and High Availability Replication and Scale-Out Security and Database Administration Developers: Java LAMP .NET/Windows PHP and MySQL Ruby and MySQL General Audience Business and Case Studies Storage Engine Development and Optimization Web 2.0, Ajax, and Emerging Technologies The General Track | 2/27/07 | Free | View In iTunes |
|
85 |
CleanOurSQL Episode 8: Basic MySQL Security | 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 podcast@technocation.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. Direct play this episode at: http://tinyurl.com/2r9kom 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/ News MySQL offers an unlimited number of Gold licenses per year for $40,000: http://mysql.com/products/enterprise/unlimited.html http://mysql.com/products/enterprise/features.html MySQL begins to talk about going public: http://www.businessreviewonline.com/os/archives/2007/01/mysql_set_to_jo.html Learning Resource: http://www.hackmysql.com Feature — MySQL Security: Bruce Scneier’s latest Crypto-Gram newsletter refers to an article where a person gets on an airplane, having bypassed all airport security via climbing a fence. http://www.schneier.com/crypto-gram-0701.html http://www.newsobserver.com/102/story/523482.html Feedback To leave a comment, suggestion, question or other feedback: 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 podcast@technocation.org Acknowledgements/Sponsors www.technocation.org http://music.podshow.com www.russellwolff.com http://www.smallfishadventures.com/Home.html “The Thank you song” — Smallfish | 2/11/07 | Free | View In iTunes |
|
86 |
CleanOurSQL Episode 7: What's it Like To Be Normal? | 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 SQLzoo http://www.sqlzoo.net Links about database normalization: http://en.wikipedia.org/wiki/1NF http://www.datamodel.org/NormalizationRules.html http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html 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://tinyurl.com/sc6qw | 1/30/07 | Free | View In iTunes |
|
87 |
CleanOurSQL Episode 6: Falcon, Part 2 | 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/ Links: Falcon features: http://dev.mysql.com/doc/falcon/en/se-falcon-features.html Falcon documentation http://www.mysql.org/doc/refman/5.1/en/se-falcon.html Special thanks to Arjen Lentz (http://arjen-lentz.livejournal.com/ ) and Mark Matthews (http://www.jroller.com/page/mmatthews ) of MySQL AB for their answers and explanations, and Jim Starkey and Technocation for their use of the audio from the July 2006 Boston User Group meeting with Jim Starkey. 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://tinyurl.com/sc6qw | 1/15/07 | Free | View In iTunes |
|
88 |
CleanOurSQL Episode 5: Falcon, Part 1 | 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 You can Direct download all the oursql podcasts at: http://technocation.org/podcasts/oursql/ Jim Starkey is a great speaker, and very funny to listen to – at one point he refers to a performance hit as a “performance surprise”. He’s also a piece of history – listen for his take on MVCC, which he invented. Links: Falcon features: http://dev.mysql.com/doc/falcon/en/se-falcon-features.html Falcon documentation http://www.mysql.org/doc/refman/5.1/en/se-falcon.html Special thanks to Arjen Lentz (http://arjen-lentz.livejournal.com/) and Mark Matthews (http://www.jroller.com/page/mmatthews ) of MySQL AB for their answers and explanations, and Jim Starkey and Technocation for their use of the audio from the July 2006 Boston User Group meeting with Jim Starkey. | 1/14/07 | Free | View In iTunes |
|
89 |
CleanOurSQL 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://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 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://tinyurl.com/sc6qw | 1/3/07 | Free | View In iTunes |
|
90 |
CleanOurSQL 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://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=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://tinyurl.com/sc6qw | 12/19/06 | Free | View In iTunes |
|
91 |
CleanOurSQL 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/index.php?option=com_content&task=view&id=22&Itemid=29 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://tinyurl.com/sc6qw | 12/14/06 | Free | View In iTunes |
|
92 |
CleanOurSQL Episode 1: Backups, Backups Everywhere | -- | 12/5/06 | Free | View In iTunes |
|
93 |
CleanOurSQL Episode 0: 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://tinyurl.com/sc6qw Or send an e-mail to podcast@technocation.org | 11/27/06 | Free | View In iTunes |
| Total: 93 Episodes |
Customer Reviews
Required listening for anyone using MySQL
I listen to a variety of different podcasts, and OurSQL is at the top of the heap. It's incredibly well produced, is topical for almost anyone using MySQL, and it moves along nicely while still diving deeply into both theory and practice. Also make sure you listen through to the end for the bloopers! A++
Great Information, Well Presented, & fantastic hosts!!!
These podcasats are great classes on particular MySQL subjects. Each is concise but has suffucuent detail for any DBA or developer. These presentations move moderately quickly and well worth the time. These are vary valuable and you should be listening to them!!
Clearly explain complicated issues
A lot of excellent advice from people who are obviously in the the trenches. For someone who doesn't have to deal with some of the extreme situations or scales that they do, this is extremely helpful in thinking about making proactive changes in all aspects of MySQL administrations and utilization. Highly recommended for anyone who needs to deal with MySQL issues on even an occasional basis.
Listeners also subscribed to
- DevZone - Items tagged as: PHP Abstract
- Zend DevZone Editor-in-Chief
- View In iTunes
- EnterpriseDB Podcast Series
- EnterpriseDB Corporation
- View In iTunes
