Re: Mysql Scenario

2004-05-28 Thread tachu
thanks all for your responses. so basically replication would be one option. now how many servers do you think i would need to replicate to have say a set of mysql servers and then on top of that have a set of say 50 application servers 25 accesing each server would that be feasable consideri

Re: Mysql Scenario

2004-05-28 Thread Brent Baisley
You wouldn't setup one repository to hold the data. You would actually probably hit disk and network limitations with a single repository. MySQL supports master/slave setups which would replicate the data across machines. One machine would be the "master" handling updates which would propagate

Re: Mysql Scenario

2004-05-28 Thread Thomas Spahni
Hi, sharing a data directory between different servers (probably using nfs) is not a good idea and it would create a new bottleneck. A quote from the very fine manual: "Make it easy for yourself: Forget about sharing a data directory among servers over NFS. A better solution is to have one compu

Re: Mysql Scenario

2004-05-28 Thread Scott Haneda
on 05/27/2004 06:30 PM, tachu at [EMAIL PROTECTED] wrote: > WOuld the following scenario be possible > I currently have about 1.2 Tb of data that i need to transform into > mysql and be able to server a very high amount of pages from a > discussion board. would i be able to place the mysql/data di

Mysql Scenario

2004-05-27 Thread tachu
WOuld the following scenario be possible I currently have about 1.2 Tb of data that i need to transform into mysql and be able to server a very high amount of pages from a discussion board. would i be able to place the mysql/data directory in a main server with huge storage and then have several