48 Sites, 150,000+ Entities, 287 Fields on an Entity (and counting), 2 Databases (MySQL & MongoDB), and 1 Drupal

A leading manufacturer of hose fittings and accessories had a diverse range of websites and products. The goal of the project? Unify all of their websites into one, international website and drastically improve the ecommerce experience. The problem? The initial spreadsheet of product data for the website went to past row 28,000 and to column OP. A standard SQL database such as MySQL would die trying to load data from that many tables just to load one entity. With that in mind, we moved the entire field storage engine into MongoDB and utilized the MongoDB module. This allows us to fully search and load commerce products in milliseconds without the need for a million JOINS.

During the session we will share our secrets for working with Mongo. We’ll share how much we liked (or disliked) Views, we’ll share how much Commerce relies on Views, and we’ll share which modules just flat out don’t play nicely with Mongo. We’ll also share some of our best tips for using Entity Field Query, NGINX, Queues, and managing a project of this scale.

You’ll walk away having learned about a fantastic, responsive, Drupal e-commerce website as well as having an understanding of the pros and cons of MongoDB. Along the way, you’ll pick up some of of our tips for running a successful Drupal project which are sure to help you with your next project.

Schedule info
Track: 
Experience level: 
Intermediate
Drupal Version: 
Drupal 7.x