Manual Database Configuration

Database

1. Install MySQL or MariaDB

   • MySQL minimum required version - 5.7.17+
     • When installing on the same instance the ACE server will run on (recommended), select "Server Machine" as the server type.
     • The optional "MySQL Workbench" application can be used to interface with the database to apply new and updated .sql files.
     • If you would like to add automated DB backups to your Windows-MYSQL DB (https://github.com/KT053374/MySQL_Auto_Backup_Windows)
   • MariaDB minimum required version - 10.2+
   • Optionally install SQLYog editor on Github for the following steps

2. Create three databases named ace_auth, ace_shard, and ace_world

3. Load AuthenticationBase.sql and ShardBase.sql for their respective databases. These can be found in the Database\Base directory.

4. Load all incremental SQL updates found in the Database\Updates\Authentication sub directory in the order of oldest to newest. Skip this step if there are no updates in this directory.

5. Load all incremental SQL updates found in the Database\Updates\Shard sub directory in the order of oldest to newest. Skip this step if there are no updates in this directory.

6. Download the latest release of world data, extract and load into your ace_world database.

7. SKIP THIS STEP IF USING DOWNLOADED WORLD DATA FROM PREVIOUS STEP.

   • If using a custom database, you may need to update the schema for the emulator to operate correctly. If you're using the official release data, this step is not recommended.
   • Load WorldBase.sql from Database\Base into your ace_world database
   • Load all incremental SQL updates found in the Database\Updates\World sub directory in the order of oldest to newest. Skip this step if there are no updates in this directory.

Recommended Database Configuration

• inno_db_buffer_pool_size This setting can have a significant impact on your database performance. The minimum size recommended for a public server is 2G. As the server approaches 500+ active players, the recommended buffer pool size will grow to over 5G. You will need to manage the memory consumed by your database and the ACE server vs the total system memory available. The buffer pool size should not exceed more than half of your total system memory. Using about 25% of your system memory for the buffer pool is a likely safe number for a common ACE configuration, assuming your system is provisioned at or greater than the recommended system requirements described above.