MySQL is looking for a top-notch certification exam writer for authoring MySQL certification exams. You must be a self-starter, able to work effectively and independently in a virtual setting, delivering consistently high-quality questions and answers. This full-time position is available for qualified candidates world-wide. See http://www.mysql.com/company/jobs/cert-exam-writer.html for details. More MySQL jobs at http://www.mysql.com/company/jobs/
From a fab idea by Roland Bouman, I just created a new forum Data Modelling and Database Design in the MySQL Forums. An important topic indeed. Enjoy! And do keep it practical… 3NF is very decent for most purposes.
Following up on my post from last week… http://openquery.com/blog/hordes-schema Looking at the comments, I think people got the point. It’s not a nice design. And yes, the large varchar id fields are in fact used as foreign keys in the overall schema, so the result is very inefficient in terms of storage, disk access requirements, [...]
In SQL RDBMS land, people often talk about relations when they actually mean relationships. Sometimes the meaning is clear from the context, but that’s not always the case; so I thought it might be helpful to know which is which and why: You may be surprised to learn that: relation = set = table. It’s [...]
Homework! Below is a fairly random extract from the database schema of Horde 3.0.7… what’s wrong with this: CREATE TABLE horde_prefs ( pref_uid VARCHAR(200) NOT NULL, pref_scope VARCHAR(16) NOT NULL DEFAULT ”, pref_name VARCHAR(32) NOT NULL, pref_value LONGTEXT NULL, PRIMARY KEY (pref_uid, pref_scope, pref_name) ); Please post your insights and conclusions as comments to this [...]
One slightly older than the other. One credited with inventing the spreadsheet, the other possibly the first geek in space. These days, Mitch “Lotus 1-2-3″ Kapor is very involved in online collaboration of the kind that Wikipedia displays. Mark Shuttleworth, South African cosmonaut and founder of Thawte, is behind one of the fastest growing Linux [...]
So you’ve read about at least some of the many sessions that will be at the MySQL Users Conference, but want to see the grand picture? No worries, there is The Grid! Yes it’s big, there will be choices to make as an attendee. But I’ve tried to schedule things in such a way that [...]
We’re pleased to also have Mark Spencer, creater of the Asterisk PBX software and founder of Digium, at the MySQL Users Conference, 24-27 April (Santa Clara, CA). Asterisk is very popular with home users, but big VoIP providers like Vonage also use Asterisk, and MySQL of course. It’s important infrastructure stuff! Mark’s session is entitled [...]
At MySQL Users Conference 2006, Johan Andersson will be teaching a 3 hour tutorial on MySQL Cluster. Johan is a cluster expert with a wealth of practical experience from his daily work as sales engineer at MySQL AB. If you are thinking about deploying MySQL Cluster, or just want to learn more about it, this [...]
Yes, part 0 Situation: this stuff appears to be a disaster zone, docs/config wise. Lots of HOWTOs online, but mostly for older versions with different config requirements. And to make things more interesting, most don’t mention which versions they refer to! So much fun… So the question is, who has got this working with say [...]