Hello,
If you have not already done so, check out the Cluster Eval Guide which has some tips which may assist you in your process. Much
of the content was put together by the professional services group here at MySQL.
http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php
Al
Hi,
As usual, everything is heavilly dependant on your specific scenario.
Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
benefit from I/O (more, faster disks).
Regards,
Ricardo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
That's kind of like asking what kind of car to buy to get from point A
to point B. A sports car, it will get you there fast and in style.
Unless you are a moving company, then it's totally inappropriate. A
taxi service? Well that's different too.
Ok, so you are selling by internet. Amazon.com,
At 10:17 AM 5/6/05, Berta Alcala Larramendi wrote:
I'm doing an University project and I need to "buy" a server for a
business. I have to simulate an enterprise that sells by Internet. There
are many clients and products in the Data Base and we use MySQL in a Linux OS.
I need to find as much info
THanks everyone for all your help!
Steve
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "David T-G" <[EMAIL PROTECTED]>
Cc: "mysql users" <[EMAIL PROTECTED]>; "Steve Vernon"
<[EMAIL PROTECTED]>
Sent: Frida
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hiya!
Hi!
%
% Thanks for the quick reply!!!
Sure thing :-)
%
% But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
% Gig file?
I wouldn't think so. The manual doesn't seem
On Fri, Oct 31, 2003 at 05:44:02AM -0500, David T-G wrote:
> %
> % Does the 2 Gig file size limit on Linux get broken when I have a hardware
> % raid controller?
>
> The limit applies only to ext2 filesystems, and not all of them at that;
> ext3 and reiserfs (and others) can happily write much la
---
-Original Message-
From: Steve Vernon [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 14:19
To: Peter Lovatt; Mysql List
Subject: Re: Hardware Raid and 2 Gig Limit
Hiya!
Thanks for the help!!!
Do RSync like big files? Or does it prefer smaller
ovatt" <[EMAIL PROTECTED]>
To: "Steve Vernon" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:17 PM
Subject: RE: Hardware Raid and 2 Gig Limit
> Hi
>
> We have a similar challenge
Don't confuse hardware RAID with MySQL RAID. The 2GB file size limit is
a function of the operating system and the file system in use, it has
nothing to do with the disk hardware you have installed.
Your ISP may say you don't need the raid option activated because the
system they are using doesn
[mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 12:00
To: Mysql List
Cc: [EMAIL PROTECTED]
Subject: Re: Hardware Raid and 2 Gig Limit
Hiya!
Thanks for the quick reply!!!
But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
Gig file?
I know you can split files, but basi
I looked into big tables for myself and everyone said
you need the raid option in MySQL. Now I'm not sure!
Thanks,
Steve
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Cc: "Steve Vernon" <
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hello,
Hi!
%
% Does the 2 Gig file size limit on Linux get broken when I have a hardware
% raid controller?
The limit applies only to ext2 filesystems, and not all of them at that;
ext3 and reiserfs
On Fri, Aug 08, 2003 at 04:30:21PM -0500, Jackson Miller wrote:
> I am going to have to put MySQL on it's own box, and I am wondering what makes
> the biggest difference with hardware.
>
> I am hoping to set max_connections to 1000 at least (and I will probably use
> at least 500 several times a
On Thursday, 27. June 2002 21:26, [EMAIL PROTECTED] wrote:
Hi,
> I apologize for not being more specific. The query that is taking too long
> is :
> SELECT * FROM Stories WHERE UCASE(Path) LIKE 'toUpper(path)%';
> Path is a 255 char field with an index on it. path is variable passed in.
> Thanks
Hi
A few thoughts. I am not an expert on this kind of use, so there may be
others with better suggestions :)
If every search is different then your search efficiency is critical. If you
fulltext index the field then it should help.
If not then what about indexing the text document words. You s
"Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 3:08 PM
Subject: Re: Hardware Planning
> Hi.
>
> On Thu 2002-06-27 at 13:35:28 -0400, [EMAIL PROTECTED] wrote:
> > I am currently using mys
Hi.
On Thu 2002-06-27 at 13:35:28 -0400, [EMAIL PROTECTED] wrote:
> I am currently using mysql 4.01 with caching for web page serving. I
> pull several records out with a like statement on a text field. The db
> consists of about 200,000 records right now and it is using 100% of the cpu
> whe
At 12:35 PM 6/27/2002, you wrote:
> I am currently using mysql 4.01 with caching for web page serving. I
>pull several records out with a like statement on a text field. The db
>consists of about 200,000 records right now and it is using 100% of the cpu
>when the search is ran.
> Since thi
Kris Saw writes:
> We have been using mysql for some time to run and administer our dynamic
> content sites. During this time we have run mysql on low end intel
> hardware (dual PIII 900 with a gig of RAM) on linux and have discovered
> that a single mysql server in this configuration could not
You didn't mention how many 'transactions per second/minute/hour' you
expect... (on those 25 connections)
A Sun Ultra 10 is just a PC built by Sun (but with a Ultra-SPARC CPU and
other nice enhancements). I don't know if Sun has made it possible to
attach ANY brand of disk drive (that they haven
Try: http://eliteukserve.net/dedicatedservers/dedicated_servers.html
We specialise in managed custom server solutions. We have great experience in
providing mass virtual solutions incorporating Linux
based systems such as SuSE and RedHat with MySQL.
I would say perhaps a Dual PIII 1GHz SCSI wou
Look on Ebay for Compaq 1850R 'rackmount' servers...
You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can
plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the
disk space (and the different number of storage devices to 'mirror' and s
23 matches
Mail list logo
