Page 1 of 1

Backup Database

PostPosted: Tue Jan 12, 2016 4:23 pm
by aleyva
Hi,
What is the best way of backup a BD ???
Actually my DB has 18Gb, With mysqldump It takes about 9 minutes, but in that time the whole system hangs.
Our operation works 24 hours.


AL

------------
ViciBox Redux v.5.0.3
Asterisk 1.8.28.2-vici
1 Database Server (5.5.33-MariaDB-log) / Web Server
1 Web Server
4 Agent Servers

Re: Backup Database

PostPosted: Tue Jan 12, 2016 6:25 pm
by mflorell
The best way would be to have a slave database and perform your backups on the slave.

Re: Backup Database

PostPosted: Tue Jan 12, 2016 8:16 pm
by rrb555
making a slave is one of my wishlist this year. is there someone has a guide to make a slave database?