MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

© Jesper Wisborg Krogh 2018

Jesper Wisborg KroghMySQL Connector/Python Revealedhttps://doi.org/10.1007/978-1-4842-3694-9_5

5. Connection Pooling and Failover

Jesper Wisborg Krogh¹ 

(1)

Hornsby, New South Wales, Australia

 

In the two previous chapters, you went through the workings of MySQL Connector/Python from a query point of view. It is time to change the topic a bit and look at some of the more advanced connection features: connection pooling and failover.

Tip

There are several example programs in this chapter. All example programs that appear in a listing are available for download. See the discussion of example programs in Chapter 1 for more information about using the example programs.

Connection Pooling – Background

Connection pooling makes it ...