{"id":8369,"date":"2020-12-14T15:21:39","date_gmt":"2020-12-14T14:21:39","guid":{"rendered":"https:\/\/blog.capdata.fr\/?p=8369"},"modified":"2020-12-14T16:53:52","modified_gmt":"2020-12-14T15:53:52","slug":"aws-rds-aurora-postgresql","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/","title":{"rendered":"AWS RDS, Aurora et PostgreSQL"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369&#038;title=AWS%20RDS%2C%20Aurora%20et%20PostgreSQL\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=AWS%20RDS%2C%20Aurora%20et%20PostgreSQL&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><h1>Introduction<\/h1>\n<p>Cet article fait partie d&#8217;une suite d&#8217;articles venant \u00e0 d\u00e9couvrir les services PaaS BDD PostgreSQL que fournissent les principaux acteurs acteurs du cloud.<\/p>\n<p>Le sc\u00e9nario de test sera toujours le m\u00eame, un bench de type <a href=\"http:\/\/www.tpc.org\/tpcc\/\">TPC-C<\/a> sera lanc\u00e9 \u00e0 l&#8217;aide d&#8217;une version benchmarksql revue pour int\u00e9grer la connexion SSL et la capture de traces SGBD (sources disponibles ici : <a href=\"https:\/\/github.com\/Capdata\/benchmarksql\">https:\/\/github.com\/Capdata\/benchmarksql<\/a>), chaque bench :<\/p>\n<ul>\n<li>Durera 20 minutes<\/li>\n<li>Base de donn\u00e9es avec 200 entrep\u00f4ts (Cf norme TPC-C)<\/li>\n<li>Sera lanc\u00e9 avec 50 clients \u00e0 partir d&#8217;une VM cr\u00e9\u00e9e dans la m\u00eame zone que le PaaS<\/li>\n<\/ul>\n<p>Le but est de mesurer pour des configurations particuli\u00e8res le nombre de transactions par minutes, les valeurs seront ensuite agr\u00e9g\u00e9es et extrait le 90e <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Centile\">centile<\/a> du nombre de transactions totales par minutes (tpm \/ min) et du nombre de commandes par minutes (nopm \/ min, c&#8217;est la valeur de r\u00e9f\u00e9rence pour les benchmark de type TPC-C).<\/p>\n<p>&nbsp;<\/p>\n<h1>AWS<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8371 aligncenter\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/11\/AWS-300x166.png\" alt=\"\" width=\"546\" height=\"302\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/11\/AWS-300x166.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/11\/AWS-1024x567.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/11\/AWS-768x425.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/11\/AWS.png 1426w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Pr\u00e9sentation<\/h2>\n<p>AWS fournit un acc\u00e8s \u00e0 PostgreSQL en service manag\u00e9 au travers de 2 offres :<\/p>\n<ul>\n<li>RDS PostgreSQL<\/li>\n<li>RDS Aurora<\/li>\n<\/ul>\n<p>RDS PostgreSQL est disponible en versions 9.5.2 \u00e0 12.4 ,quant \u00e0 Aurora il offre une compatibilit\u00e9 de 9.6.8 \u00e0 11.8<\/p>\n<h2>Un peu d&#8217;historique<\/h2>\n<p>2009 : Mise en service de RDS<br \/>\n2013 : Support de PostgreSQL dans RDS<br \/>\n2014 : Mise en service de Aurora (support Mysql uniquement)<br \/>\n2017 : Support de PostgreSQL par aurora<br \/>\n2019 : Aurora PostgreSQL logical replication<br \/>\n2019 : Aurora <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-serverless.html\">Serverless<\/a> disponible pour PostgreSQL (nombre de r\u00e9gions disponibles encore assez limit\u00e9 aujourd&#8217;hui)<br \/>\n2020 : <a href=\"https:\/\/aws.amazon.com\/blogs\/opensource\/want-more-postgresql-you-just-might-like-babelfish\/\">Babelfish*<\/a> en preview sur Aurora pour PostgreSQL<\/p>\n<p>*Babelfish (annonc\u00e9 en d\u00e9cembre 2020) est un projet sous licence apache v2 (ouverture des sources pr\u00e9vue pour le premier trimestre de 2021) qui ajoute un endpoint \u00e0 PostreSQL rendant transparente pour les application la conversion SQL Server \/ PostgreSQL et ce sans \u00e0 avoir \u00e0 changer quoi que ce soit c\u00f4t\u00e9 applicatif.<\/p>\n<h2><strong>AWS RDS<\/strong><\/h2>\n<p>RDS pour Relational Database Service est le service de Base de donn\u00e9es Relationnelle g\u00e9r\u00e9 par AWS, offre un large choix de moteurs SGBD propri\u00e9taire (SQLServer, Oracle, Mysql, Aurora) ou libres (MariaDB, PostgreSQL).<\/p>\n<p>En plus de profiter de tous les services inh\u00e9rents \u00e0 tous les composants AWS, celui-ci comprend le stockage, la gestion des sauvegarde et des mont\u00e9es de versions mineures automatiques (si valid\u00e9).<\/p>\n<p>Pour une description d\u00e9taill\u00e9e de RDS je vous renvoie \u00e0 l&#8217;excellent article de David Baffaleuf : <a href=\"https:\/\/blog.capdata.fr\/index.php\/comparatif-mysql-dans-le-paas-episode-3-amazon-rds-2-2\/\">https:\/\/blog.capdata.fr\/index.php\/comparatif-mysql-dans-le-paas-episode-3-amazon-rds-2-2\/<\/a><\/p>\n<h2>RDS Aurora<\/h2>\n<p>Aurora est le moteur SGBD RDS d\u00e9velopp\u00e9 par AWS, offrant une compatibilit\u00e9 avec soit PostgreSQL soit MySQL (choix d\u00e9fini lors de la cr\u00e9ation).<br \/>\nAurora, en plus de promettre un gain en performances promet \u00e9galement une durabilit\u00e9 accrue des donn\u00e9es ; en effet, les donn\u00e9es sont regroup\u00e9es par block de 10Gb et pr\u00e9sent\u00e9es par 6 storage nodes diff\u00e9rents r\u00e9partis de fa\u00e7on uniforme sur 3 Zones de disponibilit\u00e9s (AZ) diff\u00e9rentes (on a donc 2 storages nodes par AZ ) le stockage s&#8217;agrandit de fa\u00e7on autonome par block de 10Gb jusqu&#8217;\u00e0 atteindre la limite (contrainte par le syst\u00e8me) de 64To (limite qui augmente r\u00e9guli\u00e8rement).<\/p>\n<p>L&#8217;historique des modifications du service est disponible ici : <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/WhatsNew.html\">https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/WhatsNew.html<\/a><\/p>\n<h2>Aurora un moteur SGBD-R \u00e0 part<\/h2>\n<h3>Aurora et le stockage<\/h3>\n<p>Aurora se distingue des PaaS RDS classique par son stockage et l&#8217;optimisation SGBD qui a \u00e9t\u00e9 faite pour en tirer plein parti.<\/p>\n<p>En effet, la fa\u00e7on dont est con\u00e7u le stockage sur <a href=\"https:\/\/aws.amazon.com\/blogs\/database\/introducing-the-aurora-storage-engine\/\">Aurora<\/a> est tr\u00e8s particulier, comme expliqu\u00e9 ci-dessus, le stockage est allou\u00e9 et prot\u00e9g\u00e9 par block de 10Gb :<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/d2908q01vomqb2.cloudfront.net\/887309d048beef83ad3eabf2a79a64a389ab1c9f\/2016\/11\/18\/StorageAllocation.png\" alt=\"StorageAllocation\" \/><\/p>\n<p>De plus, ce stockage est r\u00e9guli\u00e8rement backup\u00e9 sur <a href=\"https:\/\/aws.amazon.com\/fr\/s3\/\">S3 :<\/a><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/d2908q01vomqb2.cloudfront.net\/887309d048beef83ad3eabf2a79a64a389ab1c9f\/2016\/11\/18\/FaultTolerance.png\" alt=\"FaultTolerance\" \/><\/p>\n<p>(ci-dessus, chaque carr\u00e9 vert correspond \u00e0 1 storage node et chaque bloc de couleur \u00e0 un &#8220;protection group&#8221; (ensemble de donn\u00e9es) de 10Gb<\/p>\n<p>Pour \u00e9viter les latences sur le stockage le moteur n&#8217;attend pas l&#8217;acquittement de tous les storage nodes mais consid\u00e8re la donn\u00e9e comme \u00e9crite si au moins 4 des 6 storage nodes l&#8217;ont valid\u00e9e, ainsi m\u00eame avec la perte d&#8217;une AZ (ou de 2 storage nodes d&#8217;AZ diff\u00e9rentes) le service est toujours rendu.<\/p>\n<p>De plus des modifications ont \u00e9t\u00e9s apport\u00e9es au sein m\u00eame des SGBD (Mysql et PostgreSQL) de fa\u00e7on \u00e0 ce que les donn\u00e9es \u00e9chang\u00e9es (entre les instances de BDD et les storage nodes) soient r\u00e9duites au strict minimum (les logs de transaction).<\/p>\n<p>Pour plus d&#8217;informations :<\/p>\n<p><iframe loading=\"lazy\" title=\"What&#039;s New in Amazon Aurora (DAT204-R1) - AWS re:Invent 2018\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/nPCPgxU6IwYetr\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/AmazonWebServices\/whats-new-in-amazon-aurora-dat204r1-aws-reinvent-2018\" title=\"What&#39;s New in Amazon Aurora (DAT204-R1) - AWS re:Invent 2018\" target=\"_blank\">What&#39;s New in Amazon Aurora (DAT204-R1) &#8211; AWS re:Invent 2018<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/AmazonWebServices\" target=\"_blank\">Amazon Web Services<\/a><\/strong> <\/div>\n<p><iframe loading=\"lazy\" title=\"AWS re:Invent 2018: [REPEAT 1] Deep Dive on Amazon Aurora with MySQL Compatibility (DAT304-R1)\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/U42mC_iKSBg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h1>Performances<\/h1>\n<p>Comme expliqu\u00e9 en introduction, l&#8217;outil benchmarkSQL sera utilis\u00e9 (l\u00e9g\u00e8rement modifi\u00e9 pour supporter le SSL et capturer des m\u00e9triques compl\u00e9mentaires), seront en plus captur\u00e9 en fin de chaque bench les m\u00e9triques des PaaS.<\/p>\n<p>Les sources sont disponibles \u00e0 l&#8217;adresse : <a href=\"https:\/\/github.com\/Capdata\/benchmarksql\">https:\/\/github.com\/Capdata\/benchmarksql<\/a><\/p>\n<p>Les PaaS ont tous la version 11 de PostgreSQL, les options PostgreSQL sont laiss\u00e9es \u00e0 leurs d\u00e9fauts et leur configuration est la suivante :<\/p>\n<p>aws_aurora : Aurora en compatibilit\u00e9 PostgreSQL<br \/>\naws_rds : Stockage de type gp2 et taille allou\u00e9e 2To (IOPS li\u00e9es \u00e0 la taille du stockage : 3\u00a0IOPS\/Go max 16k IOPS), IOPS :\u00a0 \u00a06k IOPS<br \/>\naws_rds_pio_10k : Stockage de type IO provisionn\u00e9s, 10k IOPS max<br \/>\naws_rds_pio_30k : Stockage de type IO provisionn\u00e9s, 30k IOPS max<\/p>\n<p>Partant de l\u00e0, la seule variable \u00e0 \u00eatre ajust\u00e9e a \u00e9t\u00e9 la capacit\u00e9 \/ classe d&#8217;instance EC2 (CPU et m\u00e9moire) de l&#8217;instance :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8388\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/aws_results_bench.png\" alt=\"\" width=\"2048\" height=\"1057\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/aws_results_bench.png 1366w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/aws_results_bench-300x155.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/aws_results_bench-1024x528.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/aws_results_bench-768x396.png 768w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/p>\n<p>(Il n&#8217;y a pas de valeurs pour aurora pour les classes db.m5.* car ces classes ne sont pas disponibles sur aurora).<\/p>\n<h2>Tarification des instances<\/h2>\n<h3>CPU \/ MEM<\/h3>\n<p>Les tarif donn\u00e9s ici sont sur la Zone Paris pour une seule instance en dollar US (donn\u00e9es au 04\/12\/2020 et donn\u00e9s ici \u00e0 unique titre de comparaison).<\/p>\n<table border=\"0\" cellspacing=\"0\">\n<colgroup width=\"124\"><\/colgroup>\n<colgroup span=\"2\" width=\"91\"><\/colgroup>\n<colgroup span=\"4\" width=\"104\"><\/colgroup>\n<tbody>\n<tr>\n<td rowspan=\"2\" align=\"center\" valign=\"middle\" height=\"59\"><b><span style=\"font-size: medium;\">Instance class<\/span><\/b><\/td>\n<td rowspan=\"2\" align=\"center\" valign=\"middle\"><b><span style=\"font-size: medium;\">CPU<\/span><\/b><\/td>\n<td rowspan=\"2\" align=\"center\" valign=\"middle\"><b><span style=\"font-size: medium;\">MEM<\/span><\/b><\/td>\n<td colspan=\"2\" align=\"center\" valign=\"middle\"><b><span style=\"font-size: medium;\">RDS<\/span><\/b><\/td>\n<td colspan=\"2\" align=\"center\" valign=\"middle\"><b><span style=\"font-size: medium;\">Aurora<\/span><\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\"><b><span style=\"font-size: medium;\">Prix \/ heure\u00a0<\/span><\/b><\/td>\n<td align=\"left\"><b><span style=\"font-size: medium;\">Prix \/ mois\u00a0<\/span><\/b><\/td>\n<td align=\"left\"><b><span style=\"font-size: medium;\">Prix \/ heure\u00a0<\/span><\/b><\/td>\n<td align=\"left\"><b><span style=\"font-size: medium;\">Prix \/ mois\u00a0<\/span><\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#8E86AE\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.m5.8xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">32<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">128<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$3,30<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$2\u00a0373,12<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#8E86AE\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.m5.4xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">16<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">64<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$1,65<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$1\u00a0186,56<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#8E86AE\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.m5.2xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">8<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">32<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$0,82<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$593,28<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#8E86AE\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.m5.xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">4<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">16<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$0,41<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">$296,64<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#8E86AE\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.m5.large<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">2<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">8<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">0,206<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">148,32<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<td align=\"right\" bgcolor=\"#8E86AE\"><span style=\"color: #ffffff; font-size: medium;\">NON DISPO<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#F10D0C\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.r5.8xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">32<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">256<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$4,70<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$3\u00a0386,88<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$5,36<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$3\u00a0859,20<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#F10D0C\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.r5.4xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">16<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">128<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$2,35<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$1\u00a0693,44<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$2,68<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$1\u00a0929,60<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#F10D0C\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.r5.2xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">8<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">64<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$1,18<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$846,72<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$1,34<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$964,80<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#F10D0C\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.r5.xlarge<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">4<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">32<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$0,59<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$423,36<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$0,67<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$482,40<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#F10D0C\" height=\"20\"><span style=\"color: #ffffff; font-size: medium;\">db.r5.large<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">2<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">16<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$0,29<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$211,68<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$0,34<\/span><\/td>\n<td align=\"right\" bgcolor=\"#F10D0C\"><span style=\"color: #ffffff; font-size: medium;\">$241,20<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>La diff\u00e9rence de tarif entre les 2 Types de PaaS (RDS Classique et Aurora) n&#8217;est pas \u00e9norme (du moins en ce qui concerne le co\u00fbt de l&#8217;instance).<\/p>\n<h3>Stockage<\/h3>\n<p>Il y a donc de pr\u00e9sent\u00e9 3 classes de stockage diff\u00e9rentes :<\/p>\n<p><strong>GP2<\/strong>:<br \/>\nStockage \u00e0 usage g\u00e9n\u00e9ral (SSD) 0,133 USD par Go\/mois<br \/>\nCependant, les op\u00e9rations d&#8217;IO consomm\u00e9es ne vous sont pas factur\u00e9es.<\/p>\n<p><strong>IO Provisionn\u00e9es<\/strong> :<br \/>\nTarif de stockage 0,145 USD par Go\/mois<br \/>\nTarif d&#8217;IOPS provisionn\u00e9s 0,116 USD par IOPS\/mois<br \/>\nCependant, les op\u00e9rations d&#8217;IO consomm\u00e9es ne vous sont pas factur\u00e9es.<\/p>\n<p><strong>Aurora :<\/strong><br \/>\nTaux de stockage 0,11 USD par Go et par mois<br \/>\nTaux d&#8217;E\/S 0,22 USD par tranche d\u2019un million de demandes<br \/>\nLe stockage utilis\u00e9 par votre base de donn\u00e9es Amazon Aurora est factur\u00e9 par tranches de Go\/mois. <strong><span style=\"text-decoration: underline;\">Les IO consomm\u00e9es sont, quant \u00e0 elles, factur\u00e9es par tranches de millions de requ\u00eates<\/span><\/strong><\/p>\n<p>La grosse diff\u00e9rence entre Aurora et les autres types de stockage est donc le fait que les IO sont factur\u00e9es en plus du stockage, c&#8217;est donc un \u00e9l\u00e9ment \u00e0 prendre en charge lors du choix Aurora vs RDS Classique.<\/p>\n<p>Explications :<\/p>\n<p>Pour un stockage de 20Go et une moyenne de 1000 IO\/s en lecture et 1000 IO\/s en \u00e9criture (ce qui est assez faible).<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Aurora<\/strong> <\/span>:<\/p>\n<p style=\"padding-left: 40px;\">&#8211; Cout du stockage seul 20 Go x 0.11 USD = 2.20 USD<br \/>\n&#8211; 1000 Reads\/Second + 1000 Writes\/Second = 2000 Number of I\/Os per second<br \/>\n&#8211; 2000 IO\/s x 730 h x 60 min x 60 s = 5 256 000 000\u00a0 IO \/ mois<br \/>\n&#8211; 5 256 000000 x 0.00000022 USD = 1156,30 USD (co\u00fbt des IOs)<br \/>\n&#8211; 2,20 USD + 1156,30 USD = 1 158,30 USD<\/p>\n<p style=\"padding-left: 40px;\"><b>Co\u00fbt final mensuel : 1 158,30 USD<\/b><\/p>\n<p><strong><span style=\"text-decoration: underline;\">RDS Classique GP2<\/span><\/strong> :<\/p>\n<p style=\"padding-left: 40px;\">&#8211; Cout du stockage seul 20 Go x 0,133 USD = 2,66 USD<\/p>\n<p style=\"padding-left: 40px;\"><b>Co\u00fbt final mensuel : 2,66 USD<\/b><\/p>\n<p>Remarque : Les performances d&#8217;IO pour ce stockage sont de 3 IOPS pour chaque Go, avec un minimum de 100 IOPS.<br \/>\nPar exemple, les performances de base pour un volume de 100 Gio sont de 300 IOPS.<\/p>\n<p>Pour le cas pr\u00e9sent\u00e9 ci-dessus, le stockage allou\u00e9 (pour des raisons de performances) \u00e9t\u00e9 de 2048Go (ce qui repr\u00e9sente une grosse sur allocation mais n\u00e9cessaire pour atteindre un niveau d&#8217;IOPS raisonnable).<\/p>\n<p><strong><span style=\"text-decoration: underline;\">RDS Classique Provision IOPS <\/span><\/strong>\u00a0:<br \/>\nProvision de 10 000 IOPS<\/p>\n<p style=\"padding-left: 40px;\">&#8211; 20 Go\u00a0 x 0,145 USD = 2,90 USD (Stockage seul)<br \/>\n&#8211; 10 000 IOPS x 0,116 USD = 1 160,00 USD (Co\u00fbt des IO)<br \/>\n&#8211; 2,90 USD + 1 160,00 USD = 1 162,90 USD<br \/>\n<b><\/b><\/p>\n<p style=\"padding-left: 40px;\"><b>Co\u00fbt final mensuel : 1 162,90 USD\u00a0<\/b><\/p>\n<p><strong><span style=\"text-decoration: underline;\">RDS Classique Provision IOPS <\/span><\/strong>\u00a0:<br \/>\nProvision de 30 000 IOPS<\/p>\n<p style=\"padding-left: 40px;\">&#8211; 20 Go\u00a0 x 0,145 USD = 2,90 USD (Stockage seul)<br \/>\n&#8211; 30 000 IOPS x 0,116 USD = 3 480,00 USD (Co\u00fbt des IO)<br \/>\n&#8211; 2,90 USD + 3 480,00 USD = 1 162,90 USD<br \/>\n<b><\/b><\/p>\n<p style=\"padding-left: 40px;\"><b>Co\u00fbt final mensuel : 3 482,90 USD\u00a0<\/b><\/p>\n<h3><\/h3>\n<h3>Comparatif de co\u00fbts stockage<\/h3>\n<table border=\"0\" cellspacing=\"0\">\n<colgroup width=\"246\"><\/colgroup>\n<colgroup width=\"136\"><\/colgroup>\n<colgroup span=\"5\" width=\"86\"><\/colgroup>\n<tbody>\n<tr>\n<td align=\"left\" bgcolor=\"#999999\" height=\"56\"><\/td>\n<td align=\"left\" valign=\"middle\">IOPS max Disponibles<\/td>\n<td align=\"left\" valign=\"middle\">Stockage provisionn\u00e9 (en Go)<\/td>\n<td align=\"left\" valign=\"middle\">Prix stockage<\/td>\n<td align=\"left\" valign=\"middle\">Prix IO Provisionn\u00e9s<\/td>\n<td align=\"left\" valign=\"middle\">Prix des IO<\/td>\n<td align=\"left\" valign=\"middle\"><b>Total<\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#B4C7DC\" height=\"17\">RDS GP2 20 Go<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">100<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">20<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">2,66 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\"><b>2,66 $<\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#B4C7DC\" height=\"17\">RDS GP2 2 To<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">6144<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">2048<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\">272,38 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#B4C7DC\"><b>272,38 $<\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#FFE994\" height=\"17\">RDS IO Provisionn\u00e9s 10k IOPS<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">10000<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">20<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">2,90 $<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">1\u00a0160,00 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\"><b>1\u00a0162,90 $<\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#FFE994\" height=\"17\">RDS IO Provisionn\u00e9s 30k IOPS<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">30000<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">20<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">2,90 $<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\">3\u00a0480,00 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#FFE994\"><b>3\u00a0482,90 $<\/b><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" bgcolor=\"#D4EA6B\" height=\"17\">Aurora (base de 2000 IO\/s en moyenne<\/td>\n<td align=\"left\" bgcolor=\"#D4EA6B\">NON COMMUNIQUE<\/td>\n<td align=\"right\" bgcolor=\"#D4EA6B\">20<\/td>\n<td align=\"right\" bgcolor=\"#D4EA6B\">2,20 $<\/td>\n<td align=\"right\" bgcolor=\"#999999\">0,00 $<\/td>\n<td align=\"right\" bgcolor=\"#D4EA6B\">1\u00a0156,32 $<\/td>\n<td align=\"right\" bgcolor=\"#D4EA6B\"><b>1\u00a0158,52 $<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h1>Conclusion<\/h1>\n<p>Il est clair qu&#8217;Aurora est plus performant que RDS Classique et peut revenir moins cher que de l&#8217;IO provisionn\u00e9, cependant, il faut bien toujours garder \u00e0 l&#8217;esprit que sur Aurora chaque IO a un prix, de plus ce moteur, bien que pleinement compatible avec PostgreSQL (ou MySQL) reste un moteur propri\u00e9taire.<\/p>\n<p>Une assez bonne surprise est \u00e9galement ressortie de ce benchmark, les tr\u00e9s bonnes performances de RDS avec un stockage GP2 (attention, ici il n&#8217;y a aucune garantie sur les IO).<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369&#038;title=AWS%20RDS%2C%20Aurora%20et%20PostgreSQL\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=AWS%20RDS%2C%20Aurora%20et%20PostgreSQL&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8369\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Introduction Cet article fait partie d&#8217;une suite d&#8217;articles venant \u00e0 d\u00e9couvrir les services PaaS BDD PostgreSQL que fournissent les principaux acteurs acteurs du cloud. Le sc\u00e9nario de test sera toujours le m\u00eame, un bench de type TPC-C sera lanc\u00e9 \u00e0&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":8435,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[295,266],"tags":[370,303],"class_list":["post-8369","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws","category-postgresql","tag-aurora","tag-rds"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Introduction Cet article fait partie d&#8217;une suite d&#8217;articles venant \u00e0 d\u00e9couvrir les services PaaS BDD PostgreSQL que fournissent les principaux acteurs acteurs du cloud. Le sc\u00e9nario de test sera toujours le m\u00eame, un bench de type TPC-C sera lanc\u00e9 \u00e0&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-14T14:21:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-14T15:53:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/34841094-lisbonne-portugal-19-fevrier-2014-la-page-d-accueil-d-amazon-web-services-a-travers-une-loupe-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"AWS RDS, Aurora et PostgreSQL\",\"datePublished\":\"2020-12-14T14:21:39+00:00\",\"dateModified\":\"2020-12-14T15:53:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\"},\"wordCount\":1553,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"aurora\",\"RDS\"],\"articleSection\":[\"AWS\",\"PostgreSQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\",\"name\":\"AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2020-12-14T14:21:39+00:00\",\"dateModified\":\"2020-12-14T15:53:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS RDS, Aurora et PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/","og_locale":"fr_FR","og_type":"article","og_title":"AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG","og_description":"Introduction Cet article fait partie d&#8217;une suite d&#8217;articles venant \u00e0 d\u00e9couvrir les services PaaS BDD PostgreSQL que fournissent les principaux acteurs acteurs du cloud. Le sc\u00e9nario de test sera toujours le m\u00eame, un bench de type TPC-C sera lanc\u00e9 \u00e0&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2020-12-14T14:21:39+00:00","article_modified_time":"2020-12-14T15:53:52+00:00","og_image":[{"width":450,"height":300,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/12\/34841094-lisbonne-portugal-19-fevrier-2014-la-page-d-accueil-d-amazon-web-services-a-travers-une-loupe-.jpg","type":"image\/jpeg"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"AWS RDS, Aurora et PostgreSQL","datePublished":"2020-12-14T14:21:39+00:00","dateModified":"2020-12-14T15:53:52+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/"},"wordCount":1553,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["aurora","RDS"],"articleSection":["AWS","PostgreSQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/","url":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/","name":"AWS RDS, Aurora et PostgreSQL - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2020-12-14T14:21:39+00:00","dateModified":"2020-12-14T15:53:52+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/aws-rds-aurora-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"AWS RDS, Aurora et PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=8369"}],"version-history":[{"count":28,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8369\/revisions"}],"predecessor-version":[{"id":8434,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8369\/revisions\/8434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/8435"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=8369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=8369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=8369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}