Database

A database is a way to store data for all regions on a server. Homestead provides a built-in caching system to improve the performance and speed for protecting and managing all regions.

Providers

Provider	Implemented?	Notes
PostgreSQL		For big servers (~1,000 players daily)
MariaDB		For big servers (~1,000 players daily)
MySQL		For big servers (~1,000 players daily)
MongoDB	Upcoming...	For medium servers (~500 players daily)
SQLite (Default)		For small servers (~100 players daily)
YAML		For small and friends-only servers (~50 players)

Setup

By default, when you install Homestead, the selected provider is SQLite.

If you have never let other players use Homestead, or you used it for testing before public joining, and you want to change the database provider, change the current provider name to the provider you want to use. These are the valid provider names:

PostgreSQL: postgresql
MariaDB: mariadb
MySQL: mysql
SQLite: sqlite
YAML: yaml

database:
  provider: "sqlite"

  # PostgreSQL configuration
  postgresql:
    host: "localhost"
    port: 3306
    username: "USERNAME"
    password: "PASSWORD"
    database: "homestead_data"
    table_prefix: ""

  # MariaDB configuration
  mariadb:
    ...

  # MySQL configuration
  mysql:
    ...

  # SQLite configuration
  sqlite: "homestead_data.db"

Migrating to another provider

Prepare your new provider's details (username, password...) in the config.yml file.
Save the changes and reload the configuration using the command: /hsadmin reload
Migrate the current data to the new provider using the command: /hsadmin export [provider]
Stop your server.
Change the provider to the provider you migrated to earlier in config.yml.
Start the server. You're good to go!