What's installed on your MariaDB server?
- MariaDB 11.8 LTS from the official MariaDB repository
- An empty database called uygulama, using the utf8mb4 character set
- A full-rights user called yonetici that can connect from anywhere, with a password generated at install
- TLS with a self-signed certificate that MariaDB generates on every start
- Firewall with only ports 22 and 3306 open, plus fail2ban for SSH
- Settings file at /etc/mysql/mariadb.conf.d/99-seturack.cnf
What size do you need for MariaDB?
MariaDB's documentation has no minimum RAM figure. What it asks for is an InnoDB buffer pool big enough to hold most of your active data. The default is 128 MB, and the install leaves it there. As a rule of thumb, 1 GB suits a small database or a test setup, and 2 to 4 GB suits a database serving several apps. RAM, CPU and disk grow separately from your panel, and your data and IP address stay the same.
| Use | Size | Price | Choose |
|---|---|---|---|
| Starter | 1 GB RAM · 1 vCore · 25 GB NVMe | $2.58/mo | |
| Medium | 2 GB RAM · 1 vCore · 40 GB NVMe | $4.01/mo | |
| Powerful | 4 GB RAM · 2 vCore · 60 GB NVMe | $6.89/mo |
Who is it for?
- Laravel, WordPress or custom projects that want the database off the web server
- Teams connecting several apps to one database server
- Developers who need a remote database for development and testing
- Apps with users in or near Turkey that should keep their database in Istanbul
What happens after you order?
- Set the size and complete your payment.
- Your server starts and MariaDB installs itself. This took about 3 minutes in our real-server tests.
- In your panel, open your server from My servers and copy the Connection address, Login and Password rows on the Overview tab.
- Test the connection: mariadb -h IP -u yonetici -p uygulama
- Create a separate, limited user for your app and keep yonetici for admin work.
With every server
- Daily backups included in the price
- Unlimited traffic
- Full root access
- Scale RAM and CPU up or down later, and grow the disk
- Location: Istanbul · IST-1.
Good to know
- Port 3306 is open to the internet after install. To limit it, run ufw delete allow 3306/tcp, then ufw allow from YOUR_IP to any port 3306.
- Scaling up doesn't enlarge the InnoDB buffer pool by itself. Set innodb_buffer_pool_size in 99-seturack.cnf and run systemctl restart mariadb.
- The server stays on the 11.8 branch. Ubuntu security updates install themselves, but MariaDB comes from its own repository, so you update it with apt.
- The self-signed certificate is generated in memory at startup. If your driver needs CA verification, set your own certificate with ssl_cert and ssl_key.
MariaDB questions and answers
How do I connect to my MariaDB server remotely?
Use the Connection address, Login and Password from your panel. The port is 3306 and the ready-made database is called uygulama. From the command line, run mariadb -h IP -u yonetici -p uygulama. Desktop database tools and MySQL drivers work with the same details.
How much RAM does MariaDB need?
MariaDB has no official minimum. As a rule of thumb, 1 GB is a good start for a small database and 2 to 4 GB for one serving several apps. The real test is whether your active data fits in the InnoDB buffer pool.
Will my MySQL app work with MariaDB?
In most cases, yes. MariaDB's documentation says its client protocol is binary compatible with MySQL and that MySQL connectors work unchanged. MySQL 8 data moves across as a dump, so test differences such as the JSON type and authentication first.
Is the MariaDB connection encrypted?
Yes. Since MariaDB 11.4, TLS turns on by itself. The server generates a self-signed certificate, and MariaDB clients on 11.4 or later verify it using your password. With any other driver, turn on the TLS option in its settings.
How do I move my existing database to MariaDB?
Take a dump on the old server with mariadb-dump --single-transaction, or mysqldump if it runs MySQL. Load the file with mariadb -h IP -u yonetici -p uygulama. For a large dump, copy the file to the server over SFTP and load it there.
Is my MariaDB server backed up?
Your server is backed up every night, the last 7 days are kept, and this is included in the price. You can restore a single file or the whole server from your panel. To roll back one table, keep your own regular mariadb-dump files too.