diplomsko delo univerzitetnega študija Organizacija in management informacijskih sistemov
Tim Trojar Vidmar (Author), Robert Leskovar (Mentor)

Abstract

V nalogi je obravnavana replikacija baze podatkov v sistemu za upravljanje z bazo podatkov MySQL. V teoretičnem delu so predstavljene vrste replikacij, principi delovanja, prednosti in pomanjkljivosti replikacij ter tipični problemi, ki jih rešuje replikacija. Eksperimentalni del naloge obsega opis konfiguracije več vrst replikacije. Replikacije smo izvedli z različnimi vmesniki (mysql, phpmyadmin in skripti v Pythonu). Preskusili smo tri vrste replikacije: glavni strežnik in en pomožni strežnik (master/slave replikacija), dva glavna strežnika (master/master replikacija) ter en glavni in trije pomožni strežniki, pri čemer v primeru izpada glavnega strežnika njegovo vlogo prevzame eden od pomožnih. Opisan je tudi mehanizem samodejnega spreminjanja vlog strežnikov (failover). Vsi preskusi so bili izvedeni v laboratorijskem okolju.

Keywords

replikacija;MySQL;podatkovna baza;

Data

Language: Slovenian
Year of publishing:
Typology: 2.11 - Undergraduate Thesis
Organization: UM FOV - Faculty of Organizational Sciences
Publisher: [T. Trojar Vidmar]
UDC: 004.42
COBISS: 7963411 Link will open in a new window
Views: 893
Downloads: 116
Average score: 0 (0 votes)
Metadata: JSON JSON-RDF JSON-LD TURTLE N-TRIPLES XML RDFA MICRODATA DC-XML DC-RDF RDF

Other data

Secondary language: English
Secondary title: Database replication in MySQL
Secondary abstract: The thesis deals with replication of a database in the MySQL database management system. Theoretical part presents the types of replication, principles of operation, advantages and disadvantages of replication and typical problems solved by replication. The experimental part of the thesis describes how different types of replication can be configured. We created replication in two ways: object mode and phyton scripts. Three different types of replication are described: master-slave replication, master-master replication and one master and three slave servers replication. In case of master server failure, role of the master is assumed by one of the backups. A mechanism for automatically changing server roles (failover) is also described. All tests were carried out in a laboratory environment.
Secondary keywords: Replication;MySQL;Database;Virtual computer;Server;
URN: URN:SI:UM:
Type (COBISS): Bachelor thesis/paper
Thesis comment: Univ. v Mariboru, Fak. za organizacijske vede
Pages: 48 f.
ID: 10859833
Recommended works:
, diplomsko delo univerzitetnega študija Organizacija in management informacijskih sistemov
, diplomsko delo univerzitetnega študija Organizacija in management informacijskih sistemov
, diplomsko delo
, diplomsko delo univerzitetnega študijskega programa
, no subtitle data available