Server with 1000+ Players, How large is your database?

[leeleatherwood]

Im building a L2J server, I have 15000 rpm SCSI hard drives for the server files but want to put the SQL database on a SSD drive.

I am looking at 2 40gb OCZ Vertex 2's in RAID 1. Will 40gb be enough? I would imagine so, I just dont see the L2J Database growing that large.

Thanks.

[jurchiks]

Definately enough. L2J databases are really small, as far as I know you might make it to a gigabyte if you have at least 1k active users online for a very long time. But l2j cleans up the database on every startup so it's hard to get it that high.

[leeleatherwood]

Definately enough. L2J databases are really small, as far as I know you might make it to a gigabyte if you have at least 1k active users online for a very long time. But l2j cleans up the database on every startup so it's hard to get it that high.

Wow, thats very small, kinda makes getting a SSD Drive useless. Maybe I should just stick with the 15k drives for both server files and SQL database... or put the everything on the SSD and ditch the SCSI drives.

Hrm...

This is how I have the server setup right now:

Windows Server 2008 R2 64bit
Dual Opteron 280 (2.4ghz x 4)
Dual redundant power supplies.
14gb DDR ECC Ram
2x 80gb 7200rpm RAID 1 (OS and backups)
Dell PERC 4 SCSI RAID controller with 128mb DDR Cache
2x 36gb 15000rpm SCSI RAID 1 (Gameserver/Loginserver and SQL Database)

Probably getting an SSD is useless/overkill? Or maybe switch the SCSI Drives for the SSD Drives?

[jurchiks]

Loginserver can stay on the 7200rpm, it doesn't get much action. GS on the 15k, DB on the SSD with regular backups to the 7200rpm.
So you have 2x7200rpm raid1, 1x15k SCSI for GS (surely you have a backup of your server files somewhere else?) & 1xSSD for DB. I'm not sure you need a raid for the DB just yet...
Weird amount of RAM btw, maybe it's 12GB there?

[leeleatherwood]

Loginserver can stay on the 7200rpm, it doesn't get much action. GS on the 15k, DB on the SSD with regular backups to the 7200rpm.
So you have 2x7200rpm raid1, 1x15k SCSI for GS (surely you have a backup of your server files somewhere else?) & 1xSSD for DB. I'm not sure you need a raid for the DB just yet...
Weird amount of RAM btw, maybe it's 12GB there?

No, its 14gb. 6x 2gb and 2x 1gb sticks. (I had the 1gb sticks laying around)

I already have 2x 15k SCSI in Raid 1, so I will use that for the gameserver and put the SQL Database on the SSD.

Thanks.

[jurchiks]

Don't forget the regular backups.