mysql on a NAS
Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) When I played with the two servers yesterday (we are not really happy with the performance) I noticed, that the stats of each mysql server are the same. Even if I restart one server, the stats are not amended in any way - if I restart both servers the stats were reset. Now my questions: 1) is this installtion a common practise to share a mysql db with several servers (we might increase the number of servers) 2) is there a better, more performant way, to install mysql in a cluster ? 3) Just your general idea about this setup. Thanks Stefan Stonki Onken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
[EMAIL PROTECTED] wrote: Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) You cannot do this. When I played with the two servers yesterday (we are not really happy with the performance) I noticed, that the stats of each mysql server are the same. Even if I restart one server, the stats are not amended in any way - if I restart both servers the stats were reset. Now my questions: 1) is this installtion a common practise to share a mysql db with several servers (we might increase the number of servers) Never. 2) is there a better, more performant way, to install mysql in a cluster ? See 'MySQL Clustering' BY Alex Davies and Harrison Fisk MySQL Press 3) Just your general idea about this setup. Thanks Stefan Stonki Onken -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
Sounds more like it's setup on a SAN.. a NAS is a different type of unit like a NetApp filer. I'd have to agree with the other poster, I'm not sure your current config is valid. A more typical setup would be that both boxes should have their own unique SAN partitions, and a high speed network connection between them. Setup some replication and your good to go. On Tue, 28 Nov 2006 [EMAIL PROTECTED] wrote: Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) When I played with the two servers yesterday (we are not really happy with the performance) I noticed, that the stats of each mysql server are the same. Even if I restart one server, the stats are not amended in any way - if I restart both servers the stats were reset. Now my questions: 1) is this installtion a common practise to share a mysql db with several servers (we might increase the number of servers) 2) is there a better, more performant way, to install mysql in a cluster ? 3) Just your general idea about this setup. Thanks Stefan Stonki Onken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
Am Dienstag, 28. November 2006 15:21 schrieb Gerald L. Clark: [EMAIL PROTECTED] wrote: Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) You cannot do this. Can you explain this a little bit more ? I am not the guy who set it up, so I would like to go back them and say Well, You cannot do this, because... :) Thanks stonki -- www.stonki.de:the more I see, the more I know... www.proftpd.de: Deutsche ProFTPD Dokumentation www.krename.net: Der Batch Renamer für KDE www.kbarcode.net: Die Barcode Solution für KDE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql on a NAS
OCFS probably provides protection at the file level, but mysqld undoubtedly keeps some critical information in its own internal memory. The two MySQL daemons are oblivious to each other, so that memory-resident information will not be synchronized. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Stefan Onken [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 11:58 AM To: mysql@lists.mysql.com Subject: Re: mysql on a NAS Am Dienstag, 28. November 2006 15:21 schrieb Gerald L. Clark: [EMAIL PROTECTED] wrote: Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) You cannot do this. Can you explain this a little bit more ? I am not the guy who set it up, so I would like to go back them and say Well, You cannot do this, because... :) Thanks stonki -- www.stonki.de:the more I see, the more I know... www.proftpd.de: Deutsche ProFTPD Dokumentation www.krename.net: Der Batch Renamer für KDE www.kbarcode.net: Die Barcode Solution für KDE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
On Tue, 2006-11-28 at 17:58 +0100, Stefan Onken wrote: Can you explain this a little bit more ? I am not the guy who set it up, so I would like to go back them and say Well, You cannot do this, because... :) http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html describes the pitfalls of running multiple servers on the same machine about halfway down the page in the bold 'Warning' paragraph. -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
Hi, OCFS is a cluster filesystem so running two mysqld over the same OCFS directory is exactly the same as running two mysqlds over the same directory in a local filesystem on the same machine which is strictly prohibited. If you decide to consider mysql clustering over ocfs please keep in mind thad you don't really need cluster filesystem for mysql clustering. mysql clustering doesn't share disk storage. Considering they use ocfs they may also be mistaken about the difference between mysql and oracle clustering. Oracle cluster requires shared storage whereas mysql does not. Thanks, Michael -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tue, 28 Nov 2006 12:59 PM Subject: Re: mysql on a NAS On Tue, 2006-11-28 at 17:58 +0100, Stefan Onken wrote: Can you explain this a little bit more ? I am not the guy who set it up, so I would like to go back them and say Well, You cannot do this, because... :) http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html describes the pitfalls of running multiple servers on the same machine about halfway down the page in the bold 'Warning' paragraph. -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus protection. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Database and NAS
Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? Thanks! Patrick - 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: MySQL Database and NAS
Patrick Calkins wrote: Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? Thanks! Patrick You can only have one data repository and multiple servers if you never write to your database.. Unfortunately unless you use replication mysql doesn't handle mutliple servers pointing at the same data, one server has no way of knowing that cached indexes are out of date based on updates by another server. - 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: MySQL Database and NAS
On Thu, Mar 15, 2001 at 05:07:08PM -0700, Steve Ruby wrote: Patrick Calkins wrote: Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? Thanks! Patrick You can only have one data repository and multiple servers if you never write to your database.. Unfortunately unless you use replication mysql doesn't handle mutliple servers pointing at the same data, one server has no way of knowing that cached indexes are out of date based on updates by another server. Even with it's external locking support? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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