Why would someone want a non-sql server?
Unless they had sql servers quit on them way too many times(which is obviously because of their mistake).
If you know how to use MySQL, it works perfectly.
My server is running for over 13 hours now, on MySQL with 200+ players all the time. And guess what, no rollback, no lag. Why? Because if you stick your nose in MySQL configuration and you don't know what you are doing you'll break it.
Best way to handle MySQL is like this:
Code:
string connString = ""Server=" + MySqlHost + ";Database='" + MySqlDatabase + "';Username='" + MySqlUsername + "';Password='" + MySqlPassword + "';Pooling=true; Max Pool Size = 40;Min Pool Size = 5";
For any query that doesn't involve reading.
Code:
using(var conn = new MySqlConnection(connString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(commandString, conn);
cmd.ExecuteNonQuery();
}
For reading:
Code:
var conn = new MySqlConnection(connString);
conn.Open();
MySqlCommand cmd = new MySqlCommand(commandString, conn);
var Reader = cmd.ExecuteReader(CommandBehaviour.CloseConnection);
And it works smooth.
