Re: Load Balance on MySql - Shain Lee - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Load Balance on MySql

From	Sent On	Attachments
Shain Lee	17 Jan 2007 22:59
Ady Wicaksono	17 Jan 2007 23:04
Shain Lee	17 Jan 2007 23:59
Nils Meyer	18 Jan 2007 01:33

Subject:	Re: Load Balance on MySql
From:	Shain Lee (gsm_...@yahoo.co.uk)
Date:	01/17/2007 11:59:33 PM
List:	com.mysql.lists.mysql

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 <ady....@adiska.com> wrote: 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 :)

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 . perl. Hence i needed to use that both wap servers.Due
high load for the content database ,it's getting hang/stuck/panic. I couldn't
even restart the mysql service. I have restart the machine , no any other way to
release the stucked load.

OS - RHEL : 2.6.9-42.0.3.ELsmp MySql - 4.1.7

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

old_passwords=1 ######################### flush back_log=2000 connect_timeout=10 interactive_timeout=25 join_buffer_size=4M key_buffer=1024M max_allowed_packet=64M max_connections=2000 max_connect_errors=100000 myisam_sort_buffer_size=256M read_buffer_size=8M read_rnd_buffer_size=8M sort_buffer_size=8M table_cache=4096 thread_cache_size=400 thread_concurrency=16 wait_timeout=50 query_cache_size=1024M query_cache_limit=32M query_cache_type=1 log=/var/log/mysqld_sql.log log-error=/var/log/mysqld_error.log #########################

[mysql.server] user=mysql basedir=/var/lib

[mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

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.

can somebody help me on it ? what would be the perfect way to have a balance the
load ? How can we take the statics of mysql databse ? is there any open source product
available ?

Thanx in advance, Shaine.