Thread: 64-bit mirrors
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
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
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
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
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