I'm curious about how others are backing up their databases,
especially when it contains frequently changing information, such as a
list of orders and line items from an ecommerce site.
Right now, I'm backing up my mysql database every night, but of course
we can have a few hundred orders that occur during the daytime, so if
something catastrophic were to happen, we'd lose the information from
all the orders that had been placed since the last backup occurred.
But backing up every time a transaction happens is not feasible.
Is this where a read-only mysql replication slave comes in? (read only
in the sense that updates can only happen from the master database)
I'm not much of a database admin, so I'm kind of clueless about this
stuff, was hoping someone could outline some of the different