Behind almost every dynamic website is a database - the structured store that holds your posts, products, users and settings. Understanding how database hosting works helps you manage your site better and choose the right setup as you grow.

Table of Contents

What a Database Is

A database stores data in organised tables - rows and columns - so websites can read, write and query information quickly. When WordPress loads a post or a shop shows a product, it is querying the database.

MySQL vs MariaDB vs MSSQL

  • MySQL: the most popular open-source database, the default for WordPress and most web apps.
  • MariaDB: a MySQL-compatible open-source fork, common on modern hosting - faster and actively developed.
  • MSSQL: Microsoft's database, required by ASP.NET applications - available on Windows hosting and Windows VPS.

Where Your Database Lives

On shared and premium hosting, your database runs on the server alongside your site, managed through cPanel (phpMyAdmin). On VPS and dedicated servers, the database runs as a service (like MariaDB or MySQL) you install and configure - or the provider does it on managed plans.

Managing Your Database

  • Create databases and users in cPanel with strong passwords.
  • Back up regularly - a database backup plus a file backup is a complete site backup.
  • Optimise tables and clean junk to keep it fast.
  • Restrict database access to trusted IPs on advanced setups.

Frequently Asked Questions

How many databases can I create?

On shared hosting, usually 5-25 depending on your plan. VPS and dedicated servers have no practical limit - you create as needed.

Does database size affect speed?

Yes - a bloated database slows queries. Regular cleanup, proper indexes and caching keep even large databases fast.

Your database is the brain of your website - back it up, keep it clean, and choose the right engine for your stack.