Re: Load Balance on MySql

2007-01-18 Thread Nils Meyer
Hi Shain, Shain Lee wrote: Now , i have to think about any perfect load balancing method , i can't duplicate the databse in another machine. It's directly conflict with serving contents for each request. Why not use replication? If you don't want to do it on application level (seperate rea

Re: Load Balance on MySql

2007-01-18 Thread Shain Lee
Thanx for the information , but i wanted to go for a long term plan and for a fixed solution. bcause little by little that load getting high. please need some mysql expertise help. Thank you, Shaine. Ady Wicaksono <[EMAIL PROTECTED]> wrote: Hi Lee better you start to benchmark your system usin

Re: Load Balance on MySql

2007-01-17 Thread Ady Wicaksono
Hi Lee better you start to benchmark your system using tools like http://sysbench.sourceforge.net/ You will find out, what boundary you hit, if you hit max thread, reduce thread stack size but very careful on this stuff :) On 1/18/07, Shain Lee <[EMAIL PROTECTED]> wrote: Hi Friends , I have h

Load Balance on MySql

2007-01-17 Thread Shain Lee
Hi Friends , I have huge WAP content database and it's included with wallpapers, ringtones, games ...etc.That content database getting hits more that 1000 /sec. This is actually massive. My Webserver s are Tomcat and apache , because some applications written in java and some are php . per