Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 653 0071
Germany: +49 89 420 95 98 95
France: +33 1 70 38 72 00
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 653 0071
Asia Pacific: +81 3 5918 7507
Learn about new MySQL releases, technical articles, events and more.
Designing a Highly Scalable MySQL Architecture for Write-intensive Applications
Tuesday, May 20, 2008
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.
To verify your browser and operating system compatibility with Webex, please click here »
If you already have a MySQL.com account, save time by logging in now.