Musings on topics including product management, tech, art.
In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….
You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”
Anyone have anything they can add to the list?
In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….
You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”
Anyone have anything they can add to the list?
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
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
Well, it’s official:
http://code.google.com/soc/mysql/about.html
I am officially mentoring 2 students for MySQL, AB for the Google Summer of Code. I have great hopes for the MySQL Auditing Software. My first tasks: familiarize myself with different types of regulations such as Sarbanes-Oxley and HIPAA, and the MySQL Coding Standards.
This summer is going to be great!
Well, it’s official:
http://code.google.com/soc/mysql/about.html
I am officially mentoring 2 students for MySQL, AB for the Google Summer of Code. I have great hopes for the MySQL Auditing Software. My first tasks: familiarize myself with different types of regulations such as Sarbanes-Oxley and HIPAA, and the MySQL Coding Standards.
This summer is going to be great!
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/my
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=9
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/24
Eric Bergen’s -auto-vertical-output patch:
http://ebergen.net/wordpress/2007/0
Tim O’Reilly talks about why he joined the MySQL Board of Directors:
http://radar.oreilly.com/archives/2
Microsoft’s Port 25 has a MySQL plugin for Visual Studio
http://port25.technet.com/archive/2
Also how to install MySQL on Windows:
http://port25.technet.com/archive/2
Learning Resource:
How to efficiently write a MySQL Stored Procedure
http://www.ruturaj.net/tutorials/my
Download MySQL GUI Tools
http://dev.mysql.com/downloads/gui-tool
Feature: Book Review:
Learning MySQL
http://desicritics.org/2007/04/02/00472
MySQL Cookbook
http://desicritics.org/2007/04/03/00333
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/Shee
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/my
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=9
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/24
Eric Bergen’s -auto-vertical-output patch:
http://ebergen.net/wordpress/2007/0
Tim O’Reilly talks about why he joined the MySQL Board of Directors:
http://radar.oreilly.com/archives/2
Microsoft’s Port 25 has a MySQL plugin for Visual Studio
http://port25.technet.com/archive/2
Also how to install MySQL on Windows:
http://port25.technet.com/archive/2
Learning Resource:
How to efficiently write a MySQL Stored Procedure
http://www.ruturaj.net/tutorials/my
Download MySQL GUI Tools
http://dev.mysql.com/downloads/gui-tool
Feature: Book Review:
Learning MySQL
http://desicritics.org/2007/04/02/00472
MySQL Cookbook
http://desicritics.org/2007/04/03/00333
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/Shee
Or use the Technocation forums:
http://technocation.org/forum
Technocation is proud to announce its first grant to help further the goals of IT professionals. We have helped Proven Scaling’s “Free Ride” to give three people all-expense paid trips to the MySQL conference happening at the end of April. We are proud to have been able to grant Proven Scaling $300 to help, and we hope this is the first of many monetary grants we will give.
Congratulations to the Free Ride winners:
Jan Lehnardt, a student from Münster, Germany; J.R. Bullington, from a non-profit in Sterling Heights, Michigan, USA; and Carlos Proal Aguilar, from a non-profit in Puebla, Mexico. For more details on the contest winners, see Proven Scaling’s announcement at http://jcole.us/blog/archives/2007/03/31/mysql-conference-expo-free-ride-winners/
This grant was made possible by everyone who donated to the MySQL Conference Scholarship Fund, announced January 30th, 2007 at http://technocation.org/content/donate-mysql-users-conference-scholarship-fund%21
If you would like to donate to Technocation, please visit our donation page at http://technocation.org/content/donate-now. Your contribution is tax-deductible to the fullest extent of the law. Technocation is a not-for-profit organization incorporated in Massachusetts, USA, dedicated to providing resources and grants for IT professionals. Learn more about us by visiting Technocation’s FAQ page at: http://technocation.org/category/topics/faqs.
Technocation is proud to announce its first grant to help further the goals of IT professionals. We have helped Proven Scaling’s “Free Ride” to give three people all-expense paid trips to the MySQL conference happening at the end of April. We are proud to have been able to grant Proven Scaling $300 to help, and we hope this is the first of many monetary grants we will give.
Congratulations to the Free Ride winners:
Jan Lehnardt, a student from Münster, Germany; J.R. Bullington, from a non-profit in Sterling Heights, Michigan, USA; and Carlos Proal Aguilar, from a non-profit in Puebla, Mexico. For more details on the contest winners, see Proven Scaling’s announcement at http://jcole.us/blog/archives/2007/03/31/mysql-conference-expo-free-ride-winners/
This grant was made possible by everyone who donated to the MySQL Conference Scholarship Fund, announced January 30th, 2007 at http://technocation.org/content/donate-mysql-users-conference-scholarship-fund%21
If you would like to donate to Technocation, please visit our donation page at http://technocation.org/content/donate-now. Your contribution is tax-deductible to the fullest extent of the law. Technocation is a not-for-profit organization incorporated in Massachusetts, USA, dedicated to providing resources and grants for IT professionals. Learn more about us by visiting Technocation’s FAQ page at: http://technocation.org/category/topics/faqs.
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:
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:
For those that follow Daylight Savings Time in the US and Canada, watch out this weekend, because we “spring forward”!
The biggest caveat I have is: Do not arrive 1 hour late to work on Sunday or Monday.
As for MySQL, to test if you are fine, run:
SELECT @@global.time_zone;
If you get back “SYSTEM”, then MySQL is looking to the OS for timezone data, which is the default.
The real sanity check:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), UNIX_TIMESTAMP('2007-03-11 03:00:00');
This should return the same value, even though you are feeding it different times, because this is when the 1 hr change occurs. If not, and you’ve played with timezone data, remember that timezone data is only loaded when MySQL starts, so if you haven’t restarted MySQL since you patched your OS, you need to do that.
This is mostly stolen from a MySQL list post I found here:
For those that follow Daylight Savings Time in the US and Canada, watch out this weekend, because we “spring forward”!
The biggest caveat I have is: Do not arrive 1 hour late to work on Sunday or Monday.
As for MySQL, to test if you are fine, run:
SELECT @@global.time_zone;
If you get back “SYSTEM”, then MySQL is looking to the OS for timezone data, which is the default.
The real sanity check:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), UNIX_TIMESTAMP('2007-03-11 03:00:00');
This should return the same value, even though you are feeding it different times, because this is when the 1 hr change occurs. If not, and you’ve played with timezone data, remember that timezone data is only loaded when MySQL starts, so if you haven’t restarted MySQL since you patched your OS, you need to do that.
This is mostly stolen from a MySQL list post I found here:
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
http://www.webpronews.com/topnews/2007/02/26/techcrunch-others-love-linux-mysql
I’m not quite sure what to say about this article, except that a sample of 7 “big” sites showed that the LAMP[hp] stack was heavily used. Perhaps, “And this is news?”
http://www.webpronews.com/topnews/2007/02/26/techcrunch-others-love-linux-mysql
I’m not quite sure what to say about this article, except that a sample of 7 “big” sites showed that the LAMP[hp] stack was heavily used. Perhaps, “And this is news?”
The February Boston MySQL User Group meeting was great! I spoke about MySQL security; you can now download the slides and the video. I continue to be impressed with the sound quality of the video camera I have, I was pretty good about repeating the question folks asked, but you can clearly hear it in the audio (well, I could when I was wearing headphones, but I also have pretty bad hearing).
Special thanks to http://technocation.org for hosting the bandwidth for the videos.
Topics covered in the talk:
ACLs
Test dbs & anonymous accounts
OS files and permissions
Application data flow
SQL Injection
XSS (Cross-site scripting)
PDF of slides (1.4M):
http://www.sheeri.com/presentations/MySQLSecurity2007_02_08.pdf
Slides in Flash (107K):
http://www.sheeri.com/presentations/MySQLSecurity2007_02_08.swf
Video of presentation (large, 289M)
http://technocation.org/videos/original/mysqlsecurity2007_02_08large.wmv
Video of presentation (small, 27M)
http://technocation.org/videos/original/mysqlsecurity2007_02_08small.wmv
The February Boston MySQL User Group meeting was great! I spoke about MySQL security; you can now download the slides and the video. I continue to be impressed with the sound quality of the video camera I have, I was pretty good about repeating the question folks asked, but you can clearly hear it in the audio (well, I could when I was wearing headphones, but I also have pretty bad hearing).
Special thanks to http://technocation.org for hosting the bandwidth for the videos.
Topics covered in the talk:
ACLs
Test dbs & anonymous accounts
OS files and permissions
Application data flow
SQL Injection
XSS (Cross-site scripting)
PDF of slides (1.4M):
http://www.sheeri.com/presentations/MySQLSecurity2007_02_08.pdf
Slides in Flash (107K):
http://www.sheeri.com/presentations/MySQLSecurity2007_02_08.swf
Video of presentation (large, 289M)
http://technocation.org/videos/original/mysqlsecurity2007_02_08large.wmv
Video of presentation (small, 27M)
http://technocation.org/videos/original/mysqlsecurity2007_02_08small.wmv