Knowledge Base

SunLync Technical Guide & System Requirements

Article ID: 565
Last updated: 26 Jun, 2017
Revision: 17
Add comment
Views: 1036
Comments: 0

Copyright Notice

Copyright 2009-2017 SunLync Software, Inc.

All rights reserved.

Registered owners of Select software may reproduce this document for the sole purpose of education and salon management. All other photocopies, reproductions, translations or reduction to any electronic medium or machine-readable form without prior consent in writing from SunLync is forbidden.

Every effort has been made to ensure the accuracy of this guide. However, SunLync makes no warranties with respect to this documentation and disclaims any implied warranties of merchantability and fitness for a particular purpose. SunLync shall not be liable for any errors or for incidental or consequential damages in connection with the furnishing, performance, or use of this manual or the examples herein. The information in this document is subject to change without notice.

Trademarks

Select, Solo, and Solo Plus are U.S. trademarks of SunLync Software, Inc.

Other product names mentioned in this guide may be trademarked or registered trademarks of their respective companies and are the sole property of their respective manufacturers.


Technical Guide

This guide has been made available to you in order to provide detailed information on the infrastructure required to successfully operate the SunLync Select software. You will find helpful information on hardware recommendations, network configurations, and the peripherals that are compatible with SunLync Select within this guide.

As a convenience to you, SunLync has partnered with a PC Connection, Inc. to provide you a resource, to streamline your hardware and peripheral ordering experience. Within this guide, you’ll find PC Connection item numbers which serve as a baseline for hardware that would work with SunLync . If you have any additional questions regarding the ordering process, you can reach out to Justin Vieira at 800-800-0014 x34186.


Computer Recommendations


SunLync Select is built on client/server technology. This means that two computer programs communicate with one another to store and retrieve information. The client software makes a service request from the server software, and the server software then responds with the requested information to the client.

The server component of SunLync Select is a MySQL database that resides on the server. All data is housed and processed on that system. The type of server that you will need is determined by the number of salons and workstations that will be connecting to that server.

The client component of SunLync Select resides on a workstation. A workstation is nothing more than a standard computer. However, since the client does not have the same type of processing and connection needs as the server, the workstation does not need to be quite as powerful.


Workstation Recommendation


  • Windows 7 Professional; Windows 8 Professional; Windows 10 Professional operating systems

  • Dual Core Processor (Intel Core i5 or higher)

  • 8GB RAM recommended

  • 128 GB Hard Drive or larger

  • 16:9 or 16:10 Widescreen Monitor with resolution of at least 1366 x 768

  • Microsoft Word (full installed version) is required in order to take advantage of the SunLync electronic document process.

Note: Please consider the amount of USB peripherals and available USB ports, when considering a workstation purchase. The use of USB hubs may not be supported.


PC Connection Recommendation


HP Workstation [ Good: K1K49UT#ABA; Better: G5R59UT#ABA; Best: J6D7BUT#ABA ] HP Monitor [ E2T0BAB#ABA ] Lenovo Workstation [ Good: 10B60009US; Better: 10B60008US; Best: 10AM000AUS ] Lenovo 4GB Memory [ 0A65729 ]


Server Recommendation


The server specifications outline below are suggestions. SunLync highly recommends that you consult with your IT professional on the best hardware configuration for your server. The more salons that you have, the more memory that you will want to add to your server. Fast hard drives configured properly by an IT professional will also increase performance of the server.

Single Store

The following server specification would be sufficient for a single salon. We recommend that the Point of Sale workstation be separate from the server.

Z

  • Windows 7 Professional; Windows 8 Professional, Windows Server 2012 or newer operating systems
  • Dual Core Processor (Intel Core i5 or higher)
  • 8GB RAM recommended
  • 512 GB Hard Drive or larger (consider storing MySQL data on a separate drive or partition)
  • Backup Device to be used for backups of MySQL Data
  • 16:9 or 16:10 Widescreen Monitor with resolution of at least 1366 x 768

PC Connection recommendations: As part numbers for servers consistently change more regularly than workstations, contact PC Connection for additional information regarding server purchases.

Multiple Stores

To help you to determine the specifications for the server that will be used within multiple salon operations, you will find recommendations below.

9k=

2 - 10 Stores (Database Server Suggestion)
  • Windows Server 2012 or Newer (Please consult your IT professional for other options)
  • Latest Intel multi Core Processor or better
  • 8-16 GB ECC RAM
  • 500 GB Hard drives in raid configuration
  • Server Grade Network adapters
  • 16:9 or 16:10 Widescreen Monitor with resolution of at least 1366 x 768
  • UPS Backup Device, to protect against a power outage

PC Connection recommendations: As part numbers for servers consistently change more regularly than workstations, contact PC Connection for additional information regarding server purchases.

11 - 30 Stores (Database Server Suggestion)
  • Windows Server 2012 or Newer (Please consult your IT professional for other options)
  • Latest Intel multi Core Processor or better
  • 16-32 GB ECC RAM
  • 1 TB Hard drives in raid configuration
  • Server Grade Network adapters
  • 16:9 or 16:10 Widescreen Monitor with resolution of at least 1366 x 768
  • UPS Backup Device, to protect against a power outage

PC Connection recommendations: As part numbers for servers consistently change with technically more regularly than workstations, contact PC Connection for additional information regarding server purchases.

30+ Stores (Database Server Suggestion)
  • Windows Server 2012 or Newer (Please consult your IT professional for other options)
  • Latest Intel Xeon multi Core Processor or better
  • 32-64 GB ECC RAM
  • 2 TB Hard drives in raid configuration
  • Server Grade Network adapters
  • 16:9 or 16:10 Widescreen Monitor with resolution of at least 1366 x 768
  • UPS Backup Device, to protect against a power outage

PC Connection recommendations: As part numbers for servers consistently change more regularly than workstations, contact PC Connection for additional information regarding server purchases.


Server Recommendations


The following options are not required to use SunLync Select on your server, but you may want to consider following the guidelines outlined below:

  • Install an external USB drive or utilize a cloud based backup solution for backups.
  • Store MySQL data on partition separate from your operating system.
  • Use a RAID configuration for MySQL data.
  • Virtualization Technologies from VMware and XenServer can be used. Please consult with your IT professional on these technologies.

MySQL Database Recommendations


SunLync Select is compatible with the MySQL Community Edition of MySQL; however we highly recommend for a multi-salon environment that you purchase MySQL directly from MySQL. You can purchase installation support along with extended support. SunLync Select Versions 8.0 and higher are compatible with 5.5 +. MySQL configuration of any kind, including replication setup, is outside of the SunLync support services. Please have a qualified IT professional install, configure and maintain MySQL on your server.

Report Server Recommendation

In a multi-salon environment reports can be very taxing on server performance dependent upon the type of report run, when the report is run, and the amount of data that the report is requesting. For this reason we recommend the use of a second server for reports if necessary. MySQL replication can be setup to automatically update a second server. As noted above, SunLync highly recommends that you consult with your IT professional, or directly with MySQL, for information on how to set up replication. SunLync support is unable to assist with as this is outside the scope of our support services.


Network/WAN


The following are some suggestions for broadband Internet speeds. To verify your current download and upload speeds, go to http://www.dslreports.com/speedtest

  • Server Location: 10-50 Mbps download and 1-10 Mbps upload speed and a static IP Address.
  • Other Locations: 5-20 Mbps Mbps download and 1-10 Mbps upload*. Static IP addresses at remote locations are recommended.

It is recommended that you establish a Virtual Private Network (VPN) connection or use SSL between your salon location(s) and the server location with a dedicated DNS server. For security and PCI compliance purposes, this is imperative.

Using a VPN connection will help you to control the systems that can connect to your server. This type of connection uses the Internet to connect remote sites or users together. Instead of using a dedicated, real-world connection such as a leased line, a VPN uses virtual connections from the company's private network through the Internet to a remote location.

Additionally, if a user wants to connect to the SunLync Select database from outside the salon, again a VPN or SSL is a must for Payment Card Industry compliance. For more information on PCI compliance please visit:

https://www.pcisecuritystandards.org/security_standards/download.html?id=pci_dss_v1-2.pdf

For assistance with choosing a VPN solution or enabling SSL, please consult your IT representative.

Please be advised that VPN connections and SSL are outside the scope of SunLync support services. We highly recommend that you consult with an IT professional with regards to the best solution for your needs. SunLync is unable to assist with setting up or troubleshooting any network or VPN connection.

We highly recommend the use of a wired network as opposed to a wireless network in your salons – wireless networks can have a slower transfer rate as well as an unstable connection. Choosing a wired network not only gives your salons a stable network connection, but offers increased security that a wireless network cannot offer.

Firewall

Most modern systems will include some kind of firewall solution, meant to protect your system from unwanted connections. Please use the following information when configuring any associated firewall.

  • The MySQL database uses port 3307. Any workstation using SunLync Select must be able to connect to the server on this port.
  • The SunLync Timer Server uses port 6005. This port should be available to any workstation in that system’s location. All other workstations should allow connections out to the Timer Server workstation.

If you do not know how to configure your firewall, please contact your IT Professional, as SunLync Support does not configure firewalls, routers or networks.


Proper PC Management


You are responsible for maintaining all PCs that will be running SunLync. The use of good Anti-Virus software is a must. The PC must be maintained by keeping Windows updated with all the latest security patches available. The SunLync support team will NOT assist with PC maintenance. If the PC running SunLync is infected with a virus, malware or worm, the salon must have it properly removed before SunLync can support the SunLync Select software running on the PC.


Test Environment


When using the SunLync Select software we recommend that you configure a test environment. This will be extremely helpful to you, especially when evaluating new versions of SunLync Select prior to upgrading your salon(s). For more information on the importance of establishing a test environment within your organization, please refer any inquiries to the SunLync support team.


Peripherals


The use of the following hardware devices are supported with SunLync Select:

Timer Systems

SunLync is compatible with the following timer systems:

  • T-Max

  • Intellitan

SunLync does not currently offer timers or timer managers for sale, and cannot support their operation. Some timer systems use new technology and work better than others.

*If utilizing a T-Max or Intellitan Timer Manager system, the following items must be completed prior to interfacing with the SunLync T-Server program:

  • The Timer Manager must be connected to your workstation via a serial cable (or a serial cable with a serial to USB adaptor, depending upon your workstation configuration)
  • The proper drivers must be installed
  • Confirm that test times can be successfully sent to all equipment types via the Adnet program

Report Printers

SunLync Select will work with most any Windows compatible printers. The printer must be 100% compatible with your version of Windows to work properly. [PC Connection Part #: Check with PC Connection for different options based on your needs]

Receipt Printers

SunLync Select is currently compatible with the following Receipt Printers:

  • Star TSP100 Series (USB) [PC Connection Part #: 17074006]

Although other receipt printers may function correctly, we cannot guarantee their operation.

F4TQaqQFFTfLAAAAAElFTkSuQmCC

Cash Drawers

SunLync Select supports any MMF Cash Drawer that connects to the supported receipt printers listed above.

  • Advantage MMF Cash Drawer (18” x 16.7”) [PC Connection Part #: 10711017]
  • Cash Drawer Receipt Printer Cable [PC Connection Part #: 5763445]

Z

Biometrics

Digital Persona U.are.U 4500 thumbprint scanner [PC Connection Part #: 9275545]

No other biometric device is supported for use with the SunLync Select software at this time. Please contact SunLync support prior to installing any biometrics device!

9k=

Cameras

Any digital camera with a Windows driver will allow you to capture customer images and store them in SunLync Select. No particular device is required.

Signature Pads

SunLync Select has been tested and confirmed to work correctly only with signature pads manufactured by ePad. Most signature pads that interface with Microsoft Word will also work with SunLync Select, but are not supported. [PC Connection Part #: 5470319]

*Please note that a fully installed version of Microsoft Word is required in order to take advantage of SunLync's electronic document process

Barcode Scanners

SunLync Select has been tested and confirmed to work correctly with the following Barcode Scanner:

  • ID TECH USB Barcode scanner (non 2D compatible) [PC Connection Part #: 11984148]
  • Motorola Symbol DS9208 2D Barcode scanner [PC Connection Part #: 13126745]

Note: If you plan to use the driver’s license scanning feature, you may need to purchase a barcode scanner that supports 2D barcodes. Although some US States comply with AAMVA standard, we cannot guarantee the result of the drivers’ license scanning feature for states that do not.
 

2Q==
 

Pole Displays

SunLync Select is currently compatible with the following Pole Displays:

  • POS-X XP8200U [PC Connection Part #: 16026766]

Although other pole displays may function correctly, we cannot guarantee their operation.

9k=

As SunLync software is a software development company, our primary focus is on the development of software specifically for the indoor tanning industry. We do not support hardware issues associated with presently installed hardware that does not meet recommended specifications.

System Security


Due to the nature of computers and networks, many administrators need additional security settings for their SunLync Select installation. We highly recommend that such options be enabled, but you must remain aware that certain settings are required for the proper operation of the SunLync Select software. In Windows, the following security settings are required:

  • The SunLync Select server must accept incoming connections and be able to transmit data on port 3307 for the TCP protocol.
  • The PC with the Timer system connected must accept incoming connections and be able to transmit data on port 6005 for the TCP protocol.
Failure to configure the system to use these security options will prevent the SunLync Select software from operating correctly. SunLync Support will be unable to assist you in the resolution of any issues should these settings not be configured as listed. By changing such settings, you accept all responsibility for maintaining the SunLync Select software.
 

Prevention and Disaster Recovery

Although no one can determine how and when a given system may fail, awareness of and preparation for the most common disastrous events can assist you in recovering from such events. This holds true for SunLync Select software and its associated hardware components as it does for any system.
 

The key to surviving a disaster is prevention. After all, if you can keep a disaster from occurring in the first place, you would have no need to recover.

How to backup MySQL

The most important component of your SunLync Select system is the MySQL database that stores your customer’s information. It is imperative that this data be maintained and remains available at all times. Without it, not only will the software not operate, but your valuable information would be lost. With this in mind, we highly recommend that you backup your MySQL data on a regular schedule, if not daily.

SunLync is not responsible for generating or configuring backups! We can, however, suggest the following methods:

The `MySQLDump` Command

You can manually backup the databases from the command line by using the mysqldump command. There are a number of options associated with this command that will help you process the information. The recommended options are detailed below.

The basic command for MySQLDump is:

mysqldump databasename > dumpfile.dump

Replace the databasename with the name of the database that you want to backup and dumpfile.dump with the name of the backup file to be created.

There are some additional options that you can use with mysqldump to help speed up the process. Such a command may appear similar to the following:

\bin\mysqldump --user=sunlync --password --host=XXX.XXX.XXX.XXX --compress --opt --quote-names sunlync > c:\sunlync.dump
 

The following information describes each setting in detail:

  • mysqldump

    • command to create dump file.

  • --user=sunlync

    • The username used to connect to the database. Some options require you to use the root username to create the dump file. We recommend that you do so if possible.

  • --password

    • Allows the password prompt to appear after the command is run. Use this if a password exists for the account, such as for the sunlync user.

    • After completing the mysqldump command, you will be prompted to enter your password. The prcoess will be halted until a correct password has been entered.

  • --host=XXX.XXX.XXX.XXX

    • The IP address or host name where the server is located. You can remove this option if you are running the backup on the server itself. Please only use the -- host command if your server is local. DO NOT try to back up a MySQL server across the Internet.

    • Examples: --host=192.168.1.50, --host=localhost, --host=10.0.10.230, etc.

  • --compress
    • Reduces the size of packets sent to and from the systems involved. This is not necessary if running the backup on the server.
  • --opt

    • Speeds up the dump process and makes it easier to recreate the database. This option can only be used if the user has the LOCK TABLES privilege. Note that the sunlync user does not have this privilege, and thus cannot use this option.

  • --quote-names

    • Puts database, table, and column names in single quotes. This helps avoid any cases where a table name is the same as a MySQL command or if the table name includes unusual characters.

  • sunlync
    • The name of the source database.
  • c:\sunlync.dump

    • The name of the target dump file. We usually save these in the format SalonName_YYYYMMDD.dump

    • Example: TanningSalon_20160101.dump

To use the MySQLDump command, follow these steps:

  1. Open a Command Prompt window.

  2. At the prompt, change to the MySQL directory. Usually you can just type cd c:\mysql\bin and press enter. Modify this depending on your installation.

  3. Enter the mysqldump command using any appropriate options and press Enter. You may want to copy and paste the command as indicated above.

  4. You will be prompted to enter the password for the database. Do so, and press Enter. The dump file will then be created.

It may take some time before the dump is completed. Always make sure that the dump completes successfully by using that dump file to create a new database.

Copy the MySQL Database Folders

Backups can also be performed by copying the data folders. Since this requires stopping the mysql service, this method is not recommended for regular backups. Use the following steps to copy the folders: 

  1. Right-click the MySQL Service and choose Stop.
  2. Find the folder where the MySQL data is stored. The default location is C:\ProgramData\MySQL\MySQL Server 5.x\data (Please consult with your IT professional on where this folder is located as it may have been installed in the non-default location)00000000
  3. Copy the sunlync, mysql and other db folders from the data folder to your backup device.
  4. Restart the MySQL service

Please do not hesitate to contact us should any questions arise regarding information contained within this guide, or for inquires about our implementation and support procedures.

Additionally, as a member of the JK Products and Services family, please feel free to let us know if you have bed, lamp or leasing needs, as we would welcome the opportunity to put you in contact with someone who would be more than happy to assist you!

If you haven’t already done so, follow us on Facebook and Twitter for regular member only contests and promotions, as well as important updates about the SunLync Select software!

This article was: