Hi all...
We system analysts need to trust on our database software. Once they
crash, all of hard work will be lost.
So, people says replication is a good way to keep your data safe.
Let me present you my point.
I am using a RedHat 9.0/Mysql with a Raid 1(Mirror) file system. In
case of a file error, the software raid 1 will handle this problem and
replication will not add any good.
Another crash could be a MySql bug, and in this case the slave Mysql
will crash too.
So, why should i replicate???
Remember it's a case of safe data, not fast response.
I am just logging (bin-log) the changes made on database data. In
case of crash, i will rebuild the database using this log.
By the way, how can i rebuild the data using the log? What is the
command?
I think the log is recorded before the query is runned. This way, the
log is complete safe. Am i right?
One more qustion...
Since the log will keep increasing, there is no way to check the
logged querys runned all right and delete then from log? Does Mysql do
this automatic?
Thanks!