2 Interchangeable databases

[narutoroot]

I was wondering if on my website i can run two databases one local and one on another host so every time some posts something or adds shit it goes to both databases.

Btw i want to do this so incase my host gets down itll only take like 2 minutes to change dns servers

narutoroot Reviewed by narutoroot on 27th Jun 2009. 2 Interchangeable databases I was wondering if on my website i can run two databases one local and one on another host so every time some posts something or adds shit it goes to both databases. Btw i want to do this so incase my host gets down itll only take like 2 minutes to change dns servers :P Rating: 5

[SplitIce]

its called mysql replication. Heres a guide: http://dev.mysql.com/doc/refman/5.0/...ion-howto.html