RedTail Specifications

RedTailSQL is built using one of the world's most popular and robust database management systems - Oracle MySQL.

Minimum Server Requirements:

  • RedTailSQL is a 64-bit application only
  • Operating Systems: Windows 10, Windows 11, Windows Server 2019 or Higher
  • Processor: Intel Core i3 10the Generation or Higher or AMD equivalent
  • Memory: 16GB RAM
  • Hard Disk Space: 30GB free disk space

 

Recommended:

  • For businesses with 4 or more stations running RedTail POS and/or related modules, dedicated server running either Windows server  or desktop O/S
    • Windows 10, Windows 11, Windows Server 2019 or Higher
    • 16GB RAM
    • MySQL Server configured for Innodb database and 50% memory usage
  • For businesses with 10 or more stations running RedTail POS and/or related modules, dedicated server running Windows server  operating system
    • 32GB RAM
    • MySQL Server configured for Innodb database and 50% memory usage
    • MySQL Server configured for 50% memory usage
  • For businesses with 10 or more stations running RedTail POS and/or related modules, in a shared server environment
    • Windows Server Software 2019 or Higher
    • 64GB RAM or higher
    • MySQL Server configured for Innodb database and 50% memory usage
  • Processor: Intel Core i5 10th generation or higher or AMD equivalent
  • Hard Drive: NvME drive or Solid State Drive, In addition to RedTail storage space, free drive space may need to consider a network servers requiring a percentage of free space for overall performance

Configuring RedTailSQL Server:

RedTailSQL server contains the royalty free license Oracle MySQL release 8.0.32. This is bundled as pre-requisite software which first requires installing and configuring the Oracle MySQL instance.

Download and install the latest release of RedTailSQL.

Installing Oracle MySQL:

  • Launch RedTailSQL
  • Install the pre-requisite software - Microsoft Visual C++ 2015-2022 Redistributable (x64) - 14.34.31938
  • Install the pre-requisite software  - Oracle MySQL Connector/ODBC 8.0 Release 8.0.14. Install
  • Install the MySQL software release 8.0.32 and configure the MySQL instance
    • The installer will prompt for an instance password. You must remember the password you use in order to continue with future components of the installation
  • Edit the my.ini file that Oracle MySQL installs as part of the server software configuration.
  • NOTE! TO OPEN EDIT THE MY.INI FILE, YOU MUST LAUNCH NOTEPAD BY RUNNING AS ADMINISTRATOR
  • By default the file is located in the following path C:\ProgramData\MySQL\MySQL Server 8.0\my.ini
  • Press the Ctrl-F key sequence to open the search tool
  • Enter 151 in the search field and press the ENTER key
  • You should be taken to the following line
    • max_connections=151
    • If you have a single station or small network Replace 151 with 500
    • If you have a network running 4 or more RedTail stations replace 151 with 1000
      • It is not recommended to set this too high
  • Return to the search field by pressing Ctrl-F to perform the next search
  • Enter innodb_buffer_pool_size in the search field and press the ENTER key
  • You should be taken to the following line
    • innodb_buffer_pool_size=128M
      • This is the setting that tells MySQL how much system memory to use
    • Replace the 128M with the following
      • 4G if you have a server or PC with 8GB RAM
      • 8GB if you have a server or PC with 16GB RAM
      • 16GB if you have a server or PC with 32GB RAM
      • 32GB if you have a server or PC with 64GB RAM
  • NOTE! If you are running a network server where RedTailSQL is not the only application you can set this memory setting lower to allow for more memory to be allocated to other applications. For example, on a 64GB server running multiple apps set the memory to 20GB.
  • Return to the search field by pressing Ctrl-F to perform the next search
  • Enter sql-mode in the search field and press the ENTER key and continue until you are taken to the following line
    • sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  • Replace wth the following line (Be very careful recording this line - it needs to be exactly as follows)
    • sql-mode="NO_AUTO_VALUE_ON_ZERO"
  • Save the my.ini
  • Restart the RedTailSQL Windows service via Windows Control Panel

From Within Windows Control Panel Set to Large Icon View and Locate the Windows Tools icon (formally Administrative Tools in Windows 10)

Locate and Open the Services Applet

Scroll Until You Locate the RedTailSQL Windows Service. Highlight the Service
NOTE! The RedTailSQL Service may have a different name if you specified a different name during setup

Stop and Start the Service for the Revised My.ini Configuration To Take Effect

Note the Service as Running Before Leaving Control Panel. If the Service is Not Able to Start It Means That You Have a Syntax Error Within Your Revised My.ini File

You Are Now Ready To Use RedTailSQL Server. Proceed with the RedTail Workstation Express Installation