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 unlikely all of them will be running a query at the same time. Unless your queries are really slow.
I'm using a server with 2GB RAM that gets 300K hits a day, adds 250K records per day to the databases, with one table having almost 50 million records. Brent Baisley On Fri, Sep 4, 2009 at 12:48 PM, muhammad subair<msub...@gmail.com> 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, just running simple transactions and the > number of users concurent is under 10. > > I need information and suggestion about this condition, whether the effort > spent on implementation and future maintenance is not too large for use > MySQL with this condition? > > *btw sorry for my English* > > Thanks you very much, > -- > Muhammad Subair > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org