All, We have a system that we need to track orders, inventory, etc. Pretty much an enterprise system. We also would like to be able to mirror and/or set up a distributed database. What system would you guys suggest for this task? TIA, -y ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer ------------------------- Maximus: What we do in life, echoes in eternity. -- Gladiator
Be a bit more detailed and tell us your requirements. When you speak of distributed database in the sense of replication I think of Oracle and of spending much money :-) Andreas ----- Original Message ----- From: "Yvonne Totty" <ytotty@atinucleus.com> To: "Zope List" <zope@mail.zope.org> Sent: Wednesday, April 18, 2001 11:12 AM Subject: [Zope] Native Database for Zope
All,
We have a system that we need to track orders, inventory, etc. Pretty much an enterprise system.
We also would like to be able to mirror and/or set up a distributed database.
What system would you guys suggest for this task?
TIA,
-y ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer ------------------------- Maximus: What we do in life, echoes in eternity. -- Gladiator
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
My boss says that we need to mirror our system between here (Mobile, AL), the UK and Germany. I do not know why, but this needs to be done. We have about 500 people who will need access to the system in one way or another. -y ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer, x2198 ------------------------- Maximus: What we do in life, echoes in eternity. -- Gladiator
Be a bit more detailed and tell us your requirements. When you speak of distributed database in the sense of replication I think of Oracle and of spending much money :-)
Andreas
----- Original Message -----
We have a system that we need to track orders, inventory, etc. Pretty much an enterprise system.
We also would like to be able to mirror and/or set up a distributed database.
What system would you guys suggest for this task?
This sounds like a database decision to be made but not a Zope problem. Oracle offers several kind of replication for database but as I mentioned before you should ask your boss to give you all his money :-) Maybe on can tinker a cheaper solution using Open-Source databases like MySQL, PostgresQL but I am not sure if they are suitable for this kind of mission-critical usage. Andreas Digital Creations ----- Original Message ----- From: "Yvonne Totty" <ytotty@atinucleus.com> To: "Zope List" <zope@mail.zope.org> Sent: Wednesday, April 18, 2001 11:49 AM Subject: RE: [Zope] Native Database for Zope
My boss says that we need to mirror our system between here (Mobile, AL), the UK and Germany. I do not know why, but this needs to be done.
We have about 500 people who will need access to the system in one way or another.
-y
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer, x2198 ------------------------- Maximus: What we do in life, echoes in eternity. -- Gladiator
Be a bit more detailed and tell us your requirements. When you speak of distributed database in the sense of replication I think of Oracle and of spending much money :-)
Andreas
----- Original Message -----
We have a system that we need to track orders, inventory, etc. Pretty much an enterprise system.
We also would like to be able to mirror and/or set up a distributed database.
What system would you guys suggest for this task?
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Yvonne Totty wrote:
My boss says that we need to mirror our system between here (Mobile, AL), the UK and Germany. I do not know why, but this needs to be done.
We have about 500 people who will need access to the system in one way or another.
-y
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer, x2198 ------------------------- Maximus: What we do in life, echoes in eternity. -- Gladiator
Either use the Zope database and ZEO, or a replicated SQL backend such as Oracle. It really depends on whether your data model maps better to the ZODB or an RDBMS. ZEO would still prove useful with an RDBMS backend to keep the Zope instances synched. Likely a hybrid approach such as this would work best. Unfortunately the Open source world lacks a RDBMS that has robust replication. It is something that has been discussed for PostgreSQL for some time, and I suspect it will eventually be implemented in it. Until then... -- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>
On Wed, 18 Apr 2001, Yvonne Totty wrote:
My boss says that we need to mirror our system between here (Mobile, AL), the UK and Germany. I do not know why, but this needs to be done.
It sounds like an odd requirement. I think what you should clarify with your boss is: what is the motivation behind mirroring a database at three locations? Does your boss want a database in each place, or an *application* in each place that users interact with? I bet it's the latter, and the way your boss thinks this is done is to mirror a database in all your locations, where really there are many easier web based solutions for bringing an _application_ to remote locations and having only one database location. If what you really want is a distributed application, then using Zope with ZEO and possible some kind of relational backend would be ideal. The following two chapters will probably help you make that decision: http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml http://www.zope.org/Members/michel/ZB/ZEO.dtml -Michel
participants (4)
-
Andreas Jung -
Casey Duncan -
Michel Pelletier -
Yvonne Totty