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

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.

References

[1]. 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.
[2]. 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
[3]. E. Purnomo, A. Ashari, "Implementasi Replikasi Data Asynchronous untuk Keamanan Data Sistem Informasi Akademik Online", Berkala MIPA 24(2), Mei 2014
[4]. F. Zaini, L. Atika, U. Ependi, "Implementasi Metode Asynchronous pada Replikasi Database Invenaris Universitas Bina Darma", Jurnal Informatika Universitas Bina Darma Palembang, Oktober 2015
[5]. Nugi, 2014, Instalasi dan Konfigurasi Mysql Master to Master, https://www.excellent.co.id/excellent/blog/instalasi-dan-konfigurasi-replikasi-mysql-master-to-master/
[6]. A.P. Basuki, 2010, Membangun Web Berbasis PHP dengan Framework Codeigniter, Lokomedia, Yogyakarta.
[7]. K.R. Gufron, 2013, Mengenal Aplikasi Virtualisasi Oracle VM Virtual Box, http://dosen.gufron.com/artikel/mengenal-aplikasi-virtualisasi-oracle-vm-virtualbo/10/
[8]. Nugroho, 2004, Database Relasional dengan MySQL, Andi, Yogjakarta.
[9]. PostgreSQL, 2015, What is PostgreSQL?, http://www.postgresql.org/docs/9.5/static/intro-whatis.html
[10]. Slony Development Group, 2010, Sloni-I Introduction, http://slony.info/
[11]. 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-17
How to Cite
DHINING, Defriyanuar; ROKHAYATI, Yeni; KURNIAWAN, Dwi Ely. Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony PostgreSQL. JOURNAL OF APPLIED INFORMATICS AND COMPUTING, [S.l.], v. 1, n. 1, p. 9-18, dec. 2017. ISSN 2548-6861. Available at: <https://jurnal.polibatam.ac.id/index.php/JAIC/article/view/472>. Date accessed: 22 may 2018.
Section
Articles