MySQL Implementation & Management

In this week's post I want to briefly discuss leveraging MySQL for WebReports and the steps to take to do so. The main advantage of using MySQL over MS SQL is that MySQL is completely free. If using SQL Express (Free Version of MS SQL), you could be limited based on the WebReports usage due to the 10 GB limit for SQL Express.

Full WebReports Installation Steps Using My SQL

Step 1. Install and Setup IIS

Step 2. Install ASP.NET Core Hosting Bundle

Step 3. Install My SQL Server & MySQL Workbench

Step 4. Adjust the MySQL Data Storage

Step 5. Configure Microsoft Internet Information Services (IIS)

The main steps for leveraging MySQL to run WebReports requires downloaded and configuring MySQL Server and Workbench.

Click here to download the MySQL installer.

Click here to download the MySQL Workbench installer.

The setup process is very straight forward, with minimal changes needed during the install (such as establishing the root password & creating the DB Admin Account).

One of the key things to keep in mind when using MySQL is that the data storage size will need to be adjusted based on the size of reports being queued / downloaded.

Code snippet to adjust the MySQL data storage

Note: If the data storage needs to be larger, add some zeros.

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;