Running A VDS for Database Only

[rustydusty1717]

They are two completely different database engines, writing SQL Queries, while similar, for SQL Server Express, are not the same as writing a query for MySQL, and MySQL is not the same as PostgreSQL, and PostgreSQL is not the same as SQLite, and SQLite is not the same as AccessDB, and AccessDB is not the same as an excel spreadsheet.

These are all different database systems, if something is built to use MySQL, it typically will not work with anything but MySQL.

Everything I've ran, will work on both. Great Plains, FRx, Diamond, Print Audit, etc. Some fairly large software programs that are widely used and I've seen them run on both. I know they are different, but they are also similar in many ways. All depends on program, as some can be picky. Lots it just has to be anything but an Access DB. Can't believe someone would use one in first place.

[soja]

I wouldn't recommend running an active database on the same server as your game servers. I have a mysql server running "hlstats" for ~10 game servers and the cpu can spike quite a bit. I suppose if your machine is underloaded it won't have too much of an issue with this, but I would deff. recommend a seperate machine. If you have any sort of large database events (like database cleaning etc) it can take up an entire core until its done.

Just my experience and 2 cents

[.=QUACK=.Major.Pain]

Servers are setup to cleanup early in the morning when it's quiet and it only cleans up 1 area off the database.

Running 6 dayz servers right now with db on same server.
Keeping an eye on it.

[FlyingMongoose]

Let us know how it goes for you.