Topic: Can't believe how cheap servers are these days

[phanophish]

So I'm pricing out a new database environment for an application at work.  Decided to pretty much go to the top end for a stand alone MySQL database servers.  So I speced out the box below....

IBM 3650 Rack Mount
Dual Quad Xenons 2.26GHz 8MB L3 Cache
12 - 73GB 15K 6Gbps SAS Drives  (2 Drive RAID1 Boot, 8 Drive Raid 10 Data volume)
16GB DDR3 1033 RAM
Redundant power
Remote management card
3yr 24/7/4 support

Essentially a smoking fast database box that came in at less than $6500 for the hardware.  Seriously the pricing amazes me.  And the server will really kick some hiney.  I remember paying nearly that for some simple file servers with just 72GB of RAID 5 storage & 2GB of RAM a few years ago.

[Sebastian]

I'm currently doing an internship at IBM and my team just recently got two new servers, too. It was quite mindboggling for me to just throw some 48 GB of RAM and 20 x 1TB drives at the things

But why in the world are you running MySQL on such a machine? I haven't worked with it for a few years, but does it really scale up to such dimensions these days?

[phanophish]

Yea, it will run fine on a machine like this.  Essentially we are using the RAM to aggressively cache table data for improved query performance. really fast disk so anything that happens not to be cached will still preform well, but it gives us headroom for replication & backup to be preformed concurrently to production.  The system is used to manage a large order picking/fulfillment system for an online sales business.

[Sebastian]

Yea, it will run fine on a machine like this.  Essentially we are using the RAM to aggressively cache table data for improved query performance.

Ah, I see. The one thing MySQL is really good at: fast reads

But what I was really trying to ask... Is MySQL still lacking the more professional features like tablespaces and incremental backups/point in time recovery?

[phanophish]

Yea, it will run fine on a machine like this.  Essentially we are using the RAM to aggressively cache table data for improved query performance.

Ah, I see. The one thing MySQL is really good at: fast reads

But what I was really trying to ask... Is MySQL still lacking the more professional features like tablespaces and incremental backups/point in time recovery?

Not sure, our use is pretty much real time so we don't have a need for that.  By the time any data is 4 hours old it is of no value