Tech

Oracle Focuses on Improving Database Speed ​​During LogFire Migration

Improve your enterprise data technology and strategy with. Transform 2021..


when Oracle With the acquisition of LogFire, everyone in the company knew there was a change. LogFire managed a warehouse for hundreds of e-commerce shops. That is, I was juggling hundreds of PostgreSQL databases. Oracle has planned at least two major migrations. Integrating LogFire’s e-commerce backend tools with Oracle’s collection of web services and migrating data storage work to Oracle’s own Autonomous Database.

The acquisition legal process was completed in September 2016, and LogFire’s product is now known as the Oracle Supply Chain Management Cloud. Database migration — Migrating from PosgreSQL to Oracle Autonomous Data — took some time and was finally completed about 18 months ago. Oracle advertises this transition as an experiment to show the value of its products. The database giant calculated the numbers and found that the cloud was supporting twice as many customers 55% faster. In addition, automation eliminates the need for contractors to do all the manual database work.

Prior to the acquisition, LogFire used a PostgreSQL database on Rackspace hardware to track each customer’s order processing. The contractor team was “on-call” to handle all tasks related to patching, scaling, and failover planning, and to resolve issues caused by outages. Each of these chores looks small on its own, but required a team of 10 database administrators in total.

Oracle said the switch to an autonomous database was completed shortly before the pandemic occurred and was essential to manage the surge in orders. Matched with the people at home We rely on e-commerce shops to get what we need.

“they [database administrators] George Lumpkin, Vice President of Product Management at Oracle, explains: “You don’t need a DBA to resize your database. You don’t have to budget or add capacity. You can add capacity as needed.”

This migration also included migrating the database to Oracle’s own cloud with a “dedicated” Exadata machine. This was a major factor in the response time reduction reported by Oracle.

“they [LogFire’s servers] We’ve moved from Postgres running in fairly common virtual machines to a highly optimized hardware platform with critical flash and optimized IO, ”says Lumpkin. “that is [Exadata machine] It’s just a hardware system built for an Oracle database. “

What can other businesses expect? This depends heavily on the consistency of the database load. E-commerce shops tend to receive more luggage during the holidays. Demand for some streaming services increases over the weekend. These fluctuations are the job of the DBA, which can be mitigated by automation.

For small businesses with only a small number of databases, the impact of switching to Oracle Autonomous Data may not be as significant as with LogFire. Database chores usually merge with other tasks on the developer’s lap.

“It’s not the same as doing everything manually,” explains Steve Zivanic, Global VP of Databases and Autonomous Services. “I had to tune the database manually. I had to do a manual backup. Basically, I had to make sure I had enough processing power. It’s all done, so my eyes You can focus on the business in front of you. “

Venture beat

VentureBeat’s mission is to become a digital town square for technical decision makers to gain knowledge about innovative technologies and transactions. Our site provides important information about data technologies and strategies to guide you in leading your organization. Become a member of our community and visit:

  • The latest information on the subject you are interested in
  • Our newsletter
  • Gated Sort Reader Content and Discounted Access to Valuable Events such as: Transform 2021: learn more
  • Network function etc.

Become a member

Oracle Focuses on Improving Database Speed ​​During LogFire Migration

Source link Oracle Focuses on Improving Database Speed ​​During LogFire Migration

Related Articles

Back to top button