Skip to content

MariaDB/MySQL

rAthena supports both MariaDB and MySQL, and the selection between these two database systems depends on various factors. While both databases are compatible with rAthena, differences exist that should be considered:

Feature MariaDB MySQL
Compatibility with rAthena Compatible Compatible
Performance Generally faster, especially on complex queries; Additional storage engines (Aria, TokuDB, MyRocks) may provide advantages Good performance; Performance may vary with storage engines and configurations
Licensing GPL v2 GPL v2
Replication Galera Cluster for synchronous multi-master replication MySQL Replication with semi-synchronous and asynchronous options
Community & Support Community-driven, with enterprise support from MariaDB Corporation Developed by MySQL AB (now Oracle) with enterprise support available

You can choose either MariaDB or MySQL based on your specific requirements, performance needs, and licensing considerations. Both databases should work well, it's up to you 🐸👌



Installing MariaDB on Windows

Step 1: Download the MariaDB Installer

  1. Visit the official MariaDB website at https://mariadb.org/ and navigate to the "Downloads" section.
  2. Choose the appropriate version of MariaDB for Windows and click on the download link to start the download.

MariaDB Download Page
MariaDB Download Page

Step 2: Run MariaDB Installer

  1. Once the installer is downloaded, locate the file and double-click on it to run the installer.
  2. You may be prompted by Windows to confirm the installation. Click "Yes" to proceed.
  3. Accept the terms of License Agreement.
  4. You will be prompted to choose the features you want to install.
  5. Once you choose the features you want to install, click "Next" to continue.

MariaDB Installer
MariaDB Installer

Step 3: Change User Settings

  1. Tick the "Modify password for the database user "root" and change the password.
  2. Click "Next" to continue.

Change User Settings
Change User Settings

Step 4: Database Settings

  1. You can configure other options like the service name and port number if desired.
  2. Click on "Next" to continue.

Database Settings
Database Settings

Step 5: Ready to Install

  1. Reached this point, the installation will start.

Ready to Install
Ready to Install

Step 6: Complete the Installation

  1. Once the installation is complete, you will see a "Installation Complete" message.
  2. Click "Finish" to exit the installer.

Step 8: Verify the Installation

  1. Search for Mysql Client and run it.
  2. You will be prompted to enter the root password you set during the installation.
  3. If the command-line client opens without any errors, it indicates that MariaDB is successfully installed on your Windows system.

MariaDB Installer
Run Mysql Client

Congratulations! You have successfully installed MariaDB on Windows. You can now start using MariaDB as your relational database management system.

Additional Notes

  • You can find documentation and resources for using MariaDB on the official MariaDB website.
  • Remember to secure your MariaDB installation by creating user accounts with appropriate privileges and configuring suitable security measures.


Installing MySQL on Windows

Last update: 2023-11-04

Comments

Authors: Sapito Sucio