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
Backup Database
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
3 posts
• Page 1 of 1
Backup Database
by aleyva » Tue Jan 12, 2016 4:23 pm
- aleyva
- Posts: 20
- Joined: Wed Oct 23, 2013 12:25 pm
Re: Backup Database
by mflorell » Tue Jan 12, 2016 6:25 pm
The best way would be to have a slave database and perform your backups on the slave.
- mflorell
- Site Admin
- Posts: 18386
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
Re: Backup Database
by rrb555 » Tue Jan 12, 2016 8:16 pm
making a slave is one of my wishlist this year. is there someone has a guide to make a slave database?
One server that I am managing | Single Server | ViciBox Redux 6.0 | VERSION: 2.12-549a | BUILD: 160404-0940 | revision 2508| No other hardware
For help you can send me a direct email info@support.com.ph
For help you can send me a direct email info@support.com.ph
- rrb555
- Posts: 585
- Joined: Tue Feb 08, 2011 4:24 pm
- Location: Quezon City, Philippines
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 115 guests