Re: [nyphp-talk] databases with PHP

2009-05-08 Thread Anthony Wlodarski
Yeah at my current company we are thinking of a master-slave implementation and we can speed up the website by making read only requests head to the slave server. When working with MySQL is there a stop gap to prevent requesting data from the slave that is currently in transit from the master serv

Re: [nyphp-talk] databases with PHP

2009-05-08 Thread Jerry B. Altzman
on 5/8/2009 10:17 AM Anthony Wlodarski said the following: It can be a PITA sometimes. The typical usage is the master-slave replication. Even with this type of replication there can be some data loss too. MySQL replication is great when it works. With 5.1 they've introduced row-level replic

Re: [nyphp-talk] databases with PHP

2009-05-08 Thread Anthony Wlodarski
It can be a PITA sometimes. The typical usage is the master-slave replication. Even with this type of replication there can be some data loss too. -Anthony On Thu, May 7, 2009 at 10:10 PM, David Mintz wrote: > > One nice thing about MySQL, however, is that replication is pretty easy. I > have