Storage

Choose where AscendSMP keeps player data, with zero-setup SQLite by default and MySQL as an option.

AscendSMP remembers each player's abilities, levels, kills, and deaths. That data has to live somewhere, and the storage section of config.yml decides where. See Configuration for the rest of the file.

Choosing a backend

storage:
  # SQLITE (default, no setup) or MYSQL.
  type: SQLITE

Type	What it means
`SQLITE`	The default. Everything is stored in a single file inside the plugin's folder. Zero setup: it just works.
`MYSQL`	Stores data in a MySQL database server instead. Needs the connection details below.

💡

Stay on SQLite unless you already run a MySQL server or need to share player data across several servers. For a single server, SQLite is simpler and has nothing to configure.

MySQL settings

If you set type: MYSQL, fill in the storage.mysql block:

storage:
  type: MYSQL
  mysql:
    host: localhost
    port: 3306
    database: ascendsmp
    username: root
    password: ''
    table-prefix: 'ascend_'
    pool:
      max-pool-size: 10
      connection-timeout: 30000

Option	What it does
`host`	The address of your MySQL server.
`port`	The port MySQL listens on (`3306` is the usual default).
`database`	The name of the database the plugin should use.
`username`	The MySQL account name.
`password`	That account's password.
`table-prefix`	Text added to the front of every table name. It lets several plugins share one database without their tables clashing.
`pool.max-pool-size`	The most database connections the plugin will keep open at once. The default of `10` is fine for almost everyone.
`pool.connection-timeout`	How long (in milliseconds) to wait for a connection before giving up. `30000` is 30 seconds.

The MySQL driver and connection pooling library are downloaded automatically on startup; you do not need to install anything extra.

When data is saved

Player data saves in the background while the server runs, so gameplay is never held up by the database. On shutdown, everything left in memory is flushed safely before the plugin turns off. There is nothing you need to do.

ℹ️

Changed the storage settings? Apply them with `/ascend reload` or a restart. See [Commands](/docs/commands/) for the reload command.

If storage misbehaves, ask on Discord: discord.arrowtan.cc. Common questions are covered in the FAQ.