{"id":3144,"date":"2019-09-02T09:57:06","date_gmt":"2019-09-02T09:57:06","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=3144"},"modified":"2022-03-03T12:14:06","modified_gmt":"2022-03-03T12:14:06","slug":"database-and-replication","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/","title":{"rendered":"Database and Replication"},"content":{"rendered":"\n<p>Understand the concepts of Database and Replication.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Cloud continues to drive down the cost of storage and compute<\/li><li>New applications need databases to store terabytes to petabytes of storage <\/li><li>new types of data is to be stored<\/li><li>Access to the data with millisecond latency is needed<\/li><li>process millions of requests per second<\/li><li>Scale to support millions of users anywhere in the world<\/li><li>Both relational and non-relational databases are needed<\/li><li>AWS offers broadest range of databases. <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"374\" height=\"275\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-16.png\" alt=\"Database and Replication\" class=\"wp-image-3342\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>AWS Managed database services <\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>removes constraints that come with licensing\ncosts <\/li><li>supports diverse database engines <\/li><li>Access to the information stored on these\ndatabases is the main purpose of cloud computing.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">There are three different categories of databases to keep in\nmind while architecting:<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Relational databases \u2013 Data is normalized into\ntables and also provided with <ul><li>powerful query language<\/li><\/ul><ul><li>flexible indexing capabilities<\/li><\/ul><ul><li>strong integrity controls<\/li><\/ul><ul><li>ability to combine data from multiple tables in\na fast and efficient manner. <\/li><\/ul><ul><li>Can be scaled vertically and are highly\navailable during failovers.<\/li><\/ul><\/li><li>NoSQL databases\u2013 They have flexible data model\nthat seamlessly scales horizontally. NoSQL databases utilize a variety of data\nmodels, including graphs, key-value pairs, and JSON documents. They offer <ul><li>ease of development<\/li><\/ul><ul><li>scalable performance<\/li><\/ul><ul><li>high availability<\/li><\/ul><ul><li>&nbsp;resilience<\/li><\/ul><\/li><li>Data warehouse \u2013 A specialized type of\nrelational database, optimized for analysis and reporting of large amounts of\ndata. It can be used to combine transactional data from disparate sources\nmaking them available for analysis and decision-making. <ul><li>Horizontal-scaling is usually based on the\npartitioning of the data i.e. each node contains only part of the data <\/li><\/ul><ul><li>Vertical-scaling the data resides on a single node\nand scaling is done through multi-core i.e. spreading the load between the CPU\nand RAM resources of that machine.<\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Database Engines<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon Aurora<\/li><li>PostgreSQL<\/li><li>MySQL<\/li><li>MariaDB<\/li><li>Oracle<\/li><li>Microsoft SQL Server<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"351\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-17.png\" alt=\"Database and Replication\" class=\"wp-image-3343\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Relational Database<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Relational databases store data with pre-defined\nschema <\/li><li>relationships between them are defined<\/li><li>designed for supporting ACID transactions<\/li><li>maintaining referential integrity<\/li><li>maintain data consistency<\/li><li>Used for<ul><li>Traditional\napplications<\/li><\/ul><ul><li>ERP<\/li><\/ul><ul><li>CRM<\/li><\/ul><ul><li>e-commerce<\/li><\/ul><\/li><li>AWS Offerings<ul><li>Amazon\nAurora<\/li><\/ul><ul><li>MySQL,\nPostgreSQL<\/li><\/ul><ul><li>Amazon\nRDS<\/li><\/ul><ul><li>MySQL,\nPostgreSQL, MariaDB, Oracle, SQL Server<\/li><\/ul><ul><li>Amazon\nRedshift<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Key-value\ndatabses<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Optimized to store and retrieve key-value pairs <\/li><li>large data volumes with milliseconds retrieval<\/li><li>without the performance overhead <\/li><li>scale limitations of relational databases<\/li><li>Used for<ul><li>Internet-scale\napplications<\/li><\/ul><ul><li>real-time\nbidding<\/li><\/ul><ul><li>shopping\ncarts<\/li><\/ul><ul><li>customer\npreferences<\/li><\/ul><\/li><li>AWS Offering<ul><li>Amazon\nDynamoDB<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Document\nDatabases<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Designed to store semi-structured data <\/li><li>Stores documents <\/li><li>Data is typically represented as a readable\ndocument<\/li><li>Used for<ul><li>Content\nmanagement<\/li><\/ul><ul><li>Personalization<\/li><\/ul><ul><li>mobile\napplications<\/li><\/ul><\/li><li>AWS Offering<ul><li>Amazon\nDocumentDB (with MongoDB compatibility)<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>In-memory\nDatabases<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Used for applications that require real time\naccess to data. <\/li><li>By storing data directly in memory, microsecond\nlatency is provided <\/li><li>Used for<ul><li>Caching<\/li><\/ul><ul><li>gaming\nleaderboards<\/li><\/ul><ul><li>real-time\nanalytics<\/li><\/ul><\/li><li>AWS Offerings:<ul><li>Amazon\nElastiCache for Redis<\/li><\/ul><ul><li>Amazon\nElastiCache for Memcached<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Graph Databases<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Used for applications needing to query and\nnavigate relationships between highly connected, graph datasets with\nmillisecond latency. <\/li><li>Used for<ul><li>Fraud\ndetection<\/li><\/ul><ul><li>social\nnetworking<\/li><\/ul><ul><li>&nbsp;recommendation engines<\/li><\/ul><\/li><li>AWS Offering<ul><li>Amazon\nNeptune<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Time Series\nDatabases<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Used to efficiently <ul><li>Collect<\/li><\/ul><ul><li>Synthesize<\/li><\/ul><ul><li>derive\ninsights from enormous amounts of data <\/li><\/ul><\/li><\/ul>\n\n\n\n<p>that\nchanges over time (known as time-series data)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Used for<ul><li>IoT\napplications<\/li><\/ul><ul><li>DevOps<\/li><\/ul><ul><li>industrial\ntelemetry<\/li><\/ul><\/li><li>AWS Offering:<ul><li>Amazon\nTimestream<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Ledger Databases<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Used for a centralized, trusted authority to maintain a scalable, complete and cryptographically verifiable record of transactions. <\/li><li>Used for<ul><li>Systems of record<\/li><\/ul><ul><li>supply chain<\/li><\/ul><ul><li>registrations<\/li><\/ul><ul><li>banking transactions<\/li><\/ul><\/li><li>AWS Offering:<ul><li>Amazon Quantum Ledger Database (QLDB) <\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Amazon RDS<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Expands to Relational Database Service<\/li><li>Eliminates much of relational database management<\/li><li>Can be scaled independently<ul><li>CPU<\/li><\/ul><ul><li>memory<\/li><\/ul><ul><li>storage<\/li><\/ul><ul><li>IOPS\u00a0 <\/li><\/ul><\/li><li>AWS manages <ul><li>backups<\/li><\/ul><ul><li>software patching<\/li><\/ul><ul><li>automatic failure detection<\/li><\/ul><ul><li>recovery<\/li><\/ul><\/li><li>Can trigger, manual or automated backups <\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>It provides high availability with primary instance which if fails, switch to secondary instance <\/li><li>Has a soft limit of 40 Amazon RDS DB instances per account<\/li><li>From 40, up to 10 can be Oracle or Microsoft SQL Server DB instances under the License Included model. <\/li><li>Customers can Bring Own License (BYOL) model to have all 40 DB instances for Oracle or Microsoft SQL Server<\/li><li>Supports database engines<ul><li>MySQL<\/li><\/ul><ul><li>MariaDB<\/li><\/ul><ul><li>PostgreSQL<\/li><\/ul><ul><li>Oracle<\/li><\/ul><ul><li>Microsoft SQL Server<\/li><\/ul><ul><li>MySQL-compatible Amazon Aurora <\/li><\/ul><ul><li>AWS IAM controls AWS resources access to Amazon RDS databases.<\/li><\/ul><\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>For security: <\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>put database in an Amazon Virtual Private Cloud (Amazon VPC) <\/li><li>using Secure Sockets Layer (SSL) for data in transit <\/li><li>Using encryption for data at rest<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">Further,<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>RDS APIs and the AWS Management Console provide a management interface that allows you to create, delete, modify, and terminate RDS DB instances; to create DB snapshots; and to perform point-in-time restores<\/li><li>There is no AWS data API for Amazon RDS.<\/li><li>Once a database is created, RDS provides a DNS endpoint for the database which can be used to connect to the database.<\/li><li>Endpoint does not change over the lifetime of the instance even during the failover in case of Multi-AZ configuration<\/li><li>RDS leverages Amazon EBS volumes as its data store<\/li><li>RDS provides database backups, which are replicated across multiple AZ\u2019s<\/li><li>Then, RDS Multi AZ\u2019s feature synchronously replicate data between a primary RDS DB instance and a standby instance in another Availability Zone, which prevents data loss,<\/li><li>RDS provides a DNS endpoint and in case of an failure on the primary, it automatically fails over to the standby instance<\/li><li>Next, RDS also allows Read replicas for the supported databases, which are replicated asynchronously<\/li><li>RDS Provisioned IOPS, where the IOPS can be specified when the instance is launched and is guaranteed over the life of the instance <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Resource<\/strong><\/td><td><strong>Default Limit<\/strong><\/td><\/tr><tr><td>Cross-region snapshots copy requests<\/td><td>5<\/td><\/tr><tr><td>DB Instances<\/td><td>40<\/td><\/tr><tr><td>Event subscriptions<\/td><td>20<\/td><\/tr><tr><td>Manual snapshots<\/td><td>100<\/td><\/tr><tr><td>Option groups<\/td><td>20   <\/td><\/tr><tr><td>Parameter groups   <\/td><td>50   <\/td><\/tr><tr><td>Read replicas per master   <\/td><td>5   <\/td><\/tr><tr><td>Reserved instances   <\/td><td>40   <\/td><\/tr><tr><td>Rules per DB security group   <\/td><td>20   <\/td><\/tr><tr><td>Rules per VPC security group   <\/td><td>50 inbound 50 outbound   <\/td><\/tr><tr><td>DB Security groups   <\/td><td>25   <\/td><\/tr><tr><td>VPC Security groups   <\/td><td>5   <\/td><\/tr><tr><td>Subnet groups   <\/td><td>50   <\/td><\/tr><tr><td>Subnets per subnet group   <\/td><td>20   <\/td><\/tr><tr><td>Tags per resource   <\/td><td>50   <\/td><\/tr><tr><td>Total storage for all DB instances   <\/td><td>100 TiB   <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-18-590x400.png\" alt=\"Database and Replication\" class=\"wp-image-3345\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-18-590x400.png 590w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-18.png 624w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Amazon DynamoDB&nbsp;<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>It is a fully managed NoSQL database service <\/li><li>It provides fast and predictable performance with seamless scalability. <\/li><li>Offload the administrative burdens of operating and scaling a distributed database<\/li><li>It also offers encryption at rest<\/li><li>Create database tables that can store and retrieve any amount of data<\/li><li>Serve any level of request traffic. <\/li><li>Scale up or down tables&#8217; throughput capacity without downtime or performance degradation<\/li><li>Use the AWS Management Console to monitor resource utilization. <\/li><li>Also, provides on-demand backup capability with full backups of tables for long-term retention and archival.<\/li><li>tables, items, and attributes are the core components <\/li><li>A table is a collection of items<\/li><li>item is a collection of attributes. <\/li><li>primary keys are used to uniquely identify each item in a table <\/li><li>secondary indexes provide more querying flexibility<\/li><li>DynamoDB Streams capture data modification events in DynamoDB tables. <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"188\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-19.png\" alt=\"\" class=\"wp-image-3346\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>DynamoDB\ncomponents<\/strong><\/h4>\n\n\n\n<p>Tables <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Similar to other database systems, DynamoDB stores data in tables. <\/li><li>A table is a collection of data<\/li><li>Example, see the example table called People, is listed below, to store personal contact information about friends, family, or anyone else of interest. You could also have a Cars table to store information about vehicles that people drive.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">Items <\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Each table contains zero or more items<\/li><li>An item is a group of attributes that is uniquely identifiable among all of the other items. <\/li><li>In a People table, each item represents a person. For a Cars table, each item represents one vehicle. <\/li><li>Items are similar in many ways to rows, or tuples in other database systems. <\/li><li>There is no limit to the number of items you can store in a table.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">Attributes <\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Each item is composed of one or more attributes. <\/li><li>It is a fundamental data element, and is not to be broken down any further. <\/li><li>For example, an item in a People table contains attributes called PersonID, LastName, FirstName, and so on. <\/li><li>Attributes are similar to fields or columns in other database systems.<\/li><\/ul>\n\n\n\n<p>The following diagram shows a table named People with some example items and attributes. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-20-217x400.png\" alt=\"\" class=\"wp-image-3347\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-20-217x400.png 217w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-20.png 274w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/figure>\n\n\n\n<h6 class=\"wp-block-heading\">Note the following about the People table:<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Each item in the table has a unique identifier,\nor primary key, that distinguishes the item from all of the others in the\ntable. In the People table, the primary key consists of one attribute\n(PersonID).<\/li><li>Other than the primary key, the People table is\nschemaless, which means that neither the attributes nor their data types need\nto be defined beforehand. Each item can have its own distinct attributes.<\/li><li>Most of the attributes are scalar, which means\nthat they can have only one value. Strings and numbers are common examples of\nscalars.<\/li><li>Some of the items have a nested attribute (Address).\nDynamoDB supports nested attributes up to 32 levels deep.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">DynamoDB supports two different kinds of primary keys:<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Partition key \u2013 A simple primary key, composed\nof one attribute known as the partition key. Partition key&#8217;s value is input to\nan internal hash function. The output from the hash function determines the\npartition (physical storage internal to DynamoDB) in which the item will be\nstored. In a table that has only a partition key, no two items can have the\nsame partition key value. The People table has a simple primary key (PersonID)\nto access any item in the table directly by providing it.<\/li><li>Partition key and sort key \u2013&nbsp; Called as a composite primary key. Has two\nattributes &#8211; first is the partition key, and second is the sort key. Partition key\nvalue as input to an internal hash function. The output from the hash function\ndetermines the partition (physical storage internal to DynamoDB) in which the\nitem will be stored. All items with the same partition key value are stored\ntogether, in sorted order by sort key value. <\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Secondary\nIndexes \u2013 <\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Can create one or more secondary indexes on a\ntable. <\/li><li>Query the table using an alternate key by\nsecondary index, instead of primary key. <\/li><li>DynamoDB doesn&#8217;t require index, but index give\nmore flexibility during querying data. <\/li><li>With a secondary index on a table, read data\nfrom index similar as, from the table.<\/li><\/ul>\n\n\n\n<p><strong>DynamoDB index types<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Global secondary index \u2013 Partition key and sort\nkey that can be different from those on the table.<\/li><li>Local secondary index \u2013Same partition key as the\ntable, but a different sort key.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\">DynamoDB supports eventually consistent and strongly\nconsistent reads.<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Eventually Consistent Reads &#8211; When you read data\nfrom a DynamoDB table, the response might not reflect the results of a recently\ncompleted write operation. The response might include some stale data. If you\nrepeat read request after a short time, the response should return the latest\ndata.<\/li><li>Strongly Consistent Reads &#8211; When you request a\nstrongly consistent read, DynamoDB returns a response with the most up-to-date\ndata, reflecting the updates from all prior write operations that were\nsuccessful. A strongly consistent read might not be available if there is a\nnetwork delay or outage. Consistent reads are not supported on global secondary\nindexes (GSI).<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Amazon Redshift<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>It is a fast, scalable data warehouse <\/li><li>Used to analyze all data across data warehouse and data lake. <\/li><li>Integrates with machine learning, parallel query execution, and columnar storage. <\/li><li>Setup and deploy a new data warehouse in minutes<\/li><li>Run queries across petabytes in Redshift, and exabytes in data lake.<\/li><li>uses columnar storage, data compression, and zone maps to reduce I\/O to perform queries.<\/li><li>Has a massively parallel processing (MPP) architecture to parallelize and distribute SQL operations <\/li><li>stores three copies of data \u2014 all data written to a node in cluster is automatically replicated to other nodes within the cluster, and all data is continuously backed up to Amazon S3.<\/li><li>Snapshots are automated, incremental, and continuous and stored for a user-defined period (1-35 days)<\/li><li>Manual snapshots can be created and are retained until deleted.<\/li><li>Continuously monitors health of cluster <\/li><li>Automatically re-replicates data from failed drives and replaces nodes as necessary.<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Three pricing components:<\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>data warehouse node hours \u2013 total number of hours run across all the compute node<\/li><li>backup storage \u2013 storage cost for automated and manual snapshots<\/li><li>data transfer<\/li><\/ul>\n\n\n\n<p>number of nodes can be easily scaled as per demand<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Monitoring Amazon RDS <\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon RDS Events \u2013 Subscribe to Amazon RDS events to be notified when changes occur with a DB instance, DB cluster, DB snapshot, DB cluster snapshot, DB parameter group, or DB security group. <\/li><li>Database log files \u2013 View, download, or watch database log files using the Amazon RDS console or Amazon RDS API actions. You can also query some database log files that are loaded into database tables. <\/li><li>Amazon RDS Enhanced Monitoring \u2014 Look at metrics in real-time for the operating system that DB instance or DB cluster runs on.<\/li><li>Amazon CloudWatch Metrics \u2013 Amazon RDS automatically sends metrics to CloudWatch every minute for each active database instance and cluster. <\/li><li>Then, Amazon CloudWatch Alarms \u2013 Watch a single Amazon RDS metric over a specific time period, and perform actions based on the value of the metric relative to a threshold you set. <\/li><li>Amazon CloudWatch Logs \u2013 MariaDB, MySQL, and Aurora MySQL enable you to monitor, store, and access database log files in CloudWatch Logs. <\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Understand the concepts of Database and Replication. Cloud continues to drive down the cost of storage and compute New applications need databases to store terabytes to petabytes of storage new types of data is to be stored Access to the data with millisecond latency is needed process millions of requests per second Scale to support&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2471,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[7,543],"class_list":["post-3144","page","type-page","status-publish","hentry","category-amazon-aws","tag-aws","tag-database-and-replication"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database and Replication - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database and Replication - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-03T12:14:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-16.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/\",\"name\":\"Database and Replication - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-09-02T09:57:06+00:00\",\"dateModified\":\"2022-03-03T12:14:06+00:00\",\"description\":\"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Certified Solutions Architect Professional (SAP-C02)\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database and Replication\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database and Replication - Testprep Training Tutorials","description":"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/","og_locale":"en_US","og_type":"article","og_title":"Database and Replication - Testprep Training Tutorials","og_description":"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2022-03-03T12:14:06+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/09\/image-16.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/","name":"Database and Replication - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-09-02T09:57:06+00:00","dateModified":"2022-03-03T12:14:06+00:00","description":"Enhance your knowledge level by learning the concepts of Database and Replication for AWS Certification Exam Preparation Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/database-and-replication\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"AWS Certified Solutions Architect Professional (SAP-C02)","item":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-professional-sap-c01\/"},{"@type":"ListItem","position":3,"name":"Database and Replication"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/3144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=3144"}],"version-history":[{"count":7,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/3144\/revisions"}],"predecessor-version":[{"id":51895,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/3144\/revisions\/51895"}],"up":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/2471"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=3144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=3144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=3144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}