Well, it seems to be the thing to do to talk about the things you submitted to MySQL Conference. So, I figured I would share. I submitted 3 topics.
From one server to a cluster
In the last 10 years, dealnews.com has grown from a single shared hosting account to an entire rack of equipment. Luckily, we started using PHP and MySQL very early in the company’s history.
From the early days of growing a forum to surviving _Slashdotting_, _Digging_ and even a Yahoo! front page mention, we have had to adapt both our hardware and software many times to keep up with the growth.
I will discuss the traps, bottlenecks, and even some big wins we have encountered along the way using PHP and MySQL. From the small scale to using replication and even some MySQL Cluster we have done many interesting things to give our readers (and our content team) a good experience when using our web site.
MySQL hacks and tricks to make Phorum fast
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Things we will talk about in this session include:
* Using temporary tables for good uses.
* Why PHP and MySQL can be a bad mix with large data sets.
* What mysqlnd will bring to the table with the future of PHP and MYSQL.
* How Phorum uses full text indexing and some fancy SQL to make our search engine fast.
* Forcing MySQL to use indexes to ensure proper query performance.
Perils of distributed software
Ever wrote software that has to be installed on n + infinity environments? Phorum is such software. The Phorum team has been developing for 10 years. The vast number of configurations and wide range of user experience has shaped how we have written Phorum. I will share some of the PHP, MySQL and user issues we have seen and how we have tried to work around them.
Wish me luck. Maybe you can get the full version of one or all of thse in April.