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:

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:'