What is "enough" for remote mariadb server
Hello folks!
I want to setup a remote mariadb server and I was wondering if anyone could help me choose the best linode plan just for that.
This db wouldn't be used much, it's not for commercial use, just my side project to enjoy with friends.
I expect maximum queries per second would be around 10 and this could be going on just for a few hours per day.
Is Nanode enough?
Or maybe I should get something more just to be sure?
Thanks!
2 Replies
✓ Best Answer
A Nanode should be fine, especially if you're only using it as a database server. I'm using 3 Nanodes (all running Debian 11) as a MariaDB Galera cluster for a fairly large MediaWiki installation and around 20 WordPress sites. It's worthwhile monitoring your memory usage after MariaDB has been running for several days and tweaking the innodb_buffer_pool_size until you find a value that maximizes the memory usage without ever going into swap. In my case, the sweet spot was 256MB and memory usage tends to settle at around 94% after a few days.
+------------------------------------------+--------------------+
| key_buffer_size | 0.062 MB |
| query_cache_size | 0.000 MB |
| innodb_buffer_pool_size | 256.000 MB |
| innodb_additional_mem_pool_size | 0.000 MB |
| innodb_log_buffer_size | 16.000 MB |
+------------------------------------------+--------------------+
| BASE MEMORY | 272.062 MB |
+------------------------------------------+--------------------+
| sort_buffer_size | 2.000 MB |
| read_buffer_size | 0.125 MB |
| read_rnd_buffer_size | 0.250 MB |
| join_buffer_size | 0.250 MB |
| thread_stack | 0.285 MB |
| binlog_cache_size | 0.031 MB |
| tmp_table_size | 8.000 MB |
+------------------------------------------+--------------------+
| MEMORY PER CONNECTION | 10.941 MB |
+------------------------------------------+--------------------+
| Max_used_connections | 25 |
| max_connections | 50 |
+------------------------------------------+--------------------+
| TOTAL (MIN) | 545.598 MB |
| TOTAL (MAX) | 819.133 MB |
+------------------------------------------+--------------------+
