Re: load-balancing with NFS
On Fri, Jun 15, 2001 at 09:54:32AM +0200, Wouter de Jong wrote: On Thu, Jun 14, 2001 at 05:05:56PM -0700, Justin Bauer wrote: You can do load balancing, you just need to have the same information on each server. With mysql you would use Replication to keep the servers sync'ed. Well, then you'd have to do 2way replication. And that doesn't work great with AUTO_INCREMENT fields, etc AFAIK : And since I have no way of controlling query's (it's a database-server for our customers), I don't think that's going to work...*argh* : What`s wrong with the most obvious way: database1.widexs.nl database2.widexs.nl database3.widexs.nl ? Just tell them on which server there dbaseaccount lives and they are happy. But that`s probably the way it is right now. Just curious, Harmen As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html Thanks, I'll skip the plan. No load-balancing for me thus : we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp filer) -- The Moon is Waning Crescent (37% of Full) nieuw.nl - 2dehands.nl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load-balancing with NFS
On Wed, Jun 13, 2001 at 08:55:50PM +0200, Sven Huster wrote: Hi Hi, As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html Thanks, I'll skip the plan. No load-balancing for me thus : we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp filer) regards Sven Huster Senior IT Systems Engineer -Original Message- From: Wouter de Jong [mailto:[EMAIL PROTECTED]] Sent: 13 June, 2001 10:21 To: [EMAIL PROTECTED] Subject: load-balancing with NFS *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a shared /var/ directory for all databases inside ? I want load-balancing, cause my server can't handle the pressure good anymore. database-01 IN A 192.168.0.101 database-01 IN A 192.168.0.102 192.168.0.101: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.102: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.100: will be NFS-mounted by the 2 mysqld machines And how to configure MySQL with RAID(5) (3 disks, 1 spare) ? Is --with-raid anough, and everything will go automatically good ? I don't have to use other table-types then MyISAM ? Thanks for any input : -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: load-balancing with NFS
Hi As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp filer) regards Sven Huster Senior IT Systems Engineer -Original Message- From: Wouter de Jong [mailto:[EMAIL PROTECTED]] Sent: 13 June, 2001 10:21 To: [EMAIL PROTECTED] Subject: load-balancing with NFS *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a shared /var/ directory for all databases inside ? I want load-balancing, cause my server can't handle the pressure good anymore. database-01 IN A 192.168.0.101 database-01 IN A 192.168.0.102 192.168.0.101: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.102: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.100: will be NFS-mounted by the 2 mysqld machines And how to configure MySQL with RAID(5) (3 disks, 1 spare) ? Is --with-raid anough, and everything will go automatically good ? I don't have to use other table-types then MyISAM ? Thanks for any input : -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php