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