So, when you connect on the fly to a database your subject to a
variety of issues, like when the db is not available and when the
db does not have a route.
One of the main reasons why a dev may want to connect on the fly
is because they have too many front ends to hold a persistent
connection on the backends. Since mySQL does not use libevent,
holding open threads to mySQL is much more costly. Threads ==
Memory.
But, that's here nor there. The main purpose of this post is to
talk about how to recover from failed connections that block
apache threads.
Common Failures:
No route to Host
Flapping NIC
Locked Tables
Recovering from a Crash
more of the same.
My Environment:
I have a bunch of webservers (200+) that all have 300 possible
threads (60000 possible connections to a single DB) behind a load
balancer that uses the LB least connections …
The German Oracle User Association (DOAG e.V.) has published a statement (in German) about the acquisition of Sun/MySQL by Oracle and its impact for Oracle users. You can find the statement here.
Oh and btw, I'll give a session about "PHP5 & Oracle" at the local Oracle usergroups in Frankfurt on June, 23rd and Hamburg on Sep 14th. The main goal is to promote the usage of PHP5 in Oracle environments (and how you can leverage PHP's potential in Enterprise environments) as there are good Oracle database connectors for PHP5 available. See you there!
|
|
There must be something that gets coders and barbecue together. In Australia, I was invited to a hackers barbecue, while at FrOSCon, the Saturday evening meal is a grill fest. It seems just right that the PHP coders in Germany are getting together with a BBQ Tour, starting on Monday, June 15, and touching seven German towns in one week. |
I will join the happy campers on Saturday, June 20, in Hamburg,
and finish off the tour in Kiel the next day.
The event is open. However, for …
The PHP BBQ Tour starts in exactly one week. The first barbecue will be held in Munich on Monday, 15.06, 19:00 CEST. The tour is an offering and a suggestion to the user group to come together for a barbecue instead of meeting in conference rooms in the middle of the summer, when the days are long. Everybody is invited to join the tour and to visit the PHP user group in his neighbor town. Tour dates: Munich (Monday, 15.06), Frankfurt (Tuesday, 16.06), Karlsruhe (Wednesday, 17.06), Berlin (Thursday, 18.06), Dortmund (Friday, 19.06), Hamburg (Saturday, 20.06) and Kiel (Sunday, 21.06).
Be a pioneer, sail together with the crew of Mayflower (thinkPHP) and the PHP locals into the Hirschgarten park for the first barbecue on the tour. If you consider to come, please add your name to the Wiki page at …
[Read more]Picture at http://www.flickr.com/photos/juanpol/78895688/ - argentinian asado. We love this country!
When it's summer, it's likely that you go out with friends having a barbecue or drinking some cocktails while having fun meeting those people you're mostly communicating with virtually. A good friend of Mayflower, Ulf Wendel, came up with the idea of a PHP BBQ tour - getting in touch with various PHP Usergroups in Germany. For all those people who like meat and gathering with the local PHP crowd, we can really recommend the PHP BBQ tour. At the wiki page on forge.mysql.com you can see the tour dates.
Of course, some of the …
[Read more]
Just a short announcement: I am going to join Ulf for his
PHP
Barbeque Tour across Germany, which will take place between
June 15th until the 21st. We will start in the south of Germany
and will work our way up north in one week, stopping by at
various cities in Germany to enjoy a barbecue with local PHP User
Groups and to talk about PHP (of course), MySQL, Open Source,
The Web and anything else. We've set up a Wiki
page that outlines the various stations of our journey. At
the Moment, we will visit the following cities:
- Monday, 15th: Munich
- Tuesday, 16th: Frankfurt
- Wednesday, 17th: Karlsruhe
- Thursday, 18th: Berlin
- Friday, 19th: …
I just realized that I haven't blogged for more than a month! Shame on me. But I will blame it on being away on conferences and vacation for quite some time And if you are following me on twitter, you may have noticed what I was going on in my life and that I did't get hit by a bus...
So what was going on since I returned back home from the MySQL Conference? First off, I uploaded und sorted my pictures from the conference and the Drizzle developer day on Flickr. I also uploaded the slides (PDF) from Colin and myself speaking about "MySQL Server Backup, …
[Read more]
First there was LAMP. But are you using GLAMMP? You
have probably not heard of it because we just coined the term
while chatting at work. You know LAMP (Linux, Apache, MySQL
and PHP or Perl and sometimes Python). So, what are the extra
letters for?
The G is for Gearman - Gearman is a system
to farm out work to other machines, dispatching function calls to
machines that are better suited to do work, to do work in
parallel, to load balance lots of function calls, or to call
functions between languages.
The extra M is for Memcached - memcached is
a high-performance, distributed memory object caching system,
generic in nature, but intended for use in speeding up dynamic
web …
Leopard 10.5.7 now comes with PHP 5.2.8, I wasn’t aware of this, and it’s caused me a great amount of agony and hair pulling over the past few days. So, for those of you running XAMPP and recently upgraded to 10.5.7 you may want to be aware of this.
When I had installed XAMPP, I had removed the php binaries in /usr/bin, and linked them to their equivalents in /Applications/XAMPP/xamppfiles/bin/
10.5.7, removed the php symlink and replaced it with the 5.2.8 binary. This caused all sorts of problems for me, as my tasks stopped working. The fix is simple, just replace the symlink again.
Thought I’d share this with others in the same situation as me. On irc people told me to switch to MAMP, but that’s not solving the problem .
As I write this, my friend (and eLiberatica chair) Lucian is packing up to fly to Bucharest for this year’s instance of the eLiberatica Electronic Frontier/Free Software/Open Source conference. Sadly, I won’t be participating this year – a commitment to less travel and a new venture make doubly sure that I’m staying home.
Despite the downturn, it looks like this is going to be a great year for the conference: 400 people have registered and the list of speakers is formidable, including: OSI board member Danese Cooper, FSFE founder Georg Greve, MySQL founders David Axmark and Monty Widenius and Zbigniew “Gandalf” Branecki from Mozilla Europe.
If you are in or near Romania, you should try to …
[Read more]