CMON - the Cluster Monitor has recently been released and here is a little how to about how to install from binary and source (at the end), deployment etc.

1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and 32-bit (statically linked) and works for MySQL Cluster 7.0.9 and later.

In this case the monitoring host will be on 'ndb05' (IP address 10.0.1.5) - see 9. Suggested Deployment for a picture describing the setup.

The Monitoring machine should have installed:

• a mysql server up and running that will store the cmon database (if you build from source you need to have the mysql cluster libraries and include files)
• apache (if you want to have the web interface) + php_mysql
• rrdtool (if you want to have graphs in web interface)
…

Your site is getting awfully slow? There's just to much reads to your database and you have already tweaked the performance of every query? In most cases data caching is the solution to your problem!

The idea is to cache all processed data you heave retrieved from the database. Let us look on a example. It uses a mockup class that basically can handle any caching system like memcached or xcache

I’ve talked about PERFORMANCE_SCHEMA in the past - almost a year ago now.

Back then the feature was just coming together in to something useable, and was on the cusp of moving towards code review. It entered code review, and went around, and around for 9 months, whilst various refinements were made.

Never the less, Marc Alff persevered (much respect!), and yesterday pushed his final merge in to the mysql-next-mr bzr tree. PERFORMANCE_SCHEMA is now awaiting the next milestone release, and will be a part of the next GA release of MySQL!

We have the initial documentation ready:

http://dev.mysql.com/doc/performance-schema/en/index.html

This first round adds the infrastructure to take monitoring of the MySQL Server to the …

http://wp.me/pEk8Y-1M

Installing Apache2 With PHP5 And MySQL Support On Fedora 12 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 12 server with PHP5 support (mod_php) and MySQL support.

The tracks of this year's "MySQL & Friends" Developer Room at FOSDEM 2010 have now been scheduled - please check the Wiki page for details on the talks as well as some background information about the speakers. This info should soon be available via the FOSDEM conference system as well. We had some last-minute changes and we actually managed to schedule two more talks due to a small glitch in the initial calculation. The topics look very interesting, we hope that we can provide some valuable information for developers, users as well as MySQL DBAs!

One of our speakers (Kris Buytaert) suggested to arrange a joint dinner for Saturday evening, which is indeed a good idea! Thankfully he also volunteered for coordinating it - thanks in advance! If …

Like a lot of you, I’ve been following with interest Percona’s testing of the open source column databases. One thing I think is pretty cool about some column databases that work with MySQL is that they don’t require you to create indexes. The reason is, in general, the column is the index. Not having to create indexes is nice because lots of indexes can really bog down a database if you’ve got a lot of load or DML activities because the indexes have to be maintained for all data input and alterations.

In Percona’s test, they showed the load time for all the different databases, but I noticed that the times didn’t include the index creation for LucidDB or MonetDB. I decided to follow Vadim’s link on the …

Around a year ago, I took on a new role at Sun as vice president of lifecycle marketing. While the title was an odd one, the charter was pretty straightforward: Bring the best practices of open source, Web 2.0, and modern online marketing to Sun's portfolio of servers, storage, software, and services in order to drive up revenues and drive down customer acquisition costs.

Open source was an incredible calling card that we could use to determine what customers were interested in. Now we just needed to figure out how to harvest that interest.  It worked for …

I received a question from my last entry on how to let others see your MySQL Certifications. In the past, the MySQL site had a list of those with the various certifications. Sun's certification system is different.

1. 
   
2. Go to the Sun Certification Database
   
3. Enter your ID and password. The format for the ID is usually SUNnnnnnnn but it may be different. There is a First Time Users link and a link to get your ID and password (you do remember the email you used when you took that MySQL, don't you?). And if you get stuck, contact Certificiation@SUN.Com
   
4. On the left hand menu, under Certifications will be a link for Publish Credentials.
   
5. Here you provide an email address …

http://wp.me/pEk8Y-1M