This document offers some tips on how to migrate your Drupal website from a database running on the same server as your web server, to a physically separate database server.

read more

As days goes by, more and more multi-core systems are popping up everywhere. Infact, with the advent of the new 4-socket quad-core Sun Fire X4450 , 16-core systems are soon becoming common out there.

However,personally, I think these systems are still underutilized from their true potentials.  Of course virtualization is a way of increasing the utilization but  that is like working around the symptoms and not fixing the real problems. Software Applications fundamentally has lagged behind the microprocessor innovations. Operating Systems too have lagged behind too. Solaris, however advanced opertating system has still lot to achieve in this area. For example, yes the kernel is multi-threaded, yes it can scale well easily to 100s of cores but that scaling is generally achieved by creating copies of the process (or multiple connections or multiple threads however you look at it) at the APPLICATION level.  One area however …

Virgin Mobile, a leading Mobile Virtual Network Operator, has implemented a MySQL Enterprise Platinum subscription to manage its data using the world's most popular open source database.

I posted this at the new blog but it never hit Planet MySQL, so we’ll see if posting it here does the trick.

Learn all about it at http://www.mikehillyer.com/mysql/speaking-at-the-2008-mysql-conference-expo/

I was blog-tagged by Doug Burns - his post is here: I *hate* chain letters …. I hate them too, I literally never pass them on no matter what vile fate that condemns me to (so far nothing has happened so maybe those are idle threats). But this one includes a chance to talk about myself [...]

I know it’s a little late, but as this is my first post of 2008 I wanted to start on a high!

After receiving my copy of the MySQL 5.1 Cluster DBA book at Christmas, I spent an hour or so each day with my head engrossed in MySQL Cluster technology, so much so that my goal of reading every Perl book I own (cover to cover) has been somewhat put on hold…

The book was much smaller than I expected, in both physical size and pages (266) which was not a bad thing as I could carry it around if needed, and each chapter could be read within 15-20 minutes, just about right for my attention span

I booked the exam a couple of weeks ago thinking I might need some incentive to fully digest MySQL …

I was eager to read the Open Solutions Alliance open source CEO predictions for 2008, figuring it would have some interesting thoughts and perspectives on the open source year ahead. However, I had no idea the forward-looking statements would apply to me, personally and directly. One did. Adaptive Planning CEO William Soward, in the first response of the OSA predictions report, quotes my colleague Raven Zachary on the discussions we’ve had about open source coverage and my job title. Let me explain.

I was hired by 451 Group a litle over a year ago as an analyst covering enterprise software, and more specifically, open source software. Thus, my title has been: analyst, open source. We’ve found that I’m working …

mysqlreport v3.3 is ready. Changes:

• –all is now the default option and all the sub-report options like –dms, –sas, etc. have been removed. All reports that can be made are made automatically.
• Slow line now displays long_query_time and log_slow_queries
• Created Temp Table line now displays tmp_table_size
• The mysqlreport tgz and zip now extract into their own directory

The mysqlreport Documentation and The Guide To Understanding mysqlreport have been updated to reflect these changes.

DRBD 8.2.3 was released today. Even though just a micro release in terms of version numbering, it comes with a couple of very handy brand new features: on-line device verification, and tunable processor affinity.
(more…)

YouTube, it turns out, uses MySQL as its backend.

Paul Tuckfield, the YouTube DBA, speaks about using MySQL at YouTube.

Before I even finished listening to the whole presentation, I got several key points:

• Paul Tuckfield started out at YouTube with a lot of database experience under his belt as an Oracle DBA--but no MySQL experience. Which tells me that switching from Oracle to MySQL, while retaining people, should not be an obstacle.
• MySQL scales, nicely. YouTube has three DBAs. They served 100 million videos a day, back in mid-2006. Without DB2 or Oracle.
• Scaling MySQL to YouTube-scale is non-trivial. Tuckfield talks about using master/slave architecture and doing clever things with replication, to …