As hinted at earlier this month, we’re happy to announce our latest on-demand webinar:
“An Introduction to Database Proxies (for MySQL)”

In this webinar, Gilles Rayrat, our VP of Engineering and database proxies guru, shares some of his knowledge on the world of database proxies, how they work, why they’re important and what to use them for.

Starting with a simple database connectivity scenario, Gilles builds up the content by discussing clustered databases and what happens in the case of a failure through to explaining the important role database proxies play; including a more in-depth look into some advanced database connectivity setups and proxies functionalities.
…

It is finally here.  After three years of development, the new version of Shard-Query is finally available for broad testing.

This new version of Shard-Query is vastly improved over previous versions in many ways.  This is in large part due to the fact that the previous version of Shard-Query (version 1.1) entered into production at a large company.  Their feedback during implementation was invaluable in building the new Shard-Query features.   The great thing is that this means that many of the new 2.0 features have already been tested in at least one production environment.

This post is intended to highlight the new features in Shard-Query 2.0.  I will be making posts about individual features as well as posting benchmark results.

…

MySQL replication enables data to be replicated from one MySQL database server (the master) to one or more MySQL database servers (the slaves). However, imagine the number of use cases being served if the slave (to which data is replicated) isn't restricted to be a MySQL server; but it can be any other database server or platform with replication events applied in real-time! 
This is what the new Hadoop Applier empowers you to do.
An example of such a slave could be a data warehouse system such as Apache Hive, which uses HDFS as a data store. If you have a Hive metastore associated with HDFS(Hadoop Distributed File System), the Hadoop Applier can populate Hive tables in real time. Data is …

Hello Folks,

I have never been consistent with blogging and most of the time
I create a blog hoping that I would  share my thoughts and plans
with everyone, but as It has to happen, I neglect it.

On this new year I made a resolution that I will work on this blog
(actually it was to create one) and maintain it throughout. This
blog will be the reflection of my ideas, and an attempt to get a feedback on
my work in MySQL replication, together with providing tips and tricks
on using MySQL in distributed environment.

So, last July I joined MySQL replication development team, straight out of
college and it is kind of a big thing for me. In past 7 odd months I have
worked with great people and learnt a lot of things and this has finally lead
to an idea of starting this blog, and posting my thoughts in my spare time.

This …

For me, GSOC was a learning experience. I feel that I’ve learned more

from doing this than I have over the course of all my university

classes. So for me, the things that I’ve learned break down as

follows:

Technical things:

1. Installed cygwin and learnt some basic stuff regarding cygwin. Have never really used cygwin before.

2. Learnt how to use bkclient for downloading mysql source code which was replaced by bazaar in the middle of GSOC. Again I have never realy used a distributed version control system.

3. Learnt how to use bazaar which has more functionality than bkclient

4. Downloaded the mysql source code and built it on Windows as well as Linux.

5. Learnt how to debug the mysql source on Windows using Visual Studio …

For me, GSOC was a learning experience. I feel that I’ve learned more

from doing this than I have over the course of all my university

classes. So for me, the things that I’ve learned break down as

follows:

Technical things:

1. Installed cygwin and learnt some basic stuff regarding cygwin. Have never really used cygwin before.

2. Learnt how to use bkclient for downloading mysql source code which was replaced by bazaar in the middle of GSOC. Again I have never realy used a distributed version control system.

3. Learnt how to use bazaar which has more functionality than bkclient

4. Downloaded the mysql source code and built it on Windows as well as Linux.

5. Learnt how to debug the mysql source on Windows using Visual Studio …

Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

Week 6 (30th June – 7th July 2008 )

Key Accomplishments Last Week

1. Implemented a feature to rearranger.c to allow it to accept multiple input files (as requested by Brian). There are a few problems with this feature, however, and I plan on rectifying them soon.

2. Learnt some basics of Lua.

3. Learnt a bit about the ddd.

4. Started learning about the internals of mysql and bought a book, “Expert MySQL” by Charles A. Bell. I already have a fair idea about the working of mysqlslap. Once I get a good grasp of the ddd debugger I should be able to understand mysqlslap more thoroughly.

Key Tasks that stalled last Week

None

Key Concerns

The upcoming midterm evaluation gives me a sense of urgency in my work. On looking back, I feel I have given my best but it could definitely have been better. Hope …

Week 6 (30th June – 7th July 2008 )

Key Accomplishments Last Week

1. Implemented a feature to rearranger.c to allow it to accept multiple input files (as requested by Brian). There are a few problems with this feature, however, and I plan on rectifying them soon.

2. Learnt some basics of Lua.

3. Learnt a bit about the ddd.

4. Started learning about the internals of mysql and bought a book, “Expert MySQL” by Charles A. Bell. I already have a fair idea about the working of mysqlslap. Once I get a good grasp of the ddd debugger I should be able to understand mysqlslap more thoroughly.

Key Tasks that stalled last Week

None

Key Concerns

The upcoming midterm evaluation gives me a sense of urgency in my work. On looking back, I feel I have given my best but it could definitely have been better. Hope …