> For the complete documentation index, see [llms.txt](https://ulrichcraft.gitbook.io/ultimateclans/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ulrichcraft.gitbook.io/ultimateclans/getting-started/lets-edit-and-play/storage.md).

# Storage

The **UltimateClans** plugin supports three types of storage:

* **YAML**: Used by default for Minecraft 1.8.x servers.
* **SQLite**: Set as the default storage method for newer versions.
* **MySQL**: Highly recommended for better performance and scalability.

If you choose **MySQL**, ensure that a database is created beforehand. The storage type can be configured in the `storage.yml` file located in the `/plugins/UltimateClans/` directory.

#### Recommended Setup

Using **MySQL** is advised for servers with higher player counts or those seeking improved performance and stability.

**Example MySQL Connection**

Below is an example of how to configure a MySQL connection in the `storage.yml` file:

```yaml
Storage:
  # sqlite/mysql/yaml
  # For better performance it is recommended to use MYSQL as storage.
  type: mysql
  mysql:
    # Only mysql
    host: localhost
    # Only mysql
    port: 3306
    # Only mysql
    base: MyDatabase
    #SSL is only valid for MYSQL, most servers are not necessary to use it as true.
    useSSL: false
    #Change mysql table default charset (utf8, latin1 etc...), Use empty for default.
    charset: utf8
    # maximum size that the (mysql) pool is allowed to reach. (https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing)
    maximumPoolSize: 10
  # Used for Mysql mandatory and optional for H2 and Sqlite (default: root)
  user: MyUsername
  # Used for Mysql mandatory and optional for H2 and Sqlite (default is empty)
  pass: 'MyPasswd'
  databases:
    clan_table: uclans-clans
    player_table: uclans-players
    invite_table: uclans-invite
    moderation_table: uclans-moderation
    logger_table: uclans-logger
    mail_table: uclans-mail
    rewards_table: uclans-rewards
  datasource:
    mysql: jdbc:mysql://
    sqlite: 'jdbc:sqlite:'

```