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
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
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
One nice thing about MySQL, however, is that replication is pretty easy. I
have no experience with PostgreSQL but after doing a little research it
looks like replication in PostgreSQL is a comparative PITA.
--
David Mintz
http://davidmintz.org/
The subtle source is clear and bright
The tributary
Looks like I am upgrading my DB on my Ubuntu machine later tonight.
Cheers Dan for pointing that out!
-Anthony
On Thu, May 7, 2009 at 9:16 AM, Daniel Horning wrote:
> > -Original Message-
> > From: talk-boun...@lists.nyphp.org [mailto:talk-
> > boun...@lists.nyphp.org] On Behalf Of Dan
> -Original Message-
> From: talk-boun...@lists.nyphp.org [mailto:talk-
> boun...@lists.nyphp.org] On Behalf Of Dan Cech
>
> Anthony Wlodarski wrote:
> > Here is an example of a convenience that is not yet built into
> PostgreSQL
> > (and if it is please correct me as I am using 8.1.1).
>
Anthony Wlodarski wrote:
> Here is an example of a convenience that is not yet built into PostgreSQL
> (and if it is please correct me as I am using 8.1.1).
>
> INSERT INTO x (a,b)
> VALUES
> ('1', 'one'),
> ('2', 'two'),
> ('3', 'three')
It seems like this was added in 8.2, it's been a while
Same here, I am still a "noob" to the SQL game but I prefer PostgreSQL over
MySQL. The one thing I do find rewarding is that at the end of the day I
can watch PostgreSQL run circles around MySQL in regards to performance.
But those nice to haves are missed that make MySQL user friendly for the
maj
Anthony Wlodarski wrote:
We use PostgreSQL for our environments. Although it is quite powerful there
are some ease of use issues with tuning and getting it to perform at its
maximum. But the great thing about PostgreSQL is transactions right out of
the box, that has been the most useful feature
We use PostgreSQL for our environments. Although it is quite powerful there
are some ease of use issues with tuning and getting it to perform at its
maximum. But the great thing about PostgreSQL is transactions right out of
the box, that has been the most useful feature so far.
I haven't had a c
Jesse Callaway wrote:
I think the idea is that MySQL had a decent business model and was
doing quite well. If Oracle does decide to shitcan it, it's GPL'd
anyway and will live on kinda like CentOS does.
Besides that MySQL forked already and while I do like and use MySQL, there is
still Postgr
Ahem, I meant Sun. And I meant to not top-post, but here we go
On Wed, May 6, 2009 at 7:22 PM, Jesse Callaway wrote:
> I think the idea is that MySQL had a decent business model and was
> doing quite well. If Oracle does decide to shitcan it, it's GPL'd
> anyway and will live on kinda like Ce
I think the idea is that MySQL had a decent business model and was
doing quite well. If Oracle does decide to shitcan it, it's GPL'd
anyway and will live on kinda like CentOS does.
-jesse
On Wed, May 6, 2009 at 6:53 PM, SusanS wrote:
> Now that Oracle has bought Sun (and also MySQL), is there an
Now that Oracle has bought Sun (and also MySQL), is there any discussion in the
community about a change in open-source databases?
___
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.ny
14 matches
Mail list logo
