| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Replikacija baze podatkov v MySQL
Authors:ID Trojar Vidmar, Tim (Author)
ID Leskovar, Robert (Mentor) More about this mentor... New window
Files:.pdf UN_Trojar_Vidmar_Tim_2017.pdf (2,21 MB)
MD5: B4DD4094E1AA1D55235132F61A72DD0D
PID: 20.500.12556/dkum/cc2ec9bb-0c42-426b-9fe6-5ed8b1d7db91
 
Language:Slovenian
Work type:Bachelor thesis/paper
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
Place of publishing:Dob
Year of publishing:2017
PID:20.500.12556/DKUM-67578 New window
COBISS.SI-ID:7963411 New window
NUK URN:URN:SI:UM:DK:0DCVRQEM
Publication date in DKUM:21.09.2017
Views:1648
Downloads:160
Metadata:XML DC-XML DC-RDF
Categories:FOV
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share



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

Licences

License:CC BY-NC-ND 4.0, Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International
Link:http://creativecommons.org/licenses/by-nc-nd/4.0/
Description:The most restrictive Creative Commons license. This only allows people to download and share the work for no commercial gain and for no other purposes.
Licensing start date:23.08.2017

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 must 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