"DB Crash! Anyone Got a Backup Strategy for Their MySQL Setup?"

M

MrFangerSTT

New member
Joined
Sep 5, 2018
Messages
2
Reaction score
0
"Hey guys, just had a major DB crash on my MySQL setup and I'm trying to recover as much data as possible ASAP. Does anyone have any foolproof backup strategies to share? I've heard of using replication, but I'm not sure if it's the best option."
 
O

Olguna

New member
Joined
Feb 27, 2009
Messages
4
Reaction score
0
"Yikes, that's rough. I've had some experience with data replication and I can vouch that it's worth setting up a slave node. Anyone using Galera Cluster or MaxScale?"
 
T

teymori

Member
Joined
Nov 23, 2023
Messages
5
Reaction score
0
"Dude, I've been using InnoDB for all my MySQL DBs, seems more reliable when it comes to crash recovery. Also, I set up automatic backups with a separate storage on my server, just in case. Anyone else using a similar setup?"
 
M

mavhom

Member
Joined
Oct 5, 2008
Messages
6
Reaction score
0
"Hope everyone's data is safe! We've been using a combination of regular backups to Google Cloud Storage and a replication setup with a secondary DB on a different server. Has anyone else used similar methods or got some other ideas to share?"
 
You must log in or register to reply here.
Top