Akbun

  Overview Hello. This article explains the AWS RDS S3 import/export feature and shares the results of import performance testing. What is S3 import/export? RDS S3 import/export is a feature that exports RDS data to S3 or imports S3 data to RDS. To allow RDS to access S3, you need to configure IAM role connection settings. This article conducted hands-on practice for Aurora MySQL and Aurora Postgres. INFILE import VS S3 import Performance Comparison I conducted performance testing to import 18 million records using MySQL Aurora db.r6i.xlarge spec. I executed only the import function without any database settings, such as indexes. For the 18 million records of data, I used TPC-H, which I documented in a previous blog post. https://malwareanalysis.tistory.com/878 Comparing LOAD DATA LOCAL INFILE and LOAD DATA FROM S3 PREFIX import, the INFILE import was  approximately 12% faster  than the S3 import. S3 import performs worse than the INFILE method due to addi...