| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document

Title:Replikacija baze podatkov v MySQL
Authors:Trojar Vidmar, Tim (Author)
Leskovar, Robert (Mentor) More about this mentor... New window
Files:.pdf UN_Trojar_Vidmar_Tim_2017.pdf (2,21 MB)
 
Language:Slovenian
Work type:Bachelor thesis/paper (mb11)
Organization:FOV - Faculty of Organizational Sciences in Kranj
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, Virtualni računalnik, Strežnik
Year of publishing:2017
Source:Dob
COBISS_ID:7963411 Link is opened in a new window
NUK URN:URN:SI:UM:DK:0DCVRQEM
License:CC BY-NC-ND 4.0
This work is available under this license: Creative Commons Attribution Non-Commercial No Derivatives 4.0 International
Views:246
Downloads:57
Metadata:XML RDF-CHPDL DC-XML DC-RDF
Categories:FOV
:
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:AddThis
AddThis uses cookies that require your consent. Edit consent...

Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:Database replication in MySQL
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.
Keywords:Replication, MySQL, Database, Virtual computer, Server


Comments

Leave comment

You have to log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica