{"id":20192,"date":"2022-04-12T11:36:00","date_gmt":"2022-04-12T08:36:00","guid":{"rendered":"http:\/\/dev.profelis.net\/?p=20192"},"modified":"2023-02-01T10:57:58","modified_gmt":"2023-02-01T07:57:58","slug":"postgresql-entegrasyonu-bolum-8-altyapi-entegrasyonu","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2022\/04\/12\/postgresql-entegrasyonu-bolum-8-altyapi-entegrasyonu\/","title":{"rendered":"PostgreSQL Entegrasyonu B\u00f6l\u00fcm 8: Altyap\u0131 Entegrasyonu"},"content":{"rendered":"<p>PostgreSQL Entegrasyonu blog serisinin s\u0131radaki b\u00f6l\u00fcm\u00fcnde kurumlar\u0131n daha fazla ve h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131na yard\u0131mc\u0131 olabilecek PostgreSQL entegrasyonunu ke\u015ffetmeye devam ediyoruz.<\/p>\n<p>Bu blog yaz\u0131s\u0131 son alan olan altyap\u0131 entegrasyonuna odaklanacak.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-22176\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/03\/Integration-Map-Infographic-Final_Infrastructure-Integration.png\" alt=\"\" width=\"1024\" height=\"492\" title=\"\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/03\/Integration-Map-Infographic-Final_Infrastructure-Integration.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/03\/Integration-Map-Infographic-Final_Infrastructure-Integration-300x144.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/03\/Integration-Map-Infographic-Final_Infrastructure-Integration-768x369.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong><span style=\"color: #000000; font-size: 29px;\">Altyap\u0131 Entegrasyonu<\/span><\/strong><\/p>\n<p>[<span style=\"font-weight: 400;\">PostgreSQL \u00e7ok \u00e7e\u015fitli i\u015fletim sistemleri ve donan\u0131m mimarileri \u00fczerinde \u00e7al\u0131\u015fabilmektedir. Fakat, Linux\/X86 platformu a\u00e7\u0131k ara en pop\u00fcler olan\u0131d\u0131r. Kurumlardaki \u00fcretim PostgreSQL veritabanlar\u0131n\u0131n %90\u2019\u0131ndan fazlas\u0131n\u0131n Linux \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 tahmin ediyoruz. RedHat Enterprise Linux en b\u00fcy\u00fck paya sahiptir ve Debian ve Ubuntu onu takip etmektedir. Windows tabanl\u0131 \u00fcretim da\u011f\u0131t\u0131mlar\u0131n\u0131n y\u00fczdesi son 10 y\u0131lda h\u0131zla azalmaktad\u0131r.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00d6zellikle Kubernetes\u2019in konteyner orkestrasyonunun birinci se\u00e7im olmas\u0131yla birlikte, konteyner tabanl\u0131 da\u011f\u0131t\u0131mlar giderek daha fazla dikkat \u00e7ekmektedir.&nbsp;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Depolama taraf\u0131nda, PostgreSQL disk eri\u015fimi i\u00e7in i\u015fletim sistemini kullan\u0131r; do\u011frudan I\/O kullanmaz. Bu demektir ki PostgreSQL; h\u0131zl\u0131, \u00f6ng\u00f6r\u00fclebilir ve g\u00fcvenilir depolama eri\u015fiminden b\u00fcy\u00fck \u00f6l\u00e7\u00fcde fayda sa\u011flamaktad\u0131r. Direct Attached Storage (DAS) ve Fibre-Channel-based Storage Area Networks (SAN) fiziksel ortamda veri dizini ve yazma \u00f6ncesi kay\u0131t i\u00e7in tercih edilen ara\u00e7lard\u0131r. Yedeklemeler NFS mountlar\u0131nda saklanabilir. Bulutta ise, y\u00fcksek I\/O de\u011ferine sahip SSD\u2019ler \u00f6nerilmektedir. Depolama se\u00e7enekleri ve RAID konfig\u00fcrasyonlar\u0131 ile ilgili detayl\u0131 tart\u0131\u015fma i\u00e7in buraya <a href=\"https:\/\/www.enterprisedb.com\/blog\/postgres-storage-system-raid-levels-compare-performance-costs-das-nas-iscsi-nfs\" target=\"_blank\" rel=\"noopener\">t\u0131klay\u0131n<\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL \u00f6nbelle\u011fe alma ve disk eri\u015fimi konusunda i\u015fletim sisteminden faydalan\u0131r. Bu da demektir ki PostgreSQL ayarlama stratejisi kilit i\u015fletim sistemi ayarlar\u0131 i\u00e7ermelidir. Linux \u00fczerinde ayarlama se\u00e7eneklerinin kapsaml\u0131 anlat\u0131m\u0131 i\u00e7in buraya <a href=\"https:\/\/info.enterprisedb.com\/whitepaper_PostgreSQL-and-EPAS-Guide-Linux.html\" target=\"_blank\" rel=\"noopener\">t\u0131klay\u0131n<\/a>, Windows i\u00e7in buraya <a href=\"https:\/\/info.enterprisedb.com\/Whitepaper_PostgreSQL-EPAS-Guide-Windows-users.htmlhttps:\/\/info.enterprisedb.com\/Whitepaper_PostgreSQL-EPAS-Guide-Windows-users.html\" target=\"_blank\" rel=\"noopener\">t\u0131klay\u0131n<\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL, kullan\u0131c\u0131lar\u0131n teknoloji y\u0131\u011f\u0131nlar\u0131ndan en fazla fayday\u0131 sa\u011flamas\u0131n\u0131, pazara daha h\u0131zl\u0131 \u00e7\u0131kmas\u0131n\u0131 ve kurum ortam\u0131nda daha kolay entegre olmalar\u0131n\u0131 sa\u011flayan en iyi veritaban\u0131 platformu olarak \u00f6ne \u00e7\u0131kmaktad\u0131r.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu seriyi takip etti\u011finiz i\u00e7in te\u015fekk\u00fcr ederiz. <\/span><\/p>\n<p>PostgreSQL entegrasyonuna ili\u015fkin b\u00fcy\u00fck resmi g\u00f6steren <a href=\"https:\/\/info.enterprisedb.com\/rs\/069-ALB-339\/images\/PostgreSQL-Integration-Map-Infographic.pdf?_ga=2.235702145.1480050179.1630920683-144310236.1630423604\" target=\"_blank\" rel=\"noopener\">infografi\u011fi<\/a> inceleyebilirsiniz.<\/p>\n<p>Kaynak: <a href=\"https:\/\/www.enterprisedb.com\/blog\/integrating-postgresql-part-8-infrastructure-integration\" target=\"_blank\" rel=\"noopener noreferrer\">Integrati<\/a><a href=\"https:\/\/www.enterprisedb.com\/blog\/integrating-postgresql-part-8-infrastructure-integration\" target=\"_blank\" rel=\"noopener noreferrer\">ng PostgreSQL Part 8: Infrast<\/a><a href=\"https:\/\/www.enterprisedb.com\/blog\/integrating-postgresql-part-8-infrastructure-integration\" target=\"_blank\" rel=\"noopener noreferrer\">ructure Integration<\/a>, EDB Ekibi Kas\u0131m 16, 2021<br \/>\n\u00a9 Copyright EnterpriseDB Corporation 2020 EnterpriseDB Corporation<br \/>\n34 Crosby Drive Suite 201 Bedford, MA 01730<br \/>\nEnterpriseDB and Postgres Enterprise Manager are registered trademarks of EnterpriseDB Corporation. EDB and EDB Postgres are trademarks of EnterpriseDB Corporation. Oracle is a registered trademark of Oracle, Inc. Other trademarks may be trademarks of their respective owners.<\/p>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL Entegrasyonu blog serisinin s\u0131radaki b\u00f6l\u00fcm\u00fcnde kurumlar\u0131n daha fazla ve h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131na yard\u0131mc\u0131 olabilecek PostgreSQL entegrasyonunu ke\u015ffetmeye devam ediyoruz. Bu blog yaz\u0131s\u0131 son alan olan altyap\u0131 entegrasyonuna odaklanacak. Altyap\u0131 Entegrasyonu [PostgreSQL \u00e7ok \u00e7e\u015fitli i\u015fletim sistemleri ve donan\u0131m mimarileri \u00fczerinde \u00e7al\u0131\u015fabilmektedir&#8230;.<\/p>","protected":false},"author":16,"featured_media":22104,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76,75,45],"tags":[58,48,50],"class_list":["post-20192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-postgresql","category-yazi","tag-acikkaynak","tag-enterprisedb","tag-veritabani"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/20192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=20192"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/20192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/22104"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=20192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=20192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=20192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}