Goodbye Oracle! Exclusive Insights into PrestoMall’s Transition to Alibaba Cloud

Why Did PrestoMall Stop Using Oracle?

In recent years, with the development of mobile Internet throughout Southeast Asia, PrestoMall experienced a boom in growth. In terms of revenue scale, the company achieved a growth of 256% over the past three fiscal years. With PrestoMall’s business successes, the amount of data they need to process started to increase sharply, which made their IT costs also soar. To ease these costs, PrestoMall saw getting away from Oracle as a solution.

Choosing the Best Option

The main motivation for PrestoMall to part ways with Oracle was reducing its IT spending. Therefore, early in the process of looking for alternatives, IT costs and fees were naturally a major concern. Plus with the current license about to expire, quick migration was also an extremely important consideration.

  1. Use an open-source database product, such as MySQL or PostgreSQL.
  2. Continue using their Oracle databases and renewing the license when it was due.
  1. Would the existing local deployment solution be able to be retained or would a cloud-based migration solution need to be implemented?
  2. How intense would the migration process be and how long would it take?
  3. Is there sufficient technical support to adopt the new technical solution?
  • Alibaba Cloud Data Transmission Service (DTS) is a migration tool that supports data communication among RDBMS, NoSQL, OLAP, and other data sources, incorporating the data migration, subscription, and synchronization process all together.
  • Alibaba Cloud’s Advanced Database and Application Migration (ADAM) service supports the complete and comprehensive migration of Oracle-based systems.
  • Second, the migration cost is optimal. Here cost not only refers to the monetary costs related to using database resources after migration but also includes the migration process in all of its complexity, including code modification and migration time, among other things. Through a thorough investigation, it was found that ApsaraDB for PolarDB was highly compatible with Oracle database systems, and therefore all the associated migration costs could be reduced significantly.
  • Third, risks are controllable and technical support was guaranteed.

Migration Process

Now that the migration solution had been determined, the next is to plan specific migration tasks. The process of migrating PrestoMall’s systems from Oracle was done in six steps. Companies that are interested in going forward with similar migration processes can also take these steps.

  • Step 2. Make it possible to migrate from Oracle. This involves decoupling from Oracle databases and upgrading the business IT architecture to achieve greater business flexibility.
  • Step 3. Transform your business. This is the most difficult part for all customers who want to move away from Oracle. The two major challenges for business transformation are workload evaluation and compatibility.
  • Step 4. Migrate data. This not only ensures consistency between full and incremental data, but also ensures data backflow capability so that data can flow back and forth freely.
  • Step 5. Test and fine-tune the new database. Although PolarDB is compatible with Oracle, they are two products with different product features. Therefore, further debugging is required after migration.
  • Step 6. Perform cutover and provide support. Two weeks of support from Alibaba technical experts was available after the cutover and launch is completed.

Afterword

There is a saying in the industry that “the world has suffered under Oracle for a long time,” but actually going away from Oracle is more difficult than you can imagine. So, what are the options people usually go for when they don’t want to use Oracle anymore?

Original Source:

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store