On Prime Day Promotion Day, this number one electronics retailer is busy dealing with major websites that cause slow sales processes, while busy dealing with the technical problems encountered in the largest warehouse in Ohio, this should be Technical problems have led to tens of thousands of pieces of parcel shipping delay.

The file shows that this problem is largely attributed to Amazon's migration from Oracle database to its own database technology. The failure highlights the challenges that Amazon wants to completely get rid of the Oracle database by 2020, and how difficult it is to re -get this level of reliability. This also shows that Oracle's database is indeed more efficient in similar software in some aspects. Oracle may emphasize this at the annual OpenWorld conference held in San Francisco this week.

After the Prime Day failure, Amazon's engineer wrote a report of 25 pages, Amazon said it was a correction error. Amazon uses this standard process to try to understand why major accidents happen and how to prevent the future.

The report shows that the root cause of Amazon's efforts to find out the problem of the Prime Day issue is because the database migration has lost a function. The file shows that in the event of an error in the newly installed database (called Aurora PostgreSQL), Amazon did not give an emergency plan.

In a question, the engineer was asked why Amazon's warehouse database did not encounter \"the same question of the last period of traffic (then using Oracle database). They replied that \"Oracle and Aurora Postgresql are two different [databases] technology\", and the way to handle the \"saving point\" is different.

Save point is an important database tool for tracking and restoring a single transaction. The report said that on the day of Prime Day, the number of preservation points was created, and Amazon's Aurora software was overwhelmed, thus dragging the overall performance of the database.

It may occur anyway

\u0026 nbsp;

CNBC revealed the details of the file, the University of Illinois Embassin -Shang Shang \"If Amazon insists on using the Oracle database,\" said Matt Caesar, a professor of computer science at Payne, said this failure may not occur. question,It is expected to shorten the duration of the fault. \"

Amazon's spokesman described this question in a statement issued by an email, saying that there was no failure, although the internal file claimed that the database\" performance downgrade caused lag and severe failure. \"

The spokesman said:\" It is necessary to point out this, that is, what failure has never happened in the warehouse, and the problem only causes about 1%of parcels to delay short -term delivery. This problem was quickly found and was resolved. \"

This warehouse in Ohio is the largest of the 13 warehouses that moved away from the Oracle database before Prime Day. The document states that during the Prime Day promotion, the warehouse's daily parcels were handled more than 1.1 million pieces. . All services and software that handles inventory and delivery data has been relocated to the Aurora database in those warehouses.

According to the report, the failure lasted for several hours in Prime Day, causing more than 15,000 parcels to wrap than 15,000 pieces of parcels. Delayed delivery, and wasted about $ 90,000 in labor costs. The loss does not include all time or any time that may be missed by engineers to exclude and repair errors. \"In the part, Amazon's engineer wrote:\" Save the behavior in Aurora Postgresql is different from its behavior in Oracle. \"The meaning of Oracle is more effective. SQL statement data, and if there is this data, the root cause of \"originally helps to find out\" problem.

If Amazon is more prepared to be more fully prepared, the failure may not be so serious. One of the files in the file. In part, the company said that \"lack of response solutions when encountering performance problems when the POSTGRESQL database encountered performance problems\", the problem was solved for a long time. The document also claimed that a \"complete response plan or operation manual\" was originally originally originally originally originally. It helps to \"eliminate the impact faster\".

Henning Schulzrinne, a professor of computer science at Columbia University, said, \"I guess, Amazon just replaced the database , I did not test the specific load mode that appeared on the day of Amazon Prime Day. It was shocked. \"

In recent years, Amazon and Oracle have been spoken, because Amazon expanded the software variety and became more positive with Oracle. The comparison is over. CNBC has reported in August that Amazon is trying to move the entire set of databases from Oracle by early 2020.

\"Really difficult\"

\u0026 nbsp ; ORACLE chairman and co -founder Larry Erisen did not believe in Amazon. At the company's financial report conference on December last year, Erisen said Amazon \"did not move away from Oracle.\" He reiterated his views in an event in August this year, saying: \"I think Amazon can't do this.\"

He said: \"Amazon has 10 years to move Oracle, but now it is still still Using Oracle. It is not easy to use your own technology. So it is not cost -effective. I mean it is really difficult. \"