{"title":"系统复制的基础数据数据库数据库MySQL的menggunakan容器Docker","authors":"Ilmiyatus Sholihah, Cahyo Darujati","doi":"10.24843/mite.2022.v21i02.p08","DOIUrl":null,"url":null,"abstract":"This study aims to implement database replication using the master-slave technique. The main focus of this research is to run data replication on the master server so that it can be copied automatically on the slave server. Master-slave replication techniques aim to prevent data loss from system failure events or device damage on the main server. The concept of master-slave replication is to copy data from the master server database to the slave server so that users do not need to manually backup data from the database. Master-slave database replication is one of the features provided by the MySQL database application in the Docker container. Still, to run the replication system, some adjustments and configurations are required for the database application to establish a replication infrastructure automatically. In this study, the replication was run on a MySQL database application with 20 multimedia data files capacity of 100MB. Testing is done by entering data into the database on the master server. The test scenario in this study was to upload data and delete data. The test results show that the data changes automatically: the data on the slave server is the same as on the master server, even though the data on the master server has gone through data uploads and deletions. And vice versa, data changes made on the master server are also directly replicated on the slave server.","PeriodicalId":53323,"journal":{"name":"Majalah Ilmiah Teknologi Elektro","volume":"1 1","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2022-12-13","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Sistem Replikasi Basis Data berdasarkan MySQL menggunakan Container Docker\",\"authors\":\"Ilmiyatus Sholihah, Cahyo Darujati\",\"doi\":\"10.24843/mite.2022.v21i02.p08\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This study aims to implement database replication using the master-slave technique. The main focus of this research is to run data replication on the master server so that it can be copied automatically on the slave server. Master-slave replication techniques aim to prevent data loss from system failure events or device damage on the main server. The concept of master-slave replication is to copy data from the master server database to the slave server so that users do not need to manually backup data from the database. Master-slave database replication is one of the features provided by the MySQL database application in the Docker container. Still, to run the replication system, some adjustments and configurations are required for the database application to establish a replication infrastructure automatically. In this study, the replication was run on a MySQL database application with 20 multimedia data files capacity of 100MB. Testing is done by entering data into the database on the master server. The test scenario in this study was to upload data and delete data. The test results show that the data changes automatically: the data on the slave server is the same as on the master server, even though the data on the master server has gone through data uploads and deletions. And vice versa, data changes made on the master server are also directly replicated on the slave server.\",\"PeriodicalId\":53323,\"journal\":{\"name\":\"Majalah Ilmiah Teknologi Elektro\",\"volume\":\"1 1\",\"pages\":\"\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-12-13\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Majalah Ilmiah Teknologi Elektro\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.24843/mite.2022.v21i02.p08\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Majalah Ilmiah Teknologi Elektro","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.24843/mite.2022.v21i02.p08","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Sistem Replikasi Basis Data berdasarkan MySQL menggunakan Container Docker
This study aims to implement database replication using the master-slave technique. The main focus of this research is to run data replication on the master server so that it can be copied automatically on the slave server. Master-slave replication techniques aim to prevent data loss from system failure events or device damage on the main server. The concept of master-slave replication is to copy data from the master server database to the slave server so that users do not need to manually backup data from the database. Master-slave database replication is one of the features provided by the MySQL database application in the Docker container. Still, to run the replication system, some adjustments and configurations are required for the database application to establish a replication infrastructure automatically. In this study, the replication was run on a MySQL database application with 20 multimedia data files capacity of 100MB. Testing is done by entering data into the database on the master server. The test scenario in this study was to upload data and delete data. The test results show that the data changes automatically: the data on the slave server is the same as on the master server, even though the data on the master server has gone through data uploads and deletions. And vice versa, data changes made on the master server are also directly replicated on the slave server.