Customers have always asked me to make NDB Cluster starts automatically upon startup of the servers. For the ones who know NDB Cluster, it is tricky to make it starts automatically. I know at least 2 sets of scripts to manage NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. If all the nodes come up at about the same time, it is not too bad but what if one the critical node takes much longer to start because of an fsck on a large ext3 partition. Then, a startup script becomes a nightmare. Finally, if the box on which the script is supposed to run didn't start at all. That's a lot of rules to handle.

Since all aspects of HA interest me, I was recently reading the …

It's great to see such good interest in InfiniDB, but now that we are seeing increasing numbers of users, we're also seeing people who are trying to use InfiniDB in places where they shouldn't. The end result is a bad experience for them and a bad impression of InfiniDB, which is a shame. InfiniDB is somewhat like MySQL Cluster: in the right use cases, you can't beat it, in the wrong use cases, it beats you.

So I thought I would quickly speak to when you should NOT use InfiniDB in hope...

===============================================================

MySQL is really poor in is support for AUDITING.

There will be some new feature in 5.5 or later, in which we will see the AUDIT interface finally implemented.

But ... who knows what will really happen, and who know if it will work or not.

So in the meantime, if you want to have some information printed out (at least), you can use this simple pathc.

What you need to do is modifying the file mysqld.cc in the sql directory.

in:> sql/mysqld.cc
Look for the function : int my_message_sql(uint error, const char *str, myf MyFlags)

change the code in the function with the one here, but also check that it is not inserting new bugs ;-).

int my_message_sql(uint error, const char *str, myf MyFlags)
{
THD *thd;
DBUG_ENTER("my_message_sql");
…

Sphinx As MySQL Storage Engine (SphinxSE)

SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So if you use Debian or Centos and install your MySQL from a .deb or .rpm package this is how you do it.

I was trying to import some data into my local MySQL (Mac) and ran into the following error: #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes. I was storing some images in a LongBlob column which was causing this …don’t even bother saying it ;-).

In short, you need to locate your mysql my.cnf config file and add or change the max allowed packet:

[mysqld]
max_allowed_packet = 50M

At the shell, you can type “mysqladmin” and scroll up a bit to see what the default location options are for my.cnf.

In my case, I tried using MySQL Workbench (awesome tool by the way) to change this parameter.  It changed it but it appeared MySQL wasn’t reading Workbenches location for my.cnf (as circled at the bottom of the screen-shot).  I’m not sure why my.cnf wasn’t in a standard directory like “/etc” or why that location was …

The MySQL track at Kaleidoscope in Washington, DC during June 28-July 1st is set! Here is the schedule, Lincoln VI is the MySQL track room.

Ronald has done a super job and spent a ton of hours in the past several weeks coordinating this effort. Work has kept me much busier than normal, but I have lent some time to the coordination as well. It is a credit mostly to Ronald that we have been able to plan an entire 19-session conference track, complete with confirming speakers, in less than a month. (You may notice the schedule does not have all 19 sessions full, we are just waiting for some more speakers to confirm details.)

Whether …

It is possible to trap all the query sent to MySQL, using tcpdump.

This will be done capturing the network traffic. Since this uses the libpcap library, we need to have root privileges.

Because tcpdump will not capture queries sent to socket file, be sure that the request you want to track will not use it.

So having clarified this obvious limitation, let us assume that all the application running locally are accessing MySQL using 127.0.0.1 on standard port 3306.

Capturing the queries to a file named all_query_tcpdump.log executing:

tcpdump -i lo port 3306 -s 2000 -w all_query_tcpdump.log

Please note that we will capture 2000 (-s 2000) headers bytes, which should be fine in the most cases.

Having done the data collection, we have now to analyze it.
For that we will use  …

Novell has announced Service Pack 1 for SUSE Linux Enterprise. LINBIT is a key contributor to this release, delivering DRBD and a number or cluster resource agents as part of Novell’s SLE High Availability Extension add-on.

This puts Novell firmly ahead of competitor Red Hat in terms of currently released and supported HA clustering solutions.  In case you haven’t noticed, Red Hat is also being questioned by customers for not shipping DRBD at this time, …

OSSCube is seeking candidates who are passionate about Open Source development to join our team of PHP Geeks.  We follow agile and standards based development methodologies and have an informal, friendly environment.  If you are a highly skilled PHPdeveloper and are looking for challenging work, OSSCube is the right company for you. Please send us your resume.

OSSCube is India’s leading Open Source software development company with expertise in outsourced product development. We are dedicated to providing solutions to businesses by leveraging the power of open source software, solutions and technologies. We have partnered with leading technology development companies such as  …

OSSCube is seeking candidates who are passionate about Open Source development to join our team of PHP Geeks.  We follow agile and standards based development methodologies and have an informal, friendly environment.  If you are a highly skilled PHPdeveloper and are looking for challenging work, OSSCube is the right company for you. Please send us your resume.

OSSCube is India’s leading Open Source software development company with expertise in outsourced product development. We are dedicated to providing solutions to businesses by leveraging the power of open source software, solutions and technologies. We have partnered with leading technology development companies such as  …