-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Rakesh Kumar writes:
[...] > Not Yet.. Please provide any fruitful suggestion to solve this. My > experience based on studies done so far is, i can have a master database > and other slave database servers would be connected with this via LAN and > master would be responsible to update other slaves. > But this is still doubtful that when master is down slaves should serve the > requests and so they must be updated so that every instance viewed by the > user should give them correct information and same should be with master > server. You need to setup data replication from master database server to slave servers. And, then in your application logic you've to send database reads (SELECTs) to slaves and writes (UPDATE, INSERT, etc.) to master. In case your master goes down, you need to promote some slave as new master, and update your application configuration, database slaves configuration to reflect the change. And, there is also multi-master replication[1] where you can setup multiple master hosts. The exact implementation details are specific to the database/application stack you're planning to use. References: [1] http://en.wikipedia.org/wiki/Multi-master_replication HTH - -- Ashish SHUKLA “I don't believe in morality. I'm a disciple of Bernard Shaw.” (George Bernard Shaw, "The Doctor's Dillema", 1911) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (FreeBSD) iQIcBAEBCgAGBQJPNzSDAAoJEMdGz6nnT6Sw9z8P/iQBGCOC81sv48jcDWoXCjOW Mx1+Ye+O6oPdu4rsQUni4R4wOaXw/n5llLALAcAgZojpvgUZIgjPVbOy9BSZW9nL iYmtLyt3iVA8Rs6SjxldKaq7SrQ8DDQs5mJZ6nJCjEgsvr4zZBmzzNMKJsMCtSDR sc1cidl8CXsf/JsZFZB5hPekedSkD96REES7DrytqsMZvjxEc/BHqnn8I6oBd30+ Ml6dJV/hVxVQFXa0I5Ik7l6eDyRtNHMMwEW9KPLylhsPoViEc6BN1j4lXkNQ355i ZViwoPI24bCZws3HtptoleEhgz0NGPVcrqGdrqg6e7u2nePo9mRs62XHMAEmQ6hg /7DjxDwG9CP8G09hsC7Yht9gkJxcssObuGd7D+zt7xZG5DXXAScXbRonGf9uNKI7 rqBhI9tHDi2uOi3YvWpHylUO5VLW7BpuNM1zpdRuMaLDpMrloC4gtlDefyLXFf6Y 3+X7fgwO1yOiNGZ7aBj4TxaNF1ZBrKiiQQNcAa+of/1CVBywGKtWtKrUqtQy9Ltp 8tZRjlbVQuM3pvsXIjaEQv/gXLef/fMO4Z+k2p4frEzXNRpDx24WT0gYLRtzt2qj o1OrzxY2GnscYFkScnS3xfG9uY6wKiZslh0k0c8PuggQzYFTbzcSF+EAji+DFof8 HbWab4tkAJMfVBIw7vkI =wpA8 -----END PGP SIGNATURE----- _______________________________________________ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd