I’d like to share some great news — The Pythian Group and Open Query have become partners!

Open Query is a leading provider of high-quality MySQL, PostgreSQL and related training in Australia and New Zealand. They offer consulting services too, and are also known for their MySQL Graph Storage Engine. Feel free to browse through Open Query web-site for more info.

Open Query was founded by Arjen Lentz, who was employee number 25 at MySQL AB. If you follow the MySQL community then I’m sure you already read Arjen’s blog.

Since you’re reading this …

I was looking for an example of how to write a MySQL UDF for my upcoming book "Writing Web Applications in Perl, Memcached, MySQL and Apache", and decided using Curl would be fun. Maybe there are some philosophical issues of why not to do it. But I can do it, and I did do it. So be it ;) Once I started the idea, I had to at least finish it. I hate not finishing something.

The single function is http_get(). It's very simple -- it just fetches a url (doesn't yet take the "http" part, it's _that_ simple). This severely needs to be fleshed out.

So, the proof in the pudding is at: http://patg.net/http_get.txt

A Launchpad project: https://launchpad.net/curludfs

Code: …

For those of you interested in getting maximum performance out of your DRBD-based HA clusters, I am hosting a webinar on the subject on Wednesday, 8/27 at 1800 UTC (2pm Eastern, 11am Pacific).

The webinar is offered free of charge and it’s already pretty tight in terms of attendance, the event being limited to a maximum of 60 attendees. But if you’re quick, you might still stand a chance of grabbing a front-row seat. Check out this page on our website, it has all the relevant information.

…

Lukas Kahwe Smith has an awesome post titled "Open Source is not making enough rich people richer" .
Indeed, there is much talk that the VC's , the Investors and different others aren't seeing the big money fast enough, according to them that is.
Does that mean that the open source industry is going bad ? Does that mean you can't make a living when working in the Open Source industry ?

Absolutely not, as he points out there are uncountable people gaining a good living with Open Source, developers working on the different projects as their day job, system administrators managing open source platforms. We are helping out customers to implement Open Source and Free Software. And there are numerous other Drupal, Mysql, Xen, shops out there. Some have their own open source products and create a business on top of …

Being able to use an Open Source DBMS to manage your data is nice, but what good would it be if you can't easily access it from your applications? One key factor to the popularity of MySQL is probably its wide range of available language bindings, which started with support for C, PHP and Perl from early on.

I've tried to gather a list of languages and their respective MySQL drivers/modules below. It's by no means complete or exhaustive, but I think I covered quite a lot of popular as well as exotic programming languages.

There is a number of connectors which are actually developed by the Sun Database Group (aka MySQL) itself and that are ready to use:

• Connector/ODBC - Standardized database driver Windows, Linux, Mac OS X, and Unix platforms.
• …

This is the last week to participate in a database usage survey. If you haven't already done so, please take a few minutes to answer 25 questions.

LewisC

Technorati : database, mysql, survey

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.