A case study on how we redesigned our client’s system to improve the RADIUS server’s database, which had lost performance over time. The database performance was restored, even with ten times the amount of data, and our client did not need to replace any systems.
Project description
Our customer had installed a basic RADIUS server with an SQL database backend. After a few months, the system slowed down to an unacceptable performance level.
How we solved it
Our approach
We redesigned the customer’s system to increase the efficiency of the RADIUS server’s database use. We added tables and indices and updated the RADIUS SQL queries to use the new system. We lowered the load on the SQL server by a factor of 400, which meant that the customer could continue using their existing systems, instead of replacing them.
The results
The final system regained the performance level that the customer had originally seen. It retained that performance level even with ten times as much data in the SQL database as before.
Need more help?
InkBridge Networks has been at the forefront of network security for over two decades, tackling complex challenges across various protocols and infrastructures. Our team of seasoned experts has encountered and solved nearly every conceivable network security issue. If you're looking for insights from the architects behind some of the internet's most foundational authentication systems, you can request a quote for network security solutions here.
Related Articles
High availability and performance
Building a RADIUS system that can handle 10 million users takes time. Our experienced team can work with you to design a customized solution using your desired hardware and Operating System to achieve that goal. Having a High Availability (HA) system means that system uptime (and therefore customer experience) is unaffected when a piece of the system fails.
User Authentication Performance
The current Covid-19 crisis has created an unprecedented situation for businesses. More people are working remotely than ever before, in order to maintain corporate productivity in the face of this crisis. This remote access applies to Enterprises, Government agencies, Universities, and every other type of business.