The latest from the MySQL community

Wow, another surprise, did I miss something in release notes! I hunted again and again, I think I got the treasure first Actually, today I was again looking into PHP support, so thought of opening my first ever PHP application, I created using Dreamweaver 8, WAMPServer (which was actually my semester project) last December.

I was going through application’s index.php, which had embedded php scripts, and links to javascripts using following tags-

<script type="text/javascript" src="styles/some_script.js"></script>

where styles/some_script.js is the script used, along with 2 more scripts. So, in body tag, there was a call to one of the functions belonging to one of the three .js files, like-

<body onload="javascript:call_func();">

So, today I was thinking, it would be nice if I click on this function, and get directed …

So, following the lead of Brian, I spent a few hours of the weekend to create a very simple replication scheme for Drizzle using protobuf for specifying the binary log events.

Since we are developing a replication for a cloud, there are a few things we have to consider:

• Servers are unreliable. We shall not trust server, but we shall expect them to crash at the worst possible time (Murphy is a very good friend of mine, you know. He must be, since he visits me very often.) This means that we need to have support to allow statements to be sent to the slaves before the transaction is complete, which means that we need to support …

Today I worked on rather interesting customer problem. Site was subject what was considered DDOS and solution was implemented to protect from it. However in addition to banning the intruders IPs it banned IPs of web services which were very actively used by the application which caused even worse problems by consuming all apache slots which were allocated to the problem. Here are couple of interesting lessons one can learn from it.

Implement proper error control In reality it took some time to find what was the issue because there was no error reporting for situation of unavailable web services. If log would be flooded with messages about web services being unavailable it would be much easier to find.

User Curl PHP Has a lot of functions which can accept URL as parameter and just fetch the data transparently for you. They however do not give you good error control and timeout management compared to …

KEY ACCOMPLISHMENTS LAST WEEK

• Refactored and cleaned up source code.
• Updated JavaDoc.
• Uploaded source code to code.google.com.

KEY TASKS THAT STALLED LAST WEEK

• Tried to upload source code to launchpad, but code.google.com was easier to use.

KEY CONCERNS

• None

TASKS IN THE UPCOMING WEEK

• Keep working on the project until the semester starts (Sept 2nd), at least.
• Integrate all server side processing scripts and tools (Java, Perl, R, HTML).
• Collect and analyze MySQL runtime information.

We've completed the first pass of the new domain driven architecture, so I wanted to give you an update about how it works and tell you about some of the interesting things we found out along the way.

How It Works

The basic idea of the domain driven architecture is to separate your application's business logic from the underlying nuts and bolts, so that you can use several different applications interchangeably or migrate from one platform to another while preserving the essential core of your application. Another related goal is for you to be able to write business logic code in business terms, so instead of working with tables in a database or their equivalents, you can work with business concepts such as customers, orders, and invoices. Later, when someone else comes in to read your code, it will be easier for them to understand what you've done and help maintain it going forward.

To do this, we …

So, you have a binlog. You want to find out something specific that happened inside of it. What to do? mysqlbinlog has some neat features, which I thought we would look at here.

I should first explain what mysqlbinlog really is. It is a tool that lets you analyze and view the binlogs/relaylogs from mysql, which are stored in binary format. This tool converts them to plaintext, so that they’re human-readable.

For the first tip, let’s start with the --read-from-remote-server option, which allows you to examine a binlog on a master server in order, perhaps, to dump it onto your slave and compare master/slave logs for potential problems*.

$ mysqlbinlog --read-from-remote-server -uwesterlund -p mysql-bin.000001 -h 127.0.0.1 -P 3306 | head -5
Enter password:
/*!40019 SET …

On Saturday, I spent a couple of hours running with Alexander Stubb. No, Alex is not our newest recruit to the MySQL Support Team, he’s the Foreign Minister of Finland (the guy in the yellow T-shirt below).

But let me rewind to the beginning. I have been increasing my running to over 1200 km a year, and when I heard that the Münchner Stadtlauf half-marathon doesn’t crash with Finnish midsummer (something never to be missed), I registered for it and finished it in 1:45:58. And I calculated I would have a chance at going below four hours at a …

Project: MySQL Forge RSS/Atom feeds

Note: I was on vacation for the last 2 weeks (10+11) and didn't have internet access, so this report is a little later than it should be.

KEY ACCOMPLISHMENTS LAST WEEKS

* Installing SeleniumRC.
* Writing basic SeleniumRC test script for the Forge.
* Writing PHPUnit tests for all HiPPo classes.

KEY TASKS THAT STALLED LAST WEEK

* None

KEY CONCERNS
* None

TASKS IN THE UPCOMING WEEK

* Prepare for extending the SeleniumRC test script to cover a larger part of the Forge.
* Submitting the Final Student Survey.

I would like to thank Google, MySQL and specially my mentor Jay for the opportunity to collaborate in the open source community and let me contribute something which will be useful in the future to many other open source hackers I hope.

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 …