Catatan ini akan dibuat secara bertahap dengan tujuan akhir ‘server SPSE yang bisa berjalan dengan sistem master-slave secara streaming’, sehingga bila server-master mengalami kegagalan perangkat dan tidak dapat difungsikan, dengan sedikit mengubah konfigurasi pada server-slave akan langsung menjalankan tugas menggantikan server-master.<\/p>\n
Fitur streaming replication (dalam hal ini kita akan menggunakan hot_standby) hanya ada pada PostgreSQL 8.5 Alpha3 keatas, seperti dilansir oleh https:\/\/wiki.postgresql.org\/wiki\/Hot_Standby :
\n“Hot Standby is the name for the capability to run queries on a database that is currently performing archive recovery. Log Shipping replication allows you to create one or more standby nodes that are replicas of the primary node (or master node). Standby nodes can then be used for read-only query access.
\nHot Standby was developed for inclusion in PostgreSQL 9.0 by Simon Riggs of 2ndQuadrant via public sponsorship.
\nThe feature was committed in PostgreSQL 8.5 Alpha3 and is available in PostgreSQL 9.0 and above. See the Hot Standby docs for full details.
\nThis feature augments streaming replication feature that was introduced in PostgreSQL 9.1, though it does not rely on it and has minimal interaction with it.”<\/p>\n
Server SPSE menggunakan Centos 6 dan Postgresql 8.4, maka dilakukan upgrade database ke PostgreSQL 9.5, versi terbaru (stable) saat catatan ini ditulis. Postgresql 9.5 bisa di install berdampingan dengan Postgresql 8.4 tanpa saling mengganggu, proses instalasi ini dijalankan tanpa terlebih dahulu me-remove Postgresql 8.4 yang sedang berjalan. <\/p>\n
1. yum update
\n2. yum upgrade
\n3. netstat -tulpn | grep postmaster
\n (127.0.0.1:5432 – ini adalah postgresql yang sedang berjalan\/digunakan)
\n4. rpm -ivh https:\/\/download.postgresql.org\/pub\/repos\/yum\/9.5\/redhat\/rhel-6-x86_64\/pgdg-centos95-9.5-2.noarch.rpm
\n5. yum install postgresql95 postgresql95-server postgresql95-devel postgresql95-contrib
\n6. service postgresql-9.5 initdb
\n7. lakukan proses backup database dari Postgresql 8.4 :
\n su – postgres
\n psql -l (misal databasenya = epns-prod)
\n pg_dump -U postgres epns-prod -f epns-prod.sql (akan terbentuk file \/var\/lib\/pgsql\/epns-prod.sql)
\n8. nano \/var\/lib\/pgsql\/9.5\/data\/pg_hba.conf
\n local all all trust
\n host all all 127.0.0.1\/32 trust
\n host all all ::1\/128 trust
\n9. service postgresql stop
\n service postgresql-9.5 start
\n10. chkconfig postgresql off
\n chkconfig postgresql-9.5 on
\n11. su – postgres
\n psql
\n CREATE USER epns password ‘epns’;
\n \\q
\n createdb -U postgres -O epns epns-prod;
\n psql -U postgres -d epns-prod -f epns-prod.sql
\n exit
\n12. service postgresql-9.5 restart<\/p>\n
Sampai sini proses upgrade dan pemindahan database ke Postgresql 9.5 sudah selesai, silakan melakukan check dan re-check kembali terhadap server SPSE anda, apakah sudah bisa berjalan dengan normal? Bila tidak ada masalah , lanjutkan dengan uninstall Postgresql 8.4 :<\/p>\n
13. yum remove postgresql postgresql-server<\/p>\n
Siap untuk melanjutkan ke SPSE Master-Slave Streaming Replication #2?…tunggu tanggal main nya!<\/p>\n","protected":false},"excerpt":{"rendered":"
Catatan ini akan dibuat secara bertahap dengan tujuan akhir ‘server SPSE yang bisa berjalan dengan sistem master-slave secara streaming’, sehingga bila server-master mengalami kegagalan perangkat dan tidak dapat difungsikan, dengan sedikit mengubah konfigurasi pada server-slave akan langsung menjalankan tugas menggantikan server-master. Fitur streaming replication (dalam hal ini kita akan menggunakan hot_standby) hanya ada pada PostgreSQL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-linux-server"],"_links":{"self":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94"}],"version-history":[{"count":22,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":116,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions\/116"}],"wp:attachment":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}