CWare powers its File-O solution with MySQL Database Service on Oracle Cloud Infrastructure.
Business Challenges
CWare Technologies is an Independent Software Vendor who in 2017 began as a support specialist of Oracle Siebel customer relationship management (CRM) systems for organizations in the Middle East. Their services evolved into the implementation and development of enterprise applications for on-premises deployments in the fields of customer relationship management (CRM) and Enterprise Resource Planning (ERP).
CWare's File-O solution aims to provide a workspace file-sharing tool to meet the basic order management needs of small and medium-sized companies. Recently, the company took the step of developing cloud-based applications but struggled to find a high performance back-end database.
The company started out using AWS, then moved to MongoDB. Users who performed the acceptance testing of the company's workspace collaboration app complained of sluggish website loading, a bottleneck to commercial roll out.
Business Results & Metrics
CWare found what they needed in MySQL Database Service on Oracle Cloud Infrastructure (OCI). Starting from scratch in cloud apps development, CWare seized the advantages of not having to run servers by developing File-O through the Oracle Cloud Region Germany Central data center in Frankfurt. "OCI is just wonderful," says Ousaid Imtiaz. "We spin up compute instances any time and put it down as we wish. The corresponding apps are live in a second."
MySQL Database Service substantially accelerated the loading speed of File-O pages through the high availability and performance supplied by Oracle Cloud Infrastructure. File-O's dashboard and landing page load times decreased by 3X and users immediately noticed the improvement. "We have 500 prospects using the app and their feedback tells us that speed issues disappeared now that we are on Oracle Cloud with MySQL as a database," notes Ousaid Imtiaz.
CWare also saw a sharp reduction in iterative and frequently used Application Programming Interface (API) calls, down from 12 calls to 4 calls with MySQL Database Service, and response time decreasing from 7 seconds to below 1 second. "MySQL is saving us time and cost in transferring data between the application and the customer," Ousaid Imtiaz comments.
Cost savings come from running workloads on Oracle Cloud Infrastructure as well as from low egress fees, due to OCI's high threshold for free outbound data transfer. MySQL Database Service also solved pain points related to searching long strings through the Like Operator ability to run through client folders, personal folders, project/team folders, or chat folders at high speed.
CWare provides further client satisfaction by protecting data through Oracle Cloud Infrastructure's Web Application Firewall, a cloud-based shield against malicious and unwanted internet traffic compliant with the Payment Card Industry Data Security Standard (PCI DSS).
Going forward, the company is planning to use Oracle Cloud Infrastructure Service Operator for Kubernetes to make it easier to manage and scale their application, while leveraging MySQL Cluster for Oracle Kubernetes. They also have their sights on the HeatWave in-memory query accelerator for providing customers with enhanced analytics and reporting tools. "We rely on MySQL Database Service for performance and speed. Once we reach a high customer count, we will certainly deploy HeatWave, which I'm sure will be another great improvement," says Ousaid Imtiaz.
Meanwhile, CWare enjoys the availability of Oracle Premier Support, whose experts worked with the company from the outset to help their workspace collaboration tool develop in the cloud. "I just love Oracle Support," Ousaid Imtiaz says. "I know that these guys can help us within an hour of any issue. No more sleepless nights worrying about load times, poor database response, or anything like that."
Why Oracle
Having tried out AWS and MongoDB, CWare ran a proof of concept on the newly launched Oracle MySQL Database Service and found the right cost and performance combination for moving their applications development to the cloud.
CWare selected MySQL Database Service for the database's high availability, the low latency of the Oracle Cloud Region data center, the minimal data egress costs, and a roadmap that includes MySQL HeatWave and Oracle Cloud Infrastructure Service Operator for Kubernetes.
"We are using Oracle Cloud Infrastructure to our fullest capability and are eager to adopt more as soon as our workload increases," states Ousaid Imtiaz.