> The good solution for this would be to put OOPS behind of apache.
What is OOPS ?
Is it like SQL Relay ? Others have said that we should be using a
connection pooler & that it's a PHP/Apache config problem that we're
running into. We may also move to BSD from Redhat.
> P.S Are you using
On Thursday, March 7, 2002, at 12:38 AM, Jeremy Zawodny wrote:
> Are the Web servers doing write operations on the database, or
> read-only?
read-only now.
Can you talk a bit about how Yahoo Finance does it as far as # of web
servers to MySQL servers ? Apache & PHP tuning ?
- Sam.
We have a very high volume site (3 million page views a day) that's run
on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with
persistent connections. Each MySQL serves 8 web servers & is supposed to
act as a failover machine for the other group of 8 web servers.
The failover
>> Is there some way that I can avoid doing an ORDER BY and get my
>> rows back ordered by album_id, rank they way I inserted them ?
>No. That is the nature of relational databases.
Is this because the index cache in ram may not be loaded in order ?
> You might want to consider adding an A
