[問] Anyway to make sure a database system can run 24x7 ?
2005, 六月 1 - 12:15 — pcleung
Hello Debian gurus,
Is OpenSSI or DRDB a solution?
There is a number of Debian Sarge packages on OpenSSI.
But it needs two machines.
Is hotcopy or disk replication a solution too?
Say, for every 10 minute, a daemon program replicates changes
of a harddisk or of a database to another machine.
Is it the simpler way of increasing the availability?
thanks
© 2004-2007 Debian HK - About Debian HK
Debian and the Debian logo are trademarks of Software in the Public Interest, Inc
Debian and the Debian logo are trademarks of Software in the Public Interest, Inc
It depend on which database s
It depend on which database server you use. if you use MySQL and Oracle,
then already provide replication feature and you can use them to replicate
the data and use Heartbeat for the failover.
If you use PostgreSQL, you may need drbd or rsync for real-time / non-realtime
file system level replication respectively. depend on your need.
Cluster Server -MCD
If you really that serious about 724, build a cluster. Mostly server down because of
1. harddisk
2. power
3. cards or main board, if you get a very unreliable one. Like whatever "practise" or something.
Sole Database cluster is easy. Check out mysql.com cluster section. very good start. If you want to build "server" base cluster, please choose your favour first. Like oscar, ha, mosix... your path may vary.
thnx
thnx