InMobi, one of the fastest growing global mobile advertising networks, delivers results to its partners through intelligent mobile advertising solutions. The advanced technology enables advertisers to discover their target audience on mobile internet sites and mobile applications in a measurable manner. Publishers can leverage the capability to serve contextual ads to the users of their sites, thereby increasing the value of their mobile property. InMobi’s vast reach coupled with the precision of the mobile medium provides the optimal platform for advertisers and publishers to take advantage of mobile advertising.
A key requirement for supporting mobile advertising is a scalable database. InMobi serves over 26 billion ad impressions per month which requires a unique set of capabilities from the underlying database.
The Challenge: Scalable Database Infrastructure to Support Billions of Ads
When InMobi was founded in 2007, the CTO knew that scalability and performance would be key concerns. With billions of mobile devices increasingly being used to browse the web, taking advantage of the opportunity to deliver a mobile advertising platform would require the right infrastructure. But as a startup, InMobi did not have an unlimited budget and couldn’t just turn to the traditional database vendors for a solution. InMobi needed a low-cost database solution that would meet its scalability and performance requirements, now and in the future.
The Solution: EnterpriseDB Postgres Plus Advanced Server
InMobi’s CTO had experience with several open-source databases including MySQL and PostgreSQL. Given the scalability requirements InMobi had, PostgreSQL was the better fit, but the CTO did not want to be self supported or rely on just the community for support. He needed a partner to be there throughout the process.
The CTO had heard of EnterpriseDB and upon further research and evaluation discovered EnterpriseDB offered the product InMobi needed in Postgres Plus Advanced Server and the support it would need to implement the infrastructure for its global mobile advertising network, all at a reasonable cost.
InMobi’s initial database installation took only 30 minutes, and that same installation is still running today. With the features of Postgres Plus Advanced Server and the assistance of the EnterpriseDB team, the InMobi team have been able to simply add space when needed and add replication when desired without having to reinstall the database.
Postgres Plus is the backbone of everything InMobi does. There are 25 database instances across four datacenters with replication implemented between them. The databases range from reporting databases that reach 600 GB to read-only transactional databases that are just 1 GB in size.
InMobi implemented its solution using a combination of Java, Python, and Perl along with technologies including Hadoop and Cassandra.
With EnterpriseDB and these technologies, InMobi achieved the scale it needs, with over 26 billion ad impressions per month, each ad served involving Postgres Plus. The infrastructure supports over 200,000 transactions per minute across the globe with a three millisecond response time.
Partnership with EnterpriseDB
InMobi’s distributed data centers required the use of the replication features Postgres Plus offered. The challenge was that a multi-master setup was needed but PostgreSQL natively supported only a single master configuration. Working with EnterpriseDB, InMobi was able to engineer a solution providing multi-master support, but the most recent release of PostgreSQL has enhanced replication features natively offering this support and InMobi is looking forward to moving to this release. And in response to feedback from InMobi and other customers, EnterpriseDB has accelerated how quickly features from the community are available in Postgres Plus which will enable InMobi to move to new versions more quickly than before.