Re: [linux-lvm] System Suggestions
We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system Is there anything that I can avoid while still using the card (ie; specific RAID config)? We haven't had a chance yet to qual the latest firmware, etc., but we went with dumb IDE expansion cards (we're only using 4 ide drives per system) and we're getting better speed (RAID0 or 1+0 depending) than we were off the 3ware card. We are not using XFS, so no comments there. We're also having some problems with Mysql that people keep pointing fingers at LVM for, but at this time we're point right back and saying No! in a firm voice... What kind of problems with MySQL, if you don't mind to summarize? Thank You, Anthony - 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: [linux-lvm] System Suggestions
On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. -- Share and Enjoy. - 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: [linux-lvm] System Suggestions
On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole? Anthony - 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[2]: [linux-lvm] System Suggestions
Anthony, I'd be careful with the IDE Raid controller. We just built a lab machine with a Promise IDE Raid controller and the assumption that we could get it and XFS to co-exist. I'm not doing the work, but the engineer that is tells me that the Promise Patch Kit only works with a very limited number of stock Redhat Kernels, and that we are NOT free to add the XFS patch. Even worse, promise does not supply their patch in source, so we are not free to tweak it ourselves. I'm not sure I really believe that, but that is what I'm told. If you do get the 3Ware IDE RAID controller to work with XFS, please let me know. Greg Freemyer Internet Engineer Deployment and Integration Specialist The Norcross Group www.NorcrossGroup.com On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole? Anthony - 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: [linux-lvm] System Suggestions
On Wed, Mar 06, 2002 at 04:11:30PM -0500, Theo Van Dinter wrote: On Wed, Mar 06, 2002 at 03:59:50PM -0500, Greg Freemyer wrote: If you do get the 3Ware IDE RAID controller to work with XFS, please let me know. Works beautifully. Have RH7.2, XFS, LVM, and a 3Ware 7410 running the box that I'm sending this from. :) The Promise RAID cards are cute but crappy from what I've heard. The 3ware cards seem to be excellent quality so far, and the driver (as far as I can tell) was GPLed and is standard in the 2.4 kernel series (well, it's in 2.4.9 anyway...) We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system We haven't had a chance yet to qual the latest firmware, etc., but we went with dumb IDE expansion cards (we're only using 4 ide drives per system) and we're getting better speed (RAID0 or 1+0 depending) than we were off the 3ware card. We are not using XFS, so no comments there. We're also having some problems with Mysql that people keep pointing fingers at LVM for, but at this time we're point right back and saying No! in a firm voice... -- Share and Enjoy. - 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: [linux-lvm] System Suggestions
On Wed, Mar 06, 2002 at 07:40:09PM -0800, Petro wrote: [snip] We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system What were the stability problems? We haven't had a chance yet to qual the latest firmware, etc., but we went with dumb IDE expansion cards (we're only using 4 ide drives per system) and we're getting better speed (RAID0 or 1+0 depending) than we were off the 3ware card. So you're doing software RAID now? Some more specifics would be appreciated. What 3ware cards? 7410s? What type of drives? What motherboard? Were you doing RAID 1+0? Do you run your application-specific benchmarks, or general benchmarks? Have any actual numbers? Thanks, Maurice sql, query - 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