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://technocation.org/forum
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://technocation.org/forum
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.
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:
Download all podcasts at:
Subscribe to the podcast at:
Google Summer of Code Home Page:
MySQL Summer of Code Ideas:
MySQL Summer of Code Accepted Projects:
Direct play this episode at:
Download all podcasts at:
Subscribe to the podcast at:
Google Summer of Code Home Page:
MySQL Summer of Code Ideas:
MySQL Summer of Code Accepted Projects:
Direct play this episode at:
http://technocation.org/content/oursql-episode-11%3A-catching-0
Download all episodes at:
http://technocation.org/podcasts/oursql/
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://technocation.org/forum
Direct play this episode at:
http://technocation.org/content/oursql-episode-11%3A-catching-0
Download all episodes at:
http://technocation.org/podcasts/oursql/
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://technocation.org/forum
This week I talk about the MySQL Query Cache.
Direct play the podcast here:
http://technocation.org/content/oursql-episode-10%3A-how-about-some-cache%3F-0
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
This week I talk about the MySQL Query Cache.
Direct play the podcast here:
http://technocation.org/content/oursql-episode-10%3A-how-about-some-cache%3F-0
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
This week I spoke with Jay Pipes about the upcoming MySQL Conference, April 23-26 in Santa Clara, California, USA.
Direct play the podcast here:
http://technocation.org/content/oursql-episode-9%3A-jay-speaks-about-mysql-conference
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
This week I spoke with Jay Pipes about the upcoming MySQL Conference, April 23-26 in Santa Clara, California, USA.
Direct play the podcast here:
http://technocation.org/content/oursql-episode-9%3A-jay-speaks-about-mysql-conference
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
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://technocation.org/forum
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://technocation.org/content/oursql-episode-8%3A-basic-mysql-security-0
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://technocation.org/forum
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
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://technocation.org/forum
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://technocation.org/content/oursql-episode-8%3A-basic-mysql-security-0
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://technocation.org/forum
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
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://technocation.org/content/oursql-episode-6%3A-falcon%2C-part-2-0
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://technocation.org/forum
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://technocation.org/content/oursql-episode-6%3A-falcon%2C-part-2-0
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://technocation.org/forum
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://technocation.org/content/oursql-episode-5%3A-falcon%2C-part-1-0
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.
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://technocation.org/content/oursql-episode-5%3A-falcon%2C-part-1-0
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.