Jason Hull of OpenSource Connections, a company in my town, posted an article on what Sun’s acquisition of MySQL means for the US government. I thought Planet MySQL readers might appreciate a different angle on the issue than many of the Planet MySQL posts, which are often focused on business or community more than government. (I’m just passing the link along, not agreeing or disagreeing).

Arjen and Stewart are on stage, and there’s an introduction session going on now. We’re now, introducing the ex-MySQLers (Arjen), and MySQLers (Stewart, Giuseppe, me). Trent has just walked in, so that makes all the MySQLers that are around at linux.conf.au.

Highlights of some of the attendees:

• A user from LG, who has been using MySQL for about 3 years now
• An technology manager in defense, interested in MySQL as an education exercise
• A MySQL user for over 8 years
• Systems administrator who’s been heavily using MySQL for 5 years, however with a total of about 8 years of use
• Systems administrator at IBM, using MySQL for a long time
• Travel startup in the Gold Coast, doing lots of MySQL, replication, proxy use
• A software engineer at HP, in China, and they use MySQL for benchmarking on HP hardware
• A Connector/J user
…

I passed the MySQL 5.0 DBA I and II certification tests today with very nice results. Just figured I’d post that so it’s verifiable that I’m not entirely spewing nonsense and general rabble. Today is a good day, and I will celebrate with the finest wines, and choicest of meats.

Exam Date: Monday, January 28, 2008 at 9:00 AM
Candidate: Matthew Reid
Candidate ID: MYSQL005372
Registration #: xxxxx2740
Exam Series: 005-002
Exam: Certified MySQL 5.0 DBA Part I
Validation #: xxxxx5662
Grade: pass

Exam Date: Monday, January 28, 2008 at 10:30 AM
Candidate: Matthew Reid
Candidate ID: MYSQL005372
Registration #: xxxxx7164
Exam Series: 006-002
Exam: Certified MySQL 5.0 DBA Part II
Validation #: xxxxxx5956
Grade: pass

Just a few hours ago, Fotolog crossed the 400,000,000 photos milestone. Considering that free members can only upload one photo a day, that's a lot of dedication by 14.5 million members (and growing).

What they need the most in the short term is someone who could do customer support between 3am and 11am, London time, so someone in Australia would be perfect

Do you happen to know anyone who might be interested in the job?

Ideally it would be someone who’s familiar with web technologies (web, DNS, e-mail servers), linux and maybe some web frameworks (Django, Rails,. ..).

The candidate would be doing customer support (answering tickets) but if they’re interested they could also do sysadmin work or even development work.

see the webfaction job page for more details

Great news! Monty released Maria, the new transactional storage engine for MySQL. This is fantastic news! I can't wait to try it out. I remember when it was in the planning stage. Now it's here!

http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html

First saw this off of Planet MySQL:

 New Vendor Neutral Database Certification (Dave's Stuff)

Following the link to the CIW site, there are six domains that are being tested:

1. Relational Database Fundamentals
2. Relational Database Design and Application
3. Normalization and Database Design
4. Structured Query Language (SQL)
   
5. Relational Algebra and Databases
6. Transactions, Concurrency Control and Security

I wonder how much traction this independent certification will get, given the flavors each of the various database platforms use of SQL and …

A friend asked for this, so I thought it’d be helpful: All tables with no primary key:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c ON (t.TABLE_NAME=c.TABLE_NAME AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA AND constraint_name='PRIMARY') WHERE t.table_schema!="information_schema" AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, c.column_name,c.constraint_name from TABLES AS t LEFT JOIN [...]

Lefred pointed us to O'Reilly Maker

This one really is my preferred one

It's sad, but so true.

This Nokia rant makes me wonder where the Mac version is.

Didn't Scott Adams already write this one ?

That's Wally right ? :)

And even the IT Crowd also has it's own manual already.

Dave wrote about new vendor neutral database certification, or as I like to call it "Jack-of-all-trades-but-master-of-none certification "