I've been wondering about that for years and well, I've suddenly been placed into this position, which leads me to believe that somewhere there is a deity bent on playing parlour games with my life. Even as of two weeks ago I wasn't quite sure what a community manager did. I mean, it's not like I get to "manage" all of you people, I can't write reports or evaluate any of you.

This week, as I move away from my previous duties and into the new ones under the care and guidance of my new Community Team family, headed by chief whipmaster Giuseppe, and trying very hard to avoid the smoking pits of doom that I might fall prey to, I think I'm getting a small vision of my future.

It involves multiple presentations. Good thing I like public speaking. Too bad you may all hate my publicly speaking :)

So what's upcoming? I'm preparing two presentations, one of which I know I have to give and that is to the New York PHP …

If you are a MySQL 5.x/6.0 InnoDB replication user, right now you take a significant performance hit on the replication master simply by turning on the binlog. The good news is that we've taken a big step toward eliminating that performance gap. I'll describe the problem, how I was able to track down the root cause, and point to a patch that fixes the problem. Since the changes are in the InnoDB code, right now we're waiting on Oracle/Innobase to review the fix and formally commit it. Once that happens, you should see it show up in binary releases. In the meantime, if you build your own binaries you can test the prototype patch yourself.

One of the things I have been working on quite a bit over the past several months is scalability of the nodes within a MySQL scale-out replication environment.  The reason being that there has been a rapid …

If you are a MySQL 5.x/6.0 InnoDB replication user, right now you take a significant performance hit on the replication master simply by turning on the binlog. The good news is that we've taken a big step toward eliminating that performance gap. I'll describe the problem, how I was able to track down the root cause, and point to a patch that fixes the problem. Since the changes are in the InnoDB code, right now we're waiting on Oracle/Innobase to review the fix and formally commit it. Once that happens, you should see it show up in binary releases. In the meantime, if you build your own binaries you can test the prototype patch yourself.

One of the things I have been working on quite a bit over the past several months is scalability of the nodes within a MySQL scale-out replication environment.  The reason being that there has been a rapid …

Here is a short summary of CMON news:

• it is now on launchpad
• versioning has restarted at 0.1 (I have realized this is how it should be done :) )
• cmon 0.1 is available for download at Severalnines (see screenshots below)
• how to install it has been updated and details added for e.g fedora.
• bugs should be reported on launchpad/cmon (get a launchpad account now!)
  

Feature update of cmon 0.1 (the same as cmon 1.2.2 plus):

• monitor your mysql servers (add/remove mysql servers that should be monitored)
• view status and variables of your mysql servers
• view …

Happy Halloween! – well by the time you read this it will be more – Remember, remember the 5th of November!. So what’s been happening?

Well I spent the last month getting to grips with DB2 – why I hear you ask?.
You shouldn’t keep all your eggs in one basket, and there were rumors that DB2 might become Open Source at some point (or not). Anyway even if that never happens there is a lot to learn from the original DBMS and with DB2 Express-C available for free there’s nothing to stop your Open Source app taking advantage of that fact. Besides competition is a good thing.

Anyway not forgetting my …

Recently, I read an interview that Jonathan Schwartz gave to Computerworld dated October, 13 2008.  The following question was posed: "Do you really expect customers in the near term — with the economic downturn— to, say, swap out an Oracle database and replace it with MySQL?"  Jonathan's answer: "Unquestionably.  Now that doesn't mean they are leaving Oracle ... But there is no longer one-size-fits-all in the enterprise database marketplace.".  With 80-90% of the functionality of expensive proprietary databases at 10-15% of the cost, it's no wonder that MySQL has gained such large adoption and will continue to expand as customers look to reduce discretionary spending due to software license costs.

 Adding to this, I just got this email from …

ritu

The primary advantage of deploying the MySQL database in a Solaris Cluster environment is high availability. The Solaris Cluster environment provides fault monitoring and failover capabilities not only for the MySQL software, but also for the entire infrastructure including servers, storage, interconnects, and the operating system. If any component of the entire infrastructure fails, that failure is isolated and managed independently with no impact on availability.

MySQL Master-Slave configurations, deployed outside of a Solaris Cluster environment, provide limited availability: if the master fails, then the slave can manually be assigned master status and take over operation. However, this process is not automatic but requires manual intervention by a system administrator. Solaris Cluster removes this limitation, as it automatically fails over in the case of a master node failure. In addition, Solaris Cluster provides high …

For those of you who have been under a rock for the last several years, there is a buzz-phrase floating around—cloud computing. If you haven’t been paying attention, it is time to wake up.

While I could spend an entire blog post—if not several—on a definition of cloud computing, I will be talking only about cloud computing in the sense of companies moving servers from their building or network operations center to running virtual servers in this computing cloud.

While there are a number of companies providing virtual servers, the most visible is Amazon, with their Amazon Web Services (AWS). I will be talking about AWS in this post as it is the service with which I am most familiar. It seems like every month, AWS rolls out new options and services. Just recently Amazon announced that you can now run on AWS the Windows operating system along with SQL Server.

Amazon also announced a service level …

You are just getting started with MySQL on OpenSolaris. You've installed the OpenSolaris Community Edition and CoolStack MySQL. To explore this new environment you decide to run some tests using the sysbench benchmark. After running a number of tests you realize that for some reason the options you are setting in /etc/my.cnf are not getting used.

What is going on? Not to worry, you've just hit a problem common to new users of MySQL on OpenSolaris.

Run this command:

 # /opt/coolstack/mysql/bin/mysqladmin | more

page down until you see:

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /opt/coolstack/mysql/etc/my.cnf ~/.my.cnf

This shows …

You are just getting started with MySQL on OpenSolaris. You've installed the OpenSolaris Community Edition and CoolStack MySQL. To explore this new environment you decide to run some tests using the sysbench benchmark. After running a number of tests you realize that for some reason the options you are setting in /etc/my.cnf are not getting used.

What is going on? Not to worry, you've just hit a problem common to new users of MySQL on OpenSolaris.

Run this command:

 # /opt/coolstack/mysql/bin/mysqladmin | more

page down until you see:

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /opt/coolstack/mysql/etc/my.cnf ~/.my.cnf

This shows …