Comments on: How Life360 Used ProxySQL to Lower Its Database Load https://www.percona.com/blog/life360-used-proxysql-lower-database-load/ Tue, 06 Aug 2019 20:04:05 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: sherry https://www.percona.com/blog/life360-used-proxysql-lower-database-load/#comment-10968425 Wed, 06 Sep 2017 08:19:43 +0000 https://www.percona.com/blog/?p=44879#comment-10968425 In reply to Nils.

understood, thank you Nils

]]> By: Nils https://www.percona.com/blog/life360-used-proxysql-lower-database-load/#comment-10968424 Wed, 06 Sep 2017 07:39:12 +0000 https://www.percona.com/blog/?p=44879#comment-10968424 In reply to sherry.

As far as I understand it they set up another MySQL instance and configured ProxySQL to forward Pings to that instance. They instead found out that ProxySQL can itself answer the pings, saving a round trip when deployed locally.

]]> By: sherry https://www.percona.com/blog/life360-used-proxysql-lower-database-load/#comment-10968421 Wed, 06 Sep 2017 02:08:31 +0000 https://www.percona.com/blog/?p=44879#comment-10968421 Nice sharing, what does “decoy” MySQL instance mean?

]]> By: Nils https://www.percona.com/blog/life360-used-proxysql-lower-database-load/#comment-10968419 Tue, 05 Sep 2017 12:45:06 +0000 https://www.percona.com/blog/?p=44879#comment-10968419 I would have thought that PHP will issue a COM_CHANGE_USER once it re-uses a connection from the pool (I don’t know how clever the implementation actually is, e.g. does it only store file descriptors hashed by server or the whole combo of server + user + db), but the COM_PING is pretty asinine, often made worse by the fact that most PHP Frameworks don’t actually handle Database errors very well…

Running a local SQL Proxy usually makes sense just for the sake of improved connection pooling.

]]>