MySQL: Replication can be enough for heavy traffic.

Average: 8.3 (4 votes)

Distributing traffic smartly in a small cluster setup can be enough to deliver content fast and easily. In this session I would like to show our setup on, where we host thousands of merchants and over 60 Terabytes of downloadable products on a very simple and easy self-made LAMP cluster with SphinxSearch Server.

The session includes a complete sketch of all involved servers, NFS response times, traffic handling methods with Squid reverse proxies, catalog browsing with MySQL and Sphinx and how the data is distributed with 2 masters and 6 slaves with MySQL 5.x.

The idea is to have a scaling setup that is focused on the load balancing of reads and writes and how faulty servers can be handled without downtime.

Replication and High Availability Strategies
Experience level: 

Schedule info

Union Square

Schedule Info

2 October 11:30 - 12:20 @
Union Square


Ralf Schwoebel's picture
CEO, Tradebit, Inc.

In 1995 Ralf started one of the first online shops in Germany and is connected to the eCommerce topic since then. From 2001-2004 he led one of the biggest SEO companies in Germany and started as the download marketplace in late 2004 on a self-made Linux cluster. now hosts more than 25,000 merchants on a LAMP cluster with more than 60 Terabytes of downloadable products. Peter Zaitsev assisted Ralf in 2006 when the platform took the first steps towards a scalable setup.

Ralf is speaking regularly on Internet marketing conferences with practical insights in his daily work and shares real life examples.

His activities include: :
SMX US and SMX Germany:
IPv6 Kongress Germany:
Affiliates4u :

He is a big Linux fan and supporter, married and an active blogger.

Sponsored By