Tag Archives: mysql

Percona Live London 2013

Over the recent months I’ve been pushing myself to be more of a software engineer than a “coder”. To that end I’ve been investing my time heavily in a lot of things, and part of that is attending talks and conferences on interesting topics. So when I saw the tweet below, I jumped at the chance!

https://twitter.com/webandphp/status/385324546254835713

I earnestly entered and chance would have it, I won two tickets to Percona Live. The boss, Mike Nolan, graciously decided free was a good amount to spend on professional development. It probably didn’t hurt that I offered him the second ticket.

We unfortunately didn’t get to attend the well regarded Percona Live tutorials, something I was reminded of talking to other attendees when they mentioned quite how good they were. We did however try to attend different sessions on the conference schedule.

The keynotes were both informative and amusing, Mike hadn’t previously been aware of the animosity between Monty and Oracle, by the end of the keynotes he was. Nothing serious, just veiled digs!

Here’s the breakdown of my day:

Whilst I took notes in most of the talks covering tips, tricks, tweaks.. my biggest take home was from Luis Motta Campos‘ talk about MySQL, the ebay Classifieds Way. It was really interesting to see things we do (and have planned to do) at Edge Hill University, done on such a scale in a truly professional way. It both reinforced my plans for our own infrastructure and heavily added to my wishlist and roadmap!

Hopefully I’ll get some more time next week to do a more detailed break down of the individual talks. Or perhaps cover PHPNW 2013 or the Inviqa TDD Immersion day I did over the past couple of months!

Steve Daniels

ERROR 2013 (HY000): Lost connection to MySQL server during query

If you’ve just set up a new mysqld service and your getting the above error when trying to connect over TCP (even when tunnelling in over SSH), don’t fret. The answer lies in /etc/hosts.allow. You need to add in a line similar to this:

mysqld: 192.168.0.123

This foxed me a while ago and I didn’t get round to fixing it as it wasn’t yet mission critical, however it also stopped us dead in our tracks yesterday. Thank fully to Neil in Core Services who had a moment of clarity we’re now back in business.

UPDATE:

Now I know the problem, a little more simpler Google querying led me here a 2004 post on MySQL’s access denied troubleshooting page which mentions that the cause of this is mysqld being compiled with tcp-wrapper support.