One of the most asked questions is how to setup MySQL replication. The MySQL Reference Manual provides a good Replication How To as a starting guide on MySQL Replication 101.

MySQL replication has many uses including read scalability, backups, failover, online maintenance, upgrade testing and verification, software upgrades, alternative data or structure for performance queries and even benchmarking to name the popular uses.

When reviewing an installation of MySQL replication I use the following as part of my checklist of steps used for confirming your replication environment is operational.

Master Variables

• server-id – Replication will not work without this correctly set and unique
• log-bin – Pre-requisite for working replication
• log-bin-index
• max_binlog_size
…

I used to develop with MySQL, and those were the golden days. These days I don’t write queries so much. But yesterday I needed to answer this question: are there any issues in our issue-tracking system that meet the following criteria? The last two or more emails are from the customer These emails were separated by at least two hours (i.e. it wasn’t a single train of thought) I could do it with all kinds of correlated subqueries and so on – but maybe I could also just do it without them, no?

Recently I was working on a project which used Infobright as the database. The version tested was 3.1.1 both on OpenSolaris as well as Solaris 10. Infobright is like a column-oriented database engine for MySQL primarily targeted towards data warehouse, data mining type of project deployments.

While everything was working as expected, one thing we did notice that as number of concurrent connections tried to query against the database we noticed that queries deteriorated fast in the sense that not much parallel benefits were being squeezed from the machine. Now this sucks! (apparently sucks is now a technical term). It sucks because the server has definitely many  cores and typically each Infobright query still can at the max peg a core. So the expectation will be typically to atleast handle concurrent queries which is close to the number of cores  (figuratively speaking though …

Recently I was working on a project which used Infobright as the database. The version tested was 3.1.1 both on OpenSolaris as well as Solaris 10. Infobright is like a column-oriented database engine for MySQL primarily targeted towards data warehouse, data mining type of project deployments.

While everything was working as expected, one thing we did notice that as number of concurrent connections tried to query against the database we noticed that queries deteriorated fast in the sense that not much parallel benefits were being squeezed from the machine. Now this sucks! (apparently sucks is now a technical term). It sucks because the server has definitely many  cores and typically each Infobright query still can at the max peg a core. So the expectation will be typically to atleast handle concurrent queries which is close to the number of cores  (figuratively speaking though …

Been a while since we did a post for open positions but this is an important one so wanted to get it out there.

Position Overview:
Manage Zimbra’s rapidly growing technical community and launch our developer outreach program.  A key part of Zimbra’s rapid growth and ongoing success is the ability for us to engage and interact with our open source community.  This position will take the solid base we’ve grown over the past 5 yrs and define and implement a Zimbra developer program to lower the bar for external developers, partners and customers to build solutions around the Zimbra platform.  This will include expanding and leveraging the relationships between Zimbra, our customers, our developers and our sysadmin community members.  A few of the existing public tools and touch points are listed below. This position will build upon and improve the current tools and evaluate and add to these as needed.  The …

If you ever wondered how big is that or another index in InnoDB ... you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of a VARCHAR - since you need to estimate average length) on count of records. And it still would be quite inaccurate as secondary indexes tend to take more space. So we added more detailed index statistics into our xtrabackup utility. The thanks for this feature goes to a well known Social Network who sponsored the development.

We chose to put this into xtrabackup for a couple of reasons - the first is that running statistics on your backup database does not need to hurt production servers, and the second reason is that running statistic on a stopped database is more accurate than with online (although online is also supported, but you may have inexact results).

Let's see how it works. I have one table with size 13Gb what was filled during about 2.5 years.
…

On the 23rd of June 2008, I wrote a note saying that I had just joined Pythian. Today I am posting a similar, but different, note saying that as of the last of September, I will no longer be employed by Pythian, the time has come to look for new challenges. Although I am sad to leave, I do look forward to the future and what it may hold for me.

I wanted to take this moment to thank Pythian for having me, for having such great co-workers whom I count myself lucky to have worked with. I also want to give a special thanks to Augusto for taking care of me when I first joined, and showing me around how the company works. I must thank Paul as well—he is an exceptional person to work with, and I’ve come to value his …

Just a short heads up on what is going on with the Open Database Alliance.

read more

MySQL is proud to announce the MySQL Enterprise Fall 2009 Release!

The MySQL Enterprise Fall 2009 Release includes the MySQL Enterprise Monitor with the improved MySQL Query Analyzer - now with new correlation graphs for faster performance optimization. Join our webinar series and see a live demonstration of the new MySQL Enterprise Monitor and the improved Query Analyzer, hear about the new Advisor rules and support services and get live answers to your questions from our MySQL experts.

The "What's New in the MySQL Enterprise Fall 2009 Release - EMEA" web presentation will be delivered on Wednesday, September 16.

For those of you who speak Italian I'll deliver a local version of it on the Thursday, September 24 at 10am CET. Register and listen to it from the comfort of your home or office via this …

I haven’t blogged in over a month now.  This is for a number of reasons.  Firstly I have been flat out with various activities.  This included a trip to VLDB in Lyon mid month.  Secondly, a lot of the companies I have spoken with this month aren’t ready to speak publically so hence no blog posts resulting from these sorts of discussions.

However there has been a wiff of a change in the air in terms of focus that is interesting and worth highlighting.  After years of lots of innovation around data analytics, OLTP is starting to make a comeback in terms of reclaiming some of the limelight.  Much more on this between now and the end of the year, but a couple things to watch:

• On the Radar: VoltDB
• …