ݺߣ

ݺߣShare a Scribd company logo

AWS ???? MySQL Infra ????-2?.??

I Goo Lee
I Goo Lee

MySQL PowerGroup Tech Seminar (2016.1) - 5.AWS ???? MySQL Infra ????-2?.?? (by ???) - URL : cafe.naver.com/mysqlpg

Internet
1 of 59
Downloaded 28 times
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
v ??? ???? ????, ??????? sangpill@amazon.com 2016? 3? 26? AWS ???? MySQL Infra ???? - Amazon Aurora
v Amazon RDS ??? ? Amazon Aurora
v? ?? ??? ??? ?????? ??? ? Aurora, ?MySQL, ?MariaDB, ?PostgreSQL, ?Oracle, ?SQL ?Server ? ???? ? ???? ??? ? Multi-?AZ ???? ?? ???? ?? ? ???(Snapshot)? ?? ??/?? ?? ? ?? ??(Read ?Replica)? ?? ??? Amazon RDS Aurora RDS ??? ??
vv Amazon Aurora ?? ? Amazon Aurora? MySQL ?? ??? ?????? ?? ? Aurora? ?? ??????? 10?? 1 ???? MySQL?? ?? 5? ??? ??? ?? ? 3 ????? ?? 6?? ??? ???? ???? ?? ? Amazon S3? ????? ???? ?? ? ?? ? 15? Amazon Aurora Replicas ? 10GB?? 64TB?? ???? ?? ?? ? ?? : Virginia, Oregon, Ireland ? Tokyo
vv Amazon Aurora ?? ? ??? ?? ????? ?? ? ?? ? ???? ????, ??- ???, ???-??, ?????? ???? ???? ??? ?? ? ?? ??? ??? EC2, VPC, DynamoDB, SWF, Route 53 ? AWS ?? ??? ?? ? ?? ??? ??? Amazon S3 ?? Logging ?+ ?Storage SQL Transactions Caching Control ?PlaneData ?Plane Amazon S3 DynamoDB Amazon SWF Amazon Route 53
vv Amazon Aurora? ???? ? ?? ???? ? 3????? 6-way ?? ? 4 / 6 ??, 3 / 6 ?? ?? ? S3 ???? ?? ?? ? SSD, ???-??, ??- ??? ???? ? ??? ???? ?? ? ?? 64TB ?? ? ?????? ?? ? ??-?? ?? ???? SQL Transactions AZ ?1 AZ ?2 AZ ?3 Caching Amazon S3
vv Amazon Aurora Replica? ?? ?? MySQL ?? ?? ? ??? ??? ??? ?? ? ??? ???? ???? ?? ? ?? ??? ?? ? ???? ? ??? ?? ?? ?? Page ?cache invalidation Aurora Master 30% ?Read 70% ?Write Aurora ?Replica 100% ?New ?Reads Shared ?Multi-?\AZ ?Storage MySQL Master 30% ?Read 70% ?Write MySQL ?Replica 30% ?New ?Reads 70% ?Write Single ?threaded binlog ?apply Data ?Volume Data ?Volume Amazon Aurora ?? ?? ? ?? ?? ?? ? ??? ?? ??, ?? 15? ?? ? ~100 ms ?? ?? ? ?? ????? ???? ???? ? ??? ?? ??
v AWS ???? MySQL ??? ?? - ????
vv 2. RDS MySQL ? Multi-AZ ?? ? ??? ?? ? ?? ??-?? MySQL ???? ?? ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Slave (EC2 ?+ ?EBS) Replication 1. MySQL on EC2/EBS ? EC2 + EBS ?? ?? ? MySQL Replication ?? Availability ?Zone RDS ?Master MySQL Availability ?Zone RDS ?Standby MySQL Multi-?\AZ ?/w Syncronoous Replication Availability ?Zone RDS ?Master Aurora Availability ?Zone RDS ?Standby Aurora 3. RDS Aurora ? ???? ???? ??? ? ?? ??-?? ? ?? ??? ?? Multi-?\AZ ?/w Aurora ? Replica
vv Multi-?AZ ???? ?? ???? Enterprise-grade fault tolerance solution for production databases
vv Multi-?AZ ??? ? ???? ???? ? Planned ?? unplanned ???? ?? ?, ? ?? ?? ?? ?? ? ????? DB ???? ?? ? DB ???? ?? ?? ? DB ????? ????? ?? ? Reboot with failover? ?? ?? ???? ? ?? ?? ??? Standby ???? ???? ?? ? ????? 60-120? ?? ?? ??. (??? ???? ? ?? ???? ??? ?? ??? ? ??)
vv Multi-?AZ ??? ? ???? ???? ? DB ???? ????? ????, DNS ??? ???? ? Java DNS ??? ?? ?? ?? ??? ? ?? ? http://docs.aws.amazon.com/AWSSdkDocsJava/latest/DeveloperGuide/java-dg-jvm- ttl.html ? JVM ?? ?? ?????? ??? ?? ? Set networkaddress.cache.ttl in the$JAVA_HOME/jre/lib/security/java.security file: ? networkaddress.cache.ttl=60 ? ?? ?????? ?? ? set networkaddress.cache.ttl in your applications initialization code: ? java.security.Security.setProperty("networkaddress.cache.ttl" , "60"); ? ?????? ?? ???(re-establish) ??
vv RDS MySQL Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
vv RDS MySQL Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
vv RDS MySQL Multi-AZ ?? (CLI) ? Syntax ? Example $ aws rds create-db-instance --db-instance-identifier <value> --db-instance-class <value> --engine <value> [--multi-az | --no-multi-az] $ aws rds create-db-instance --db-instance-identifier mysql- powergroup-demo --allocated-storage 20 --db-instance-class db.m1.small --engine mysql --master-username myawsuser -- master-user-password myawsuser --multi-az
vv RDS MySQL Multi-AZ ??(CLI) ? Syntax ? Example $ aws rds describe-db-instances [--db-instance-identifier <value>] [--filters <value>] [--cli-input-json <value>] $ aws rds describe-db-instances --db-instance-identifier mysql-powergroup-demo "MultiAZ": true,
vv Amazon Aurora? ???? ?? ??-?? ?? ?? ?? ?? ? ?? ??? ? ?? ????? ?? ? DB ???? ????? ????, ?? ?? ????? DNS ??? ?? ? ????? 1? ??? ?? AZ ?1 Primary instance Replica instance Replica instance Replica instance Shared ?Multi-?\AZ ?Storage Automatic ? Failover ?to ? Replica ?Instance AZ ?1 Primary instance Primary instance Shared ?Multi-?\AZ ?Storage Create ?new ? primary ?Instance Aurora Replica? ?? ?? Aurora Replica? ?? ?? ?? ?? ?? ?? ? ?? ?? ??? ? DB ???? ?? ?? ? ?? ?? ? ?? ?? ??? ?? DB ???? ?? ?? ? ????? 15? ??? ?? AZ ?3AZ ?2AZ ?3AZ ?2 Primary instance
vv Amazon Aurora? ???? ?? ??-?? ??-?\?? 1? ??
v?? ?????? ? ?? ????? ?? ?? ?? ?? ? MySQL? ??-??? ?? ? ??? ??? ??? ?? Amazon Aurora ? ???? ???? ?? ? ?-??? ??? Redo ??? ?? ? ??, ??, ??? Checkpointed ?Data Redo ?Log Crash ?at ?T0 requires a ?re-?\application ?of ?the SQL ?in ?the ?redo ?log ?since last ?checkpoint T0 T0 Crash ?at ?T0 will ?result ?in ?redo logs ?being ?applied ?to ?each ?segment on ?demand, ?in ?parallel, ?asynchronously ??? ??? ??
vv RDS Aurora Multi-AZ ?? (?? ??) Multi-?\AZ ??? Create ?Replica ?in ?Different ?Zone ???
vv RDS Aurora Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
vv RDS Aurora Multi-AZ ?? (CLI) ? Syntax $ aws rds create-db-cluster --db-cluster-identifier <value> --engine <value> --master-username <value> --master-user-password <value> $ aws rds create-db-instance --db-instance-identifier <value> --db-instance-class <value> --engine <value> --db-cluster-identifier <value>
vv RDS Aurora Multi-AZ ?? (CLI) ? Example $ aws rds create-db-cluster --db-cluster-identifier mysql- powergroup-aurora-demo --engine aurora --master-username master --master-user-password Master00 $ aws rds create-db-instance --db-cluster-identifier mysql- powergroup-aurora-demo --db-instance-identifier mysql- powergroup-aurora-demo --db-instance-class db.r3.large -- engine aurora $ aws rds create-db-instance --db-cluster-identifier mysql- powergroup-aurora-demo --db-instance-identifier mysql- powergroup-aurora-demo-replica1 --db-instance-class db.r3.large --engine aurora
vv RDS Aurora Multi-AZ ??(CLI) ? Syntax ? Example $ aws rds describe-db-clusters [--db-cluster-identifier <value>] $ aws rds describe-db-clusters --db-cluster-identifier mysql-powergroup-aurora-demo { "DBClusters": [ { "DBClusterMembers": [ { "IsClusterWriter": false, "DBInstanceIdentifier": "mysql-powergroup-aurora-demo-replica1" }, { "IsClusterWriter": true, "DBInstanceIdentifier": "mysql-powergroup-aurora-demo" } ],
vv RDS Aurora Multi-AZ ??-??(CLI) ? Syntax ? Example $ failover-db-cluster [--db-cluster-identifier <value>] [-- cli-input-json <value>] [--generate-cli-skeleton] $ aws rds failover-db-cluster --db-cluster-identifier mysql-powergroup-aurora- demo DBCLUSTER 1 2 mysql-powergroup-aurora-demo default.aurora5.6 default2016-03-25T07:00:45.666Z mysql-powergroup-aurora- demo.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a 2016-03-25T08:12:08.108Z master 3306 05:35-06:05 tue:10:27- tue:10:57 available False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e DBCLUSTERMEMBERS in-syncmysql-powergroup-aurora-demo-replica1False 1 DBCLUSTERMEMBERS in-syncmysql-powergroup-aurora-demo True 1 VPCSECURITYGROUPS active sg-71f69814
v AWS ???? MySQL ??? ?? C ??/??
vv 1. MySQL on EC2/EBS ? EBS Snapshot ?? ? ?? ?? ?? ?? 2. RDS MySQL ? RDS ??? (??/??) ? Point-in-Time ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Slave (EC2 ?+ ?EBS) Replication Availability ?Zone RDS ?Master MySQL Availability ?Zone RDS ?Standby MySQL Multi-?\AZ ?/w Syncronoous Replication Availability ?Zone RDS ?Master Aurora Availability ?Zone RDS ?Standby Aurora 3. RDS Aurora ? RDS ??? (??/??) ? Point-in-Time ?? Multi-?\AZ ?/w Aurora ? Replica MySQL ??/?? ?? ?? EBS ? snapshot RDS snapshots RDS snapshots Backup (EC2 ?+ ?EBS)
v EBS ??? ???? ?? ??
v [[ console screenshot ]] RDS automated backups EBS ????? ?? ??
v [[ console screenshot ]] RDS automated backups EBS ????? ?? ??
v [[ console screenshot ]] restore EBS from snapshot EBS ???? ?? ??
vv Amazon RDS? ???? ?? ? ?? ?? ??(Automated Backup) ? RDS? ??? ???? ?? ? ?? DB ????? ???? ??? ? ?? ?? ??(Backup Retention Period) ?? ??? ?? (1~35?) ? ?? ? ?? ?? ? ?? ? ?? ?? ?? ??? (DB Snapshots) ? ???? ??? ?? ? ??? ??? ?? ? ?? ?? ?? ?? ?? ? ?? ????? ?? ??
vv Amazon RDS? ???? ?? ? ?? ?? (Restore) ? ?? ?? ??????? ?? Aurora DB ???? ?? ? ?? ?? ?? ? ?? ????? ?? ? Latest Restorable Time : ?? 5? ?? ? Earliest Restorable Time : ?? ?? ?? ? Aurora Backup? ??, ?? ???? ?? ?? ??? ?? ??? ??? ??? ? ?? ??
v RDS ???? ?? ?? C ?? ??
v [[ console screenshot ]] RDS automated backups RDS ????? ?? ?? C ?? ??
v RDS ???? ?? ?? C ?? ??
v [[ console screenshot ]] RDS DB snapshots RDS ???? ?? ?? C ?? ??
v [[ console screenshot ]] RDS DB snapshots RDS ???? ?? ?? C ?? ??
v RDS ???? ?? ?? C ?? ??
v RDS ???? ?? ??
v [[ console screenshot ]] restore EBS from snapshot RDS ???? ?? ??
v RDS ???? ?? ??
v [[ console screenshot ]] RDS snapshot restore RDS ???? ?? ??
v RDS ???? ?? ??
vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds create-db-cluster-snapshot --db-cluster-snapshot- identifier <value> --db-cluster-identifier <value> [--tags <value>] [--cli-input-json <value>] [--generate-cli-skeleton] $ aws rds create-db-cluster-snapshot --db-cluster-identifier mysql- powergroup-aurora-demo --db-cluster-snapshot-identifier mysnapshot-03- 05-17-25 DBCLUSTERSNAPSHOT 1 2016-03-25T07:00:05.099Z mysql- powergroup-aurora-demo mysnapshot-03-05-17-25 aurora aurora master 0 0 2016-03-25T08:29:39.920Z manual creating False vpc-14c21f71 AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e
vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds describe-db-cluster-snapshots [--db-cluster- identifier <value>] [--db-cluster-snapshot-identifier <value>] [--snapshot-type <value>] [--filters <value>] [--max-records <value>] [--marker <value>] [--cli-input-json <value>] $ aws rds describe-db-cluster-snapshots { "DBClusterSnapshots": [ { "Engine": "aurora", "SnapshotCreateTime": "2016-03-25T08:29:39.920Z", "DBClusterIdentifier": "mysql-powergroup-aurora-demo", "DBClusterSnapshotIdentifier": "mysnapshot-03-05-17-25", "ClusterCreateTime": "2016-03-25T07:00:05.099Z", .. },
vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds restore-db-cluster-from-snapshot [--availability- zones <value>] --db-cluster-identifier <value> --snapshot- identifier <value> --engine <value> $ aws rds restore-db-cluster-from-snapshot --db-cluster-identifier mysql-powergroup-aurora-demo-restore --snapshot-identifier mysnapshot- 03-05-17-25 --engine aurora DBCLUSTER 1 2 mysql-powergroup-aurora-demo-restore default.aurora5.6 default mysql-powergroup-aurora-demo- restore.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a master 3306 05:35-06:05 tue:10:27-tue:10:57 creating False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e VPCSECURITYGROUPS active sg-71f69814
vv RDS Aurora Poin-Tn-Time ??(CLI) ? Syntax ? Example $ aws rds restore-db-cluster-to-point-in-time --db-cluster- identifier <value> --source-db-cluster-identifier <value>[-- restore-to-time <value>] $ aws rds restore-db-cluster-to-point-in-time --db-cluster-identifier mysql-powergroup-aurora-demo-pitr --source-db-cluster-identifier mysql-powergroup-aurora-demo --use-latest-restorable-time DBCLUSTER 1 2 mysql-powergroup-aurora-demo-pitr default.aurora5.6 default mysql-powergroup-aurora-demo- pitr.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a master 3306 05:35-06:05 tue:10:27-tue:10:57 creating False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e VPCSECURITYGROUPS active sg-71f69814
v AWS ???? MySQL ??? ?? C ???
vv 3. RDS Aurora ? Aurora Replica ?? ? ?? ?? ?? ? ?? 15? 2. RDS MySQL ? MySQL Replica ?? ? Cross-region Replica ?? ? ?? 5? 1. MySQL on EC2/EBS ? MySQL Replication ?? MySQL ??? ?? ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Replica (EC2 ?+ ?EBS) Replication Availability ?Zone RDS ?Primary MySQL Availability ?Zone RDS ?REplica MySQL Ayncronoous Replication Availability ?Zone RDS ?Primary Aurora Availability ?Zone RDS ?Replica Aurora Aurora ? Replica
vv Amazon Aurora Replica? ?? ?? MySQL ?? ?? ? ??? ??? ??? ?? ? ??? ???? ???? ?? ? ?? ??? ?? ? ???? ? ??? ?? ?? ?? Page ?cache invalidation Aurora Master 30% ?Read 70% ?Write Aurora ?Replica 100% ?New ?Reads Shared ?Multi-?\AZ ?Storage MySQL Master 30% ?Read 70% ?Write MySQL ?Replica 30% ?New ?Reads 70% ?Write Single ?threaded binlog ?apply Data ?Volume Data ?Volume Amazon Aurora ?? ?? ? ?? ?? ?? ? ??? ?? ??, ?? 15? ?? ? ~100 ms ?? ?? ? ?? ????? ???? ???? ? ??? ?? ??
vv ? ?? 13,800 ? ???? ?? ? Aurora Replica? 7.27 ?? ? ?? ? ?? ??? MySQL 5.6 ? ?? 2,000 ? ???? ?? ? ~2? ?? Read Replica ?? (console screenshot)
vv Aurora ????? ? ???? ????? ? ??? DB ????? ????? ????? ?? ? ??? ?? ?? ?? ? ????? ???? ???? ? ??? ????? ???? ?? ? e.g.) Cluster Endpoint: auroraha.cluster-cnehurulmovt.us-east- 1.rds.amazonaws.com:3306 ? ???? ????? ? DB ???? ? ? ????(????? ?? ?? ??)? ?? ? ???? ??? ?? ?? ?? ?? ?? ? e.g.) Endpoint: auroraha.cnehurulmovt.us-east-1.rds.amazonaws.com
v ????
MySQL ????? ?? 880?? ??! http://bit.ly/awskr-feedback AWS Activate ??? 100?? ?? ??? + 80 ?? Qwiklab Credit 600?? ??? ?? ???+ 100?? 1?? ???? ??? ????? ???? ??? ? ?? URL? ???? ??????!
???? 1 http://aws.amazon.com/ko/blogs/korea/c ategory/amazon-?aurora/ ??? ??? Aurora ??
???? 2 https://www.qwiklab.com/lab_catalogue ??? ?? ?? 3? 31??? ?? ?? ??? ?? ?? ?? ?? ??
???? 3 ??? ? ??? ?? ?
? ??? ?? AWSKRUG ?? ? ?? ????? ???? ??

More Related Content

What's hot (20)

PDF
Amazon Aurora Deep Dive (???) - AWS DB Day
Amazon Web Services Korea
?
PDF
Amazon Aurora 100% ????
Amazon Web Services Korea
?
PDF
AWS DMS? ?? ??? DB ?????? ?? - AWS Summit Seoul 2017
Amazon Web Services Korea
?
PDF
[124]????? ???? ???? Data Platform, ??? MongoDB
NAVER D2
?
PDF
AWS CLOUD 2018- Amazon Aurora? ?? ??? ???? (??? ???? ????)
Amazon Web Services Korea
?
PDF
?? ??? ??? ?? ??? : DB Migration case study (??? ??????? Technical Manager, ?...
Amazon Web Services Korea
?
PDF
20131002 AWS Meister re:Generate - DynamoDB (Korean)
Amazon Web Services Korea
?
PDF
20140806 AWS Meister BlackBelt - Amazon Redshift (Korean)
Amazon Web Services Korea
?
PDF
??? ???? AWS Migration ?? factor - BD ??? ??:: AWS Cloud Track 1 Intro
Amazon Web Services Korea
?
PDF
???? IT ???? ?? 7?? ??? ? - ??? ???? ????:: AWS Cloud Track 3 Gaming
Amazon Web Services Korea
?
PDF
AWS ??? ?? ??? ??? ?? :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
PPTX
AWS lambda, step function, cloud watch
Han Sung Kim
?
PDF
Amazon EC2 Container Service ??? ?? - ??? (AWS ???? ????)
Amazon Web Services Korea
?
PPTX
AWS RDS, DYNAMO
Han Sung Kim
?
PDF
? ?? ?? ?? ?? ?? ? ?? ?? ??? ???? ?? AWS ???? ?? (??? ???? ????, AWS) :: Gami...
Amazon Web Services Korea
?
PDF
AWS??? ?????????? Daily Report ???????? : ?? ???? ???? ????
Changje Jeong
?
PPTX
About memcached
Sinhyub Kim
?
PDF
CloudWatch ?? ????? ??? ??? ?? ??? - ??? ???? ????:: AWS Cloud Track 3 Gaming
Amazon Web Services Korea
?
PDF
Amazon RDS ???? (???) - AWS ??? ???
Amazon Web Services Korea
?
PDF
[Gaming on AWS] AWS? ?? ? ??? ?? Re-architecting ?? - ??????
Amazon Web Services Korea
?
Amazon Aurora Deep Dive (???) - AWS DB Day
Amazon Web Services Korea
?
Amazon Aurora 100% ????
Amazon Web Services Korea
?
AWS DMS? ?? ??? DB ?????? ?? - AWS Summit Seoul 2017
Amazon Web Services Korea
?
[124]????? ???? ???? Data Platform, ??? MongoDB
NAVER D2
?
AWS CLOUD 2018- Amazon Aurora? ?? ??? ???? (??? ???? ????)
Amazon Web Services Korea
?
?? ??? ??? ?? ??? : DB Migration case study (??? ??????? Technical Manager, ?...
Amazon Web Services Korea
?
20131002 AWS Meister re:Generate - DynamoDB (Korean)
Amazon Web Services Korea
?
20140806 AWS Meister BlackBelt - Amazon Redshift (Korean)
Amazon Web Services Korea
?
??? ???? AWS Migration ?? factor - BD ??? ??:: AWS Cloud Track 1 Intro
Amazon Web Services Korea
?
???? IT ???? ?? 7?? ??? ? - ??? ???? ????:: AWS Cloud Track 3 Gaming
Amazon Web Services Korea
?
AWS ??? ?? ??? ??? ?? :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
AWS lambda, step function, cloud watch
Han Sung Kim
?
Amazon EC2 Container Service ??? ?? - ??? (AWS ???? ????)
Amazon Web Services Korea
?
AWS RDS, DYNAMO
Han Sung Kim
?
? ?? ?? ?? ?? ?? ? ?? ?? ??? ???? ?? AWS ???? ?? (??? ???? ????, AWS) :: Gami...
Amazon Web Services Korea
?
AWS??? ?????????? Daily Report ???????? : ?? ???? ???? ????
Changje Jeong
?
About memcached
Sinhyub Kim
?
CloudWatch ?? ????? ??? ??? ?? ??? - ??? ???? ????:: AWS Cloud Track 3 Gaming
Amazon Web Services Korea
?
Amazon RDS ???? (???) - AWS ??? ???
Amazon Web Services Korea
?
[Gaming on AWS] AWS? ?? ? ??? ?? Re-architecting ?? - ??????
Amazon Web Services Korea
?

Similar to AWS ???? MySQL Infra ????-2?.?? (20)

PDF
Aurora MySQL Backtrack? ??? ?? ?? ?? - ??? :: AWS Database Modernization Day ???
Amazon Web Services Korea
?
PDF
??? ??????? ??? ???? Amazon Aurora :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
PDF
??? ???? ??? AWS? ??? ?????? ??::??? (AWS ????????)
Amazon Web Services Korea
?
PDF
[Games on AWS 2019] AWS ???? ?? ?? ?? ?? | Aurora? ?? ?????? ?? ?! - ??? AWS ...
Amazon Web Services Korea
?
PDF
Amazon RDS ??? ???? - ?? ?? ???? (???) :: AWS ?? ???
Amazon Web Services Korea
?
PDF
2017 AWS DB Day | Amazon Aurora ??? ????
Amazon Web Services Korea
?
PPTX
?? 4. ??????:: AWSome Day Online Conference
Amazon Web Services Korea
?
PDF
[D3T2S01] Amazon Aurora MySQL ??? ?? ????? ? Amazon B/G Deployments ??
Amazon Web Services Korea
?
PDF
Amazon Aurora ?? ?? ? ?????? ?? ?? - AWS Summit Seoul 2017
Amazon Web Services Korea
?
PDF
?????? ?? AWS ???? ???? ???? C ???, AWS???? ????:: AWS Summit Online Korea 2020
Amazon Web Services Korea
?
PDF
?????? ??, ????? ?? ?! - ???, AWS ???????? - AWS Builders Online Series
Amazon Web Services Korea
?
PPTX
AWS 6? ??? | AWS?? MS SQL ?? ???? (??? ????????)
Amazon Web Services Korea
?
PDF
AWS 9? ??? | AWS ?????? ?????? ??? ????
Amazon Web Services Korea
?
PDF
??? ?? ??? AWS DB ??? ?? Dynamo DB, Aurora - ??? / Principle Enterprise Evang...
BESPIN GLOBAL
?
PPTX
10? ??? - AWS ??? Microsoft SQL Server ??? ?? ?? ???? (??? ???? ????)
Amazon Web Services Korea
?
PDF
[2017 Windows on AWS] AWS ? ??? SQL Server ?? ?? ??
Amazon Web Services Korea
?
PDF
??? ? ??? ??? MS SQL 100% ????::???::AWS Summit Seoul 2018
Amazon Web Services Korea
?
PDF
RDS?? Aurora PostgreSQL Migration? ??
Kyuhyun Byun
?
PDF
??? ?? AWS ?????? ??? ???? :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
PDF
???? ???? ?????? ???? - ???, AWS SR. Database SA
Amazon Web Services Korea
?
Aurora MySQL Backtrack? ??? ?? ?? ?? - ??? :: AWS Database Modernization Day ???
Amazon Web Services Korea
?
??? ??????? ??? ???? Amazon Aurora :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
??? ???? ??? AWS? ??? ?????? ??::??? (AWS ????????)
Amazon Web Services Korea
?
[Games on AWS 2019] AWS ???? ?? ?? ?? ?? | Aurora? ?? ?????? ?? ?! - ??? AWS ...
Amazon Web Services Korea
?
Amazon RDS ??? ???? - ?? ?? ???? (???) :: AWS ?? ???
Amazon Web Services Korea
?
2017 AWS DB Day | Amazon Aurora ??? ????
Amazon Web Services Korea
?
?? 4. ??????:: AWSome Day Online Conference
Amazon Web Services Korea
?
[D3T2S01] Amazon Aurora MySQL ??? ?? ????? ? Amazon B/G Deployments ??
Amazon Web Services Korea
?
Amazon Aurora ?? ?? ? ?????? ?? ?? - AWS Summit Seoul 2017
Amazon Web Services Korea
?
?????? ?? AWS ???? ???? ???? C ???, AWS???? ????:: AWS Summit Online Korea 2020
Amazon Web Services Korea
?
?????? ??, ????? ?? ?! - ???, AWS ???????? - AWS Builders Online Series
Amazon Web Services Korea
?
AWS 6? ??? | AWS?? MS SQL ?? ???? (??? ????????)
Amazon Web Services Korea
?
AWS 9? ??? | AWS ?????? ?????? ??? ????
Amazon Web Services Korea
?
??? ?? ??? AWS DB ??? ?? Dynamo DB, Aurora - ??? / Principle Enterprise Evang...
BESPIN GLOBAL
?
10? ??? - AWS ??? Microsoft SQL Server ??? ?? ?? ???? (??? ???? ????)
Amazon Web Services Korea
?
[2017 Windows on AWS] AWS ? ??? SQL Server ?? ?? ??
Amazon Web Services Korea
?
??? ? ??? ??? MS SQL 100% ????::???::AWS Summit Seoul 2018
Amazon Web Services Korea
?
RDS?? Aurora PostgreSQL Migration? ??
Kyuhyun Byun
?
??? ?? AWS ?????? ??? ???? :: ??? :: AWS Summit Seoul 2016
Amazon Web Services Korea
?
???? ???? ?????? ???? - ???, AWS SR. Database SA
Amazon Web Services Korea
?
Ad

More from I Goo Lee (20)

PDF
MySQL_Fabric_???????
I Goo Lee
?
PDF
MySQL Deep dive with FusionIO
I Goo Lee
?
PDF
From MSSQL to MySQL
I Goo Lee
?
PDF
From MSSQL to MariaDB
I Goo Lee
?
PDF
Backup automation in KAKAO
I Goo Lee
?
PDF
????? ??? ??? ???? ??? ??
I Goo Lee
?
PDF
Federated Engine ??????
I Goo Lee
?
PDF
MySQL ?? ??? ?? ? ??
I Goo Lee
?
PDF
MySQL 5.7 NF C Optimizer Improvement
I Goo Lee
?
PDF
MySQL 5.7 NF C JSON Datatype ??
I Goo Lee
?
PDF
Intro KaKao MRTE (MySQL Realtime Traffic Emulator)
I Goo Lee
?
PDF
MS ???? ??? ? ??? PoC ?? ??
I Goo Lee
?
PDF
AWS ???? MySQL Infra ????-2??
I Goo Lee
?
PDF
AWS ???? MySQL Infra ????-1????
I Goo Lee
?
PDF
AWS ???? MySQL BMT
I Goo Lee
?
PDF
MySQL Slow Query log Monitoring using Beats & ELK
I Goo Lee
?
PDF
MySQL Audit using Percona audit plugin and ELK
I Goo Lee
?
PDF
PostgreSQL ???
I Goo Lee
?
PDF
Intro KaKao ADT (Almighty Data Transmitter)
I Goo Lee
?
PDF
Binlog Servers ????
I Goo Lee
?
MySQL_Fabric_???????
I Goo Lee
?
MySQL Deep dive with FusionIO
I Goo Lee
?
From MSSQL to MySQL
I Goo Lee
?
From MSSQL to MariaDB
I Goo Lee
?
Backup automation in KAKAO
I Goo Lee
?
????? ??? ??? ???? ??? ??
I Goo Lee
?
Federated Engine ??????
I Goo Lee
?
MySQL ?? ??? ?? ? ??
I Goo Lee
?
MySQL 5.7 NF C Optimizer Improvement
I Goo Lee
?
MySQL 5.7 NF C JSON Datatype ??
I Goo Lee
?
Intro KaKao MRTE (MySQL Realtime Traffic Emulator)
I Goo Lee
?
MS ???? ??? ? ??? PoC ?? ??
I Goo Lee
?
AWS ???? MySQL Infra ????-2??
I Goo Lee
?
AWS ???? MySQL Infra ????-1????
I Goo Lee
?
AWS ???? MySQL BMT
I Goo Lee
?
MySQL Slow Query log Monitoring using Beats & ELK
I Goo Lee
?
MySQL Audit using Percona audit plugin and ELK
I Goo Lee
?
PostgreSQL ???
I Goo Lee
?
Intro KaKao ADT (Almighty Data Transmitter)
I Goo Lee
?
Binlog Servers ????
I Goo Lee
?
Ad

AWS ???? MySQL Infra ????-2?.??

  • 1. v ??? ???? ????, ??????? sangpill@amazon.com 2016? 3? 26? AWS ???? MySQL Infra ???? - Amazon Aurora
  • 2. v Amazon RDS ??? ? Amazon Aurora
  • 3. v? ?? ??? ??? ?????? ??? ? Aurora, ?MySQL, ?MariaDB, ?PostgreSQL, ?Oracle, ?SQL ?Server ? ???? ? ???? ??? ? Multi-?AZ ???? ?? ???? ?? ? ???(Snapshot)? ?? ??/?? ?? ? ?? ??(Read ?Replica)? ?? ??? Amazon RDS Aurora RDS ??? ??
  • 4. vv Amazon Aurora ?? ? Amazon Aurora? MySQL ?? ??? ?????? ?? ? Aurora? ?? ??????? 10?? 1 ???? MySQL?? ?? 5? ??? ??? ?? ? 3 ????? ?? 6?? ??? ???? ???? ?? ? Amazon S3? ????? ???? ?? ? ?? ? 15? Amazon Aurora Replicas ? 10GB?? 64TB?? ???? ?? ?? ? ?? : Virginia, Oregon, Ireland ? Tokyo
  • 5. vv Amazon Aurora ?? ? ??? ?? ????? ?? ? ?? ? ???? ????, ??- ???, ???-??, ?????? ???? ???? ??? ?? ? ?? ??? ??? EC2, VPC, DynamoDB, SWF, Route 53 ? AWS ?? ??? ?? ? ?? ??? ??? Amazon S3 ?? Logging ?+ ?Storage SQL Transactions Caching Control ?PlaneData ?Plane Amazon S3 DynamoDB Amazon SWF Amazon Route 53
  • 6. vv Amazon Aurora? ???? ? ?? ???? ? 3????? 6-way ?? ? 4 / 6 ??, 3 / 6 ?? ?? ? S3 ???? ?? ?? ? SSD, ???-??, ??- ??? ???? ? ??? ???? ?? ? ?? 64TB ?? ? ?????? ?? ? ??-?? ?? ???? SQL Transactions AZ ?1 AZ ?2 AZ ?3 Caching Amazon S3
  • 7. vv Amazon Aurora Replica? ?? ?? MySQL ?? ?? ? ??? ??? ??? ?? ? ??? ???? ???? ?? ? ?? ??? ?? ? ???? ? ??? ?? ?? ?? Page ?cache invalidation Aurora Master 30% ?Read 70% ?Write Aurora ?Replica 100% ?New ?Reads Shared ?Multi-?\AZ ?Storage MySQL Master 30% ?Read 70% ?Write MySQL ?Replica 30% ?New ?Reads 70% ?Write Single ?threaded binlog ?apply Data ?Volume Data ?Volume Amazon Aurora ?? ?? ? ?? ?? ?? ? ??? ?? ??, ?? 15? ?? ? ~100 ms ?? ?? ? ?? ????? ???? ???? ? ??? ?? ??
  • 8. v AWS ???? MySQL ??? ?? - ????
  • 9. vv 2. RDS MySQL ? Multi-AZ ?? ? ??? ?? ? ?? ??-?? MySQL ???? ?? ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Slave (EC2 ?+ ?EBS) Replication 1. MySQL on EC2/EBS ? EC2 + EBS ?? ?? ? MySQL Replication ?? Availability ?Zone RDS ?Master MySQL Availability ?Zone RDS ?Standby MySQL Multi-?\AZ ?/w Syncronoous Replication Availability ?Zone RDS ?Master Aurora Availability ?Zone RDS ?Standby Aurora 3. RDS Aurora ? ???? ???? ??? ? ?? ??-?? ? ?? ??? ?? Multi-?\AZ ?/w Aurora ? Replica
  • 10. vv Multi-?AZ ???? ?? ???? Enterprise-grade fault tolerance solution for production databases
  • 11. vv Multi-?AZ ??? ? ???? ???? ? Planned ?? unplanned ???? ?? ?, ? ?? ?? ?? ?? ? ????? DB ???? ?? ? DB ???? ?? ?? ? DB ????? ????? ?? ? Reboot with failover? ?? ?? ???? ? ?? ?? ??? Standby ???? ???? ?? ? ????? 60-120? ?? ?? ??. (??? ???? ? ?? ???? ??? ?? ??? ? ??)
  • 12. vv Multi-?AZ ??? ? ???? ???? ? DB ???? ????? ????, DNS ??? ???? ? Java DNS ??? ?? ?? ?? ??? ? ?? ? http://docs.aws.amazon.com/AWSSdkDocsJava/latest/DeveloperGuide/java-dg-jvm- ttl.html ? JVM ?? ?? ?????? ??? ?? ? Set networkaddress.cache.ttl in the$JAVA_HOME/jre/lib/security/java.security file: ? networkaddress.cache.ttl=60 ? ?? ?????? ?? ? set networkaddress.cache.ttl in your applications initialization code: ? java.security.Security.setProperty("networkaddress.cache.ttl" , "60"); ? ?????? ?? ???(re-establish) ??
  • 13. vv RDS MySQL Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
  • 14. vv RDS MySQL Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
  • 15. vv RDS MySQL Multi-AZ ?? (CLI) ? Syntax ? Example $ aws rds create-db-instance --db-instance-identifier <value> --db-instance-class <value> --engine <value> [--multi-az | --no-multi-az] $ aws rds create-db-instance --db-instance-identifier mysql- powergroup-demo --allocated-storage 20 --db-instance-class db.m1.small --engine mysql --master-username myawsuser -- master-user-password myawsuser --multi-az
  • 16. vv RDS MySQL Multi-AZ ??(CLI) ? Syntax ? Example $ aws rds describe-db-instances [--db-instance-identifier <value>] [--filters <value>] [--cli-input-json <value>] $ aws rds describe-db-instances --db-instance-identifier mysql-powergroup-demo "MultiAZ": true,
  • 17. vv Amazon Aurora? ???? ?? ??-?? ?? ?? ?? ?? ? ?? ??? ? ?? ????? ?? ? DB ???? ????? ????, ?? ?? ????? DNS ??? ?? ? ????? 1? ??? ?? AZ ?1 Primary instance Replica instance Replica instance Replica instance Shared ?Multi-?\AZ ?Storage Automatic ? Failover ?to ? Replica ?Instance AZ ?1 Primary instance Primary instance Shared ?Multi-?\AZ ?Storage Create ?new ? primary ?Instance Aurora Replica? ?? ?? Aurora Replica? ?? ?? ?? ?? ?? ?? ? ?? ?? ??? ? DB ???? ?? ?? ? ?? ?? ? ?? ?? ??? ?? DB ???? ?? ?? ? ????? 15? ??? ?? AZ ?3AZ ?2AZ ?3AZ ?2 Primary instance
  • 18. vv Amazon Aurora? ???? ?? ??-?? ??-?\?? 1? ??
  • 19. v?? ?????? ? ?? ????? ?? ?? ?? ?? ? MySQL? ??-??? ?? ? ??? ??? ??? ?? Amazon Aurora ? ???? ???? ?? ? ?-??? ??? Redo ??? ?? ? ??, ??, ??? Checkpointed ?Data Redo ?Log Crash ?at ?T0 requires a ?re-?\application ?of ?the SQL ?in ?the ?redo ?log ?since last ?checkpoint T0 T0 Crash ?at ?T0 will ?result ?in ?redo logs ?being ?applied ?to ?each ?segment on ?demand, ?in ?parallel, ?asynchronously ??? ??? ??
  • 20. vv RDS Aurora Multi-AZ ?? (?? ??) Multi-?\AZ ??? Create ?Replica ?in ?Different ?Zone ???
  • 21. vv RDS Aurora Multi-AZ ?? (?? ??) Multi-?\AZ ??? Yes ???
  • 22. vv RDS Aurora Multi-AZ ?? (CLI) ? Syntax $ aws rds create-db-cluster --db-cluster-identifier <value> --engine <value> --master-username <value> --master-user-password <value> $ aws rds create-db-instance --db-instance-identifier <value> --db-instance-class <value> --engine <value> --db-cluster-identifier <value>
  • 23. vv RDS Aurora Multi-AZ ?? (CLI) ? Example $ aws rds create-db-cluster --db-cluster-identifier mysql- powergroup-aurora-demo --engine aurora --master-username master --master-user-password Master00 $ aws rds create-db-instance --db-cluster-identifier mysql- powergroup-aurora-demo --db-instance-identifier mysql- powergroup-aurora-demo --db-instance-class db.r3.large -- engine aurora $ aws rds create-db-instance --db-cluster-identifier mysql- powergroup-aurora-demo --db-instance-identifier mysql- powergroup-aurora-demo-replica1 --db-instance-class db.r3.large --engine aurora
  • 24. vv RDS Aurora Multi-AZ ??(CLI) ? Syntax ? Example $ aws rds describe-db-clusters [--db-cluster-identifier <value>] $ aws rds describe-db-clusters --db-cluster-identifier mysql-powergroup-aurora-demo { "DBClusters": [ { "DBClusterMembers": [ { "IsClusterWriter": false, "DBInstanceIdentifier": "mysql-powergroup-aurora-demo-replica1" }, { "IsClusterWriter": true, "DBInstanceIdentifier": "mysql-powergroup-aurora-demo" } ],
  • 25. vv RDS Aurora Multi-AZ ??-??(CLI) ? Syntax ? Example $ failover-db-cluster [--db-cluster-identifier <value>] [-- cli-input-json <value>] [--generate-cli-skeleton] $ aws rds failover-db-cluster --db-cluster-identifier mysql-powergroup-aurora- demo DBCLUSTER 1 2 mysql-powergroup-aurora-demo default.aurora5.6 default2016-03-25T07:00:45.666Z mysql-powergroup-aurora- demo.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a 2016-03-25T08:12:08.108Z master 3306 05:35-06:05 tue:10:27- tue:10:57 available False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e DBCLUSTERMEMBERS in-syncmysql-powergroup-aurora-demo-replica1False 1 DBCLUSTERMEMBERS in-syncmysql-powergroup-aurora-demo True 1 VPCSECURITYGROUPS active sg-71f69814
  • 26. v AWS ???? MySQL ??? ?? C ??/??
  • 27. vv 1. MySQL on EC2/EBS ? EBS Snapshot ?? ? ?? ?? ?? ?? 2. RDS MySQL ? RDS ??? (??/??) ? Point-in-Time ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Slave (EC2 ?+ ?EBS) Replication Availability ?Zone RDS ?Master MySQL Availability ?Zone RDS ?Standby MySQL Multi-?\AZ ?/w Syncronoous Replication Availability ?Zone RDS ?Master Aurora Availability ?Zone RDS ?Standby Aurora 3. RDS Aurora ? RDS ??? (??/??) ? Point-in-Time ?? Multi-?\AZ ?/w Aurora ? Replica MySQL ??/?? ?? ?? EBS ? snapshot RDS snapshots RDS snapshots Backup (EC2 ?+ ?EBS)
  • 28. v EBS ??? ???? ?? ??
  • 29. v [[ console screenshot ]] RDS automated backups EBS ????? ?? ??
  • 30. v [[ console screenshot ]] RDS automated backups EBS ????? ?? ??
  • 31. v [[ console screenshot ]] restore EBS from snapshot EBS ???? ?? ??
  • 32. vv Amazon RDS? ???? ?? ? ?? ?? ??(Automated Backup) ? RDS? ??? ???? ?? ? ?? DB ????? ???? ??? ? ?? ?? ??(Backup Retention Period) ?? ??? ?? (1~35?) ? ?? ? ?? ?? ? ?? ? ?? ?? ?? ??? (DB Snapshots) ? ???? ??? ?? ? ??? ??? ?? ? ?? ?? ?? ?? ?? ? ?? ????? ?? ??
  • 33. vv Amazon RDS? ???? ?? ? ?? ?? (Restore) ? ?? ?? ??????? ?? Aurora DB ???? ?? ? ?? ?? ?? ? ?? ????? ?? ? Latest Restorable Time : ?? 5? ?? ? Earliest Restorable Time : ?? ?? ?? ? Aurora Backup? ??, ?? ???? ?? ?? ??? ?? ??? ??? ??? ? ?? ??
  • 34. v RDS ???? ?? ?? C ?? ??
  • 35. v [[ console screenshot ]] RDS automated backups RDS ????? ?? ?? C ?? ??
  • 36. v RDS ???? ?? ?? C ?? ??
  • 37. v [[ console screenshot ]] RDS DB snapshots RDS ???? ?? ?? C ?? ??
  • 38. v [[ console screenshot ]] RDS DB snapshots RDS ???? ?? ?? C ?? ??
  • 39. v RDS ???? ?? ?? C ?? ??
  • 41. v [[ console screenshot ]] restore EBS from snapshot RDS ???? ?? ??
  • 43. v [[ console screenshot ]] RDS snapshot restore RDS ???? ?? ??
  • 45. vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds create-db-cluster-snapshot --db-cluster-snapshot- identifier <value> --db-cluster-identifier <value> [--tags <value>] [--cli-input-json <value>] [--generate-cli-skeleton] $ aws rds create-db-cluster-snapshot --db-cluster-identifier mysql- powergroup-aurora-demo --db-cluster-snapshot-identifier mysnapshot-03- 05-17-25 DBCLUSTERSNAPSHOT 1 2016-03-25T07:00:05.099Z mysql- powergroup-aurora-demo mysnapshot-03-05-17-25 aurora aurora master 0 0 2016-03-25T08:29:39.920Z manual creating False vpc-14c21f71 AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e
  • 46. vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds describe-db-cluster-snapshots [--db-cluster- identifier <value>] [--db-cluster-snapshot-identifier <value>] [--snapshot-type <value>] [--filters <value>] [--max-records <value>] [--marker <value>] [--cli-input-json <value>] $ aws rds describe-db-cluster-snapshots { "DBClusterSnapshots": [ { "Engine": "aurora", "SnapshotCreateTime": "2016-03-25T08:29:39.920Z", "DBClusterIdentifier": "mysql-powergroup-aurora-demo", "DBClusterSnapshotIdentifier": "mysnapshot-03-05-17-25", "ClusterCreateTime": "2016-03-25T07:00:05.099Z", .. },
  • 47. vv RDS Aurora ??? ??(CLI) ? Syntax ? Example $ aws rds restore-db-cluster-from-snapshot [--availability- zones <value>] --db-cluster-identifier <value> --snapshot- identifier <value> --engine <value> $ aws rds restore-db-cluster-from-snapshot --db-cluster-identifier mysql-powergroup-aurora-demo-restore --snapshot-identifier mysnapshot- 03-05-17-25 --engine aurora DBCLUSTER 1 2 mysql-powergroup-aurora-demo-restore default.aurora5.6 default mysql-powergroup-aurora-demo- restore.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a master 3306 05:35-06:05 tue:10:27-tue:10:57 creating False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e VPCSECURITYGROUPS active sg-71f69814
  • 48. vv RDS Aurora Poin-Tn-Time ??(CLI) ? Syntax ? Example $ aws rds restore-db-cluster-to-point-in-time --db-cluster- identifier <value> --source-db-cluster-identifier <value>[-- restore-to-time <value>] $ aws rds restore-db-cluster-to-point-in-time --db-cluster-identifier mysql-powergroup-aurora-demo-pitr --source-db-cluster-identifier mysql-powergroup-aurora-demo --use-latest-restorable-time DBCLUSTER 1 2 mysql-powergroup-aurora-demo-pitr default.aurora5.6 default mysql-powergroup-aurora-demo- pitr.cluster-cnehurulmovt.us-east-1.rds.amazonaws.com aurora 5.6.10a master 3306 05:35-06:05 tue:10:27-tue:10:57 creating False AVAILABILITYZONES us-east-1b AVAILABILITYZONES us-east-1d AVAILABILITYZONES us-east-1e VPCSECURITYGROUPS active sg-71f69814
  • 49. v AWS ???? MySQL ??? ?? C ???
  • 50. vv 3. RDS Aurora ? Aurora Replica ?? ? ?? ?? ?? ? ?? 15? 2. RDS MySQL ? MySQL Replica ?? ? Cross-region Replica ?? ? ?? 5? 1. MySQL on EC2/EBS ? MySQL Replication ?? MySQL ??? ?? ?? Availability ?Zone Master (EC2 ?+ ?EBS) Availability ?Zone Replica (EC2 ?+ ?EBS) Replication Availability ?Zone RDS ?Primary MySQL Availability ?Zone RDS ?REplica MySQL Ayncronoous Replication Availability ?Zone RDS ?Primary Aurora Availability ?Zone RDS ?Replica Aurora Aurora ? Replica
  • 51. vv Amazon Aurora Replica? ?? ?? MySQL ?? ?? ? ??? ??? ??? ?? ? ??? ???? ???? ?? ? ?? ??? ?? ? ???? ? ??? ?? ?? ?? Page ?cache invalidation Aurora Master 30% ?Read 70% ?Write Aurora ?Replica 100% ?New ?Reads Shared ?Multi-?\AZ ?Storage MySQL Master 30% ?Read 70% ?Write MySQL ?Replica 30% ?New ?Reads 70% ?Write Single ?threaded binlog ?apply Data ?Volume Data ?Volume Amazon Aurora ?? ?? ? ?? ?? ?? ? ??? ?? ??, ?? 15? ?? ? ~100 ms ?? ?? ? ?? ????? ???? ???? ? ??? ?? ??
  • 52. vv ? ?? 13,800 ? ???? ?? ? Aurora Replica? 7.27 ?? ? ?? ? ?? ??? MySQL 5.6 ? ?? 2,000 ? ???? ?? ? ~2? ?? Read Replica ?? (console screenshot)
  • 53. vv Aurora ????? ? ???? ????? ? ??? DB ????? ????? ????? ?? ? ??? ?? ?? ?? ? ????? ???? ???? ? ??? ????? ???? ?? ? e.g.) Cluster Endpoint: auroraha.cluster-cnehurulmovt.us-east- 1.rds.amazonaws.com:3306 ? ???? ????? ? DB ???? ? ? ????(????? ?? ?? ??)? ?? ? ???? ??? ?? ?? ?? ?? ?? ? e.g.) Endpoint: auroraha.cnehurulmovt.us-east-1.rds.amazonaws.com
  • 55. MySQL ????? ?? 880?? ??! http://bit.ly/awskr-feedback AWS Activate ??? 100?? ?? ??? + 80 ?? Qwiklab Credit 600?? ??? ?? ???+ 100?? 1?? ???? ??? ????? ???? ??? ? ?? URL? ???? ??????!
  • 57. ???? 2 https://www.qwiklab.com/lab_catalogue ??? ?? ?? 3? 31??? ?? ?? ??? ?? ?? ?? ?? ??
  • 58. ???? 3 ??? ? ??? ?? ?
  • 59. ? ??? ?? AWSKRUG ?? ? ?? ????? ???? ??
About
? 2025 ݺߣ