Providing educational resources and monetary grants to IT professionals.

The Value of Vendor-Neutral Database Certification

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. Now, the specifics of how a query optimizer handles queries, how backups, restores and security are done and with MySQL specifically, how different storage engines act are [...]

What Applications Are Good For MySQL Cluster?

Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an [...]

Special Interview with Brian Aker of MySQL

Play or download the podcast here: http://technocation.org/content/oursql-episode-24%3A-sun-shining
OurSQL Episode 24: “The Sun is Shining”
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 [...]

OurSQL Episode 24: The Sun is Shining

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

OurSQL Podcast Interviewing Brian Aker — What Are Your Questions?

At 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL.
If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment [...]

OK, Now I Am a Bit Worried

SUN Microsystems just bought MySQL, see the announcement at http://www.sun.com/aboutsun/pr/2008-01/sunflash.20080116.1.xml
Now, MySQL isn’t going away any time soon; there are just way too many people that use it. And while Postgres is not actually owned by SUN, they do employ some great folks to develop on it, and those folks are the the “known” Postgres [...]

Duplicate binlog-do-db entry — Solution

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this:
(copied from http://lists.mysql.com/replication/607)

master my.cnf:
binlog-do-db=db1

slave my.cnf:
replicate-do-db=db1;

Relevant show slave status output

Replicate_Do_DB: db1;,db1;

Handler_read_first MySQL Haiku

I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW [...]

SHOW VARIABLES Shows Variables MySQL Does Not Know About

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir="/data/mysql/data";
ERROR 1193 (HY000): Unknown system variable 'innodb_data_home_dir'

mysql> set session innodb_data_home_dir="/data/mysql/data";
ERROR [...]

Replication Presentation at the November 2007 Boston MySQL User Group

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker's DBIx::Password

Giuseppe Maxia's article about federated tables -- I think that's the right one, feel free to comment if it's not.

Pages