You DO NOT want to dump an active database that people are connected to. Instead if it you have a master/slave setup ( the slave a passive copy) you dump the slave. The master will be locked out from the slave while you do the dump, but that’s OK because it just queues up the updates and does them when the dump is finished. Yet another reason why doing such a long running process is a bad idea. There can be no synchronized backup of the master database while the dump is running. We’re talking DAYS! Names, of course, mean nothing. This is why Tix verified that the server named “master” was indeed the actual master with live connections and the server named “slave” was in fact the slave. So imagine her surprise when Tim called and informed her that she had locked out the MASTER database. This comic puts a bit of a mystery on our hands. How could that have happened?

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)