OpenX is a global leader in digital advertising technology and services, enabling digital media companies manage and maximize their ad revenue. Their unique platform conducts 250 billion monthly transactions with 12 billion daily bids from buyers.
The MySQL Architecture at OpenX was not robust enough to handle high volume reporting and delivering BI query results in a timely manner. The current infrastructure had outgrown and the data loads from HADOOP and MySQL were enormous causing the BI reports to take too long and fail. There was uneven distribution of data on the MySQL Cluster resulting in poor performance. Estuate provided a solution by migrating analytics and reporting to HP Vertica cluster.