MYSQL or SQLITE ?

[Schlup]

Ok, I guess I'm a little confused by what MySQL is needed for here or why there is even an option. I am on the 32 bit Linux version and I did the default install and everything is working, members can join and leave and come back, etc. I haven't really setup any of the permissions or anything yet but at this point I'm not seeing why I would need MySQL. Can someone explain why I need it or what advantages there are to setting up the database in MySQL and running it with TS3?

[Lil-rich]

MySQL is optional so you have no disadvantages by using the standard option (SQLite).

In my opinion the advantage of MySQL is that you can combine it with PHP or other web languages. Because I am not native english speaker it's a bit complicated to explain for me

If you use the MySQL-option all data (like channels, permissions etc pp) will be stored in a MySQL-database. This database can be easily read via PHP and you can build your own (very extended) TS3-Viewers, Webinterfaces and so on.

In addition it's just much easier to read (manually). If you want to have a look at the users table or want to compare some groups you need some extra tools for reading if you use SQLite (like SQLiteReader or something). MySQL offers some possibilities (I personally prefer the web-based PHPMyAdmin) to read the data very fast and intuitive. You can change everything without uploading/downloading the file everytime (linux server) you just have to restart the server to make the changes work.


I hope you understood a part of what I wrote because my english isn't the best And maybe some other users know about some other advantages/disadvantages because I am just focused on these aspects I wrote (and so I maybe missed one).

[Riff Raff]

The only advantage i see is that u can backup your data from mysql directly or with phpmyadmin for example.
Webinterfaces and stuff will be better use the Query-Commands so u don't have to care wich db is used and u don't make unnecessary incompatibilitys.

[NerfYoda]

The default SQLite has the advantage of being very fast and lightweight at the expense of slightly larger file I/O. Languages like PHP read SQLite just fine, and to back it up all you have to do is back up the sqlite file and you're good. Granted there's no web-ased tool that's as extensive as phpMyAdmin for managing SQLite, but there are a number of local clients that work great.

I'd only use MySQL if you're the type of admin who absolutely needs all of their settings in one place, which can be troublesome to accomplish, or if you're a large scale hosting provider. If you run dozens of TS instances with dozens of active players on each instance then MySQL will probably provide a performance benefit. Otherwise, stick with SQLite. There's less to configure, it's faster, and you don't need to rely on an external daemon.

[daMichl]

on my root server there runs a mysql server too,

but i dont know whats the best choise: run teamspeak with his own sqlite database or with a mysqldatabase.

please help me to finde the best choice in performance for the teamspeak 3 server ;-) and write it down here.

[AmrasTaralom]

normally you should use sqlite, it's faster at least if the database is not really HUGE

but besides performance you should think about features you need, i.e. for the coming web-interface you'll probably need the sqlite-extension in your apache enabled if you use sqlite. depending on your config that could even mean you have to recompile the whole thing. on the other hand moving around a sqlite-db is easier than a mysql db.

so you see it depends on quite some things

[ANR Daemon]

Not really in Apache, rather - in scripting language that you're using for your site.
I.e. Perl, PHP... etc.

But now, with this key-mess, it's not really a difference. You could use either, depends how familiar you are with MySQL.

[squirrelof09]

Okay, currently what is better? I'm hearing there are issues with mysql and that mysqlite is better.

[Stefan1200]

Okay, currently what is better? I'm hearing there are issues with mysql and that mysqlite is better.

Why there are issues? I have no problems with MySQL.

I think both have there advantages.
I use MySQL because it is easier for me to do changes on the database if I run into a bug of TS3. Also my homepage gets client database informations directly from the MySQL Database (read only!) to make life easier for the TS3 server .

SQLite is easier to handle, no need to setup an external database server. Smaller SQLite databases may be also faster than MySQL, because of the less features of SQLite.

[Giswald]

Hello Teamspeak Community,

Maybe you can answer my question.

Are there any advantages from a MySQL-based Teamspeak 3 Server compared to a SQLite3?

Thats my actually VPS:

Intel i7 920
3 GB of RAM
Debian 6.0
MySQL 5.5.19

Teamspeak 3:

10 Servers
~ 340 Channel
~ 25 Users online at the moment (at peak time about 70-90)
outgoing: 83 GB
incoming: 33 GB
117 GB Traffic total in 30 days

[Thor Erik]

I believe the best setup would be to have the MySQL on a different host to offload the io required with larger userbases.

I have a similar setup with an Ubuntu 10.11 TS3 host and a Windows based SQL backend with seperate hardware. I noticed in particular when you get more than 30 or so users on a single TS machine that the io to the SQLite rised a lot, and quickly. When offloaded to the MySQL host, the TS host didn't use that much resources at all, where as I saw the MySQL server (in particular) have higher io when many users where online/joining/leaving

[Giswald]

Well, I don't like to rent a extra VPS just for a Teamspeak 3 Server. I host those server for my Clan and some friends.

The Client table got about 1500 records. (All User connected after 31.12.'11). Most of them (~900) have less then 30connections because they joined for a random Raid (World of Warcraft) or just random visits.

I didn't monitor the IO for the SQLite Database till now, is there any usefull program or service?

The database is now 2,8 mb

[Thor Erik]

I didn't monitor the IO for the SQLite Database till now, is there any usefull program or service?

The database is now 2,8 mb

You can look into Munin for monitoring various load.
Personally I run the TS + webservices on a VMware ESXi 5 host which provides a lot of sensors in terms of different kinds of loads (eg. iops)

[Giswald]

Can maybe a Staff Member answer here please?

Would be nice to know the advantages (if there are any).

[florian_fr40]

Hello

The Thor Erik's answer is good.
My personal think, for a little teamspeak server (one virtual server) the SQLte database is good enough.
If Teamspeak server is used for a big usage or a big community, the MySQL database is better.

In your case I think a SQLite databse should be good (maybe limit but good).