Thread: 64-bit mirrors

64-bit mirrors

From
Josh Berkus
Date:
Folks,

I've been working for the past couple of months on building a new machine for
pgFoundry and to be a PostgreSQL mirror.  It's hard for me to justify,
though, NOT going Opteron.

So, my question is, if I put pgFoundry on an Opteron machine, is there another
64-bit machine in the postgresql network I could mirror it to in case of
failure?  This seems better to me than letting our 32-bit dependancy drag on
because we can't afford to upgrade all the machines at once.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Re: 64-bit mirrors

From
"Marc G. Fournier"
Date:
On Tue, 11 Jan 2005, Josh Berkus wrote:

> Folks,
>
> I've been working for the past couple of months on building a new machine for
> pgFoundry and to be a PostgreSQL mirror.  It's hard for me to justify,
> though, NOT going Opteron.
>
> So, my question is, if I put pgFoundry on an Opteron machine, is there another
> 64-bit machine in the postgresql network I could mirror it to in case of
> failure?  This seems better to me than letting our 32-bit dependancy drag on
> because we can't afford to upgrade all the machines at once.

Is there anything that has to be mirrored that is 64 vs 32bit dependent?
Isn't everything PHP based?  It should just be a matter of mirroring the
specific PHP files themselves, with the 'mirror server' having the same
overall configuration as the master ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: 64-bit mirrors

From
"Joshua D. Drake"
Date:
Marc G. Fournier wrote:
> On Tue, 11 Jan 2005, Josh Berkus wrote:
>
>> Folks,
>>
>> I've been working for the past couple of months on building a new
>> machine for
>> pgFoundry and to be a PostgreSQL mirror.  It's hard for me to justify,
>> though, NOT going Opteron.
>>
>> So, my question is, if I put pgFoundry on an Opteron machine, is there
>> another
>> 64-bit machine in the postgresql network I could mirror it to in case of
>> failure?  This seems better to me than letting our 32-bit dependancy
>> drag on
>> because we can't afford to upgrade all the machines at once.
>
>
> Is there anything that has to be mirrored that is 64 vs 32bit dependent?

Well the PostgreSQL data directory for example. You can't take a data
dir from an i586 and push it to a x86_64 compiled postgresql.

As far as the PHP itself that should not matter.

Sincerely,

Joshua D. Drake


> Isn't everything PHP based?  It should just be a matter of mirroring the
> specific PHP files themselves, with the 'mirror server' having the same
> overall configuration as the master ...
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html


--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage,  and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com


Attachment

Re: 64-bit mirrors

From
"Marc G. Fournier"
Date:
On Tue, 11 Jan 2005, Joshua D. Drake wrote:

> Marc G. Fournier wrote:
>> On Tue, 11 Jan 2005, Josh Berkus wrote:
>>
>>> Folks,
>>>
>>> I've been working for the past couple of months on building a new machine
>>> for
>>> pgFoundry and to be a PostgreSQL mirror.  It's hard for me to justify,
>>> though, NOT going Opteron.
>>>
>>> So, my question is, if I put pgFoundry on an Opteron machine, is there
>>> another
>>> 64-bit machine in the postgresql network I could mirror it to in case of
>>> failure?  This seems better to me than letting our 32-bit dependancy drag
>>> on
>>> because we can't afford to upgrade all the machines at once.
>>
>>
>> Is there anything that has to be mirrored that is 64 vs 32bit dependent?
>
> Well the PostgreSQL data directory for example. You can't take a data dir
> from an i586 and push it to a x86_64 compiled postgresql.

Shouldn't be doing that anyway ... the plan is to use slony for real-time
replication of the data itself ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: 64-bit mirrors

From
Josh Berkus
Date:
Marc,

> Is there anything that has to be mirrored that is 64 vs 32bit dependent?
> Isn't everything PHP based?  It should just be a matter of mirroring the
> specific PHP files themselves, with the 'mirror server' having the same
> overall configuration as the master ...

For pgFoundry, the issue isn't the PHP, or the database, which will be taken
care of by other means.   It's:
mailman config
mail ques
CVS
files & file permissions
cron jobs
etc.

While it might be possible to do all of the above via a straight-up file-based
RSync, it removes the convenience ... and portablility ... of the
copy-the-whole-VM approach.    And, if we can't do that, then heck if I'm
going to use VMs at all ...

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco