Category: MySQL

Installing a web server on Ubuntu

In this video we set up a LAMP stack web server for local development on an Ubuntu desktop (version 11.10). We will walk through installing and using tasksel to get the web server installed, then...

Installing MAMP web server

This video shows you how to download and do the initial setup of MAMP, which is Apache, MySQL and PHP for Macintosh. It shows some basic configuration tweaks to change the port from 8888 to the...

Installing WampServer

This video walks through the process of downloading and doing the initial configuration of WampServer, which is Apache, MySQL and PHP for Windows. It shows how to turn it on and off, as well as...

An Overview of Performance & Scalability

Drupal can power any site from the lowliest blog to the highest-traffic corporate dot-com. Come learn about the high-end of the spectrum with this comparison of techniques for scaling your site to...

Helpful tools for module development

In this video Joe Shindelar provides a quick overview of the minimum set of tools you'll need in order to get started with module development. Some kind of web server to host your development site...

Ubuntu web server configuration

In this followup video to Installing a web server on Ubuntu we learn how to configure the various pieces of our local...

Installing Memcache

In this video we'll be talking about caching authenticated user requests using Memcache. We walk thorugh installing and configuration of Memcached on the server, as well as how to use the Drupal...

Installing Varnish

In this video we discuss reverse proxy caching and install the popular cache application Varnish.

Introduction to Drupal Performance and Scalability

In Drupal Performance & Scalability, Matt Westgate and James Sansbury teach you all you need to know to get peak performance out of Drupal on the LAMP stack.

Apache optimizations

Now that we have a lot of the pieces in place on our server and within our Drupal site, we'll look at various optimizations we can make to Apache, including ModExpires, KeepAlive, and MaxClients...

MAMP server configuration

This video describes a number of the most important configuration files within MAMP that are commonly edited in order to run a web application like Drupal locally. There's a brief tour of the http...

Using the Apache benchmark tool

Here we'll learn how to use the built-in Apache benchmarking tool to get a baseline understanding of the site performance. Then, we'll make some optimizations within the Drupal site and see the...

Overview of performance optimizations

In this video we define the terminology we'll be using in the series. We'll look at the entire Drupal stack of technologies and discuss how the components all work together and what kind of...

Using MySQL from Command Line

This video looks at the basics of working with MySQL from the command line. We get into the mysql environment and look at databases, tables and fields. We cover creating and deleting databases,...

Installing Alternative PHP Cache (APC)

In this video we'll discuss PHP caching and walk through installing APC.

Isolating performance bottlenecks

With a Pressflow site all set up and having the LAMP stack optimized, we'll take a look at how to identify bottlenecks on your site and how to troubleshoot them.

LAMP stack installations

In this chapter we walk through installing our LAMP stack, using CentOS as our base.

Database tuning

In this video we'll look at optimizing your MySQL database for Drupal. We'll return to the my.cnf file to discuss more details about InnoDB and work with MySQL query caching.

WampServer Configuration

This video walks through some of the most common and important server configurations for running a local development server on WAMP. This will show you how to enable the Apache rewrite_module...

Installing Pressflow

In this video we'll be installing the Pressflow distribution of Drupal. We make some changes to Apache to prepare and then go through the steps for installation. Once we've installed Pressflow, we...

Preparing MySQL

Here we will look at basic configuration and optimizations for MySQL, using the my.cnf file. We'll also discuss using InnoDB vs MyISAM data storage.

PHP.ini optimizations

In this video we dive into optimizations for PHP by taking a tour through the php.ini file and tweaking some of the configuration.

Performance and scalability resources

We've covered a lot of Drupal performance and scalabilty tips in this series. Here are more resources so you can explore further and keep up with the latest information.

Content Delivery Networks (CDN)

In this video we'll explain what a Content Delivery Network (CDN) is, what your options are, and how to integrate one with Drupal.

Drupal Performance and Scalability Review

We're wrapping up the series with a review of all the material covered and hitting the highlights of how to keep your site running fast and smooth.

Hardware topologies for scaling

Aside from performance a site also needs to be able to scale well. We'll look at ways to handle more traffic by doing an overview of typical hardware setups for scaling and how they work.

Performance Changes in Drupal 7

Drupal 7 has introduced a number of changes that provide improvements for performance and scalability. We'll take a tour of what these changes are so you can be aware of the differences between...

Lullabot logo

Lullabot has trained thousands of Drupal developers & guided the development of some of the largest Drupal websites.