Announcing Network and SQL Connectivity Tests
Sam Aybar
Aug 25, 2022Today we are excited to announce two new connectivity test tools to make connecting to PolyScale easier. These tools test if PolyScale is able to access your SQL database from all of PolyScale’s Points of Presence (PoPs).
Network Test
Firstly, when you create a new cache, a Network Test runs automatically, to ensure that PolyScale can make a simple TCP connection from each edge location to your database.
If your database is not publicly accessible (and we would hope it is not!), typically firewall allow-lists need to be updated to allow connectivity from each PoP’s source IP. If this is being done manually, it’s easy to make mistakes so this utility is ideal to validate that the rules are correct.
TIP: It’s always a good idea to add all PoP source IP addresses to your firewall, even if you don’t intend to use them. This means in the unlikely event of a region outage, PolyScale will route the traffic via the next closest PoP.
SQL Test
In addition to the Network Test, we also offer the ability to run a SQL Test. With this tool, you are able to confirm that PolyScale can make an actual SQL connection and query against your database. To run the test, simply enter your database username and password, the name of the database, and the query you’d like to run. (PolyScale will not store any of this information – it is only used to make the query). This test is ideal for validating database user permissions which may be restricted to specific hosts or databases.
You can access our SQL Connectivity Test from the Connect tab within any cache. Try it today.
New to PolyScale?
PolyScale is a no-code, database edge cache service that distributes data and query compute, closer to the user. You can see a quick demonstration of how PolyScale can make your database more accessible globally at the PolyScale Playground.