MySQLAurora和AWSS3：需要一种替代MySQL的“LOADDATA用于从S3加载文档数据。

AWS提供了一个名为“AWS Database Migration Service”的服务，用于将数据从现有的数据库系统中迁移到AWS云。其中包括将数据从S3中的文本文件加载到MySQL Aurora中的选项。

以下是如何使用AWS Database Migration Service加载S3中的文本文件到MySQL Aurora的代码示例：

1.创建一个Amazon S3源端点。

{
    "EndpointIdentifier": "SOURCE_S3_ENDPOINT",
    "EndpointType": "source",
    "EngineName": "s3",
    "S3Settings": {
        "ServiceAccessRoleArn": "ARN-OF-SERVICE-ROLE",
        "BucketFolder": "FOLDER-NAME",
        "BucketName": "BUCKET-NAME",
        "CompressionType": "NONE",
        "CsvDelimiter": ",",
        "CsvRowDelimiter": "\n",
        "ExternalTableDefinition": "",
        "DataFormat": "csv",
        "EncodingType": "UTF-8",
        "EncryptionMode": "SSE_S3",
        "ServerSideEncryptionKmsKeyId": "",
        "NoHexPrefix": "FALSE",
        "AccessKeyId": "YOUR_ACCESS_KEY_ID",
        "SecretAccessKey": "YOUR_SECRET_ACCESS_KEY"
    }
}

2.创建一个MySQL Aurora目标端点。

{
    "EndpointIdentifier": "TARGET_MYSQL_AURORA_ENDPOINT",
    "EndpointType": "target",
    "EngineName": "aurora",
    "DatabaseName": "DATABASE-NAME",
    "ServerName": "SERVER_NAME:PORT",
    "Port": 3306,
    "Username": "USER_NAME",
    "Password": "PASSWORD"
}

3.创建迁移任务。

{
    "ReplicationTaskIdentifier": "S3_TO_MYSQL_AURORA_TASK",
    "SourceEndpointArn": "ARN-OF-S3-SOURCE-ENDPOINT",
    "TargetEndpointArn": "ARN-OF-MYSQL-AURORA-TARGET-ENDPOINT",
    "ReplicationInstanceArn": "ARN-OF-REPLICATION-INSTANCE",
    "MigrationType": "full