Connection pooling, rate limiting, and timeouts for SQL

Although the database/sql package provides support for connection pooling, rate limiting, and timeouts, it's often important to tweak the defaults to better accommodate your database configuration. This can become important when you have horizontal scaling on microservices and don't want to hold too many active connections to the database.

Getting ready

Refer to the Getting ready section in the Using the database/sql package with MySQL recipe.

How to do it...

These steps cover writing and running your application:

1. From your Terminal or console application, create a new directory called ~/projects/go-programming-cookbook/chapter6/poolsand navigate to this directory.
2. Run the following command:

          $ go mod init github.com/PacktPublishing/Go-Programming-Cookbook-Second-Edition/chapter6/pools

        

You should see a file called...