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: …
Aug
19
2008
Aug
19
2008
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.
[Read more]
Aug
19
2008
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 …
[Read more]
Aug
19
2008
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.
- …
Aug
19
2008
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
Aug
19
2008
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 …
[Read more]
Aug
19
2008
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 …
Aug
19
2008
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 …
[Read more]
Aug
19
2008
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.
Aug
18
2008
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 …