{"id":175710,"date":"2024-01-04T19:22:46","date_gmt":"2024-01-04T18:22:46","guid":{"rendered":"https:\/\/liora.io\/en\/?p=175710"},"modified":"2026-02-06T08:39:33","modified_gmt":"2026-02-06T07:39:33","slug":"amazon-aurora-overview-of-this-cloud-database","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/amazon-aurora-overview-of-this-cloud-database","title":{"rendered":"Amazon Aurora: Overview of this cloud database"},"content":{"rendered":"<h2>Amazon Aurora is a relational database solution based on a cloud-native architecture designed to deliver high performance, high availability and flexible scalability, while reducing costs.<\/h2>\t\t\n\t\t<p>Amazon Aurora is based on open-source technologies such as <a href=\"\/\" data-wplink-url-error=\"true\">MySQL<\/a> and <strong>PostgreSQL<\/strong>, enabling it to offer advanced functionalities, as we&#8217;ll see in this article.<\/p><p>Amazon Aurora&#8217;s challenges are manifold. On the one hand, it enables companies to manage their data efficiently by providing a high-performance, scalable database solution that is not cumbersome to use.<\/p><p>Secondly, it reduces the costs associated with <a href=\"https:\/\/liora.io\/en\/acid-in-database-management\">database management, by reducing infrastructure requirements.<\/a><\/p><p>&nbsp;<\/p><p>?Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\"><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;AWS Elastic Load Balancer: The solution that distributes network traffic&quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/aws-elastic-load-balancer-the-solution-that-distributes-network-traffic\"><a href=\"https:\/\/liora.io\/en\/aws-elastic-load-balancer-the-solution-that-distributes-network-traffic\" target=\"_blank\" rel=\"noopener\">AWS Elastic Load Balancer: The solution that distributes network traffic<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Jam AWS: The playful Amazon learning platform&quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/jam-aws-the-playful-learning-platform-from-amazon\"><a href=\"https:\/\/liora.io\/en\/jam-aws-the-playful-learning-platform-from-amazon\" target=\"_blank\" rel=\"noopener\">Jam AWS: The playful Amazon learning platform<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;AWS Lambda: Introduction to the Serverless Function&quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/aws-lambda-introduction-to-the-serverless-function\"><a href=\"https:\/\/liora.io\/en\/aws-lambda-introduction-to-the-serverless-function\" target=\"_blank\" rel=\"noopener\">AWS Lambda: Introduction to the Serverless Function<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;AWS Certification: What is it and how do I get it? &quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/aws-certification-what-is-it-and-how-do-i-get-it\"><a href=\"https:\/\/liora.io\/en\/aws-certification-what-is-it-and-how-do-i-get-it\" target=\"_blank\" rel=\"noopener\">AWS Certification: What is it and how do I get it? <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;AWS SageMaker: A guide for using the platform&quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/aws-sagemaker-a-guide-for-using-the-platform\"><a href=\"https:\/\/liora.io\/en\/aws-sagemaker-a-guide-for-using-the-platform\" target=\"_blank\" rel=\"noopener\">AWS SageMaker: A guide for using the platform<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;5 AWS launches and announcements making developers\u2019 life easy in 2022&quot;}\" data-sheets-hyperlink=\"https:\/\/liora.io\/en\/5-aws-launches-and-announcements-making-developers-life-easy-in-2022\"><a href=\"https:\/\/liora.io\/en\/5-aws-launches-and-announcements-making-developers-life-easy-in-2022\" target=\"_blank\" rel=\"noopener\">5 AWS launches and announcements making developers\u2019 life easy in 2022<\/a><\/td><\/tr><\/tbody><\/table>\t\t\n\t\t\t<h3>How is an Aurora cluster structured?<\/h3>\t\t\n\t\t<p>An <strong>Amazon Aurora cluster<\/strong> is made up of 2 types of instance:<\/p><ul><li><strong>Primary instance:<\/strong> supports read and write operations, and makes all modifications to the cluster volume.<\/li><li><strong>Replica instances:<\/strong> connect to the same storage volume as the primary instance, but support read operations only. Each Aurora cluster can have a maximum of 15 replicas in addition to the primary instance.<\/li><\/ul>\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t<figure>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image1-3.png\" title=\"\" alt=\"\" loading=\"lazy\">\t\t\t\t\t\t\t\t\t\t\t<figcaption>Sources : docs.aws.amazon.com\/<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t<p><strong>Amazon Aurora<\/strong> uses a unique architecture of separate storage and processing to ensure high availability and reliable data replication.<\/p><p>One of its key features is the ability to automatically detect failures and seamlessly switch to a read instance that will take the place of the primary instance.<\/p><p>What&#8217;s more, <strong>Amazon Aurora<\/strong> automates and standardizes configuration and administration tasks (which can be complex and time-consuming), enabling users to concentrate on operations rather than <a href=\"https:\/\/liora.io\/en\/acid-in-database-management\">database management.<\/a><\/p>\t\t\n\t\t\t\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><div class=\"wp-block-button \"><a class=\"wp-block-button__link wp-element-button \" href=\"\/en\/courses\/cloud-dev\/aws-solutions-architect\">Learn how to use Amazon Aurora<\/a><\/div><\/div>\n\n\t\t\t<h3>Aurora features<\/h3>\t\t\n\t\t<p>Amazon Aurora is packed with features. The table below will help you understand them:<\/p>\t\t\n\t\t\t<style type=\"text\/css\">\n  .tg  {border-collapse:collapse;border-spacing:0;}\n  .tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg .tg-xbtn{background-color:#343434;border-color:inherit;color:#ffffff;font-weight:bold;text-align:center;vertical-align:top}\n  .tg .tg-ptw0{background-color:#343434;border-color:inherit;color:#ffffff;font-size:22px;font-weight:bold;text-align:center;\n    vertical-align:top}\n  .tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top}\n<\/style>\n<table style=\"undefined;table-layout: fixed; width: 850px\">\n  <colgroup>\n    <col style=\"width: 200px\">\n    <col style=\"width: 300px\">\n    <col style=\"width: 175px\">\n    <col style=\"width: 175px\">\n  <\/colgroup>\n  <thead>\n    <tr>\n      <th>Feature<\/th>\n      <th>Description<\/th>\n      <th>Advantages<\/th>\n      <th>Use Cases<\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <td>Aurora Global DB<\/td>\n      <td>Deploys an Aurora database across multiple AWS regions<\/td>\n      <td>\n          <ul>\n              <li>Very low latency<\/li><li>Rapid data replication<\/li><li>Quick and transparent recovery after failures<\/li><li>High performance<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>Global-scale applications<\/li><li>Disaster recovery<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Amazon Aurora Serverless<\/td>\n      <td>Automatically scales the database based on application traffic<\/td>\n      <td>\n          <ul><li>Automatic scaling<\/li><li>Low maintenance costs<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>Variable traffic applications<\/li><li>Developers<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Amazon RDS Proxy<\/td>\n      <td>Creates a connection pool to improve application performance<\/td>\n      <td>\n          <ul><li>Performance improvement<\/li><li>Connection management<\/li><li>High availability<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>High-demand applications<\/li><li>Production environments<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Single-master clusters<\/td>\n      <td>Used to handle read-intensive workloads or mixed read-write workloads<\/td>\n      <td>\n          <ul><li>High availability<\/li><li>Load balancing<\/li><li>High performance<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>Larger-scale applications<\/li><li>Read-intensive workloads<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Multi-master cluster<\/td>\n      <td>Used to enable horizontal load balancing for mixed read-write workloads<\/td>\n      <td>\n          <ul><li>High availability<\/li><li>Load balancing<\/li><li>High performance<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>High-demand applications<\/li><li>Read-write intensive workloads<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Read replicas<\/td>\n      <td>Replicates data from the primary database for read operations, improving performance<\/td>\n      <td>\n          <ul><li>High availability<\/li><li>Reduced downtime<\/li><li>High performance<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>Larger-scale applications<\/li><li>Read-intensive workloads<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n    <tr>\n      <td>Babelfish for Aurora PostgreSQL<\/td>\n      <td>Allows migration of PostgreSQL applications to Aurora PostgreSQL using existing tools and skills<\/td>\n      <td>\n          <ul><li>Easy migration<\/li><li>Compatibility with PostgreSQL<\/li><li>Cost savings<\/li>\n          <\/ul>\n      <\/td>\n      <td>\n          <ul><li>Existing applications<\/li><li>PostgreSQL workloads<\/li>\n          <\/ul>\n      <\/td>\n    <\/tr>\n  <\/tbody>\n<\/table>\n\t\t\t<h3>What are the benefits of using Aurora?<\/h3>\t\t\n\t\t<p>Now that you have a better overview of <strong>Amazon Aurora,<\/strong> let&#8217;s look at the benefits of using it.<\/p>\t\t\n\t\t\t<style type=\"text\/css\">\n  .tg  {border-collapse:collapse;border-spacing:0;}\n  .tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg .tg-abx8{background-color:#c0c0c0;font-weight:bold;text-align:left;vertical-align:top}\n  .tg .tg-5qpf{background-color:#c0c0c0;font-size:100%;font-weight:bold;text-align:left;vertical-align:top}\n  .tg .tg-6qw1{background-color:#c0c0c0;text-align:center;vertical-align:top}\n  .tg .tg-mj3y{background-color:#c0c0c0;font-size:100%;text-align:left;vertical-align:top}\n  .tg .tg-y6fn{background-color:#c0c0c0;text-align:left;vertical-align:top}\n<\/style>\n<table style=\"undefined;table-layout: fixed; width: 850px\">\n  <colgroup>\n    <col style=\"width: 75px\">\n    <col style=\"width: 150px\">\n    <col style=\"width: 625px\">\n  <\/colgroup>\n  <thead>\n    <tr>\n      <th><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image4-4.png\" alt=\"Image\" width=\"50\" height=\"50\"><\/th>\n      <th>Scalability<\/th>\n      <th>Your database size adjusts automatically based on your needs<\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <td><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image6-3.png\" alt=\"Image\" width=\"50\" height=\"54\"><\/td>\n      <td>Cost Reduction<\/td>\n      <td>You pay only for the storage space and computing power you need. You also eliminate all infrastructure management costs<\/td>\n    <\/tr>\n    <tr>\n      <td><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image8-1.png\" alt=\"Image\" width=\"50\" height=\"51\"><\/td>\n      <td>Security<\/td>\n      <td>It is possible to isolate your network hosting the database. You can also use access keys provided by AWS<\/td>\n    <\/tr>\n    <tr>\n      <td><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image3-3.png\" alt=\"Image\" width=\"50\" height=\"50\"><\/td>\n      <td>Availability<\/td>\n      <td>Replicas can be created across multiple AWS availability zones<\/td>\n    <\/tr>\n    <tr>\n      <td><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image2-5.png\" alt=\"Image\" width=\"50\" height=\"50\"><\/td>\n      <td>Migration<\/td>\n      <td>Database dumps from PostgreSQL and MySQL are easily usable for migration<\/td>\n    <\/tr>\n    <tr>\n      <td><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/2023\/04\/image5-2.png\" alt=\"Image\" width=\"50\" height=\"43\"><\/td>\n      <td>Fully Managed<\/td>\n      <td>The service is fully managed. You have no management tasks, whether it&#8217;s updating your database or its maintenance<\/td>\n    <\/tr>\n  <\/tbody>\n<\/table>\n\t\t\t<h3>Fazit<\/h3>\t\t\n\t\t<p>To conclude this article, Amazon Aurora lets you take advantage of a fully managed MySQL and PostgreSQL-compatible cloud database. As a result, you won&#8217;t have to worry about database management costs and maintenance issues, while maintaining a high level of security.<\/p>\t\t\n\t\t\t\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><div class=\"wp-block-button \"><a class=\"wp-block-button__link wp-element-button \" href=\"\/en\/courses\/cloud-dev\/aws-solutions-architect\">Register for Amazon Web Services training<\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Amazon Aurora is a relational database solution based on a cloud-native architecture designed to deliver high performance, high availability and flexible scalability, while reducing costs. Amazon Aurora is based on open-source technologies such as MySQL and PostgreSQL, enabling it to offer advanced functionalities, as we&#8217;ll see in this article. Amazon Aurora&#8217;s challenges are manifold. On [&hellip;]<\/p>\n","protected":false},"author":76,"featured_media":175711,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2434],"class_list":["post-175710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-dev"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/175710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=175710"}],"version-history":[{"count":1,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/175710\/revisions"}],"predecessor-version":[{"id":206153,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/175710\/revisions\/206153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/175711"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=175710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=175710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}