Inpho's critical processes back up to speed with Pythian

Overview

InPho Interactive is Australia’s leading business-to-business technology provider, specializing in mobile applications—interactive voice response products, and web and e-mail services.

Customers had become frustrated by the poor performance of Inpho’s SMS batch process which took upwards of 40 seconds to complete. In addition, InPho had several new SMS, Chat, and IVR applications to roll out with different versions of MySQL to balance. All of these new services needed to scale gracefully and offer redundancies in the event of a server failure.

InPho partnered with Pythian to resolve customer-facing performance issues and reduce service delivery risk for the new applications.

What we did

Conducted a remote database performance and tuning audit of the main Oracle database, which supports InPho’s SMS gateway applications
Used Oracle’s function-based indexes to allow the SMS batch process to complete much faster
Conducted the necessary code change to the index structure and the programming changes to the Oracle PL/SQL packages
Worked with InPho’s team to determine the business and scaling requirements for the new SMS, Chat, and IVR applications
Provided detailed guidance on structuring InPho’s MySQL database architecture to deliver performance and availability under load
Ensured scalability by implementing the separation of applications onto individual servers and MySQL instances
Improved cost-effectiveness by implementing a secondary slave server running multiple MySQL slave instances that also ran specific MySQL versions as required by each application
Provided 24/7 support and monitoring