Strange MySql / Server Program . .. .

We run a server network of 2 director servers, 4 pawn servers, 2 image servers and 1 database server. This is an LVS system in which the request are made and the master director points the user to one of the four slaves.

We are running Red Hat LInux 6.1 and MySQL version 3.23. We deliver about 5,000,000 request per day in which about 50% of them are web page request.

On occasion, as you can imagine, we have to backup all database files.

When we dump the mysql data, it locks the tables. When it locks the tables, every single one of the pawn servers stops working. Not completely, but anything that requires PERL doesn't work. Since 99% of our pages and content is delivered using software, this becomes a problem.

We have checked the error_logs and nothing is recorded.

We have tried to check the mysql server logs and nothing.

WeWhen ever we try to run a script through the web, we receive a server error but when we try to run it through SSH it runs???

Any ideas, suggestions ???

 

 

 

 

Top