Quote:
Originally Posted by longdongsilver
He seems to think that this set up could allow us to do the backups to nas without stopping the master db. I think that is what he was saying.
|
Well you can always run a mysqldump and then scp it over to a different host or do the mysqldump on the remotehost directly (depending if you have networking enabled for mysql).
If you can't have locked tables etc you should setup replication where server 1 is the master and server 2 is the slave, this is done through binary logs so each write query is performed on both servers. You can perform reads on either one of the servers. In this case you also opt to make the backups on the slave so your master is always able to perform queries.
Quote:
Originally Posted by longdongsilver
From what i am starting to understand, simply copying a db (backing it up) is not the same as replication. Seems its not like just a giant file.
|
A mysqldump is an export file with all the queries in it to recreate a database, tables and data. Replication is where all queries on a master are replicated to a slave so both hosts contain the same data (if in sync of course).
__________________
ICQ: 267-443-722 / leon [at] adulteuhost [dotcom]
Nominated for an XBIZ Award as "Webhost of the Year" in 2007, 2012, 2013 and 2014
