balancing database mysql

eliasche · #1 (**permalink**) 10-11-07, 22:31

Hello everyone,

i am new here, we run a large file storage site and we have some mysql issues lately, can anyone help on how to organize well balancing for mysql as well as for http server apache?

Regards

mike_bike_kite · #2 (**permalink**) 10-12-07, 11:47

It might help if you explain what problems you are having. Do you get an issue when running a particular piece of SQL? Also detail what tables and indexes are involved, Knowing the number of rows in the tables concerned also helps.

Is it load balancing that's the issue, how many accesses do you get and are you sure it's MySQL that's the problem?

Mike

eliasche · #3 (**permalink**) 10-12-07, 14:51

Mike,

I pmed u

EL

mike_bike_kite · #4 (**permalink**) 10-12-07, 16:37

I'm afraid dbforums is a public forum - both to help you and others in future with similar issues. If you can describe your issue and what you think might cause it then we can try to solve it. If you have a file that can be placed on a web server etc then you can put a link in a post. There are others on this forum with far more knowledge than me on load balancing and it's worth showing to all.

Mike