Re: how to design mysql clusters with 30,000 clients?
Hello I have similar scenario of mysql, but i can't put mysql data on NFS, because there have some locks and cache problems. My NFS is NetworkAppliance too, and my mysql have very hard traffic. I'm studing the posibility to put on SAN with fiberchannel cards. We will buy specefic software (in develop now) for clustering mysql. > I'd like to discuss the NFS server in this network scenario. > Say, if I put a linux-based NFS server as the central storage device and > make all web servers as well as the single mysql write server attached > over the 100Base ethernet. When encountering 30,000 concurrent clients, > will the NFS server be the bottleneck? -- A. Ramos: [EMAIL PROTECTED] Admin Sistemas, PrisaCOM Telf: 91.353.7930 Edificio Apot, 5a planta 28042 Madrid. -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: how to design mysql clusters with 30,000 clients?
Hello I have similar scenario of mysql, but i can't put mysql data on NFS, because there have some locks and cache problems. My NFS is NetworkAppliance too, and my mysql have very hard traffic. I'm studing the posibility to put on SAN with fiberchannel cards. We will buy specefic software (in develop now) for clustering mysql. > I'd like to discuss the NFS server in this network scenario. > Say, if I put a linux-based NFS server as the central storage device and > make all web servers as well as the single mysql write server attached > over the 100Base ethernet. When encountering 30,000 concurrent clients, > will the NFS server be the bottleneck? -- A. Ramos: [EMAIL PROTECTED] Admin Sistemas, PrisaCOM Telf: 91.353.7930 Edificio Apot, 5a planta 28042 Madrid. -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Bandwidth control on FTP
Hello, Try to install glftpd (www.glftpd.com) it's very configurable for your bandwith usage -- A. Ramos: [EMAIL PROTECTED] Admin Sistemas, PrisaCOM Telf: 91.353.7930 Edificio Apot, 5a planta 28042 Madrid. -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Securing MySQL
Always www.mysql.com read: http://www.mysql.com/doc/index.html section 4.2 -- A. Ramos: [EMAIL PROTECTED] Admin Sistemas, PrisaCOM Telf: 91.353.7930 Edificio Apot, 5a planta 28042 Madrid. -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Traffic control with traffic shaper
###
PATH=/usr/sbin:/sbin
echo -n "Shaping incoming traffic to ${IN_BANDWIDTH}Kbit/s "
tc qdisc add dev $DEV root handle 10: cbq bandwidth 10Mbit avpkt 1000
echo -n .
tc class add dev $DEV parent 10:0 classid 10:1 cbq bandwidth 10Mbit rate 10Mbit
allot 1514 weight 1Mbit prio 8 maxburst 20 avpkt 1000
echo -n .
tc class add dev $DEV parent 10:1 classid 10:100 cbq bandwidth 10Mbit rate
${IN_BANDWIDTH}kbit allot 1514 weight 85kbit prio 5 maxburst 20 avpkt 1000
bounded
echo -n .
tc qdisc add dev $DEV parent 10:100 sfq quantum 1514b perturb 15
echo -n .
tc filter add dev $DEV parent 10:0 protocol ip prio 100 u32 match ip dst
$FILTERMASK flowid 10:100
echo -n .
echo
echo -n "Shaping outgoing traffic to ${OUT_BANDWIDTH}bytes/s "
modprobe rshaper
rshaperctl $FILTERMASK $OUT_BANDWIDTH
echo -n .
echo
-
Questions/Comments/Credits
--
The information contained herein was gathered from a weekends worth of
searches on google. Hopefully you'll find it useful and usable. I
claim to be no expert on this topic by any means, so I don't know if
I'll be much help if you run into problems, but I'll do my best to help.
So please direct comments and questions to me, Brian Wilson
([EMAIL PROTECTED]). Thanks to z3d and sh00p for pointing me in
the right direction.
--
Prisacom
A. Ramos mailto:[EMAIL PROTECTED]
Dpto. Admin. Sistemas
--
Re: Traffic control with traffic shaper
###
PATH=/usr/sbin:/sbin
echo -n "Shaping incoming traffic to ${IN_BANDWIDTH}Kbit/s "
tc qdisc add dev $DEV root handle 10: cbq bandwidth 10Mbit avpkt 1000
echo -n .
tc class add dev $DEV parent 10:0 classid 10:1 cbq bandwidth 10Mbit rate 10Mbit allot
1514 weight 1Mbit prio 8 maxburst 20 avpkt 1000
echo -n .
tc class add dev $DEV parent 10:1 classid 10:100 cbq bandwidth 10Mbit rate
${IN_BANDWIDTH}kbit allot 1514 weight 85kbit prio 5 maxburst 20 avpkt 1000 bounded
echo -n .
tc qdisc add dev $DEV parent 10:100 sfq quantum 1514b perturb 15
echo -n .
tc filter add dev $DEV parent 10:0 protocol ip prio 100 u32 match ip dst $FILTERMASK
flowid 10:100
echo -n .
echo
echo -n "Shaping outgoing traffic to ${OUT_BANDWIDTH}bytes/s "
modprobe rshaper
rshaperctl $FILTERMASK $OUT_BANDWIDTH
echo -n .
echo
-
Questions/Comments/Credits
--
The information contained herein was gathered from a weekends worth of
searches on google. Hopefully you'll find it useful and usable. I
claim to be no expert on this topic by any means, so I don't know if
I'll be much help if you run into problems, but I'll do my best to help.
So please direct comments and questions to me, Brian Wilson
([EMAIL PROTECTED]). Thanks to z3d and sh00p for pointing me in
the right direction.
--
Prisacom
A. Ramos mailto:[EMAIL PROTECTED]
Dpto. Admin. Sistemas
--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
indexing
What free XML indexing system can i used? I test swish-e spanish version, but i need other indexing system. (more powerfull) -- A. Ramos mailto:[EMAIL PROTECTED] "Existen dos productos importantes que salieron de Berkeley: LSD y UNIX. No creemos que esto sea una coincidencia." -- Jeremy Anderson --
indexing
What free XML indexing system can i used? I test swish-e spanish version, but i need other indexing system. (more powerfull) -- A. Ramos mailto:[EMAIL PROTECTED] "Existen dos productos importantes que salieron de Berkeley: LSD y UNIX. No creemos que esto sea una coincidencia." -- Jeremy Anderson -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
rpc nfs
Hi I have this logs: eb 22 06:26:01 db2 kernel: RPC: sendmsg returned error 101 Feb 22 06:26:01 db2 kernel: nfs: RPC call returned error 101 Feb 22 06:26:06 db2 kernel: RPC: sendmsg returned error 101 Feb 22 06:26:06 db2 kernel: nfs: RPC call returned error 101 Feb 22 06:26:06 db2 kernel: RPC: sendmsg returned error 101 my mount: 10.90.40.3:/contenidos /DATA nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 10.90.40.3:/sesiones /SESIONES nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 10.90.40.3:/vbd2 /DB nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 uname -a Linux db2 2.2.18 #7 SMP Wed Jan 31 17:52:58 CET 2001 i686 unknown mount -V mount: mount-2.10r what is the problem? thx -- A. Ramos mailto:[EMAIL PROTECTED] --
rpc nfs
Hi I have this logs: eb 22 06:26:01 db2 kernel: RPC: sendmsg returned error 101 Feb 22 06:26:01 db2 kernel: nfs: RPC call returned error 101 Feb 22 06:26:06 db2 kernel: RPC: sendmsg returned error 101 Feb 22 06:26:06 db2 kernel: nfs: RPC call returned error 101 Feb 22 06:26:06 db2 kernel: RPC: sendmsg returned error 101 my mount: 10.90.40.3:/contenidos /DATA nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 10.90.40.3:/sesiones /SESIONES nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 10.90.40.3:/vbd2 /DB nfs rw,v3,rsize=8192,wsize=8192,addr=10.90.40.3 0 0 uname -a Linux db2 2.2.18 #7 SMP Wed Jan 31 17:52:58 CET 2001 i686 unknown mount -V mount: mount-2.10r what is the problem? thx -- A. Ramos mailto:[EMAIL PROTECTED] -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
nfs benchmarking (client)
Hi, I have NFSd server (netapp or other) whit support of nfsv2 and nfsv3, but i dont know how can i configure my client for best performace (with v3 sync, async or v2 sync or async) and 2.2 or 2.4 kernel benchmark results (time dd and others) are simil... sorry my poor english Alex. -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
