The Awesome Miner database stores mining history (hash rate, power, uptime, ...) and user activity. By default Awesome Miner stores two database files in the same folder as the configuration files. 

When deploying Awesome Miner in large scale mining operations where the mining history is stored for a longer period of time, the amount of data becomes large. To improve performance when using the Mining History feature, an external SQL server can be used.

Awesome Miner supports the following SQL server software:

Preparing SQL server

This guide assumes that either a MySQL server or a MariaDB server is already installed. These SQL servers can either run on Windows or Linux - either on the same computer as Awesome Miner or on a separate computer. To prepare the Awesome Miner database on the SQL server, use a SQL client tool to execute SQL queries. These tools are available on both Linux and Windows.

Please note that the SQL client application is not required to be installed on the same computer as Awesome Miner because it will not be used by Awesome Miner. The SQL client is only required to create the Awesome Miner database and user account.

Linux client (Ubuntu)

This guide assumes that you run the SQL client on the same computer as the SQL server. Run the following commands to connect to the local SQL server:

sudo apt install mysql-client
mysql -h 127.0.0.1 -u root -p

When prompted for the password, enter the root password.

Windows client

This guide will not describe how to install a SQL client and connect to a SQL server on Windows. There are many SQL client applications with a graphical user interface available for Windows. One example is HeidiSQL. 

SQL commands

Once the SQL client application is connected to the SQL server, execute the following commands.

CREATE DATABASE awesomeminer;
CREATE USER 'awesomeuser'@'%' IDENTIFIED BY 'awesomepass';
GRANT ALL PRIVILEGES ON awesomeminer.* TO 'awesomeuser'@'%';

The commands above will create a database called awesomeminer. This name cannot be changed. In addition, a new database user called awesomeuser with the password awesomepass is being created and given access to this database. This username and password can be changed in the SQL statements above. The recommendation is to set a more secure password than being used in this example. The username and password created here will be entered in the Awesome Miner application in the next step.

Configure Awesome Miner

The SQL server is configured in the Awesome Miner Options dialog, History section. Select MySQL/MariaDB and specify the hostname of the SQL server together with the username and password created in the previous step.

Use the Verify button to test the connection to the SQL server. The result will be displayed as a message box with one of the following messages:

  • Connection successful
    Awesome Miner has been successfully configured
  • Connection failure
    Awesome Miner was unable to establish a TCP/IP connection to the specified SQL server
  • Authentication failed
    Awesome Miner was able to connect but the specified username and password are not accepted
  • Access denied
    Awesome Miner was able to connect and login to the SQL server but unable to gain access to the database called awesomeminer.
  • General failure
    Any other error will display this message

Troubleshooting

  1. Use the Verify button in the Options dialog, History section, to get an specific error message indicating what the problem might be
  2. Use a SQL client application to connect to the SQL server. This will verify if the connection is possible to establish and can rule out any issues specific to Awesome Miner
  3. For SQL server running on Linux, verify that the SQL server process is configured to accept connections from non-local clients, in case Awesome Miner and the SQL server is running on separate servers. Use "netstat -nlp" on Linux to check if the SQL server process is configured to only listen to local connections.