high-availability loadbalanced mysql server farm

2009-01-14 Thread xufeng
Hi all, One website is based on LAMP(Linux+Apache+MySQL+PHP)(that is our case).We donot have very big tables or complicated database design.We only have one database. Because the php code is a third-party product we donot want to make much modification on the code. But when it comes to the underlyi

can we set up this architecture?

2009-01-08 Thread xufeng
er Internet for file sharing 2.sshfs 3.inotify(our system's kernel does not support this and we donot want to risk upgrading our kernel as well) 4.drbd in active-active mode 5 or any other solutions Any suggestions will be welcomed. Thank you in advance. Yours XuFeng -- MySQL General Maili

RE: On fighting with master-slave replication lag

2008-12-30 Thread xufeng
il.com [mailto:baron.schwa...@gmail.com] On Behalf > Of Baron Schwartz > Sent: 2008年12月26日 0:56 > To: xufeng > Cc: Jake Maul; claudio.na...@gmail.com; andy-li...@networkmail.eu; > mysql@lists.mysql.com > Subject: Re: On fighting with master-slave replication lag > > 2008/12/24 xufen

RE: On fighting with master-slave replication lag

2008-12-24 Thread xufeng
als (not only the tools themselves). Thank you all for your great help. Yours Xu Feng > -Original Message----- > From: xufeng [mailto:xuf...@yuanjie.net] > Sent: 2008年12月25日 10:13 > To: 'Baron Schwartz'; 'Jake Maul'; claudio.na...@gmail.com; > andy-li...@n

RE: On fighting with master-slave replication lag

2008-12-24 Thread xufeng
> -Original Message- > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf > Of Baron Schwartz > Sent: 2008年12月24日 22:06 > To: Jake Maul > Cc: mysql@lists.mysql.com > Subject: Re: On fighting with master-slave replication lag > > On Wed, Dec 24, 2008 at 2:31 AM, Ja

On fighting with master-slave replication lag

2008-12-22 Thread xufeng
Hello everyone, In my production system, I set up MySQL 5.0.67 master/slave replication, and recently I met with master/slave replication lag problem. Is there a good monitoring tool or some other tools to detect and discover this latency on slave? Any suggestion is welcomed. Thank you in advance.

RE: MySQL 5.0.67 on SMP

2008-12-16 Thread xufeng
mysql 25 0 100 1:59.25 2.7 554m 55m 2448 R mysqld 24027 mysql 25 0 100 2:12.25 2.7 554m 55m 2448 R mysqld Thank you again. Yours, Xu Feng > -Original Message- > From: Dan Nelson [mailto:dnel...@allantgroup.com] > Sent: 2008年12月16日 13:51 > To: xufeng

RE: MySQL 5.0.67 on SMP

2008-12-15 Thread xufeng
t: 2008年12月16日 11:54 To: xufeng Subject: Re: MySQL 5.0.67 on SMP hi, I think the version is not support SMP.You may use smp patches in this version. 在 2008-12-16,上午11:44, xufeng 写道: Hi Is there a way to check if my MySQL5.0.67 works well on SMP? I have two CPUs with each two cores, and I wa

MySQL 5.0.67 on SMP

2008-12-15 Thread xufeng
Hi Is there a way to check if my MySQL5.0.67 works well on SMP? I have two CPUs with each two cores, and I want to know if MySQL distributes loads over the two CPUs. System OS: Linux 2.6.9-42.ELsmp MySQL Version: 5.0.67 Intel(R) Xeon(TM) CPU 3.00GHz * 2 Thank you in advance. Yours, Xu Feng