| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Implementacija replikacije baz podatkov v virtualnem okolju
Authors:ID Kušar, Luka (Author)
ID Rajkovič, Uroš (Mentor) More about this mentor... New window
Files:.pdf UN_Kusar_Luka_2017.pdf (1,43 MB)
MD5: B98D1CF14E368D473A0796E6B47F7EB7
PID: 20.500.12556/dkum/3ff78a12-db85-451b-8001-854932c07dfc
 
Language:Slovenian
Work type:Bachelor thesis/paper
Organization:FOV - Faculty of Organizational Sciences in Kranj
Abstract:V podjetju je samo en strežnik, ki gosti spletno stran in bazo podatkov. Ker se nad bazo podatkov izvaja analiza, se ob visoki obremenitvi strežnik preneha odzivati. Cilj je na fizičnem strežniku narediti virtualna strežnika, ki bi razdelila breme med uporabniki in analizo baze ter povečala varnost podatkov z replikacijo baze. Projekt je izveden na osebnem računalniku, na katerega je naložen Virtualbox. Ustvarili smo virtualna računalnika, namestili potrebno programsko opremo in konfigurirali replikacijo baz podatkov. Rezultat sta virtualna strežnika, ki gostita spletni strežnik, poročilni strežnik in bazo podatkov. Med njima se izvaja replikacija baze podatkov. Replikacijo smo testirali s pomočjo spletne strani in aplikacije JasperReports Server. S tem smo zagotovili varnostno kopijo podatkov v primeru odpovedi glavnega strežnika. Prav tako se lahko istočasno izvajata delovni proces in analiza podatkov, saj sta strežnika ločena in imata ločena sredstva. Rešitev deluje zadovoljivo in je primerna za implementacijo v produkcijsko okolje, vendar so potrebna dodatna sredstva za virtualne računalnike in optimizacija strežnika za določeno okolje.
Keywords:virtualizacija, baze podatkov, replikacija, poročila
Place of publishing:Maribor
Year of publishing:2017
PID:20.500.12556/DKUM-68983 New window
COBISS.SI-ID:7985683 New window
NUK URN:URN:SI:UM:DK:SA8YY0ZT
Publication date in DKUM:21.12.2017
Views:1246
Downloads:96
Metadata:XML DC-XML DC-RDF
Categories:FOV
:
KUŠAR, Luka, 2017, Implementacija replikacije baz podatkov v virtualnem okolju [online]. Bachelor’s thesis. Maribor. [Accessed 17 April 2025]. Retrieved from: https://dk.um.si/IzpisGradiva.php?lang=eng&id=68983
Copy citation
  
Average score:
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share


Searching for similar works...Please wait....
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-SA 4.0, Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International
Link:http://creativecommons.org/licenses/by-nc-sa/4.0/
Description:A Creative Commons license that bans commercial use and requires the user to release any modified works under this license.
Licensing start date:15.11.2017

Secondary language

Language:English
Title:Implementation of database replication in a virtual enviroment
Abstract:There is only one server in the company that hosts a website and a database. When load is high and the analysis is started on the database the server times out. The goal is to create two virtual machines that would split the load between users and analysis, and secure data with replication. The project was performed on a personal computer with installed Virtualbox. We have created two virtual computers, installed the necessary software and configured the database replication. The result is two virtual servers that host a webserver, a reports server and a database. Replication is performed between the virtual servers. Replication was tested with the help of a website and JasperReports server application. We have assured a backup of the data in case the main server fails. The work process and analysis can work simultaneously, because the servers are separate and have separate resources. The solution works well and is ready for production if there is enough resources and the servers are properly optimized for the specific instance.
Keywords:virtualization, databases, replication, reports


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