Wednesday, 24 October 2018 10:36

Oracle migration caused Amazon Prime Day outage: report Featured

Oracle migration caused Amazon Prime Day outage: report Pixabay

Global retail giant Amazon experienced problems with its retail website on its Prime Day, the company's made-up holiday in July meant to boost sales, because of problems in migrating from Oracle's database to its own technology.

A report from CNBC, which obtained an internal Amazon report, said the incident showed that Oracle's software was superior to what Amazon had deployed in some respects.

It said the website glitches experienced on Prime Day came at a time when the company was also trying to hose down an issue at one of its bigger warehouses in Ohio. Together, these led to thousands of deliveries being delayed.

The report obtained by CNBC, running to 25 pages, showed that Amazon's technical staff struggled to find out the root cause of the issues on Prime Day.

Last year, an error by a member of its technical staff caused Amazon Web Services to go down. The company said at the time that the S3 team was attempting to debug an issue that caused a slowdown in its billing system when one of its technical staff ran a command that was intended to remove a few servers from one of the subsystems used by the S3 billing process.

The worker entered one wrong input for the command and ended up removing a much larger number of servers than intended, some of which supported two other S3 subsystems.

CNBC said Amazon also failed to come up with a contingency plan in the event of any error in its replacement database, which is the open-source PostgreSQL software, sold by a company known as Aurora.

One of the questions in the Amazon technical report obtained by CNBC asked the engineers why the database system had not failed during the previous Prime Day when it was running on Oracle. They said that Oracle and Aurora PostgreSQL handled savepoints differently.

An Amazon spokesperson attempted to play down the issue and even claimed there was no outage, even though the report that CNBC obtained said that the "degradation resulted in lags and complete outages".

CNBC said 13 warehouses had moved from Oracle to PostgreSQL before Prime Day. It said the Amazon report cited delayed deliveries for 15,000 packages and about US$90,000 in wasted labour costs.

WEBINAR event: IT Alerting Best Practices 27 MAY 2PM AEST

LogicMonitor, the cloud-based IT infrastructure monitoring and intelligence platform, is hosting an online event at 2PM on May 27th aimed at educating IT administrators, managers and leaders about IT and network alerts.

This free webinar will share best practices for setting network alerts, negating alert fatigue, optimising an alerting strategy and proactive monitoring.

The event will start at 2pm AEST. Topics will include:

- Setting alert routing and thresholds

- Avoiding alert and email overload

- Learning from missed alerts

- Managing downtime effectively

The webinar will run for approximately one hour. Recordings will be made available to anyone who registers but cannot make the live event.



Security requirements such as confidentiality, integrity and authentication have become mandatory in most industries.

Data encryption methods previously used only by military and intelligence services have become common practice in all data transfer networks across all platforms, in all industries where information is sensitive and vital (financial and government institutions, critical infrastructure, data centres, and service providers).

Get the full details on Layer-1 encryption solutions straight from PacketLight’s optical networks experts.

This white paper titled, “When 1% of the Light Equals 100% of the Information” is a must read for anyone within the fiber optics, cybersecurity or related industry sectors.

To access click Download here.


Sam Varghese

website statistics

Sam Varghese has been writing for iTWire since 2006, a year after the site came into existence. For nearly a decade thereafter, he wrote mostly about free and open source software, based on his own use of this genre of software. Since May 2016, he has been writing across many areas of technology. He has been a journalist for nearly 40 years in India (Indian Express and Deccan Herald), the UAE (Khaleej Times) and Australia (Daily Commercial News (now defunct) and The Age). His personal blog is titled Irregular Expression.



Recent Comments