(EC2) Amazon RDS for MySQL Amazon ElastiCache for Redis Amazon Redshift 201610݄ RDS for MySQL → Aurora MySQL 20213݄ EC2 → Amazon Elastic Container Service(ECS)
player SET id=(SELECT new_id FROM id_map WHERE old_id=player.id AND world='A'); UPDATE player_item SET id=(SELECT new_id FROM id_map WHERE old_id=player_item.id AND world='A'), player_id=(SELECT new_id FROM id_map WHERE old_id=player_item.player_id AND world='A'); ͜ͷαϒΫΤϦͰेԯߦΛUPDATE……ͭΒͦ͏
SELECT id*2+1 AS id, foo, bar, ... -- IDΛॻ͖͑ͯ͠·͏ FROM player INTO OUTFILE S3 's3://...' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' MANIFEST ON; MANIFEST ON : ڊେͳςʔϒϧͷ߹ɺෳS3 objectʹׂ͞ΕΔ objectҰཡ͕هࡌ͞ΕΔϚχϑΣετϑΝΠϧΛग़ྗ͢Δ