Once in a while I hear people talking about using thousands or tens of thousands of tables in one MySQL database and often how it “doesn’t work”. There are two things to say to them:

• Are you nuts?!
• Sure it works

I’ll elaborate a little on both …

Why’d you do that? Are you nuts?!

In most cases when extraordinarily many tables are brought up the “correct answer” is: Fix your schema to not duplicate the same table layout for each customer/user/site/…!

Once in a while though there are good reasons to have way too many lots of tables. Even “takes too long to fix the application now” can be a good enough answer sometimes.

My use case was to use the many tables as an extra “index” for a situation that a regular index couldn’t cover. Tens of thousands of tables, here we come.

…

Today was a mini-Pythian day at RMOUG. Both Alex and myself gave two presentations each. My first session was on using LDAP with Oracle Applications. It was at 8:30am and there were a few brave souls that fought the snow and icy road conditions to make it. The group was small and I was pleasantly surprised that almost everyone in the room indicated that they were currently using LDAP, although most were NOT using Oracle LDAP offering ( Oracle Internet Directory).

George Trujillo was presenting on MySQL for the Oracle DBA in the same room, so I stayed and learned a few things. Although I must have been really tired as I missed his comments on the Blackhole engine for database replication. George also shared some of his experiences from customer sites visits. All in all, I am glad I stayed.

Riyaj Shamsudeen had an interesting session on De-bunking the Myths about redo-undo-rollback. I enjoyed this presentation style of making an …

Thanks to Tony Lawrence for inspiring today’s post. Hopefully these links don’t stink. 

Anthony Lawrence: Reasons I Don’t Like Social Media

Tools that once were valuable for pointing out the best of the web often become obsolete or spammy (you might say this about Digg). Tony’s example is StumbleUpon, a link sharing site that I love.  He contends that the social networking site has become clogged with junk or at least doesn’t provide consistent "quality" links. [Updated: Actually check the post comments for …

No, this is not a blog post on the endless battle between end user and developers as a result of them not understanding each other. No, this post is about "what determines the value of a software/service company". Is it the number of end users or the developers/service people?

Lets start off with a made up example: What would MySQL AB be worth if, lets say Microsoft and not Sun would have bought it? Microsoft would have gotten a ton of users this way. Maybe it would have been worth the price just for an opportunity to try and kill a competitor (this would of course only partially work due to MySQL's GPL nature). How many developers would quit their jobs? How would that affect the future of the product? Ultimately I would expect the chances for a MySQL product and related services to go down considerably because key developers leaving would diminish end user trust and they would spearhead the creation of alternatives.

Now what …

I’ve been coding a couple of scripts that run on 5 minute intervals to grab RSS/Atom feed data from http://mysql-dba.com and import that into a MySQL database. It idea is to create a search function for the site that will look at all past data from the aggregated feeds. Since there are multiple pollers running at different intervals I decided to use Innodb for the read/write nature of the poller/processing scripts.

This is very simple so far - and as such I felt it should be documented from the start unlike many of my other projects. Here’s the feed table that is storing the information from the RSS feeds.


mysql> show create table feed_items\G
*************************** 1. row ***************************
Table: feed_items
Create Table: CREATE TABLE `feed_items` (
`id` bigint(20) NOT NULL auto_increment,
`rss_site_id` int(11) …

IBM plans a residency to write a Redbook about the IBM DB2 for i5/OS as a Database Engine for MySQL:

Seize this opportunity to be among the first, elite IBM System i professionals worldwide to gain hands-on and practical experience with the MySQL on i5/OS. Working alongside and exchanging knowledge with some of the top database experts in the System i, you will develop a competitive edge that will serve you well in successful service delivery to System i clients. MySQL is used extensively with opensource PHP applications. As our customers deploy PHP web applications, many of them are looking to run MySQL as well.

The …

Yesterday’s Pop Quiz seemed quite popular, I got some personal responses and a couple of funny comments.

So here’s another one:

The table t is defined thusly on a MySQL server with no sql modes set:

  CREATE TABLE t (
   id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
  );

You now do…

  INSERT INTO t (id) VALUES (NULL);
  SELECT * FROM t WHERE id IS NULL

What will be the result of the SELECT?

Spanish translation by Marcos Besteiro
(more…)

I've been doing a lot of work lately on behalf of clients who are looking to deploy applications to virtual data centers. When I first started working as a technology consultant in the '90s, it was a given that if you wanted to have a web application, you had to buy a bunch of servers and rent out a cabinet in a data center somewhere. Now the notion of spending all that money on hardware that will go obsolete in a few years seems like insanity most of the time (particularly when the size of the audience for your application is completely unknown). When I first started a hosted web service in 1999 people judged us by how many servers my company owned. Now when I tell them "we don't own any servers at all" they nod knowingly.

It's great that we have more cost-efficient virtualization options today than we had ten years ago. Unfortunately, though, virtualization is a disruptive technology, which means that there are incumbents (including …

I've been doing a lot of work lately on behalf of clients who are looking to deploy applications to virtual data centers. When I first started working as a technology consultant in the '90s, it was a given that if you wanted to have a web application, you had to buy a bunch of servers and rent out a cabinet in a data center somewhere. Now the notion of spending all that money on hardware that will go obsolete in a few years seems like insanity most of the time (particularly when the size of the audience for your application is completely unknown). When I first started a hosted web service in 1999 people judged us by how many servers my company owned. Now when I tell them "we don't own any servers at all" they nod knowingly.

It's great that we have more cost-efficient virtualization options today than we had ten years ago. Unfortunately, though, virtualization is a disruptive technology, which means that there are incumbents (including …

Congrats to Drupal for releasing version 6.0 yesterday.  This site has been running 6.0 since about rc2 (upgrading every release along the way) and I've been very happy with it.  Also, thanks to the developer(s) of the 'Channel Nine' theme, which I've adopted for my own (with some modifications).