duancai7002 2018-09-16 11:11
浏览 153

建立与Azure PostgreSQL的连接的PDO非常慢

I have PHP application running as a Docker container based on Alpine Linux inside Kubernetes. Everything went well until I tried removing container with test database and replacing it with Azure PostgreSQL. This led to significant latency increase from under 250ms to above 1500ms.

According to profiler most time is spent in PDO constructor which is establishing connection to database. The SQL queries themselves, after connection was established, then run in about 20ms.

  • I tried using IP instead of address and it was still slow.
  • I tried connecting from container using psql and it was slow (see full command below)
  • I tried DNS resolution using bind-tools and it was fast.
  • Database runs in same region as Kubernetes nodes, tried even same resource group, different network settings and nothing helped.
  • I tried requiring/disabling SSL mode on both client and server
  • I tried repeatedly running 'select 1' inside an already established connection and it was fast (average 1.2ms, median 0.9ms) (see full query below)

What can cause such a latency? How can I further debug/investigate this issue?

psql command used to try connection:

psql "sslmode=disable host=host dbname=postgres user=user@host.postgres.database.azure.com password=password" -c "select 1"

Query speed

\watch 1
  • 写回答

1条回答 默认 最新

  • doubingling4706 2018-12-18 13:21

    As far as I can tell it is caused by Azure specific authentication on top of PostgreSQL. Unfortunately Azure support was not able to help from their side.

    Using connection pool (PgBouncer) solves this problem. It is another piece of infrastructure we have to maintain (docker file, config/secret management, etc.), which we hoped to outsource to cloud provider.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



    • ¥15 VB6.0中PICTUREBOX加载本地图片无法显示
    • ¥100 关于游戏app session获取的问题
    • ¥15 MYSQL数据库建表
    • ¥15 爬虫程序爬取TTGChina网站文章代码
    • ¥35 由于系统缓冲区空间不足或队列已满,不能执行套接字上的操作。
    • ¥15 如何用下图方法在AMESim中搭建离心泵模型
    • ¥15 C#连接服务器,请求时报Ssl/Tsl未能建立安全通道
    • ¥15 xcode15build的c++ dylib在10.15上不兼容
    • ¥15 CPLD如何实现在线逻辑分析
    • ¥15 控制面板卸载无权限!!