Designing a Highly Scalable MySQL Architecture for Write-intensive Applications

10,000 Tables Can't Be Wrong: Designing a Highly Scalable MySQL Architecture for Write-intensive Applications Tuesday, May 20th, 2008

In this Webinar you will learn from ScienceLogic about how they are using MySQL to perform hundreds of millions of database writes daily and continue to scale and perform extremely well.

ScienceLogic EM7 Meta-Appliances can gather hundreds of statistics every minute from each of thousands of devices. These need to be stored, analyzed, and summarized, with reports generated showing status and trends and alerts generated for any anomalies found. All of this must be done while providing end users immediate, responsive access to both the summarized and detailed data.

Given the growth patterns and the nature of the access that was required to the data, the ScienceLogic team chose to engineer their IT Management application to create databases and highly segmented tables on the fly and as required. The large number of tables ensures that only one thread is ever writing to a particular table at a time, even with a write to read ratio of 9:1.

Some of the EM7 systems in use by larger customers now have tens of thousands of MyISAM tables performing hundreds of millions of database writes daily and continue to scale and perform extremely well.

Using real-life customer examples, we will talk about why this approach was chosen, how it was implemented, specific databases tuning requirements with this architecture and the results obtained. We will include some small code examples using Python.

WHO: Richard Chart, Co-founder, ScienceLogic, LLC

WHAT: Designing a Highly Scalable MySQL Architecture for Write-intensive Applications web presentation.

WHEN: Tuesday, May 20, 2008, 10:00 am PST; 1:00 pm EST; 17:00 GMT
The presentation will be approximately 45 minutes long followed by Q&A.

WHERE: Simply access the web seminar from the comfort of your own office.

WHY: ScienceLogic gives you an in-depth view into how they are using MySQL to perform hundreds of millions of database writes daily and continue to scale and perform extremely well.

more...