Add support for MariaDB/MySQL or another DB engine for scalability

Avatar
  • updated
  • Archived

The weakest link seems to be the SQLite DB. Once the DB gets to 1GB size, the SC application becomes unstable.

Duplicates 3
Actually Support MS SQL

When we piloted ScreenConnect several years ago, we worked with the SC team and installed using MS SQL Standard because of complications/limitations for our reporting and concurrent access needs with the built-in SQLite DB.


On two separate occasions, support has been utterly and completely useless in supporting the application because of the DB flavor. While I would not expect the support team to support the DB layer, I would still expect full support of the application.


Please either officially support MS SQL or provide reference architecture or whatever else is necessary so that it is a "supported configuration."


Given that we've been running it for going on 3 years, I wouldn't think much is necessary from a technical perspective.

MSSQL

Official support for MSSQL database instead of SQLite would make large on-prem deployments much more manageable.  

Officially Support SQL Server
Avatar Sol

Right now MS SQL Server is not officially supported, but generally works with support in the forums. It would be nice to see full support for MS SQL including SQL Clustering and Always On HA.

Avatar
2
Alex Heylin

PLEASE do this! The existing SQLite DB engine is a real problem. Even when DB size is low it's not great - as DB size grows it becomes a nightmare. Try running 90 day advanced auditing - every time server is restarted SC does 30-60 mins of DB maintenance before it's usable. Please also give option NOT to ryun DB maintenance on start up. Currently I'm trying to run an audit report of 30 days of basic auditing and it dies because there's too much data.

Avatar
2
Alex Heylin

I just had my session.db corrupt because I was trying to read the session data for reporting and the DB browser died. This NEVER happens with proper DB engines. Thankfully that file only contains a month of auditing data that my boss wants a report on by the end of the day... Nothing important then! :-(

Avatar
0
anonymous
  • Pending Review
Avatar
0
anonymous
  • Pending Review
Avatar
2
RLMC

Definitely needed! Our installation is struggling with SQLLite.

Avatar
1
r peters

This is a definite need - we use 5.6 right now on a MSSQL server and it handles A LOT better than SQLite could ever do!

Avatar
0
Tony

I will second that, R.peters. We use an MSSQL as well now and the performance difference is quite large. SQLite was always a bottleneck as the DB grew to thousands of sessions, and frequently gave us problems during SC upgrades. Many of our clients require us to send them scheduled reports that tell them which of our admins has accessed their machines, when, and why. MSSQL has allowed us to easily create SSRS audit reports to meet this need, and having this officially built-in would be fantastic.

Avatar
0
lbegnaud

Agreed.

There is a forum post about doing this, but AFAICT it's not officially supported or even documented:


http://forum.screenconnect.com/yaf_postst4414_Microsoft-SQL-Server-Support.aspx

Avatar
0
Steven P

This should be a high priority the linux version realy would be much better off with mysql

If this is running colo on the labtech server then their already is an mysql server to work with.


The sqllite code just cant handle the load, i cant even view my audit logs becuase the job times out

Avatar
0
HLA

Really need this functionnality !

 Commenting is disabled

Top contributors

Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar
Avatar