Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-04 Thread Mike Garfias
mysqldump isn't a hot backup, it causes locks table and/or row (i cant remember off hand which). There is a myisamhotbackup or something like that for MyISAM tables (why the hell would you use MyISAM?), but for a real table you need the innodb hot backup thing that is commercial, and not cheap. Al

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-04 Thread Lisa Kachold
Greenplum.com? Obnosis.com BlackBerry Message -Original Message- From: Joshua Zeidner <[EMAIL PROTECTED]> Date: Wed, 3 Dec 2008 21:58:24 To: Subject: PostgreSQL vs. MySQL, was: MySQL premium services?   you know I do see many of the advantages with Postgres, but the informati

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-04 Thread Alex Dean
On Dec 4, 2008, at 9:00 AM, Matt Graham wrote: From: Alex Dean <[EMAIL PROTECTED]> On Dec 3, 2008, at 3:16 PM, [EMAIL PROTECTED] wrote: Back then when I researched the issue (about a year or so ago), you had to take the server down to get a consistent backup with the tools provided by MySQ

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-04 Thread Matt Graham
From: Alex Dean <[EMAIL PROTECTED]> > On Dec 3, 2008, at 3:16 PM, [EMAIL PROTECTED] wrote: >> Back then when I researched the issue (about a year or so ago), you >> had to take the server down to get a consistent backup with the tools >> provided by MySQL. I haven't updated my research since...

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-04 Thread Alex Dean
On Dec 3, 2008, at 3:16 PM, [EMAIL PROTECTED] wrote: Back then when I researched the issue (about a year or so ago), you had to take the server down to get a consistent backup with the tools provided by MySQL. I haven't updated my research since... ET Setting up a replication slave just f

Re: MySQL premium services?

2008-12-03 Thread Randy Melder
27;s paying the bill. ; ) .randy On Wed, Dec 3, 2008 at 1:26 PM, Joshua Zeidner <[EMAIL PROTECTED]> wrote: > > > > Hello, > > Has anyone here used MySQL premium services? Did

Re: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
. >> > >> > On Wed, 2008-12-03 at 16:53 -0500, [EMAIL PROTECTED] wrote: >> >> Use Postgres... :) >> >> >> >> >> >> Joshua Zeidner writes: >> >> >> >> > Hello, >> >> > >> >> > Has anyone here

Re: MySQL premium services?

2008-12-03 Thread James Mcphee
form. > > > > On Wed, 2008-12-03 at 16:53 -0500, [EMAIL PROTECTED] wrote: > >> Use Postgres... :) > >> > >> > >> Joshua Zeidner writes: > >> > >> > Hello, > >> > > >> > Has anyone here used MySQL premium servi

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
Postgres > > side, but MySQL is catching up there. > > > > -jmz > > > > On Wed, Dec 3, 2008 at 2:53 PM, [EMAIL PROTECTED] < > > [EMAIL PROTECTED]> wrote: > > > >> Use Postgres... :) > >> > >> > >> Joshua Zeidner writes

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread [EMAIL PROTECTED]
Back then when I researched the issue (about a year or so ago), you had to take the server down to get a consistent backup with the tools provided by MySQL. I haven't updated my research since... ET Charles Jones writes: > [EMAIL PROTECTED] wrote: >> The final single reason why I went Post

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Charles Jones
[EMAIL PROTECTED] wrote: > The final single reason why I went Postgres was backups. > Back in the day when I did my research (this may have changed) you could not > take a hot backup in MySQL without purchasing a commercial product, as > opposite as Postgres that you can simply hot-backup a fully

Re: MySQL premium services?

2008-12-03 Thread [EMAIL PROTECTED]
ort plan for > $3K/yr/server and a number of built in features that make it an > excellent enterprise platform. > > On Wed, 2008-12-03 at 16:53 -0500, [EMAIL PROTECTED] wrote: >> Use Postgres... :) >> >> >> Joshua Zeidner writes: >> >> >

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Charles Jones
Eh, my last experience with setting up replication with postgres was not very fun. I have used Slony, and pgcluster, and pgpool. Setting up reliable replication with MySQL is a snap, and doesn't require any extra tools or daemons. In the past the biggest advantage of postgres over mysql was t

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread [EMAIL PROTECTED]
sion is one of the major gains on the Postgres > side, but MySQL is catching up there. > > -jmz > > On Wed, Dec 3, 2008 at 2:53 PM, [EMAIL PROTECTED] < > [EMAIL PROTECTED]> wrote: > >> Use Postgres... :) >> >> >> Joshua Zeidner write

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
Actually we just got through that one... It seems that it is easier to set up, but the supported concepts for replication in PostGres are stronger. PG offered this feature very early on. -jmz On Wed, Dec 3, 2008 at 2:59 PM, Charles Jones < [EMAIL PROTECTED]> wrote: > I shall now make a bl

Re: PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Charles Jones
I shall now make a blanket statement such as; "It is easier to setup replication with MySQL". :P --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoe

Re: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
> > > > > Joshua Zeidner writes: > > > > > Hello, > > > > > > Has anyone here used MySQL premium services? Did you think they are > a > > > good value? > > > > > > -jmz > > ---

PostgreSQL vs. MySQL, was: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
gains on the Postgres side, but MySQL is catching up there. -jmz On Wed, Dec 3, 2008 at 2:53 PM, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: > Use Postgres... :) > > > Joshua Zeidner writes: > > > Hello, > > > > Has anyone here used MySQL prem

Re: MySQL premium services?

2008-12-03 Thread Bryan ONeal
> Use Postgres... :) > > > Joshua Zeidner writes: > > > Hello, > > > > Has anyone here used MySQL premium services? Did you think they are a > > good value? > > > > -jmz > --- > PLU

Re: MySQL premium services?

2008-12-03 Thread [EMAIL PROTECTED]
Use Postgres... :) Joshua Zeidner writes: > Hello, > > Has anyone here used MySQL premium services? Did you think they are a > good value? > > -jmz --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.

MySQL premium services?

2008-12-03 Thread Joshua Zeidner
Hello, Has anyone here used MySQL premium services? Did you think they are a good value? -jmz --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http