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

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 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

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: plug-discuss@lists.plug.phoenix.az.us Subject: PostgreSQL vs. MySQL, was: MySQL premium services?   you know I do see many of the advantages

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.

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

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.az.us To subscribe

Re: MySQL premium services?

2008-12-03 Thread Bryan ONeal
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.az.us To subscribe

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 premium services? Did you think they are a good value

Re: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
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://lists.PLUG.phoenix.az.us

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:

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

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

2008-12-03 Thread [EMAIL PROTECTED]
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 premium services? Did you think they are a good value? -jmz

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

Re: MySQL premium services?

2008-12-03 Thread [EMAIL PROTECTED]
/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: Hello, Has anyone here used MySQL premium services? Did you think they are a good

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: 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

Re: PostgreSQL vs. MySQL, was: 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

Re: MySQL premium services?

2008-12-03 Thread James Mcphee
... :) 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.az.us To subscribe, unsubscribe

Re: MySQL premium services?

2008-12-03 Thread Joshua Zeidner
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: Hello, Has anyone here used MySQL premium services? Did you think

Re: MySQL premium services?

2008-12-03 Thread Randy Melder
. ; ) .randy On Wed, Dec 3, 2008 at 1:26 PM, Joshua Zeidner [EMAIL PROTECTED] wrote: Hello, Has anyone here used MySQL premium services? Did you think they are a good value? -jmz