Implementasi High Availability pada Database

Database adalah suatu kumpulan data yang disimpan secara sistematis di dalam komputer dan dapat dimanipulasi menggunakan aplikasi, Teknologi tersebut memungkinkan kita untuk mengolah data tanpa harus menggunakan waktu yang lama Universitas Terbuka sebagai institusi yang bergerak dibidang pendidikan telah menginvestasikan banyak tenaga, waktu, dan biaya dalam melakukan pengembangan dan pemeliharaan database. Tingginya kebutuhan dalam penggunaan database membuat tuntutan akan kebutuhan penyediakan basis data (database) yang dapat diakses terus secara aktif bekerja selama 24 jam x 7 hari. Tujuan dari penelitian ini untuk menghasilkan solusi database High Availability, flexibility, dan scalability sehingga dapat meminimalkan dampak gangguan pada database.Metode yang digunakan dalam penulisan ini adalah metode research and development model dengan pengujian yang meliputi installation tes, basic sanity test, cluster fault test, load test, scalability test dan stability test. Hasil yang dicapai pada penelitian ini adalah implementasi database high availability dengan flexibility, scalability dan kekurangannya. Dari implementasi yang dilakukan dapat disimpulkan Penerapan aplikasi Percona XtraDB Cluster sebagai solusi High Avalability database dapat meningkatkan ketersediaan database hingga 99% tanpa down time

Database Optimizing Services

Almost every organization has at its centre a database. The database provides support for conducting different activities, whether it is production, sales and marketing or internal operations. Every day, a database is accessed for help in strategic decisions. The satisfaction therefore of such needs is entailed with a high quality security and availability. Those needs can be realised using a DBMS (Database Management System) which is, in fact, software for a database. Technically speaking, it is software which uses a standard method of cataloguing, recovery, and running different data queries. DBMS manages the input data, organizes it, and provides ways of modifying or extracting the data by its users or other programs. Managing the database is an operation that requires periodical updates, optimizing and monitoring.database, database management system (DBMS), indexing, optimizing, cost for optimized databases

High Availability Web and Database Service Model with Redundacy Servers

Web server provide many informations which can be accessed by everyone in the world with a simple click. Web required a physical or logical Server to serve the users. Because of this requirement, web server must online everyday nonstop. A service disruption may occur when the server is down caused by natural disaster, blackout, or any physical or digital damage to the hardware. In order to solve this problem, an optimal model for failover redundant web server is required. A set of redundancy server which capable to do complete replication of both web files and databases which connected altogether with the main web server. The main web server has a role to do complete synchronization with secondary server, then the secondary servers will take over the service whenever the main server down. When failover event occurred, KeepAlived will manage the routing table in order to continue the web serviceSebuah peladen diperlukan oleh web agar dapat menyediakan informasi bagi semua orang di dunia hanya dengan sekali klik. Web membutuhkan sebuah Peladen berbentuk fisik maupun logis untuk melayani penggunanya. Dikarenakan oleh persyaratan inilah peladen web diharuskan untuk daring setiap hari tanpa henti. Gangguan pelayanan akan terjadi apabila peladen mengalami gangguan yang disebabkab oleh mati listrik, bencana alam, atau kerusakan fisik maupun digital lainnya. Untuk menyelesaikan masalah ini, sebuah model optimal untuk peladen web cadangan sangat diperlukan ketika terjadi gangguan. Kumpulan peladen ini terhubung di satu jaringan yang sama sehingga dapat melakukan replikasi data yang komplet dari peladen utama. Peladen utama ini memiliki tugas untuk melakukan replikasi, dan peladen kedua mengambil alih pelayanan ketika peladen utama mati. Ketika kejadian failover ini terjadi, KeepAlived akan mengatur tabel routing untuk melanjutkan pelayanan web dengan cara mengarahkan lalu lintas data ke peladen kedua yang ada

Database System Architecture for Fault tolerance and Disaster Recovery

Application systems being used today rely heavily on the availability of the database system. Disruption of database system can be damaging and catastrophic to the organization that depends on the availability of the database system for its business and service operations. To ensure business continuity under foreseeable and unforeseeable man-made or natural disasters, the database system has to be designed and built with fault tolerance and disaster recovery capabilities. This project explored existing technologies and solutions to design, build, and implement database system architecture for fault tolerance and disaster recovery using Oracle database software products. The project goal was to implement database system architecture for migrating multiple web applications and databases onto a consolidated system architecture providing high availability database application systems

Analisis High Availability Pada Sistem Berbasis Teknologi Oracle Data Guard (Studi Kasus SIA-SAT UKSW)

. High Availability on Oracle Data Guard-based System (Case Study: SIA-SAT UKSW). SIA-SAT is a subject administration system for UKSW collegian. Database SIA-SAT is backuped by autobackup system, and backup file sent directly to backup server at another building. Until these days, database SIA-SAT system still does not have a secondary database (backup) which can replace main database when failure is happening on main database.Oracle Data Guard System is a technology researched by Oracle to increase availability level on Oracle Database server. Every transaction is saved on main server and duplicated for standby database server. The advantages point of technology is standby database which indirectly becomes a backup server, and standby database can be used for replacing main database.The result of this research is the technology of Oracle Data Guard can increase availability level for a system Oracle Database. This condition can happen because standby database always duplicates data and is ready to replace primary database

Database High Availability using SHADOW Systems

Various High Availability DataBase systems (HADB) are used to provide high availability. Pairing an active database system with a standby system is one commonly used HADB techniques. The active system serves read/write workloads. One or more standby systems replicate the active and serve read-only workloads. Though widely used, this technique has some significant drawbacks: The active system becomes the bottleneck under heavy write workloads. Replicating changes synchronously from the active to the standbys further reduces the performance of the active system. Asynchronous replication, however, risk the loss of updates during failover. The shared-nothing architecture of active-standby systems is unnecessarily complex and cost inefficient. In this thesis we present SHADOW systems, a new technique for database high availability. In a SHADOW system, the responsibility for database replication is pushed from the database systems into a shared, reliable, storage system. The active and standby systems share access to a single logical copy of the database, which resides in shared storage. SHADOW introduces write offloading, which frees the active system from the need to update the persistent database, placing that responsibility on the underutilized standby system instead. By exploiting shared storage, SHADOW systems avoid the overhead of database-managed synchronized replication, while ensuring that no updates will be lost during a failover. We have implemented a SHADOW system using PostgreSQL, and we present the results of a performance evaluation that shows that the SHADOW system can outperform both traditional synchronous replication and standalone PostgreSQL systems

Middleware-based Database Replication: The Gaps between Theory and Practice

The need for high availability and performance in data management systems has been fueling a long running interest in database replication from both academia and industry. However, academic groups often attack replication problems in isolation, overlooking the need for completeness in their solutions, while commercial teams take a holistic approach that often misses opportunities for fundamental innovation. This has created over time a gap between academic research and industrial practice. This paper aims to characterize the gap along three axes: performance, availability, and administration. We build on our own experience developing and deploying replication systems in commercial and academic settings, as well as on a large body of prior related work. We sift through representative examples from the last decade of open-source, academic, and commercial database replication systems and combine this material with case studies from real systems deployed at Fortune 500 customers. We propose two agendas, one for academic research and one for industrial R&D, which we believe can bridge the gap within 5-10 years. This way, we hope to both motivate and help researchers in making the theory and practice of middleware-based database replication more relevant to each other.Comment: 14 pages. Appears in Proc. ACM SIGMOD International Conference on Management of Data, Vancouver, Canada, June 200

Disaster Recovery using Oracle Data Guard

The needs of the IT system is now become much higher, especially in terms of reliability and availability to support corporate's business continuity. It is important for companies to implement the concept of High Availability (HA) in order to protect the data which is the most important asset of the company. The purpose of this final project is to build disaster-recovery system that is easy to use, inexpensive, comprehensive, effective, efficient, reliable, and ensure the availability of data. The results of this project is a Data Guard system that can be implemented in enterprises, educational institutions, or other institution that use Oracle Database, to protect enterprise�s data from damage, disaster, failure, error, and routine maintenance that causes downtime. The system is expected to guarantee the availability of data for 24 hours per day, 7 days per week. In this system there are two kinds of database, the main database (primary database) and one or more database backup (standby database) which will be used if downtime occurred in the primary database

COMPARATION OF DISTRIBUTED DATABASE MODEL BY CLUSTERING METHOD IN E-GOVERNMENT SYSTEM. STUDY AT KEMENKEU RI

MySQL is one of the most popular open source database in the world based on its performance, its reliability, and its easiness that has been proved. MySQL is categorized into community version and commercial version. The commercial version has standalone architecture models and clusters.Database Clustering is one of distributed database model. The case study used is Kemenkeu Learning Center (KLC) Application which is an e-government application in Ministry of Finance. KLC application used for interactive learning media for all ASN especially ASN in Ministry of Finance. This makes the KLC application being categorized into a very high critical application, so it takes a good response time and has high availability. One of the most important factors to fulfill this need is by deciding the appropriate MySQL database architecture for KLC application. This research was conducted by creating 3 (three) database architecture models according to best practice from MySQL, namely the Standalone architecture model, InnoDB Cluster and NDB Cluster. Then tested with several different scenarios to get results in the form of response time and percentage of errors that indicate high availability capabilities. The tools used in testing are Apache JMeter. From the test results, it is found that the MySQL NDB Cluster is the right database architecture model in an effort to realize the need for database services with the best response time and high availability capabilities