If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
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?
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?
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.