Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony 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
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).
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) ) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).