Home  /  Podcast Directory  /  Technology  /  OurSQL: MySQL Database Community Podcast


Last update: 2013-06-23

OurSQL Episode 143: Biblical Tools

2013-06-23
Length: 25s

This week we start to discuss the Openark Toolkit. Ear Candy talks about how to estimate the size of MySQL's working set, and At the Movies is a backup presentation from Open Database Camp.

Openark Kit
Openark Kit

Episode 80, discussing the Percona Toolkit
Episode 129, interview with Shlomi about Percona Live.

read more

x

Share: OurSQL Episode 143: Biblical Tools


OurSQL Episode 142: Great Views

2013-06-01
Length: 30s

This week we discuss MySQL Views. Ear Candy is GRANTs and replication and At the Movies is a presentation by Giuseppe Maxia talking about "Creating Multi-Master clusters with Tungsten Replicator".

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings

Tungsten University trainings

read more

x

Share: OurSQL Episode 142: Great Views


OurSQL Episode 141: Performance Enhancements

2013-05-25
Length: 29s

This week we talk about server and status variables relating to the performance schema and the ps_helper tool. Ear Candy is an sql_mode bug, and At the Movies is a performance_schema and ps_helper webinar.

Performance Schema Variables
MySQL 5.5 performance schema variables
MySQL 5.6 performance schema variables - many options are auto-sized


SHOW GLOBAL VARIABLES LIKE 'performance_schema%';

read more

x

Share: OurSQL Episode 141: Performance Enhancements


OurSQL Episode 140: More Performance

2013-05-17
Length: 33s

This week we explain performance_schema a bit deeper. In Ear Candy, we talk about max_binlog_cache_size and At the Movies presents Max Mether of SkySQL talking about "High Availability Solutions for MySQL".

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events

Training
SkySQL Trainings
Tungsten University trainings

read more

x

Share: OurSQL Episode 140: More Performance


OurSQL Episode 139: Starting to Perform

2013-05-13
Length: 23s

This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who also are in a DBA role.

News
Continuent's Tungsten Replicator is now completely open source
TokuDB is now open source

read more

x

Share: OurSQL Episode 139: Starting to Perform


OurSQL Episode 138: The Relevance of Tungsten

2013-05-07
Length: 25s

This week we discuss Tungsten and MySQL 5.6 replication with friend of the show, Giuseppe Maxia (aka the Data Charmer). Ear Candy is MariaDB's Cassandra storage engine, and At the Movies is Giuseppe's "MySQL 5.6 Replication – features and usability" video from Open Database Camp.

Events
DB Hangops in May will be Wed May 8th and 22nd.
Upcoming MySQL tech tours

Training
SkySQL Trainings
Tungsten University trainings

read more

x

Share: OurSQL Episode 138: The Relevance of Tungsten


OurSQL Episode 137: Playing in the Sandbox

2013-04-26
Length: 22s

This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.

MySQL Sandbox
MySQL Sandbox

Examples:
MariaDB slave of a master:
make sandbox mysql-tarball --master
make sandbox mariadb-tarball --slaveof master-port=foo

Exporting:
./my sqldump instancename

Remote mysql sandbox deploy:
deploy remote sandboxes -m MySQLVer -l list,of,servers

Get MySQL Sandbox on Launchpad

read more

x

Share: OurSQL Episode 137: Playing in the Sandbox


OurSQL Episode 136: Digging for Information

2013-04-22
Length: 39s

We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week's Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.

Events
DB Hangops in May will be Wed May 8th and 22nd noon pacific time.
Upcoming MySQL tech tours

Training
SkySQL Trainings
Tungsten University trainings

read more

x

Share: OurSQL Episode 136: Digging for Information


OurSQL Episode 135: Another Kind of Buffer

2013-04-13
Length: 27s

This week, we explain the InnoDB and Memcached integration in MySQL 5.6. Ear Candy is about the nonexistent 2-step deadlock detection in MariaDB and At the Movies is Colin Charles talking about the features of MariaDB 10.

InnoDB and memcached in MySQL 5.6
memcached official page
InnoDB integration with memcached MySQL manual page
History of the term NoSQL
setting up the InnoDB memcached plugin in MySQL 5.6

read more

x

Share: OurSQL Episode 135: Another Kind of Buffer


OurSQL Episode 134: When Binary's Not Binary

2013-04-09
Length: 28s

This week, we take a lighter topic and talk about the many uses and meanings of "binary". Ear candy is a but about SET GLOBAL SQL_BIN_LOG, and At the Movies is Ariel Weisberg of VoltDB explaining sharding and elastic clustering.

Events
DBA Hangops - an every-other-week hangout for dba's (right now it's mostly MySQL) - The DB hangops sessions for April and May are April 10th, April 24th, May 8th and May 22nd.

Upcoming MySQL tech tours

Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.

read more

x

Share: OurSQL Episode 134: When Binary's Not Binary


OurSQL Episode 133: MySQL on Auto-Tune

2013-04-02
Length: 29s

This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.

Changed Defaults in MySQL 5.6

Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6

MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.

back_log

read more

x

Share: OurSQL Episode 133: MySQL on Auto-Tune


OurSQL Episode 132: New and Shiny!

2013-03-24
Length: 29s

This week we discuss new variables in MySQL 5.6. Ear Candy talks about a problem with XFS performance on a Linux kernel, and At the Movies discusses columnar databases.

@eRadical points out a correction to episode 130 - multiple InnoDB buffer pools were new in MySQL 5.5, not MySQL 5.6.

Events

Upcoming MySQL tech tours

Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.

read more

x

Share: OurSQL Episode 132: New and Shiny!


OurSQL Episode 131: Fresh Variables

2013-03-14
Length: 29s

This week we discuss changed behavior of variables in MySQL 5.6. In ear candy we talk about a cloud-based service to play with SQL on different databases, and At the Movies is Stewart Smith of Percona talking about MySQL in the Cloud as a Service during Linux Conf Australia in Canberra.

Changed behavior of variables in 5.6
boolean variables can be set to ON/OFF 1/0 TRUE/FALSE

Variables with changes:
log_slave_updates

read more

x

Share: OurSQL Episode 131: Fresh Variables


OurSQL Episode 130: Retired Variables

2013-03-08
Length: 28s

This week we discuss deprecated, removed and ignored variables in MySQL 5.6. Ear Candy is about innodb_file_per_table enabled by default, and At the Movies is "Different MySQL Forks for Different MySQL Folks".

Events
Upcoming MySQL tech tours

Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.

read more

x

Share: OurSQL Episode 130: Retired Variables


OurSQL Episode 129: New and Extended

2013-03-03
Length: 50s

This week we interview Shlomi Noach about the upcoming Percona Live: MySQL Conference and Expo in Santa Clara April 22-25th, 2013. There are 2 organizations with new trainings, too! Ear Candy is a resource with data models, and At the Movies is how to setup and operate Tungsten replication.

Events
Upcoming MySQL tech tours

LinuxFest Northwest will take place in Bellingham, Washington on Sat Apr 27th and Sun Apr 28th.

read more

x

Share: OurSQL Episode 129: New and Extended


OurSQL Episode 128: Your Global ID Please

2013-02-17
Length: 29s

This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a 'Senior' Employee.

Events
Oracle's upcoming webinars:
MySQL Security Enhancements and Important Security Tips for ISVs and OEMs on Thursday, February 21st.

MySQL Performance and Scalability in Spanish Thursday, February 28th.

read more

x

Share: OurSQL Episode 128: Your Global ID Please


OurSQL Episode 127: No Sweat Slaves

2013-02-08
Length: 29s

This week we begin to discuss replication features in MySQL 5.6. Ear Candy is a LOAD DATA INFILE bug and using CSV to get beyond it; At the Movies is Suzan Bond talking about "The Art of Self-Sourcing".

Events
Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Tuesday, February 19th in Petach Tikva, Israel
Thursday, February 21st in Oslo and Brussels

read more

x

Share: OurSQL Episode 127: No Sweat Slaves


OurSQL Episode 126: Subqueries and Tracking

2013-02-02
Length: 33s

This week we present part 2 of optimizer enhancements in MySQL 5.6, including subquery optimizations and the new optimizer trace feature. Ear Candy talks about what "hole punching" is with regards to file systems. In At the Movies we present "How to Deal with Difficult People".

Events
Galera, SkySQL and MariaDB are doing a Road Show in Stockholm on February 7th.

Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Friday, February 15th near Milan

read more

x

Share: OurSQL Episode 126: Subqueries and Tracking


OurSQL Episode 125: New and Improved...And Faster!

2013-01-26
Length: 34s

This week we discuss part 1 of the new optimizer enhancements in MySQL 5.6. Ear Candy is a gotcha about persistent replication configuration, and At the Movies is MVCC in PostgreSQL.

Events

Galera, SkySQL and MariaDB are doing a Road Show in Hamburg on February 1st and Stockholm on February 7th.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.

OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for speakers closes at midnight Pacific Time on Monday, February 4th.

read more

x

Share: OurSQL Episode 125: New and Improved...And Faster!


OurSQL Episode 124: When Do You Want It?

2013-01-18
Length: 24s

This week, we talk about Linux I/O schedulers. Ear Candy is iotop, and At the Movies is learning how to use EXPLAIN.

News
OurSQL is taking the EBU's recommendation for volume for mobile devices. You can find a link to a white paper titled: "On the way to loudness nirvana".

Events
Oracle is doing a small MySQL tech tour, on January 22nd to Pleasanton, CA and on January 23rd to Belmont, CA.

read more

x

Share: OurSQL Episode 124: When Do You Want It?


OurSQL Episode 123: Storing Bags of Bytes

2013-01-11
Length: 44s

This week we discuss different filesystems and how they work. Ear Candy talks about the "-bibyte" suffix, and At the Movies presents an indexing webinar.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.

OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for Speakers closes at midnight Pacific Time on Monday, February 4th.

LinuxFest Northwest will take place on Sat Apr 27th and Sun Apr 28th. The call for papers is open and you can submit proposals through Thursday Feb 28th.

read more

x

Share: OurSQL Episode 123: Storing Bags of Bytes


OurSQL Episode 122: Nobody's Perfect - 2012 Blooper Retrospective

2012-12-31
Length: 34s

This podcast would not achieve its goal if there were no listeners to learn about MySQL. This week we play a bunch of bloopers as our year-end gift to you. We hope these make you laugh!

2011 Blooper Retrospective

x

Share: OurSQL Episode 122: Nobody's Perfect - 2012 Blooper Retrospective


OurSQL Episode 121: Fun with text files

2012-12-24
Length: 43s

This week we discuss manipulating text data and the CSV storage engine. Ear Candy is Venn Diagrams visually showing joins, and At the Movies is about how to retain your individuality while being on a team.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

read more

x

Share: OurSQL Episode 121: Fun with text files


OurSQL Episode 120: Trigger Happy

2012-12-17
Length: 25s

This week we discuss triggers in MySQL. Ear Candy is SQL in the Shell, and At the Movies is Project Triage and Recovery, by Keith Casey of Twilio, at the 2012 CodeConnexx conference.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

read more

x

Share: OurSQL Episode 120: Trigger Happy


OurSQL Episode 119: I Do DECLARE

2012-12-11
Length: 32s

This week we talk more about stored routines, including the several different DECLARE statements. Ear Candy is about ssh hacks to make logging into multiple servers easy, and At the Movies is "Everything You Ever Wanted to Know About Deployment But Were Afraid to Ask".

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

read more

x

Share: OurSQL Episode 119: I Do DECLARE


OurSQL Episode 118: Not Our Usual Routine

2012-11-30
Length: 40s

This week we go over stored routine basics. Ear Candy is linux.die.net, online man pages for Linux, and At the Movies is key things that DBA need to know.

News
Open Source DBA's Holiday Gifts for MySQL DBAs - check out the CafePress link, many are positively funny.

Events
Oracle is having free Tech Tours for MySQL in Dublin, San Diego, El Segundo, CA, Miami

read more

x

Share: OurSQL Episode 118: Not Our Usual Routine


OurSQL Episode 117: Foreign Policy

2012-11-23
Length: 29s

This week, we take a look at foreign keys - what they are, what you can do with them, and how to troubleshoot the dreaded errno 150. In Ear Candy, we talk about perror, and in At the Movies, we share Secrets of Success in the Style of GLEE from CodeConnexx this month, where Jennifer Marsman Microsoft's Developer and Platform Evangelism team talks about how to be successful in a tech job, by using popular songs as illustrating points.

read more

x

Share: OurSQL Episode 117: Foreign Policy


OurSQL Episode 116: Do You Make the Grade (part 5)?

2012-11-16
Length: 32s

This week, we finish our series on the Operations Report Card as it applies to database administrators. In Ear Candy, we discuss one problem with setting table_open_cache higher than needed., and At the Movies is Tools and Techniques of Index Design by Bill Karwin.

News
MariaDB 10.0.0 alpha is out, including the SHOW EXPLAIN FOR thread_id feature for running an EXPLAIN on a running query, and multi-source replication.

read more

x

Share: OurSQL Episode 116: Do You Make the Grade (part 5)?


OurSQL Episode 115: Do You Make the Grade (part 4)?

2012-11-14
Length: 30s

This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.

Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November

read more

x

Share: OurSQL Episode 115: Do You Make the Grade (part 4)?


OurSQL Episode 114: Do You Make the Grade (part 3)?

2012-11-05
Length: 39s

This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.

Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be Reading. Thanks for your support!

read more

x

Share: OurSQL Episode 114: Do You Make the Grade (part 3)?


OurSQL Episode 113: A JS API with JDD

2012-10-29
Length: 29s

While we were at MySQL Connect last month, we interviewed long-time MySQL developer JD Duncan about integrating NoSQL and JavaScript with MySQL. His team developed the Node.js API for MySQL. This week, we present the interview we did. In Ear Candy, we discuss what makes a senior DBA, and in At the Movies we present a ScaleBase webinar.

Events
Oracle's "Scale with MySQL" seminars:
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

read more

x

Share: OurSQL Episode 113: A JS API with JDD


OurSQL Episode 112: Do You Make the Grade (part 2)?

2012-10-23
Length: 30s

This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

read more

x

Share: OurSQL Episode 112: Do You Make the Grade (part 2)?


OurSQL Episode 111: Do You Make the Grade (part 1)?

2012-10-14
Length: 36s

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October

read more

x

Share: OurSQL Episode 111: Do You Make the Grade (part 1)?


OurSQL Episode 110: The Key to 5.6

2012-10-08
Length: 51s

This week we present the MySQL Connect Keynote: Community Perspective—Why Upgrade to MySQL 5.6. This is the entire keynote panel, featuring Sarah Novotny of Meteor Entertainment as the moderator, and panelists Giuseppe Maxia of Continuent, Domas Mituzas of Facebook, Sheeri Cabral of Mozilla and Mark Leith of Oracle. We discussed the main features we thought would be useful to us as well as the community.

read more

x

Share: OurSQL Episode 110: The Key to 5.6


OurSQL Episode 109: Starting with the right foot

2012-09-28
Length: 50s

This week we talk about startup scripts and their gotchas. Ear candy is a startup cache gotcha and at the movies presents an introduction to VoltDB.

Events

Percona Live Santa Clara, 2013 call for papers closes Friday October 12th.

Oracle's "Scale with MySQL" seminars:
near Paris, Tuesday 16 October
Scale with MySQL Seminar, London, Tuesday 30 October

read more

x

Share: OurSQL Episode 109: Starting with the right foot


OurSQL Episode 108: Legendary Searches

2012-09-21
Length: 33s

This week we present the Sphinx Storage Engine. Ear Candy is a gotcha about setting variables in the configuration file, and At the Movies is a video about MariaDB.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

read more

x

Share: OurSQL Episode 108: Legendary Searches


OurSQL Episode 107: Staying concurrent

2012-09-14
Length: 23s

This week we present what Multi-Version Concurrency Control (MVCC) means, as well as how InnoDB implements it to achieve transactionality and ACID compliance. Ear candy is a GROUP BY performance gotcha, and At the Movies is a FULLTEXT webinar from Percona.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

read more

x

Share: OurSQL Episode 107: Staying concurrent


OurSQL Episode 106: FULLTEXT on ACID

2012-09-10
Length: 26s

This week we present InnoDB FULLTEXT search. Ear Candy is about SOUNDEX() and SOUNDS LIKE queries, and At the Movies is about FULLTEXT search throwdown by Bill Karwin.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

read more

x

Share: OurSQL Episode 106: FULLTEXT on ACID


OurSQL Episode 105: Lost for Words

2012-08-31
Length: 38s

This week we present the basics of MySQL FULLTEXT search. We talk about the myisam_ftdump utility in Ear Candy, and present an introduction to Sphinx in At the Movies.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

read more

x

Share: OurSQL Episode 105: Lost for Words


OurSQL Episode 104: Making a Connection, part 2

2012-08-17
Length: 25s

This week we talk about sessions at MySQL Connect we think will be interesting to DBAs. Ear Candy is Python's Fabric library and command-line tool and At the Movies is Johan Andersson of Severalnines presenting Using MySQL as a NoSQL datastore - new featuers in MysQL Cluster 7.2 GA from the SkySQL solutions day back in April.

Events
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

read more

x

Share: OurSQL Episode 104: Making a Connection, part 2


OurSQL Episode 103: Making a Connection, part 1

2012-08-10
Length: 24s

This week, we talk about the MySQL Connect format, and present our "Guide to MySQL Connect for Developers" and the few tech talks we think both DBAs and developers will find useful. In Ear Candy, we talk about how InnoDB stores the binary log position of the last successfully executed statement in its recovery logs. In At the Movies, we highlight Andrew Aksyonoff's talk on Sphinx at SkySQL's MySQL solutions day last April.

Events
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

read more

x

Share: OurSQL Episode 103: Making a Connection, part 1


OurSQL Episode 102: Virtualization 102

2012-08-04
Length: 32s

This week, we continue the virtualization talk about what to know when doing virtualization. We also talk about using KVM & virtualbox.
Episode 101, part 1 of virtualization.

Conferences
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The schedule is now online.

read more

x

Share: OurSQL Episode 102: Virtualization 102


OurSQL 101: Virtualization 101

2012-07-28
Length: 35s

This week, Sheeri talks about virtualization with Tim Hall during the Latin America Oracle Technology Network Tour. Earcandy is MySQL Sandbox and at the movies Giuseppe Maxia demos MySQL Sandbox during the 2011 MySQL Users Conference.

News
There is a new cheat sheet out from Dzone's Refcardz line, about database partitioning with MySQL. It is a free download once you make a free account: Database Partitioning with MySQL

Events
Oracle Tech Tour Pittsburgh and Chicago

read more

x

Share: OurSQL 101: Virtualization 101


OurSQL Episode 100: The Ball Pit

2012-07-20
Length: 31s

This week we present part 2 of our interview with XKCD's Randall Munroe, where we finish talking about data privacy and security, and talk about Randall's real-life ball pit in his apartment, and his thoughts on fanny packs.

Defending your Life - romantic comedy movie

lamebook

Grownups comic:

The ball pit - the blog post with pictures and notes.

read more

x

Share: OurSQL Episode 100: The Ball Pit


OurSQL Episode 99: Data Privacy and Security

2012-07-13
Length: 34s

This week we present the 100th episode (yes, we started at episode 0), which is part 1 of a 2 part interview with XKCD's Randall Munroe.

OurSQL Podcast history
Episode 0 was on November 26, 2006.
Episode 26 on December 16, 2010 added Sarah Novotny as the first co-host and we hired our audio engineer and producer, Rich Goyette, due to the support of Justin Kestelyn and the Oracle Technology Network.

read more

x

Share: OurSQL Episode 99: Data Privacy and Security


OurSQL Episode 98: MySQL Puppeteering

2012-07-07
Length: 30s

This week we present using Puppet to manage MySQL. Ear Candy is netcat and At the Movies is a video about the Master High Availability toolkit by Yoshinori Matsunobu.

Feedback
Daniël van Eeden gave us lots of great feedback this week:
Episode 93, which included iotop and ionice in ear candy
CFQ scheduler for Linux
noop scheduler for Linux
deadline scheduler for Linux

read more

x

Share: OurSQL Episode 98: MySQL Puppeteering


OurSQL Episode 97: Who's Watching the Databases?

2012-06-29
Length: 31s

This week we present an interview with Rohit Nadhani of WebYog about MONyog, a MySQL monitoring and advisory tool.

Conferences
OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a discount code!

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The schedule is now online.

read more

x

Share: OurSQL Episode 97: Who's Watching the Databases?


OurSQL Episode 96: Talking about Nothing

2012-06-21
Length: 33s

This week we talk about NULLs and how to find the right data type.

Events
OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a discount code!

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The schedule is now online.

read more

x

Share: OurSQL Episode 96: Talking about Nothing


OurSQL Episode 95: Finding data at OSCON

2012-06-15
Length: 26s

This week, we talk with Sarah Novotny about Data at O'Reilly Open Source Convention - OSCON. Listen for a 20% off discount code!

Conferences
The 1st Latin American Conference on MySQL, NoSQL and Cloud Technologies will be held in Buenos Aires from Tuesday June 26 through Thursday June 28th at the Hilton Buenos Aires.

OSCon will be held Monday Jul 16th through 20th

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps.

read more

x

Share: OurSQL Episode 95: Finding data at OSCON


OurSQL Episode 94: It's Still Not Our Type, Part 3

2012-06-07
Length: 49s

We finish our series on data types by talking about ENUM, SET and all the different sql modes.

Conferences
The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies, will be held in Buenos Aires from Tuesday, June 26th through Thursday, June 28th at the Puerto Madero Hilton Hotel.

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps.

read more

x

Share: OurSQL Episode 94: It's Still Not Our Type, Part 3


OurSQL Episode 93: A GUI is Worth a Thousand Commandlines

2012-06-04
Length: 29s

This week we sit down with Rohit Nadhani from Webyog, and talk about SQLyog as a GUI for MySQL, and why veteran commandline users would benefit from using SQLyog.

News/Events/Feedback
Conferences:
The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies, will be held in Buenos Aires from Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel. There will be live simultaneous translations for English, Portuguese and Spanish.

read more

x

Share: OurSQL Episode 93: A GUI is Worth a Thousand Commandlines


OurSQL Episode 92: It's Not Our Type, Part 2

2012-05-24
Length: 37s

This week we talk about numeric data types in MySQL.

News/Events/Feedback
OurSQL Listener Jesper Hansen was nice enough to take a screen shot of episode 0 of the ourSQL podcast hitting 12,345 downloads.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

x

Share: OurSQL Episode 92: It's Not Our Type, Part 2


OurSQL Episode 91: It's Not Our Type, Part 1

2012-05-18
Length: 43s

In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.

Gerry has joined Tokutek - Congrats Gerry! We interviewed Martin from Tokutek in episode 86.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

x

Share: OurSQL Episode 91: It's Not Our Type, Part 1


OurSQL Episode 90: Handle With Care

2012-05-11
Length: 48s

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.

News/Events/Feedback
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

x

Share: OurSQL Episode 90: Handle With Care


OurSQL Episode 89: Seal of Approval

2012-05-04
Length: 39s

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.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

x

Share: OurSQL Episode 89: Seal of Approval


OurSQL Episode 88: MySQL Founders

2012-04-27
Length: 44s

This week we listen to MySQL founders David Axmark and Michael "Monty" Widenius talk about all sorts of topics, from the MySQL ecosystem to "Crazy Monty", an open source restaurant. David and Monty don't always agree, so this panel is enlightening and also funny.

News/Events/Feedback
MariaDB 5.5 features - 5.5 is now GA!

IOUG podcast about MySQL Connect and the new Development Milestone Release (DMR) of MySQL 5.6.

read more

x

Share: OurSQL Episode 88: MySQL Founders


OurSQL Episode 87: A Shift in the Cloud

2012-04-20
Length: 34s

This week we talk with Mark Atwood of RedHat about OpenShift, a free, auto-scaling Platform as a Service (PaaS) for applications. Use promotional code "oursql" when signing up!

News/Events/Feedback
We are very thankful for our listeners! Last week we won a MySQL Community Contributor of the Year award (Sarah Novotny, Gerry Narvaja and Sheeri Cabral, who have all been hosts, won the award). Here's a picture of the award we all won.

read more

x

Share: OurSQL Episode 87: A Shift in the Cloud


OurSQL Episode 86: Speed Demon

2012-04-09
Length: 36s

This week we talk with Martin Farach-Colton of Tokutek about what's new with TokuDB.

News/Events/Feedback
Oracle announced the MySQL Connect Conference to be held in San Francisco on Saturday, September 29 and Sunday, September 30th. Call for papers and registration will open on April 16th.

There is a free webcast on Efficiently deploying new MySQL applications on Windows .

read more

x

Share: OurSQL Episode 86: Speed Demon


OurSQL Episode 85: Keep it Under Control

2012-03-30
Length: 38s

This week we talk about package and configuration management with MySQL.

News/Events:
Don't forget to send us questions to answer for future versions of Ear Candy, see the "Feedback" section below.

There are 2 free webcasts on Efficiently deploying new MySQL applications on Windows coming up: in French on Thursday April 5th and in German, on Thursday, April 19th.

read more

x

Share: OurSQL Episode 85: Keep it Under Control


OurSQL Episode 84: Going to the Big Show

2012-03-23
Length: 41s

This week we give an overview of Percona Live and what we think are the highlights, including which sessions we recommend for beginners and which we cannot wait to see for ourselves.

On Tuesday June 5th, 2012, a MySQL Innovation Day is being hosted at Oracle’s Conference Center in Redwood Shores, California. The MySQL Innovation day will feature multiple “lightning” talks by Oracle’s MySQL Engineers, If you cannot make it out to California, the lightning talks will be available via a live webcast, too - so either way, save the date! Unfortunately there's no link yet.

MariaDB 5.5 beta announcement

read more

x

Share: OurSQL Episode 84: Going to the Big Show


OurSQL Episode 83: The NewSQL World

2012-03-16
Length: 38s

This week, we talk with Ori Herrnstadt, CTO of Akiban.

MariaDB announced their 5.3 GA and 5.5 alpha releases.

Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.

Percona's XtraDB cluster announcement

read more

x

Share: OurSQL Episode 83: The NewSQL World


OurSQL Episode 82: Cloudy With a Chance of Data

2012-03-09
Length: 32s

This week, we talk about cloud computing with Amazon AWS.

News:
Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.

Percona's XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup on Wednesday, March 21st
XtraDB Webinar on Wednesday April 4th

read more

x

Share: OurSQL Episode 82: Cloudy With a Chance of Data


OurSQL Episode 81: From the Tool Bench

2012-03-02
Length: 34s

This week we present the how's and why's of benchmarking MySQL.

News/Feedback:
MySQL Cluster 7.2 can do one billion queries per minute, what does that actually mean?

Percona's XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup on Wednesday, March 21st
XtraDB Webinar on Wednesday April 4th

read more

x

Share: OurSQL Episode 81: From the Tool Bench


OurSQL Episode 80: Lesser Known Percona Tools

2012-02-24
Length: 27s

This week, we talk about lesser-known Percona tools for MySQL.

News/Feedback:
This week we have some fun audio feedback from Patrick Hurley, a MySQL DBA in the UK.

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, CA Convention Center. Early bird pricing ends March 12th, 2012. Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule.

read more

x

Share: OurSQL Episode 80: Lesser Known Percona Tools


OurSQL Episode 79: Removing Evil Queries, part 3

2012-02-17
Length: 21s

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.

Free OTN MySQL Developer Day, Singapore, Tuesday Feb 21st

Free OTN MySQL Developer Day, Paris, France, Tuesday Feb 21st

read more

x

Share: OurSQL Episode 79: Removing Evil Queries, part 3


OurSQL Episode 78: Removing Evil Queries, part 2

2012-02-10
Length: 28s

This week, we continue our series on query optimization by talking about how to use EXPLAIN to optimize queries. Part 1 of the series.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th at the Santa Clara, CA convention center. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule!

read more

x

Share: OurSQL Episode 78: Removing Evil Queries, part 2


OurSQL Episode 77: Removing Evil Queries, part 1

2012-02-04
Length: 33s

This week, we talk about how to find mysql queries to optimize in part 1 of a series on query optimization.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!.

The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires in June. It is called the MariaDB NoSQL & Cloud Latin American Conference and we'll bring you more information as it becomes available.

read more

x

Share: OurSQL Episode 77: Removing Evil Queries, part 1


OurSQL Episode 76: Off the Charts, part 3

2012-01-28
Length: 35s

This week, we continue the monitoring series, talking about snmp, rrdtool, cacti, nagios, openNMS and zabbix. Sarah Novotny joins us to talk about these monitoring tools that need very little setup

Part 1 of the monitoring series: http://bit.ly/oursql074
Part 2 of the monitoring series: http://bit.ly/oursql075

News/Feedback
Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Use code PL-pod and save 10% off the early bird prices!.

read more

x

Share: OurSQL Episode 76: Off the Charts, part 3


OurSQL Episode 75: Off the Charts, part 2

2012-01-20
Length: 30s

Part 1 of the monitoring series: http://bit.ly/oursql074
This week, we continue the monitoring series, talking about snmp, rrdtool, cacti, nagios, openNMS and zabbix.

News:
The next free Oracle Technology Network Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. Register for free here.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Use code PL-pod and save 10% off the early bird prices!. Early bird pricing is only good for about 7 more weeks, so make sure to register soon!

read more

x

Share: OurSQL Episode 75: Off the Charts, part 2


OurSQL Episode 74: Off the Charts, part 1

2012-01-13
Length: 33s

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.

News
The Independent Oracle User Group is looking for nominations to the MySQL Council.

The next OTN Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. Registration is free.

read more

x

Share: OurSQL Episode 74: Off the Charts, part 1


OurSQL Episode 73: What happened?

2012-01-06
Length: 18s

This week we present a year in review for the MySQL Ecosystem, including updates from Oracle's MySQL, SkySQL, Percona and MariaDB.

News:
The MySQL developer’s room at FOSDEM has almost 40 submissions, and only about a dozen slots, so they need your vote to figure out what sessions will be presented. Send in your votes via twitter or e-mail, see Giuseppe's blog post and session descriptions.

read more

x

Share: OurSQL Episode 73: What happened?


OurSQL Episode 72: Blooper Retrospective

2011-12-31
Length: 12s

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!

Sugus candy

x

Share: OurSQL Episode 72: Blooper Retrospective


OurSQL Episode 71: Table Manners, part 2

2011-12-26
Length: 32s

This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.

Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount for students, faculty and staff of educational organizations, and a 35% discount for government employees. http://www.percona.com/live/dc-2012/

Percona Server
Percona software

read more

x

Share: OurSQL Episode 71: Table Manners, part 2


OurSQL Episode 70: Table Manners, part 1

2011-12-16
Length: 29s

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.

News:
There will be a "MySQL and Friends" devroom at FOSDEM 2012 in Brussels, Belgium on Sunday, February 5th, 2012. If you are interested in giving a talk, please submit it before December 26th through the submission form. There will also be a dinner on Saturday February 4th, for anyone making travel plans.

Last week we talked about the debian packages available for MySQL 5.5. We went looking for the packages and could not find the Debian drop-down for downloading MySQL 5.5, but we’re happy to report that the drop-down menu item is there now. http://dev.mysql.com/downloads/mysql/

read more

x

Share: OurSQL Episode 70: Table Manners, part 1


OurSQL Episode 69: Replication Secret Agent

2011-12-09
Length: 23s

In this episode we talk about the MySQL Master High Availability Agent, aka MHA.

News

There will be a "MySQL and Friends" devroom at FOSDEM 2012. The dev room is scheduled for Sunday 5th February 2012, whole day. If you are interested to give a talk, please submit it before December 26th through the submission form. You can read the original announcement by Frédéric Descamps.

Meet the MySQL Experts Podcast

read more

x

Share: OurSQL Episode 69: Replication Secret Agent


OurSQL Episode 68: Scaling, or Sailing?

2011-12-02
Length: 32s

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.

News
Both Sheeri and Gerry have new jobs - Sheeri wrote about her change at http://palominodb.com/blog/2011/11/23/last-day-palominodb

read more

x

Share: OurSQL Episode 68: Scaling, or Sailing?


OurSQL Episode 67: HA and Replication

2011-11-27
Length: 38s

This week, we talk about mysql ha and replication.

News/Feedback
Last week we talked about how we learn and keep up to date with changes to MySQL. Mark Grennan of mysqlfanboy.com posted his own list of MySQL resources.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

read more

x

Share: OurSQL Episode 67: HA and Replication


OurSQL Episode 66: Breaking the News Reels

2011-11-18
Length: 52s

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!

News
The Meet the MySQL Experts podcast is now on iTunes. So now you can subscribe to the feedburner feed or to the iTunes feed.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

read more

x

Share: OurSQL Episode 66: Breaking the News Reels


OurSQL Episode 65: Security Blanket - The Missing Link

2011-11-11
Length: 32s

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.

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA.

To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

read more

x

Share: OurSQL Episode 65: Security Blanket - The Missing Link


OurSQL Episode 64: Are We Normal Yet?

2011-11-07
Length: 31s

This week, we talk about 2NF, 3NF and a bit about normalization vs. denormalization.

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

Normalization
Book: An Introduction to Database Systems by CJ Date

read more

x

Share: OurSQL Episode 64: Are We Normal Yet?


OurSQL Episode 63: Snowing Already?

2011-10-29
Length: 24s

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.

News
FOSDEM has a call for papers open until Sunday, November 6th. FOSDEM is one of the largest free and non-commercial open source events, taking place in Brussels, Belgium on February 4th and 5th. There will be a Developer’s room that's near and dear to our hearts called "MySQL, MariaDB and friends".

read more

x

Share: OurSQL Episode 63: Snowing Already?


OurSQL Episode 62: Data Warehousing 101

2011-10-21
Length: 37s

Josh Berkus of PostgreSQL Experts spoke at OS Bridge this summer on Data Warehousing 101:
Everything you never wanted to know about big databases but were forced to find out anyway (http://it.toolbox.com/blogs/database-soup/data-warehousing-101-slides-video-up-47456 has video and slides)

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

read more

x

Share: OurSQL Episode 62: Data Warehousing 101


OurSQL Episode 61: Security Blankets, Part 2

2011-10-14
Length: 44s

We go over the open calls for papers, upcoming conferences, conversations with Oracle, and finish up our 2-part series on MySQL security.

Calls for papers:
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA.

To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

read more

x

Share: OurSQL Episode 61: Security Blankets, Part 2


OurSQL Episode 60: Charming Data

2011-10-12
Length: 33s

This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.

News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that relate to the MySQL community:

Oracle released a NoSQL database. http://www.oracle.com/technetwork/database/nosqldb/overview/index.html
It’s an ACID-compliant key-value data store, with a Java API for put, delete and get operations and includes replication. The data partitioning and distribution is automatic and based on a hash function.

read more

x

Share: OurSQL Episode 60: Charming Data


OurSQL Episode 59: Security Blankets, Part 1

2011-10-04
Length: 45s

This week, we talk about MySQL security.

News/Feedback
Collaborate Call for papers is open until Sunday October 14th - http://events.ioug.org/p/cm/ld/fid=15
Collaborate is an Oracle Technology and Applications conference put on by IOUG, OAUG and Quest. It is the largest independent Oracle conference, and we are planning on having a one-day track there. Collaborate is at the Mandalay Bay Convention Center in Las Vegas, Nevada from Sunday April 22nd - Thursday 26th, 2012.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, October 12, 2012 in Santa Clara, CA.

read more

x

Share: OurSQL Episode 59: Security Blankets, Part 1


OurSQL Episode 58: Opening up Oracle's World

2011-09-23
Length: 26s

The main content this week is previewing Oracle OpenWorld's MySQL sessions.

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! The call will close on Monday, December 5th. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

CouchConf NYC is happening on Monday, October 24th in New York City. CouchConf is a one-day conference focused on Couch NoSQL database technology for web and mobile applications. There will be numerous technology sessions presented by leaders of the Apache CouchDB project and other Couch experts.

read more

x

Share: OurSQL Episode 58: Opening up Oracle's World


OurSQL Episode 57: Eventual Discovery part 2

2011-09-19
Length: 36s

This week we continue our series on events. We talk about events and logging, event timing, privileges and runtime behavior.

Feedback
Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/ecryptfs, "eCryptfs is a POSIX-compliant enterprise-class stacked cryptographic filesystem for Linux".

The main topic is the 2nd part of events:

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), including how the "ignore" and "do" replication limitations work with events. Manual page: http://dev.mysql.com/doc/refman/5.5/en/stored-programs-logging.html

read more

x

Share: OurSQL Episode 57: Eventual Discovery part 2


OurSQL Episode 56: Eventual Discovery part 1

2011-09-09
Length: 32s

This week is all about events - events in MySQL, and calls for papers for 2012 conferences.

Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/

A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql.

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

read more

x

Share: OurSQL Episode 56: Eventual Discovery part 1


OurSQL Episode 55: MySQL Data Encryption

2011-09-02
Length: 28s

This week, we talk with Mike Frank of http://www.gazzang.com/, answer a question about ScaleBase and stored routines/triggers, and link to over 100 videos from OSCon, OSCon Data and OSCon Java.

OSCon Data and OSCon videos
The Technocation youtube playlist, as of the time of this publishing has 18 videos, mostly from OSCon Data, is at http://www.youtube.com/playlist?list=PLE0AEC3980A198DA0

The O'Reilly YouTube playlist, as of the time of this publishing has 84 videos, from OSCon, OSCon Data and OScon Java, is at http://www.youtube.com/playlist?list=93FC98105B19725C

read more

x

Share: OurSQL Episode 55: MySQL Data Encryption


OurSQL Episode 54: Scaling MySQL

2011-08-19
Length: 38s

This week, we discuss the Percona MySQL conference and scaling with ScaleBase.

Percona Live MySQL Conference and Expo event page, and Baron's announcement of the conference.

Dates to keep in mind:
September 1st - call for speakers opens
November 1st - call for speakers closes
Tuesday April 10th - Thursday April 12th

This week we interview Doron Levari, CEO and co-founder of ScaleBase. ScaleBase transparently scales your database, so you can have many shards without having to code sharding in your application. The sharding is completely transparent to the application. This can be combined with regular replication to have automatic use of a standby if a shard's primary database fails.

read more

x

Share: OurSQL Episode 54: Scaling MySQL


OurSQL Episode 53: MySQL 5.6 at OSCon Data

2011-08-09
Length: 26s

This week we speak with Calvin Sun, the Development Manager of the InnoDB Team, and has been working on InnoDB at MySQL and Oracle for 5 years. He mentions that not only is the InnoDB team hiring, but nobody has left the InnoDB team in several years, so the team is very stable.

We grabbed Calvin at OSCon Data, where Oracle announced the new features of MySQL 5.6 released on labs.mysql.com. Remember that the labs releases are for testing only and not supported in production use.

read more

x

Share: OurSQL Episode 53: MySQL 5.6 at OSCon Data


OurSQL Episode 52: Database Theory ABC

2011-07-24
Length: 22s

This week, we present ACID, BASE, CAP theorem and more.

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, and we present the first part, the theoretical side of things.

ACID - atomicity, consistency, isolation, durability
BASE- basically available, soft state, eventual consistency (there's also a good article by Lewis Cunningham that explains ACID vs. BASE in the context of cloud computing.

read more

x

Share: OurSQL Episode 52: Database Theory ABC


OurSQL Episode 51: Data Infrastructure at OSCon Data

2011-07-08
Length: 27s

This week, we talk about OSCon Data.

Strata (Big Data Conference) - Sept 19-23 in NYC http://strataconf.com/stratany2011 - the call for proposals is still open until July 15th.

OSCon, the Open Source Convention, is Jul 25 - Thu Jul 29th
Co-located this year:
OSCon Data
OSCon Java

OSCon Data content mentioned:
Hadoop

read more

x

Share: OurSQL Episode 51: Data Infrastructure at OSCon Data


OurSQL Episode 50: MySQL at Facebook, Current and Future

2011-06-28
Length: 48s

This week we post the audio from the closing keynote of Percona Live by Harrison Fisk of Facebook, "MySQL at Facebook, Current and Future". There is no ear candy this week.

x

Share: OurSQL Episode 50: MySQL at Facebook, Current and Future


OurSQL Episode 49: Stalking MySQL

2011-06-12
Length: 43s

Reminder: Due to busy summer conference schedules, we are going to be publishing the podcast every other week.

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, and items from the PROCESSLIST.

Nagios
pnp4nagios - from the site, "PNP is an addon for the Nagios Network Monitoring System. PNP provides easy to use, easy to configure RRDTools based performance charts feeded by the performance data output of the Nagios Plugins."

read more

x

Share: OurSQL Episode 49: Stalking MySQL


OurSQL Episode 48: Percona Live NYC 2011

2011-06-03
Length: 35s

This week we have feedback from Percona Live in NYC last Thursday. We talk with:

Chander Kant of Zmanda, talking about the fact that Zmanda Backup Recovery now officially supports the Percona patched binary of MySQL.
Barry Leung of CafeMom.com who talked about all the stuff he'd learned during the day, including "How to use MySQL and DTrace on Linux" and the new mk-tcp-model.

Patrick Galbraith of BlueGecko talked about his talk, "The Building Blocks of Scaling: Drizzle/MySQL, Memcached, Sphinx, and Gearman", backups, FLUSH ENGINE ____ LOGS, and covering indexes.

read more

x

Share: OurSQL Episode 48: Percona Live NYC 2011


OurSQL Episode 47: Replication logs and objects

2011-05-30
Length: 29s

This week, we talk about replication logs and replication objects.

Feedback: Via Henrik Ingo
- Drizzle has microsecond granularity for timestamp. MariaDB just
developed a patch for that, in the 5.3 tree.

http://docs.drizzle.org/date_time_data_types.html
http://kb.askmonty.org/search/?q=microsecond
http://kb.askmonty.org/v/what-is-mariadb-53
editors note: updated with a specific link from Henrik

More Replication

Purging binary logs:
manual:
PURGE BINARY LOGS TO ‘mysql-bin.12345’;
PURGE BINARY LOGS BEFORE ‘datetime’; (can use string or date expression, like NOW()-interval 5 DAY)

read more

x

Share: OurSQL Episode 47: Replication logs and objects


OurSQL Episode 46: It's About Time

2011-05-21
Length: 35s

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 talk about how to handle and store microseconds in MySQL.

From the MySQL manual:
date and time types
TIMESTAMP properties and how it is stored in UTC transparently in the database
ALLOW_INVALID_DATES sql_mode

read more

x

Share: OurSQL Episode 46: It's About Time


OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)

2011-05-13
Length: 25s

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).

read more

x

Share: OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)


OurSQL Episode 44: Elemental Replication (Tungsten, that is)

2011-05-06
Length: 40s

Last week's podcast, containing an overview of replication

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. Tungsten Replicator won Application of the Year award at the 2011 O'Reilly MySQL Conference.

read more

x

Share: OurSQL Episode 44: Elemental Replication (Tungsten, that is)


OurSQL Episode 43: Repli-cans and repli-can'ts

2011-05-02
Length: 46s

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.

Slave IO thread states in SHOW PROCESSLIST
mk-table-checksum
MIXED binary log format defaults to STATEMENT, unless certain conditions apply, which are listed at that link.

read more

x

Share: OurSQL Episode 43: Repli-cans and repli-can'ts


OurSQL Episode 42: The Buzz about MySQL 5.6

2011-04-22
Length: 32s

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

x

Share: OurSQL Episode 42: The Buzz about MySQL 5.6


OurSQL Episode 41: Zmanda [backup series #6]

2011-04-07
Length: 31s

Previously in the backup series:

Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup

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.

read more

x

Share: OurSQL Episode 41: Zmanda [backup series #6]


OurSQL Episode 40: TokuDB 5.0 part 2

2011-04-01
Length: 39s

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.

read more

x

Share: OurSQL Episode 40: TokuDB 5.0 part 2


OurSQL Episode 39: TokuDB 5.0 part 1

2011-03-25
Length: 33s

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.

read more

x

Share: OurSQL Episode 39: TokuDB 5.0 part 1


OurSQL Episode 38: Xtrabackup (Backup Series #5)

2011-03-18
Length: 17s

Previous podcasts in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)

Special Guest Valentine Gostev, QA engineer at Percona, talks about Percona's Xtrabackup, an open source tool for consistent online physical backup of InnoDB and XtraDB.

read more

x

Share: OurSQL Episode 38: Xtrabackup (Backup Series #5)


OurSQL Episode 37: It's Still Not Our (De)fault! Part 2

2011-03-11
Length: 50s

This week, Giuseppe Maxia joins us as a special guest and we complete our 2-part series on what we always put in our configuration files, and why.
Part 1 in the series.

strings man page
MySQL manual page about defaults-group-suffix
Giuseppe's article about the hidden options file trick

Logging:
log_error

read more

x

Share: OurSQL Episode 37: It's Still Not Our (De)fault! Part 2


OurSQL Episode 36: It's Not Our (De)fault! Part 1

2011-03-04
Length: 40s

Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL's pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we change.

About the Configuration File
Location and precedence of configuration files for Windows, Unix and Mac OS X:
http://dev.mysql.com/doc/refman/5.5/en/option-files.html

Note: We use the term "directive" to refer to the groups of options that begin with [groupname]. Upon reading the manual page again, we realized that the term is actually "option group". (Sheeri takes complete blame for this -- "directive" is actually the term for what !includedir and !include are...)

read more

x

Share: OurSQL Episode 36: It's Not Our (De)fault! Part 1


OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)

2011-02-25
Length: 48s

This week, we discuss advanced mysqldump options, ear candy comparing NOW() vs. SYSDATE(), and the Manga Guide to Databases.

Previous podcasts in the series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)

ERRATA:
Giuseppe Maxia points out via twitter "The mysqldump option to skip table creation is not '--no-create-table' but '--no-create-info' " -- he's right!

read more

x

Share: OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)


OurSQL Episode 34: Collaborating

2011-02-17
Length: 32s

We talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference.

Show notes:
Collaborate - http://collaborate11.ioug.org/
Sunday, April 10th through Thursday, April 14th in Orlando, Florida.
$200 off with code: MYSQ
Pricing can be found at http://collaborate11.ioug.org/Home/Registration/tabid/82/Default.aspx#rates

MySQL Community Dinner East at Maggiano's Little Italy on Sunday, April 10th at 5 pm. RSVP at http://2011mysqlcommunitydinnereast.eventbrite.com/

read more

x

Share: OurSQL Episode 34: Collaborating


OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)

2011-02-11
Length: 45s

Previous podcasts in the backup series:
Backup Series #1: Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)

Show Notes:

This week we have Lenz Grimmer with us to speak about snapshot backups in general, MySQL backups with snapshots, and mylvmbackup, a script Lenz wrote and maintains to easily take consistent MySQL snapshot backups.

Rate/review us in iTunes (website with a link to open in iTunes, or link to iTunes [may not work in Chrome, does work in Firefox]).

read more

x

Share: OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)


OurSQL Episode 32: Backup tools you already have [Backup series #2]

2011-02-03
Length: 40s

This week we continue our series on backup tools, we talk about the backup tools that ship with MySQL.

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.

read more

x

Share: OurSQL Episode 32: Backup tools you already have [Backup series #2]


OurSQL Episode 31: The MySQL Ecosystem

2011-01-27
Length: 24s

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.

Some parts of the MySQL Ecosystem that were mentioned:
phpmyadmin
Percona Server
Percona free InnoDB hot backup tool

read more

x

Share: OurSQL Episode 31: The MySQL Ecosystem


OurSQL Episode 30: Backup Glossary (Backup Series #1)

2011-01-20
Length: 42s

This week, we start a series on backups by talking about backup concepts.

[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]

A slave is not a backup, although a slave can be used to get backups more easily.
You don't test backups, you test restores.
logical vs. physical
cold vs. hot vs. warm
consistent vs. inconsistent

strings(1) - Linux man page
"A foolish consistency is the hobgoblin of little minds" - Ralph Waldo Emerson [note: Sheeri misquotes this as "Consistency is the hobgoblin of little minds"]

read more

x

Share: OurSQL Episode 30: Backup Glossary (Backup Series #1)


OurSQL Episode 29: Subpar Subqueries

2011-01-14
Length: 38s

This week, we discuss how & why to optimize mysql subqueries.

OpenDatabaseCamp, also known as OpenSQLCamp - http://planet.mysql.com/entry/?id=26922 will be held in Sardinia, Italy on May 6-7-8, 2011.
Google Group for OurSQLCamp: http://groups.google.com/group/opensqlcamp

Manual chapter for subqueries in MySQL - http://dev.mysql.com/doc/refman/5.1/en/subqueries.html

The WorkLog entries for “subquery” http://forge.mysql.com/worklog/search.php?t=tds&k=subquery&v=0&s=0&p=0
All are low/medium priority. out of 29 worklog items, 9 are complete, almost all are scheduled for 6.0. Of the remaining 20, 1 is in progress, 4 are in the in-design stage, another 4 are simply “assigned”, 11 are unassigned. None are on hold or cancelled, so that’s good.

read more

x

Share: OurSQL Episode 29: Subpar Subqueries


OurSQL Episode 28: Conferential Integrity

2011-01-06
Length: 22s

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.

read more

x

Share: OurSQL Episode 28: Conferential Integrity


OurSQL Episode 27: To SQL or No[tto]SQL, that is the question

2010-12-22
Length: 34s

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 have to:

read more

x

Share: OurSQL Episode 27: To SQL or No[tto]SQL, that is the question


OurSQL Episode 26: Zombies!

2010-12-16
Length: 38s

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

read more

x

Share: OurSQL Episode 26: Zombies!


Drizzle Podcast #1

2009-02-25 :: Technocation, I
Length: 25s

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/

read more

x

Share: Drizzle Podcast #1


OurSQL Episode 24: The Sun is Shining

2008-01-17
Length: 12s

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

read more

x

Share: OurSQL Episode 24: The Sun is Shining


OurSQL Episode 23: Back To School

2007-10-03 :: Technocation, In
Length: 12s

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/

x

Share: OurSQL Episode 23: Back To School


OurSQL Episode 22: Things To Avoid With MySQL Querie

2007-08-16 :: Technocation, I
Length: 16s

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

x

Share: OurSQL Episode 22: Things To Avoid With MySQL Querie


OurSQL Episode 21: The Rise of the MySQL DBA

2007-08-08 :: Technocation, In
Length: 15s

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

x

Share: OurSQL Episode 21: The Rise of the MySQL DBA


OurSQL Episode 20: The Pythian Group

2007-08-02 :: Technocation, In
Length: 27s

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

x

Share: OurSQL Episode 20: The Pythian Group


OurSQL Episode 19: MySQL Proxy

2007-07-24 :: Technocation, In
Length: 26s

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:

x

Share: OurSQL Episode 19: MySQL Proxy


OurSQL Episode 18: De-myth-tifying Indexes

2007-07-12 :: Technocation, In
Length: 21s

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:

read more

x

Share: OurSQL Episode 18: De-myth-tifying Indexes


OurSQL Episode 17: Hashing it out

2007-05-30 :: Technocation, In
Length: 12s

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

read more

x

Share: OurSQL Episode 17: Hashing it out


OurSQL Episode 16: The Art of Innovation, Guy Kawasaki

2007-05-10 :: Technocation, In
Length: 49s

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/

read more

x

Share: OurSQL Episode 16: The Art of Innovation, Guy Kawasaki


OurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conference

2007-05-05 :: Technocation, I
Length: 35s

"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/

read more

x

Share: OurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conference


OurSQL Episode 14: The MySQL Conference & Expo

2007-04-26 :: Technocation, In
Length: 16s

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

x

Share: OurSQL Episode 14: The MySQL Conference & Expo


OurSQL Episode 13: The Nitty Gritty of Indexes

2007-04-21 :: Technocation, I
Length: 19s

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:

x

Share: OurSQL Episode 13: The Nitty Gritty of Indexes


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

2007-04-13 :: Technocation, In
Length: 22s

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:
h

x

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


OurSQL Episode 11: Catching Up

2007-04-09 :: Technocation, In
Length: 14s

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:

read more

x

Share: OurSQL Episode 11: Catching Up


OurSQL Episode 10: How About Some Cache?

2007-03-09 :: Technocation, In
Length: 13s

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

x

Share: OurSQL Episode 10: How About Some Cache?


OurSQL Episode 9: Jay Speaks About the MySQL Conference

2007-02-27
Length: 18s

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).

read more

x

Share: OurSQL Episode 9: Jay Speaks About the MySQL Conference


OurSQL Episode 8: Basic MySQL Security

2007-02-11 :: Technocation, Inc
Length: 21s

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.

read more

x

Share: OurSQL Episode 8: Basic MySQL Security


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

2007-01-30 :: Technocation, Inc
Length: 19s

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

read more

x

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


OurSQL Episode 6: Falcon, Part 2

2007-01-15 :: Technocation, In
Length: 15s

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/

read more

x

Share: OurSQL Episode 6: Falcon, Part 2


OurSQL Episode 5: Falcon, Part 1

2007-01-14 :: Technocation, In
Length: 15s

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

read more

x

Share: OurSQL Episode 5: Falcon, Part 1


OurSQL Episode 4: Cluster From Down Under

2007-01-03 :: Technocation, In
Length: 20s

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

read more

x

Share: OurSQL Episode 4: Cluster From Down Under


OurSQL Episode 3: Your Database on ACID

2006-12-19 :: Technocation, In
Length: 15s

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=19...

read more

x

Share: OurSQL Episode 3: Your Database on ACID


OurSQL Episode 2: Wild Performance Tips

2006-12-14 :: Technocation, I
Length: 15s

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...

read more

x

Share: OurSQL Episode 2: Wild Performance Tips


OurSQL Episode 1: Backups, Backups Everywhere

2006-12-05
Length: 26s

We have done a series of podcasts on backups that cover the topic much more thoroughly:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup
Backup Series #6: Zmanda

read more

x

Share: OurSQL Episode 1: Backups, Backups Everywhere


OurSQL Episode 0: MySQL Community Podcast

2006-11-27 :: Technocation, In
Length: 17s

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

x

Share: OurSQL Episode 0: MySQL Community Podcast


OurSQL: MySQL Database Community Podcast

OurSQL Podcast

OurSQL:  MySQL Database Community Podcast


Switch to our mobile site