On Wed, 9 Feb 2000, Ryan, Aaron wrote:
> Hi,
>
> We have designed a web site creator that uses
> Perl and DBI to work with MySQL. The integration
> between the two was great, but recently our website has
> been over run with users and our poor MySQL database is showing
> some major slow downs. So we have two possible solutions we
> are researching. Trying to optimize the MySQL to work better
> under these stressful condition (which are going to get worse) or
> moving the SQL server onto another machine with a more scalable SQL server
> such as Sybase.
>
> However, we would like to make the move with the least amount of perl code
> modification. So if we could replace the current DBI:MySQL calls with Sybase
> DBI:DBLib
> calls or the like, that would be very attractive.
at the very least, you should move mysql to a separate box, anyway.
3-tiered architecture should include physical and as well as logical
separation of presentation/logic/data/.
ky
