Next Article in Journal
A Method for Generating Variable-Scale Maps for Small Displays
Next Article in Special Issue
Augmenting Geostatistics with Matrix Factorization: A Case Study for House Price Estimation
Previous Article in Journal
Exploring Resilient Observability in Traffic-Monitoring Sensor Networks: A Study of Spatial–Temporal Vehicle Patterns
Previous Article in Special Issue
Methods and Application of Archeological Cloud Platform for Grand Sites Based on Spatio-Temporal Big Data
Open AccessEditor’s ChoiceArticle

Evaluation of Replication Mechanisms on Selected Database Systems

Department of Geoinformatics, Faculty of Science, Palacky University, 17. listopadu 50, 77146 Olomouc, Czech Republic
*
Author to whom correspondence should be addressed.
ISPRS Int. J. Geo-Inf. 2020, 9(4), 249; https://doi.org/10.3390/ijgi9040249
Received: 16 March 2020 / Revised: 12 April 2020 / Accepted: 16 April 2020 / Published: 17 April 2020
(This article belongs to the Special Issue Spatial Databases: Design, Management, and Knowledge Discovery)
This paper is focused on comparing database replication over spatial data in PostgreSQL and MySQL. Database replication means solving various problems with overloading a single database server with writing and reading queries. There are many replication mechanisms that are able to handle data differently. Criteria for objective comparisons were set for testing and determining the bottleneck of the replication process. The tests were done over the real national vector spatial datasets, namely, ArcCR500, Data200, Natural Earth and Estimated Pedologic-Ecological Unit. HWMonitor Pro was used to monitor the PostgreSQL database, network and system load. Monyog was used to monitor the MySQL activity (data and SQL queries) in real-time. Both database servers were run on computers with the Microsoft Windows operating system. The results from the provided tests of both replication mechanisms led to a better understanding of these mechanisms and allowed informed decisions for future deployment. Graphs and tables include the statistical data and describe the replication mechanisms in specific situations. PostgreSQL with the Slony extension with asynchronous replication synchronized a batch of changes with a high transfer speed and high server load. MySQL with synchronous replication synchronized every change record with low impact on server performance and network bandwidth. View Full-Text
Keywords: database; replication; spatial data; MySQL; PostgreSQL database; replication; spatial data; MySQL; PostgreSQL
Show Figures

Figure 1

MDPI and ACS Style

Pohanka, T.; Pechanec, V. Evaluation of Replication Mechanisms on Selected Database Systems. ISPRS Int. J. Geo-Inf. 2020, 9, 249.

Show more citation formats Show less citations formats
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Access Map by Country/Region

1
Search more from Scilit
 
Search
Back to TopTop