In looking at operating systems in use for last year I found a very high concentration of RedHat/CentOS 5, and Ubuntu LTS operating systems. I would like to get a better picture of what is really used for MySQL production systems.
Please take a moment to help me out. This survey only has one question.

Thanks

Download PDF Presentation

At the recent AWS Meetup group in New York, I gave a presentation on “Lessons learned managing large AWS Environments”.

This included my experiences in managing and optimizing AWS costs, CLI automation for web scale (my work at GitHub), knowing about and improving security, what is important monitoring and dealing with failure.

Date: Feb 22, 2013
Location: SpilGames, Arendstraat 23, Hilversum, Netherlands
Planned time: 5pm
Page: http://www.meetup.com/MySQL-User-Group-NL/

Agenda:
17:00 SpilGames Pub Open
18:00 Introduction
18:15 “MySQL User Defined Functions” by Roland Bouman
19:00 Pizza
20:00 “Total cost of owership” by SpilGames

Recently some of my fellow Perconians and I have noticed a bit of an uptick in customer cases featuring the following error message:

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.

The canonical solution to this issue, if you do a bit of Googling, is to increase the number of processes / threads available to the MySQL user, typically by adding a line like this to /etc/security/limits.conf:

mysql  soft  nproc  4096

followed up by a restart of MySQL in a fresh user session. If you’re running RHEL/CentOS 5, Ubuntu, or versions of Fedora prior to Fedora 9, this solution will most likely solve your problem. But with RHEL/CentOS 6 (and derivatives) and Fedora 9 and later, you’ll likely find that this tweak no longer works.

In Fedora 9 and RHEL 6, a “bug fix” was introduced which was …

Learn to create best-of-breed web applications with the MySQL and PHP - Developing Dynamic Web Applications course. 

After taking this course you will be able to:

• Describe the LAMP architecture
• Use the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL
• Use SQL query commands to retrieve data from the MYSQL database
• Change table data using the SQL Data Manipulation Language (DML) commands
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Use session handling to authenticate and monitor user identities
• Describe the purpose of template systems

FOSDEM 2013

The Free and Open source Software Developers’ European Meeting (FOSDEM) is a two-day event organized by volunteers to promote the widespread use of Free and Open Source software.

I attended for the first time over the weekend and was really impressed by the number of people there, the energy and the quality of the content. The event really lives up to it’s name and is very developer-focused.

In the end, I got the opportunity to make 2 presentations. The first is a general introduction to MySQL Cluster….

The second illustrates how you can realise the benefits promised by NoSQL data stores wihtout losing the consistency and flexibility of relational databases…

FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels.

I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.
For once, I will leave the comments around the MySQL talks to others, I am sure there will be posts on the matter. In this post I want to cover some of the non-MySQL talks and discussions I have attended and heard. Of course the topics that have been discussed are still relevant for MySQL and for the future of the MySQL ecosystem.
First of all, the number of attendees was impressive. The organisers claim there were more than 5,000 open source enthusiasts, in my opinion the number was even higher. Every room was …

FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels. I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.  

read more

I wonder if the MySQL archaeologists out there would be willing to unearth some (presumably ancient) history for me. Why does the logging configuration merit special mention in the version_comment variable?

The more I think about this, the more bizarre it seems. I enabled logging. The version reported by the server changed. No, really, is my server somehow a different version of MySQL now?

130203 15:39:55 [Note] ./bin/mysqld: ready for connections.
Version: '5.6.7-rc-log'

I assume there’s a good story behind this somewhere. I’m thinking a priest, a rabbi, and Monty walk into a bar, and black vodka is probably involved at some point too :-)

If for any reason you couldn’t attend my talk at FOSDEM earlier today on improving MySQL security, I have already uploaded the slides. You can download them from here.