On Sat, Feb 11, 2012 at 2:32 PM, S B <[email protected]> wrote:
> > Hi Rakesh, > > Did you get any useful inputs? > > Thanks, > Sid > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On > Behalf Of Rakesh Kumar > Sent: Friday, February 10, 2012 11:04 AM > To: The Linux-Delhi mailing list > Subject: [ilugd] Database Clustering using php > > Hi All, > I am facing a problem and that is, i have to create an web application > which requires 24x7 Availability and so they asked me to have a clustered > database. In this case if one server in down/unavailable we can retrieve > data from other server, a kind of master slave database system. This will > definitely provide better availability to the users. Now my problem is i > have never developed this sort of system before and i have to create it > preferably in PHP. > There are several problems that i have analyzed so far are followings- > 1 - How data is going to be stored on the servers simultaneously? > 2 - If one server is down/unavailable and we perform some transactions from > one server, how this will get updated from other server so that when it > becomes available, it uses updated information? > I want some guidance from here. > > -- > Regards > RAKESH KUMAR > http://raakeshkumar.wordpress.com > _______________________________________________ > Ilugd mailing list > [email protected] > http://frodo.hserus.net/mailman/listinfo/ilugd > > 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. -- Regards RAKESH KUMAR http://raakeshkumar.wordpress.com _______________________________________________ Ilugd mailing list [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd
