0 to 60 in 3.1. Tyler Carlton Cory Sessions. <Insert funny joke here>. The Project. Medium sized demographics data mining project 1,700,000+ User base Hundreds of data points per user. “Legacy” System – Why Upgrade?. +. Main DB (External Users) Offline backup (Internal Users)
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Smaller is Better
On average, CPU usage with MySQL was 20% lower than our old database solution.
Note: Load times differ depending on your data size
Queries per Second (over 20 days)
Stats for March 2008
MySQL ( API ) Nodes use about 9 MBs max under our current structure
Totaling 75 MBs during peak(600 Mbs)
4 node test cluster
4 x overall performance
Brand new patch to handle automatic Ethernet failover / Dolphin Fail Over
( beta as of March 28 )Net Usage: Next steps…