‘MySQL’ Videos

January 31, 2017 — WordPress is built on 12 MySQL tables than can support the weight of almost any web project. But in some cases we need to set our custom tables in order to get better results. I will show in this talk the magic behind the default tables, how to create new ones, and what WordPress tools we may use to control them.

December 10, 2015 — Mirroring WordPress data to Elasticsearch enables breaking some of the constraints that MySQL imposes on performance and relevancy. There is a high barrier to entry, but some strong benefits. I’ll survey the different use cases I’ve heard about, compare some plugins and libraries, and talk about the impact I’ve seen Elasticsearch have so far.

January 1, 2015 — Protecting our WordPress sites is important to all of us; this talk will help provide you with the tools to secure your server. Learn the best practices to follow in securing your WordPress site, and the common pitfalls to avoid. This is for both new users who are setting up a WordPress installation from the ground up, and also experienced WordPress users for hardening their existing sites.

February 24, 2009 — If your hosting package only allows you one MySQL database, then this video is for you. Kenneth Watt (founder
of TechnoFinger) shows you how to edit your wp-config.php file so that multiple versions of WordPress can be run on the one MySQL database.