Best not to use XAMPP or any similar types of bundles. They are mainly for use as development testing not to go live. Unless you secure them first, and that's more hassle than just installing L(or windows based)AMP.
And if you have many users with much data use a separate mysql server would be good. Not sure how much of an improvement this would be for a minecraft server so probably overkill.
Well this topic is getting surprising amounts of responses. Anyhow, what is the difference between SQLLite And MySQL?
SQLite is like flatfile. If SQLite would would be used for a whitelist, it has to go through all those names in the list. MySQL will search the name from database quicker and so on.
MySQL is also more organized?
I'd say this is more towards .... not right, than right.
SQLite is not like flatfile. The file that sqlite creates is no more flat than what MySQL creates. The difference between SQLIte and Mysql are many, but they have far more similarities than differences. And when it comes to the databases that will be created by Minecraft....the performance differences of searching a table might be measured in thousandths of a second.
Bukkit can work with sqlite and mysql. What you'd choose is dependent on many things, such as expected SQL activity, memory footprint, and (though not to minecraft admins), syntax.
Take a look at server.properties. Theres a bunch of key/value pairs. Take a look at a mysql or sqlite file, neither of these are editable, viewable, or in any way manipulatable in a constructive manner. SQLite is not flat, its just not running a daemon process in the background. Mysql runs mysqld (mysql daemon), which runs 24/7, which is ready to and capable of handling a ... quite ridiculously large amount of traffic and activity.
SQLite, which is geared towards lower activity databases (by comparison) is professional and well made enough that it can handle ANY level of SQL activity from ANY amount of minecraft worlds you may run on your server. SQLite will never, ever be a bottleneck to your server, no matter what the population. SQLite is not some run-of-the-mill implementation, but its not geared towards the amount of traffic sites like...wikipedia (which runs mysql). As you can read from SQLites site, it is the absolute perfect solution for embedded devices, and implementations with manageable traffic....like minecraft high pop servers.
So, for any and all questions regarding minecraft--there is, without question, no doubt SQLite can handle your Minecraft servers' (bukkit) needs with no compromise. And to be be quite honest, not having a 25mb daemon running with 95% downtime (because mysql is NOT being accessed as much as you think)...is a much bigger (even if still insignificant) performance hit. And not having to deal with mysql complexity in management is a huge plus. No matter who you are...you cannot deny mysql requires far more configuration than sqlite (even if its 'easy'--it requires more) for little benefit, and higher costs.
Wasn't the intent of the post to allow privileged users on the server to run commands with less help from the admin?
Think it would be a matter of what they would like to have and what access the admin would like to grant them. If what they want includes a database then it may be good to pursue setting one up. As it stands the best method would be to have someone else do it for you unless you want to spend a fair amount of time learning about these things. Otherwise giving a trusted user root access, or access to certain things, may be the best way to proceed.
Hijacking this thread: Any tutorial on how to do this on Linux with SSH? More specifically Debian 5.0 x64.
What you're looking for is LAMP. Google "LAMP ssh install tutorial debian" and you should find a number of resources. One nice thing with Debian is you can choose to install the LAMP packages during the installation process. I assume, however, since you're using ssh, that you don't have direct access to installing the OS.
IMO LAMP is going a little too far......unless you intend to do some website hosting; If you dont need hosting, you can drop the Apache (extra bloat) and PHP.
just install what you need instead of going for some 'common template'.
Also. LAMP is bleh. LEMP--linux-nginx-mysql-php if you were gonna host!
Wasn't the intent of the post to allow privileged users on the server to run commands with less help from the admin?
Think it would be a matter of what they would like to have and what access the admin would like to grant them. If what they want includes a database then it may be good to pursue setting one up. As it stands the best method would be to have someone else do it for you unless you want to spend a fair amount of time learning about these things. Otherwise giving a trusted user root access, or access to certain things, may be the best way to proceed.
Thank you, and if anyone would be interested in setting up one, I guess PM me.
Oh, can someone help me set up an SQLite database? Or at least a tutorial link on how to make one?
It really depends on what youre installing sqlite on. But for the most part, SQLite is the easiest, in that it is a zero-configuration tool.
If you use linux, use the appropriate package manager to add it, and youre pretty much done. Seriously. Adjust your minecraft config to tell it to USE sqlite, but sqlite itself doesnt have any configuration options because its more simple and elegant like that.
And if you have many users with much data use a separate mysql server would be good. Not sure how much of an improvement this would be for a minecraft server so probably overkill.
Latest MC video (forum link): http://www.minecraftforum.net/forums/show-your-creation/videos/lets-plays/2390805
I'd say this is more towards .... not right, than right.
SQLite is not like flatfile. The file that sqlite creates is no more flat than what MySQL creates. The difference between SQLIte and Mysql are many, but they have far more similarities than differences. And when it comes to the databases that will be created by Minecraft....the performance differences of searching a table might be measured in thousandths of a second.
Bukkit can work with sqlite and mysql. What you'd choose is dependent on many things, such as expected SQL activity, memory footprint, and (though not to minecraft admins), syntax.
Take a look at server.properties. Theres a bunch of key/value pairs. Take a look at a mysql or sqlite file, neither of these are editable, viewable, or in any way manipulatable in a constructive manner. SQLite is not flat, its just not running a daemon process in the background. Mysql runs mysqld (mysql daemon), which runs 24/7, which is ready to and capable of handling a ... quite ridiculously large amount of traffic and activity.
SQLite, which is geared towards lower activity databases (by comparison) is professional and well made enough that it can handle ANY level of SQL activity from ANY amount of minecraft worlds you may run on your server. SQLite will never, ever be a bottleneck to your server, no matter what the population. SQLite is not some run-of-the-mill implementation, but its not geared towards the amount of traffic sites like...wikipedia (which runs mysql). As you can read from SQLites site, it is the absolute perfect solution for embedded devices, and implementations with manageable traffic....like minecraft high pop servers.
So, for any and all questions regarding minecraft--there is, without question, no doubt SQLite can handle your Minecraft servers' (bukkit) needs with no compromise. And to be be quite honest, not having a 25mb daemon running with 95% downtime (because mysql is NOT being accessed as much as you think)...is a much bigger (even if still insignificant) performance hit. And not having to deal with mysql complexity in management is a huge plus. No matter who you are...you cannot deny mysql requires far more configuration than sqlite (even if its 'easy'--it requires more) for little benefit, and higher costs.
Think it would be a matter of what they would like to have and what access the admin would like to grant them. If what they want includes a database then it may be good to pursue setting one up. As it stands the best method would be to have someone else do it for you unless you want to spend a fair amount of time learning about these things. Otherwise giving a trusted user root access, or access to certain things, may be the best way to proceed.
Latest MC video (forum link): http://www.minecraftforum.net/forums/show-your-creation/videos/lets-plays/2390805
IMO LAMP is going a little too far......unless you intend to do some website hosting; If you dont need hosting, you can drop the Apache (extra bloat) and PHP.
just install what you need instead of going for some 'common template'.
Also. LAMP is bleh. LEMP--linux-nginx-mysql-php if you were gonna host!
Thank you, and if anyone would be interested in setting up one, I guess PM me.
It really depends on what youre installing sqlite on. But for the most part, SQLite is the easiest, in that it is a zero-configuration tool.
If you use linux, use the appropriate package manager to add it, and youre pretty much done. Seriously. Adjust your minecraft config to tell it to USE sqlite, but sqlite itself doesnt have any configuration options because its more simple and elegant like that.