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

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;
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.

AMA Style

Pohanka T, Pechanec V. Evaluation of Replication Mechanisms on Selected Database Systems. ISPRS International Journal of Geo-Information. 2020; 9(4):249.

Chicago/Turabian Style

Pohanka, Tomáš, and Vilém Pechanec. 2020. "Evaluation of Replication Mechanisms on Selected Database Systems" ISPRS International Journal of Geo-Information 9, no. 4: 249.

Find Other Styles
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

Back to TopTop