Curing a Critical Security Bug

A WordCamp US this year, I spoke about the Trojan Emoji security bug, which we fixed in WordPress 4.1.2. In particular, I went through how we came to wrap our head around the bug, and then write a solution that worked for every WordPress site.

WordPress and UTF-8

Update: WordPress 4.2 has full UTF-8 support! There’s no need to upgrade manually any more. ? For many years, MySQL had only supported a small part of UTF-8, a section commonly referred to as plane 0, the “Basic Multilingual Plane”, or the BMP. The UTF-8 spec is divided into “planes“, and plane 0 contains the… Continue reading WordPress and UTF-8

Partitioning the WordPress Comments Table

WordPress sites can get big. Really big. When you’re looking at a site of Cheezburger, Engadget or Techcrunch proportions, you get hundreds of comments per post, on dozens of posts per day, which adds up to millions of comments per year. In order to keep your site running in top condition, you don’t want to… Continue reading Partitioning the WordPress Comments Table

Welcome, SkySQL!

It seems the SkySQL website just went live, which I hope will breath some life back into the MySQL ecosphere – it’s been a while since there’s been some new competition, especially in the style of classic MySQL services. For those too lazy to read the SkySQL site, the services offered are similar to what… Continue reading Welcome, SkySQL!

Leaving MySQL (Not Really)

I’ve been a bit slack about writing my MySQL thoughts of late. This would be caused by the fact that, as I write this, I’m now one week into a 12 month leave of absence from MySQL. Having given it much careful consideration, I’ve decided that the wisest way to survive the current economic problems… Continue reading Leaving MySQL (Not Really)