April 16, 2014

Creating GEO-enabled applications with MySQL 5.6

In my previous post I’ve showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post I will show how we can obtain open-source GIS data, convert it to MySQL and use it in our GEO-enabled applications. I will also present at the upcoming Percona Live conference on this […]

New MySQL features, related technologies at Percona Live London

The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features: Opening keynote highlights MySQL 5.6 new features. New InnoDB Compression talk will cover the new compression algorithm, implemented by Facebook and […]

Using the new spatial functions in MySQL 5.6 for geo-enabled applications

Geo-enabled (or location enabled) applications are very common nowadays and many of them use MySQL. The common tasks for such applications are: Find all points of interests (i.e. coffee shops) around (i.e. a 10 mile radius) the given location (latitude and longitude). For example we want to show this to a user of the mobile […]

10 years of MySQL User Conferences

In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of good things, fun things to remember. 2003 was the year that marked the first MySQL user conference […]

MySQL Indexing Best Practices: Webinar Questions Followup

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway. Q: One developer on our team wants to replace longish (25-30) indexed varchars with […]

SQL Injection Questions Followup

I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs and articles have about this security risk.  You can register for the webinar even now that I’ve presented it, and you’ll be emailed a link to the recording, which will be available soon. During […]

Percona Live MySQL Conference 2012 Prize Winners and Percona Live New York 2012

I’m pleased to announce a variety of prize winners associated with the Percona Live MySQL Conference and Expo 2012. The following people won prizes in the pre-conference registration promotion: Kindle Fire Winners: Tatiana B., Etsy, United States Tom H., Cloudtree, United States Loren A., HearSayCorp, United States High Performance MySQL 3rd Edition Book Winners: Marcus […]

Benchmarking single-row insert performance on Amazon EC2

I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally built is long over, […]

Congratulations to Percona Live Ticket Winners!

It’s taken a little while to sort out the contest logistics, but we’re ready now, so I want to congratulate our three first-prize winners to the Percona Live MySQL Conference and Expo: David Juntgen Jeff Hansen Domenick Petrella For helping us to promote the conference, they’re receiving full conference passes, including tutorials. I hope you […]

Percona Training In Sydney

For those that missed it – we added training in Sydney to our website. We’ve booked a training venue near the Museum of Contemporary Art (200 George Street). Some minor logistical changes: The start time will now be 9am to 5pm We look forward to seeing you there!