Today's Competitive Global Economy Environment for DBAsWith today's competitive environments, the more marketable you are the better. Being flexible and being able to support different solutions is very important. Environments surrounding databases are getting more complex, so increasing your expertise in different areas is important. There are a lot of options with application servers,

MySQL 5.1 went GA (Generally Available) recently. Can I let you in on a secret? Promise you won't tell anyone? The MySQL.com websites have been using 5.1 for 18 months now. It is a little known fact that quite often before even beta testers get hold of our software that little bunch of anarchists that is the web team get their grubby paws on it. But we aren't the only ones. In fact there were over 2 million downloads of 5.1 before it went GA. And 11 point releases.

Why do we do this? Well for one thing the web team is like any team of highly motivated, intelligent computer geeks and we love new toys. More than that we like to try and break them. But we are also responsible and don't like software that breaks and brings our websites down. It is a delicate balancing act, but one which we are committed to in order to
improve the product and as a side benefit get to play with all the new features.

MySQL depends a lot on its web …

Over a month ago I applied for a real port for Gearman (before the default port was conflicting with AFS). After some back and forth with IANA:

We have assigned the following registered port number to 'gearman'
with you as the point of contact:

gearman         4730/tcp   Gearman Job Queue System
gearman         4730/udp   Gearman Job Queue System

See: http://www.iana.org/assignments/port-numbers

I’ll be updating this in the C version for the next release (which will trickle down into the MySQL UDFs). I’m also in the process of notifying other API and server maintainers to get their ports updated. So, if you use Gearman, watch out for possible port mismatches while the various packages transition!

Check the blueprint document on how to use DTrace integrated with MySQL
to fetch useful information that can not be obtained by other

Check the blueprint document on how to use DTrace integrated with MySQL to fetch useful information that can not be obtained by other means:
here

Today marks the one year anniversary of Sun acquiring MySQL, which had the codename "Heineken."  So we had a little reception over at our offices at Sun's Menlo Park campus.  We also opened up a beer called "Sandels" which was the codename for our IPO project.

No doubt there will be more drinking this evening.

So there’s a whole bunch of MySQL scripts included with any release, who can say they know them all? In this blog post, we will take a look at some of these and show usage examples that may help you in your environment.

mysql_access

Let’s say you want to manage your users’ rights, and you have this user ‘john.doe’ that can connect from ‘host1’, but you aren’t sure what he can do to your db: company-staging as well as company-dev.

What do you do? Well, for example, you could use mysql_access and take a look:

/5075/bin:09:13:38:Qalbi $ ./mysqlaccess -U root -d company-staging -u john.doe -h host1
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier@rug.ac.be)
Changes by Steve Harvey (sgh@vex.net)
This software comes with ABSOLUTELY NO WARRANTY.

Access-rights
for USER 'john.doe', from HOST 'host1', to DB 'company-staging'
        +-----------------+---+ …

Yahoo! in cloud OR Hadoop? (Яху в облаках) by Alexander & Natalie

tl;dr: Yahoo adds SmugMug support to Profiles. Windows Live coming. Lots of other services, too.

Wow, what a pleasant surprise! Woke up this morning to this story on TechCrunch about 20 new services they’d added to Yahoo Profiles (here’s mine). Lo and behold, SmugMug is one of them! …

In MySQL 5.0, InnoDB gained the ability to use Linux Large Page support for allocating memory for the buffer pool and additional memory pool.

A few customers have asked about using it and there is virtually no documentation on what is required on Linux to enable it. I actually ended up having to read some of the Linux kernel source code to figure out some of this.

This uses the API as documented at:

http://www.mjmwired.net/kernel/Documentation/vm/hugetlbpage.txt

To set this up and use it, you first need a kernel that supports it. All of the recent RHEL kernels do by default from what I can tell. On my Ubuntu systems, I'm not seeing it enabled normally.

Then on the OS level you will need to do the following procedures:

 # Set the number of pages to be used …

Last year when Sun acquired MySQL I did a tour of a few of the campuses meeting different engineers to see what they did with Sun. At some point last year I met up with a group in Menlo Park who had been working on a webserver at Sun. Low and behold it was the evolutionary grandchild of what was the Netscape Enterprise Server. After talking to the engineers I wrote a few internal letters to see if we could push the code out as BSD so that others could learn/use/maybe even migrate if they wanted to. I am happy to say that Sun has decided to make the release happen:


This marks another milestone in the very long history of this web server. Back in the 90's this was the Netscape Enterprise Server, which later morphed into the iPlanet Web Server during the Sun|Netscape Alliance. After some years it was renamed the SunONE Web Server and most …

This actually sounds very interesting. I'm almost tempted to take it. If you're looking at developing RIAs, it might be worth your time to really explore JavaFX this way. I like that they make you do homework :) Having been a mentor numerous times, I know the value of regular accountability to help you actually *do* something...

http://www.netbeans.org/servlets/NewsItemView?newsItemID=1333