Inpho's critical processes back up to speed with Pythian

1 min read
Sep 5, 2023

Overview

Industries
Information Technology
 
Locations:
Australia

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 
 

Technologies used

 
  • Oracle
  • MySQL

Key Outcomes

Throughout the many years of our relationship, Pythian has been instrumental in maintaining our most critical applications. We’ve come to rely on their expertise for our daily support.

– Graeme Campbell, Technical Director, Operations, InPho

inpho 

 

40 seconds to 2 seconds

reduction in SMS gateway application response times 

Improved customer satisfaction

with the performance and responsiveness of applications  

Explore our Database Services 

No matter your business, no matter the challenge: Pythian’s solutions drive results.