RE: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-05 Thread Andrew Braithwaite
@lists.mysql.com Subject: Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size On Friday 04 September 2009 08:15:35 pm muhammad subair wrote: On Sat, Sep 5, 2009 at 5:10 AM, mos mo...@fastmail.fm wrote: At 11:48 AM 9/4/2009, you wrote: One of my potential clients want to migrate

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-05 Thread muhammad subair
Amazon S3 as a backup solution, it's easy to use and quite cheap too. Cheers, Andrew -Original Message- From: Colin Streicher [mailto:co...@obviouslymalicious.com] Sent: 05 September 2009 05:16 To: mysql@lists.mysql.com Subject: Re: 1 Machine with 4 GB RAM for Big Size MySQL Data

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread Colin Streicher
What sort of data? Is it currently stored in a database? If so, how many tables? 24GB of text data in a single table is quite a bit, but manageable if maintained properly. 24 GB of binary data on the other hand, is not very much at all. Colin On Friday 04 September 2009 12:48:18 pm

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread Brent Baisley
The size of the data is largely irrelevant, it depends on how much of it you need to use at once. For most setups, 4GB should be more than enough. A single server is always a bad idea since it's a single point of failure. Concurrent users isn't really relevant with the database either since it's

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread mos
At 11:48 AM 9/4/2009, you wrote: One of my potential clients want to migrate their application to web based (PHP MySQL), estimates of the data size is 24GB and growth per month is 20MB of data. Unfortunately, they could only use 1 sever machine with 4GB RAM. The application used in intranet,

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread muhammad subair
On Sat, Sep 5, 2009 at 5:10 AM, mos mo...@fastmail.fm wrote: At 11:48 AM 9/4/2009, you wrote: One of my potential clients want to migrate their application to web based (PHP MySQL), estimates of the data size is 24GB and growth per month is 20MB of data. Unfortunately, they could only use

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread Colin Streicher
On Friday 04 September 2009 08:15:35 pm muhammad subair wrote: On Sat, Sep 5, 2009 at 5:10 AM, mos mo...@fastmail.fm wrote: At 11:48 AM 9/4/2009, you wrote: One of my potential clients want to migrate their application to web based (PHP MySQL), estimates of the data size is 24GB and growth