Can one forum write to two databases?

Here are the details:

-I have an SMF forum
-It runs on MySQL database.

I would like to do it so that the forum is writting to two instead of one database. This so that I have a backup, in case one database fails, I can simply switch to the other one.

More like mirroring.

Is this even possible?


Thanks,

 

I think it will involving scripting.
or,
Try your asking host, probably they have auto backup..

Good luck

 

yes, shouldn't be a problem
but if you're worried about a DB failing, I suggest getting a better host

 

yeah,,
writing into 2 databases will need more time...
it can influences your aplication performance,,,,

 

Try to use something similar to MySQL Replicator. You don't have to change SMF to write in 2 databases. You could use a synchronization tool/script

 

Yes it is possible. I am sure that there is a config file and if you add another database name I think it might work but remember to backup the original.

 

You can, you wouldn't do it on the save of an entry you'd probably do it on the server itself.