When you connect a Linux server to a SAN, the network driver will present the available SAN partition as normal SCSI drives. This can be more complicated when more than one Fiber Channel paths are involved. Let’s consider a server having two FC adapters (or a dual port one) and a SAN having two FC channels. For this server, each SAN partitions will appear four times but some FC adapter drivers, like the QLogic ones, will filter them out.

If you are using another brand of Fiber Channel adapters, like Emulex, you will see all of them. I recently worked on a MySQL project using 9 SAN partitions so I ended up dealing with 36 SCSI devices (/dev/sdb to /dev/sdao). Dealing with so many devices is not a fun task, especially if the order of the disks is not preserved between after a reboot. My first attempt to deal with this problem was to use partition label and mount partition by label. Although this solution worked, it was slow and I sometimes …

Yet Another Sun Bought MySQL Post

So Sun bought MySQL?. dunno about you, but I was surprised. My first impression was ?nooooooooooooooo, I liked it when it was small and my contributions made a difference?, but I realized that it has obvious big advantages.

The main one, which has been mentioned over and over again, is the support of MySQL will grow to the level which I might see it in companies that opted not to get it and use commercial databases.

When I was interviewed for my current job, I learnt that the company made a website for a large customer and that they were using MySQL along side open source frameworks for it. The customer would want in the future to integrate the data, the website gathers, to their CRM system. Because of that, they were thinking about moving to using Oracle. They were also thinking of moving to Oracle anyway, because and I quote ?we have more then 500 views a day on the …

Heh, who knew we'd see the day that Gartner would write this:Recommendations for all enterprises
...
MySQL is capable of supporting clusters, delivering atomic, consistent, isolated and durable (ACID) functionality and handling some mission-critical applications. Evaluate MySQL as an alternative to IBM DB2, Oracle and other DBMSs.Well, fact of the matter is, they did write it in a recent report on the MySQL / Sun deal. You can download the Gartner analysis right here free of charge.

A few weeks after the latest useful quiz, I want to offer a funny one.
Given the following table, on a MySQL server 5.1.22 or newer,

CREATE TABLE t1 (id int, c char(100)) engine=MyISAM;

1. Create one set of three triggers that must all be activated BEFORE INSERT.
   
   • Upon insertion of the values (1, 'nothing'), the first trigger should replace 'nothing' with 'something', leaving the number unchanged;
   • the second trigger should add ' more ';
   • the third trigger should add '!!'.
2. Create one set of three more triggers, all activated BEFORE INSERT.
   
   • Upon insertion of the values (1,'nothing') the first trigger should add 10 to the number, leaving the text unchanged.
   • the second trigger should add 100 to the number;
   • the …

It's been almost a month now since I have been evaluating JasperServer. And it has been quite hard to evaluate the software without a proper documentation. Fortunately, I was able to convince my boss to buy the books Definite Guide to iReport, Definite Guide to JasperReport and JasperServer Ultimate Guide.

What I found interesting in all this experience is that just like any open software, it is connected to a lot of different applications. I had to study Tomcat and Ant in a thorough manner to get through JasperServer. In the end, I'm actually quite happy that I had to go through this experience.

Anyway, I am now quite comfortable with JasperServer. I am now able to create reports on the fly and I'm able to understand what it is now doing in a more in-depth manner. In fact, I will be giving a demo to our boss sometime soon and who knows we might use JasperServer in our company.

Helan går sjung hopp faderallan lallan lej. Helan går, sjung hoppfaderallan lej.

Och den som inte helan tar, han ej heller halvan får. Helan går, sjung hopp faderallan lej.

while we start to wind up development of connector/odbc 5.1, i will also be taking on responsibility for libmysql, the c library that defines the client interface to mysql, and the mysql command-line utilities. there are about 120 active bugs in those areas right now, so the first task will be getting that down to a more manageable number.

after that, the field will open up for new development. i know that an asynchronous interface to libmysql is on some people’s wishlist, and there are other areas where i think that libmysql could be cleaned up in general.

but the idea that i think is the most exciting is to build a scripting …

Infobright Inc., an innovative analytic data warehouse provider, and MySQL AB today announced a multi-year extension of their partnership agreement. Infobright is a MySQL Certified Storage Engine partner. The combination of Infobright's Brighthouse and MySQL provides organizations an analytic data warehouse that delivers high levels of scalability, performance and ease-of-use.

There's been a lot of positive coverage of Sun's acquisition of MySQL last week (with one or two odd-ball conspiracy stories). To me the most significant element is that Sun has long recognized the disruptive nature of open source and is now leveraging that power as part of their overall strategy. Obviously, that's not new news. Sun has been doing this for several years with OpenSolaris, GlassFish, NetBeans, open sourcing Java, etc. The fact that both companies have bet on open source is key to the ongoing success of MySQL. I don't think MySQL would have ever sold to a... READ MORE