[Linux Academy] Amazon Aurora – Cloud SQL DB Essentials (Julie Elkins)

Dr.Vatson · 23 май 2020

Hi, and welcome to this course on Amazon Aurora! In this course we will be covering all of the essentials that you need to know for Amazon Aurora with some deeper dives into Aurora's features, management, security, storage, and reliability, data management, performance, and also troubleshooting topics.

Amazon Aurora is a proprietary technology from AWS and it is not open sourced, but Aurora is compatible with both MySQL and PostgreSQL databases. And the Amazon Aurora db will have compatible drivers so connections from either engine has been made simple and secure. AWS has made Aurora cloud optimized and Amazon Aurora MySQL has 5x the performance improvement over MySQL on RDS and over 3x the performance over Postgres on RDS plus tons of other performance improvements and features that we will cover throughout this course. One of the key differences we will see is that Aurora's is unique to other databases and its storage automatically grows in increments of 10 gigabytes up to 64 terabytes.

So we start off at 10 gigabytes and as we had more data our Aurora storage automatically grows with our data, so you no longer have to worry about managing your disk. Another cool feature of Aurora is that you can have up to 15 read replicas with Aurora compared to 5 read replicas with MySQL and the replication process to the Aurora read replicas is faster. Failover with Amazon Aurora is instantaneous and Aurora is also highly available. Aws estimates that the cost / pricing for Amazon Aurora is around 20% more than RDS, Aurora is more efficient.

As I said we will be covering all of the essentials of Aurora in this course plus some deeper dives too! Let's get started!

00-course-introduction.mp4 [27m 961k 592]
00-course-introduction.srt [3k 470]
01-using-the-interactive-diagram.mp4 [20m 441k 636]
01-using-the-interactive-diagram.srt [3k 377]
02-what-is-a-database.mp4 [105m 906k 632]
02-what-is-a-database.srt [15k 406]
03-what-is-amazon-aurora.mp4 [120m 993k 111]
03-what-is-amazon-aurora.srt [16k 840]
04-aurora-database-cluster-part-one.mp4 [266m 109k 45]
04-aurora-database-cluster-part-one.srt [42k 904]
05-aurora-database-cluster-part-two.mp4 [78m 160k 75]
05-aurora-database-cluster-part-two.srt [14k 159]
06-how-are-databases-used.mp4 [41m 348k 401]
06-how-are-databases-used.srt [9k 317]
07-mysql-and-postgresql.mp4 [145m 639k 620]
07-mysql-and-postgresql.srt [23k 931]
08-global-database.mp4 [108m 982k 404]
08-global-database.srt [17k 693]
09-multi-master.mp4 [19m 827k 853]
09-multi-master.srt [3k 190]
10-parallel-query.mp4 [38m 727k 411]
10-parallel-query.srt [6k 197]
11-performance-insights.mp4 [32m 931k 33]
11-performance-insights.srt [6k 173]
12-backtrack.mp4 [62m 869k 528]
12-backtrack.srt [10k 917]
13-aurora-serverless.mp4 [42m 895k 63]
13-aurora-serverless.srt [7k 751]
14-machine-learning.mp4 [35m 977k 536]
14-machine-learning.srt [6k 669]
15-rds-proxy.mp4 [27m 780k 780]
15-rds-proxy.srt [5k 119]
16-additional-new-aurora-features.mp4 [57m 73k 530]
16-additional-new-aurora-features.srt [10k 648]
17-amazon-aurora-pricing.mp4 [62m 830k 892]
17-amazon-aurora-pricing.srt [12k 505]
18-performing-a-proof-of-concept.mp4 [204m 629k 232]
18-performing-a-proof-of-concept.srt [31k 694]
19-security-configuring-access-and-connecting-to-your-aurora-database.mp4 [78m 760k 347]
19-security-configuring-access-and-connecting-to-your-aurora-database.srt [14k 683]
20-importing-and-exporting-data.mp4 [108m 628k 828]
20-importing-and-exporting-data.srt [19k 392]
21-managing-performance-and-scaling-for-your-aurora-db-cluster.mp4 [29m 233k 579]
21-managing-performance-and-scaling-for-your-aurora-db-cluster.srt [6k 672]
22-best-practices.mp4 [23m 140k 472]
22-best-practices.srt [5k 363]
23-connecting-to-an-aurora-db-to-transfer-data.mp4 [20m 134k 794]
23-connecting-to-an-aurora-db-to-transfer-data.srt [4k 734]
24-using-amazon-aurora-serverless.mp4 [91m 708k 901]
24-using-amazon-aurora-serverless.srt [15k 337]
25-how-amazon-aurora-serverless-works.mp4 [99m 875k 601]
25-how-amazon-aurora-serverless-works.srt [16k 971]
26-creating-an-aurora-serverless-db-cluster.mp4 [81m 384k 186]
26-creating-an-aurora-serverless-db-cluster.srt [14k 434]
27-restoring-modifying-and-viewing-your-aurora-serverless-db.mp4 [39m 349k 485]
27-restoring-modifying-and-viewing-your-aurora-serverless-db.srt [6k 718]
28-using-the-data-api-for-aurora-serverless.mp4 [28m 903k 759]
28-using-the-data-api-for-aurora-serverless.srt [5k 94]
29-using-the-query-editor-for-aurora-serverless.mp4 [19m 824k 996]
29-using-the-query-editor-for-aurora-serverless.srt [3k 910]
30-storage-and-reliability-with-amazon-aurora.mp4 [116m 959k 6]
30-storage-and-reliability-with-amazon-aurora.srt [17k 835]
31-high-availability-with-amazon-aurora.mp4 [28m 394k 156]
31-high-availability-with-amazon-aurora.srt [4k 666]
32-working-with-amazon-aurora-global-databases.mp4 [65m 770k 598]
32-working-with-amazon-aurora-global-databases.srt [11k 80]
33-performance-tuning-and-benchmarking-with-amazon-aurora.mp4 [58m 201k 368]
33-performance-tuning-and-benchmarking-with-amazon-aurora.srt [11k 516]
34-troubleshooting.mp4 [95m 631k 26]
34-troubleshooting.srt [16k 333]
35-setting-the-capacity-of-an-aurora-serverless-db-cluster.mp4 [16m 411k 77]
35-setting-the-capacity-of-an-aurora-serverless-db-cluster.srt [3k 413]
36-troubleshooting-data-api-issues.mp4 [18m 478k 971]
36-troubleshooting-data-api-issues.srt [4k 27]
37-amazon-aurora-limits.mp4 [14m 777k 65]
37-amazon-aurora-limits.srt [3k 182]
38-amazon-aurora-best-practices-and-key-take-aways.mp4 [35m 387k 437]
38-amazon-aurora-best-practices-and-key-take-aways.srt [7k 483]

downloads
1383-what-is-amazon-aurora-amazon-aurora-webarchive.webarchive [243]
1384-amazon-aurora-pricing-amazon-web-services-aws-webarchive.webarchive [2m 858k 804]
1385-amazon-aurora-storage-and-reliability-amazon-aurora-webarchive.webarchive [1m 617k 272]
1386-aurora-export-import-best-practices-v1-3-pdf.pdf [174k 308]
1387-aws-re-invent-2018-repeat-1-what-s-new-in-amazon-aurora-dat204-r1-youtube-webarchive.webarchive [8m 603k 710]
1388-getting-started-with-the-amazon-aurora-serverless-data-api-webarchive.webarchive [10m 78k 357]
1389-identity-and-access-management-in-amazon-aurora-amazon-aurora-webarchive.webarchive [1m 626k 623]
1390-managing-performance-and-scaling-for-aurora-db-clusters-amazon-aurora-webarchive.webarchive [1m 610k 555]
1391-mysql-mysql-8-0-reference-manual-26-mysql-performance-schema-webarchive.webarchive [652k 117]
1392-performing-a-proof-of-concept-with-amazon-aurora-amazon-aurora-webarchive.webarchive [1m 742k 649]
1393-postgresql-documentation-9-2-pg-statistic-webarchive.webarchive [583k 885]
1394-rds-aurora-connectivity-guide-v5-2-pdf.pdf [1m 487k 329]
1395-rds-aurora-performance-assessment-benchmarking-v1-2-pdf.pdf [786k 631]
1396-security-with-amazon-aurora-mysql-amazon-aurora-webarchive.webarchive [1m 625k 355]
1397-security-with-amazon-aurora-postgresql-amazon-aurora-webarchive.webarchive [1m 627k 325]
1398-shared-responsibility-model-amazon-web-services-aws-webarchive.webarchive [2m 841k 593]
1399-using-amazon-aurora-serverless-amazon-aurora-webarchive.webarchive [1m 625k 804]
1401-new-data-api-for-amazon-aurora-serverless-aws-news-blog-webarchive.webarchive [3m 432k 466]
1402-working-with-amazon-aurora-global-database-amazon-aurora-webarchive.webarchive [3m 163k 667]

transcript
00-course-introduction.txt [1k 937]
01-using-the-interactive-diagram.txt [1k 946]
02-what-is-a-database.txt [8k 637]
03-what-is-amazon-aurora.txt [9k 493]
04-aurora-database-cluster-part-one.txt [24k 608]
05-aurora-database-cluster-part-two.txt [7k 934]
06-how-are-databases-used.txt [5k 336]
07-mysql-and-postgresql.txt [13k 524]
08-global-database.txt [10k 73]
09-multi-master.txt [1k 827]
10-parallel-query.txt [3k 542]
11-performance-insights.txt [3k 552]
12-backtrack.txt [6k 187]
13-aurora-serverless.txt [4k 382]
14-machine-learning.txt [3k 809]
15-rds-proxy.txt [2k 906]
16-additional-new-aurora-features.txt [6k 20]
17-amazon-aurora-pricing.txt [6k 994]
18-performing-a-proof-of-concept.txt [18k 192]
19-security-configuring-access-and-connecting-to-your-aurora-database.txt [8k 322]
20-importing-and-exporting-data.txt [10k 923]
21-managing-performance-and-scaling-for-your-aurora-db-cluster.txt [3k 779]
22-best-practices.txt [3k 14]
23-connecting-to-an-aurora-db-to-transfer-data.txt [2k 725]
24-using-amazon-aurora-serverless.txt [8k 703]
25-how-amazon-aurora-serverless-works.txt [9k 658]
26-creating-an-aurora-serverless-db-cluster.txt [8k 175]
27-restoring-modifying-and-viewing-your-aurora-serverless-db.txt [3k 791]
28-using-the-data-api-for-aurora-serverless.txt [2k 881]
29-using-the-query-editor-for-aurora-serverless.txt [2k 275]
30-storage-and-reliability-with-amazon-aurora.txt [10k 12]
31-high-availability-with-amazon-aurora.txt [2k 657]
32-working-with-amazon-aurora-global-databases.txt [6k 283]
33-performance-tuning-and-benchmarking-with-amazon-aurora.txt [6k 616]
34-troubleshooting.txt [9k 326]
35-setting-the-capacity-of-an-aurora-serverless-db-cluster.txt [1k 948]
36-troubleshooting-data-api-issues.txt [2k 222]
37-amazon-aurora-limits.txt [1k 819]
38-amazon-aurora-best-practices-and-key-take-aways.txt [4k 284]

Объем: 2.43Гб.

Скрытый текст. Доступен только зарегистрированным пользователям.Нажмите, чтобы раскрыть...