[ UPDATED 2011-09-22 ] :
For French attendees : Vous participez ou souhaitez participer à cette conférence, rejoignez le groupe de la communauté francophone pour partager autour de cet évènement
For All : Download the take away PDF of the conference here : PLL2011.pdf
For All : Download the schedules : Percona_Live_London2011.ics

I don’t want to debate about the next MySQL Conference here, you can find a great summary post here : …

I am looking for people who have a bunch of r/o slaves running, and who are using a load balancer to distribute queries across them.

The typical setup would be a PHP or Perl type of deployment with transient connections which end at the end of the page generation, and where a reconnect is being made at the next request serviced. The connect would go to the load balancer, which will forward it to any suitable database in the pool.

I am looking for people who are actually deploying this, and what strategies they have to cope with potential problems. I also would like to better understand what common problems are they needed to address.

Things I can imagine from the top of my head:

- Slave lag. Slave lag can happen on single boxes due to individual failures (battery on raid controller expires) or many boxes (ALTER TABLE logjams hierarchy). In the latter case boxes cannot be dropped from the …

Be sure to drop by the MySQL Demo Pod while you are attending Oracle Open World. There you will see a demo of the changes in MySQL Cluster 7.2. My favorite part of this release is that you can access the same data via SQL, LDAP, REST, memcached or via APIs. You get the best of both SQLand NoSQL worlds in one. At the Demo Pod, you can see how to see how Adaptive Query Localization speed up joins. Plus the demo will preview the latest and
greatest 7.2 DMR capabilities, and also demonstrate how MySQL Cluster
remains operational during node failures, upgrades and re-configuration
and how simple it is to create a live cluster using MySQL Cluster Manager. In the past, many cluster users avoid joins and simply used primary key or key/value pairs. But Adaptive Query Localization gets the data nodes to do more of the work in parallel.

And Cluster Administration has been greatly streamlined. So less typing gets you more …

I'm looking forward to the upcoming Message Systems User Conference next month in San Francisco, not only for what looks like an excellent venue, but for the great set of quality sessions on the agenda.

There's a number of sessions I'm looking forward to attending, but I'd like to invite you to attend the sessions I'll be delivering next month (read to the end to save on conference admission):

What the Convergence of Data Security & Privacy Concerns Will Mean to Companies

The barrage of news stories about data breaches and privacy violations is taking a toll on consumer confidence.

What You'll Learn:

• Why data security …

Just ten days until Oracle Open World and MySQL is going to have a big presence! 
“Focus on MySQL” overall schedule is available here: http://www.oracle.com/openworld/oow11-focuson-mysql-486114.pdf
Here are a couple thoughts of mine about the week:
Support and visit the MySQL Community Kiosk at Moscone West Hall Level 2 as much as possible.

Sunday @ Moscone West  A great line-up of presentations by the IOUG/MySQL Community itself. It will be hard to pick which sessions to see. MySQL ACE members Ronald Bradford and Giuseppe Maxia are some examples of the experts talking on Sunday.
Monday @ Marriot MarquisThe MySQL keynote by Tomas Ulin, of course, should not be missed.Catch sessions by Oracle engineers and MySQL ACE members such as Sherri Cabral, Sarah Novotny, and Yoshinori Matsunobu.
…

There is a game that a small group of friends and I have been playing since my Friendster years. It's called Stump the Murph. Basically if there is some weird problem in Linux mainly but it's in a variety of subjects-that we can't figure out we pass it to one of our friends Kevin Murphy. In 8 years I believe I stumped him once but I can't remember what it is so it doesn't count.

Here is the problem

SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

"Obviously" this means you need to raise the ulimit for the process running mysql. I say "obviously" because this error means different things. In most cases it means that the server ran out of memory. perror 11 says OS error code  11:  Resource temporarily unavailable, yet when there is enough memory there may be a …

Two of my proposals for Percona Live London on October 24-25 have been approved! Yes, I really had to propose them and get them approved like everyone else, although as I’m sure you can imagine, I had a good chance at being accepted :-) Not all of my talks were accepted, though.

I’ll be presenting a half-day tutorial on how to get great results when troubleshooting MySQL problems, and a conference session on how to use TCP packet headers to measure and analyze a surprising variety of aspects of MySQL performance and scalability.

The …

 Oracle starts charging for MySQL Add-ons

Exciting news, Oracle just announced commercial MySQL extensions that they'll be offering paid extensions to the core MySQL free product.

To be sure, this has raised waves of concern among the community, but on the whole I suspect it will be a good thing for MySQL.  This brings more commercial addons to the table, which only increases the options for customers.  Many will continue to use the core database product only, and avoid license hassles while others will surely embark on a hybrid approach if it solves their everyday business problems.

Speaking of licensing, back in May, Amazon announced that it's RDS or Relational Database Service would now offer Oracle as an option. …

The Oracle Contributor Agreement, or OCA (born as the SCA) is a required document before we can accept such contributions and a fairly common practice in open source projects. One important thing that has changed for the OCA is the email address to use for signed contributor agreements. Check this …

I received a phone call from a friend of mine who had some questions about storing image files as blobs in MySQL. He wanted to design a web site that would allow someone to upload an image, and then that image would be stored in the MySQL database for viewing later. He stated that he was going to be storing thousands of images. I mentioned that it might be better to store the images on the file system, and then to just store the location of the image in the database. But, he still wanted to know how to do it and would decide which solution he would incorporate later.

I already had a Perl script that allowed me to upload files to a web site, as I would give out this URL to people that wanted to send me large files. And, I know that you can store images (and other files) in MySQL as a blob, but I wasn’t sure how to display the blob as an image in HTML (once I had retrieved it from the MySQL database). A search on Google provide bits and …