Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony PostgreSQL

  • Defriyanuar Dhining Politeknik Negeri Batam
  • Yeni Rokhayati Politeknik Negeri Batam
  • Dwi Ely Kurniawan Politeknik Negeri Batam
Keywords: Database replication, Internet Connection, PostgreSQL.

Abstract

Nowadays, almost every company use web aplication to do their business activity. Besides multi-platform it also easier for installation and maintenance. Other that web application need a fast and reliable internet connection. It is necessity to make a server in local area network with syncronize database from one server to another server. Syncronize database will run using replication server database. Database replication can use many tool, one of them is Slony that is specially create for PostgreSQL. Replication database can also to pretend stopping application when there is bad internet connection. Replication database is one of stanby server tecknic because down server. Database synchronize will be buid using PHP programming language and PostgreSQL database with Slony which is open source at all, so it will reduce the cost of installation and maintenance.

Downloads

Download data is not yet available.

References

H. Maulana, Analisis dan Perancangan Sistem Replikasi Database MySQL dengan menggunakan VMWare pada Sistem Operasi Opensource, Jurnal Nasional Informatika dan Teknologi Jaringan (InfoTekjar) Vol.1, No.1, September 2016.

A.S. Ajinusa, A.B.M. Wijaya, A. Aziz, "Pembangunan Sistem Informasi Presensi Perkuliahan Menggunakan Basisdata Terdistribusi dengan Metode Replikasi-Asynchronous," Jurnal ITSMART Vol.4 No.2 Desember 2015

E. Purnomo, A. Ashari, "Implementasi Replikasi Data Asynchronous untuk Keamanan Data Sistem Informasi Akademik Online", Berkala MIPA 24(2), Mei 2014

F. Zaini, L. Atika, U. Ependi, "Implementasi Metode Asynchronous pada Replikasi Database Invenaris Universitas Bina Darma", Jurnal Informatika Universitas Bina Darma Palembang, Oktober 2015

Nugi, 2014, Instalasi dan Konfigurasi Mysql Master to Master, https://www.excellent.co.id/excellent/blog/instalasi-dan-konfigurasi-replikasi-mysql-master-to-master/

A.P. Basuki, 2010, Membangun Web Berbasis PHP dengan Framework Codeigniter, Lokomedia, Yogyakarta.

K.R. Gufron, 2013, Mengenal Aplikasi Virtualisasi Oracle VM Virtual Box, http://dosen.gufron.com/artikel/mengenal-aplikasi-virtualisasi-oracle-vm-virtualbo/10/

Nugroho, 2004, Database Relasional dengan MySQL, Andi, Yogjakarta.

PostgreSQL, 2015, What is PostgreSQL?, http://www.postgresql.org/docs/9.5/static/intro-whatis.html

Slony Development Group, 2010, Sloni-I Introduction, http://slony.info/

Kurniawan, D. E., & Fajrianto, R. (2017, August). Sistem Pemantau Koneksi Internet Menggunakan Sistem Informasi Geografis dan Sms Gateway. In SISITI: Seminar Ilmiah Sistem Informasi dan Teknologi Informasi (Vol. 5, No. 1).

Published
2017-12-30
How to Cite
[1]
D. Dhining, Y. Rokhayati, and D. Kurniawan, “Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony PostgreSQL”, JAIC, vol. 1, no. 2, pp. 9-18, Dec. 2017.
Section
Articles