pgbalancer 1.0, ื ืงื™ื ืกื˜ืœืขืš-ืื™ื ื˜ืขืœื™ื’ืขื ืฅ-ื’ืขื˜ืจื™ื‘ืขื ืขืจ PostgreSQL ืœืึธื•ื“ ื‘ืึทืœืึทื ืกืขืจ ืžื™ื˜ REST API ืื•ืŸ MQTT ืฉื˜ื™ืฆืข, ืื™ื– ืื™ืฆื˜ ื‘ื ื™ืžืฆื.

ื“ื™ ืขืจืฉื˜ืข ืื•ื™ืกื’ืื‘ืข ืคื•ืŸ โ€‹โ€‹pgbalancer, ื ืงื™ื ืกื˜ืœืขืš-ืื™ื ื˜ืขืœื™ื’ืขื ื˜ืข (AI) ืœืึธื•ื“ ื‘ืึทืœืึทื ืกืขืจ ืžื™ื˜ ื REST API ืื•ืŸ MQTT, ืื™ื– ืืจื•ื™ืกื’ืขื’ืขื‘ืŸ ื’ืขื•ื•ืืจืŸ. Pgbalancer ื’ื™ื˜ ืงืื ืขืงืฉืืŸ ืคึผื•ืœื™ื ื’ ืื•ืŸ ืœืึธื•ื“ ื‘ืึทืœืึทื ืกื™ื ื’ ืคืืจ PostgreSQL, ื•ื•ืขืจื˜ ื’ืขืจืื˜ืŸ ืื™ื‘ืขืจ HTTP, ืื•ืŸ ืฉื˜ื™ืฆื˜ ืจืขืืœ-ืฆื™ื™ื˜ ื’ืขืฉืขืขื ื™ืฉ ืกื˜ืจื™ืžื™ื ื’. ื“ืขืจ ืคืจืื™ืขืงื˜ ืื™ื– ื ื’ืึธืคึผืœ ืคื•ืŸ pgpool-II ืžื™ื˜ ื‘ืึทื“ื™ื™ื˜ื ื“ื™ืงืข ืคึฟืึทืจื‘ืขืกืขืจื•ื ื’ืขืŸ ืคึฟืึทืจ ืื™ื ื˜ืขืœื™ื’ืขื ื˜ืข ืจื™ืงื•ื•ืขืกื˜ ืจื•ื˜ื™ื ื’. ื“ืขืจ ืงืึธื“ ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ C ืื•ืŸ ืคืึทืจืฉืคึผืจื™ื™ื˜ ืื•ื ื˜ืขืจ ื“ืขืจ PostgreSQL ืึธืคึฟืŸ ืžืงื•ืจ ืœื™ืฆืขื ืฅ.

ืฉืœื™ืกืœ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืื•ืŸ ืงื™ื™ืคึผืึทื‘ื™ืœืึทื˜ื™ื–:

  • ืงืึทื ืขืงืฉืึทืŸ ืคึผื•ืœื™ื ื’ ืื•ืŸ ืœืึธื•ื“ ื‘ืึทืœืึทื ืกื™ื ื’.
  • ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉืข ืคื™ื™ืœืึธื•ื•ื•ืขืจ ืžื™ื˜ ื•ื•ืึทื˜ืฉื“ืึธื’ ื˜ื™ื™ึทืžืขืจ ืฉื˜ื™ืฆืข.
  • ืคืึธืจืฉื˜ืขืœื•ื ื’ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืื•ืŸ ืงื•ื•ืขืจื™ ืงืึทื˜ืฉื™ื ื’.
  • ืื•ื™ื˜ืขื ื˜ื™ืคื™ืงืืฆื™ืข SSL/TLS, PAM/LDAP.
  • ืงืึธืžืคึผืึทื˜ื™ื‘ืœ ืžื™ื˜ ืคึผืึธืกื˜ื’ืจืขืกืงื™ื•-ืขืœ 13-18.
  • ืขืก ืื™ื– ื˜ื™ื™ืœ ืคื•ืŸ ื“ื™ pgElephant ื”ื•ื™ืš-ืคืืจืคึฟื™ื’ื‘ืืจืงื™ื™ื˜ ื™ื•ื˜ื™ืœื™ื˜ื™ืขืก. ืขืก ืงืขืŸ ืื™ื ื˜ืขื’ืจื™ืจื˜ ื•ื•ืขืจืŸ ืžื™ื˜ pgraft ืคืืจ Raft ืงืื ืกืขื ืกื•ืก ืื•ืŸ ืฉื˜ื™ืฆื˜ pgSentinel ืžืื ื™ื˜ืืจื™ื ื’.
  • ืงื™ื ืกื˜ืœืขืš ืื™ื ื˜ืขืœื™ื’ืขื ืฅ-ื’ืขื˜ืจื™ื‘ืขื ืข ืœืึธื•ื“ ื‘ืึทืœืึทื ืกื™ื ื’.
    • ืžืึทืฉื™ืŸ ืœืขืจื ืขืŸ ืึทืœื’ืขืจื™ื˜ืžืขืŸ ืคึฟืึทืจ ืงืœื•ื’ืข ื‘ืขื˜ืŸ ืจื•ื˜ื™ื ื’.
    • ื˜ืจืขื ื™ืจื•ื ื’ ื•ื•ืขืจื˜ ืฆื•ื’ืขืคืืกื˜ ืœื•ื™ื˜ ื“ืขืจ ืจืขืืงืฆื™ืข ืฆื™ื™ื˜ ืคื•ืŸ ืคืืจืœืื ื’ืขืŸ ืื•ืŸ ื“ืขื ืฆื•ืฉื˜ืื ื“ ืคื•ืŸ ืจืขืกื•ืจืกืŸ ืกืขืจื•ื•ื™ืจืขืจ.
    • ื“ืขืจ ืฆื•ืฉื˜ืึทื ื“ ื•ื•ืขืจื˜ ืึธืคึผื’ืขืฉืึทืฆื˜ ืื™ืŸ ืคืึทืงื˜ื™ืฉืขืจ ืฆื™ื™ื˜ ืื•ืŸ ื“ื™ ื‘ืึทืœืึทื ืกื™ืจื•ื ื’ ืคื•ืŸ ื“ื™ ื‘ืงืฉื” ื•ื•ืขืจื˜ ืคืึธืจื•ื™ืกื’ืขื–ืึธื’ื˜.
    • ืงืึธื ืคื™ื’ื•ืจืึทื‘ืœืข ื•ื•ืึธื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืคึฟืึทืจ ืœืขืจื ืขืŸ ืงื•ืจืก ืื•ืŸ ืจืึทื ื“ืึธื ื’ืขืฉืขืขื ื™ืฉ ื’ืขืกื™ื ื’ ืงื•ืจืก.
    • ืžืขื’ืœืขื›ืงื™ื™ื˜ ืคื•ืŸ ืื™ื ื˜ืขื’ืจืึทืฆื™ืข ืžื™ื˜ ืคึผืจืึธืžืขื˜ื”ืขื•ืก ืื•ืŸ ื’ืจืึทืคืึทื ืึท ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืคึผืœืึทื˜ืคืึธืจืžืขืก.

    ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ื“ื•ืจืš REST API.

    • 17 HTTP/JSON ืคื•ื ืงืฆื™ืขืก ืคึฟืึทืจ ื’ืึทื ืฅ ืงืœืึทืกื˜ืขืจ ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’.
    • ืื™ื ื˜ืขื’ืจื™ืจื˜ืขืจ API ืกืขืจื•ื•ืขืจ ื•ื•ืืก ืœื•ื™ืคื˜ ืื•ื™ืฃ ืคืืจื˜ 8080.
    • ืื•ื™ื˜ืขื ื˜ื™ืคื™ืงืืฆื™ืข ืžื™ื˜ JWT HMAC-SHA256 ื˜ืึธืงืขื ืก.
    • ื‘ืึทืงื•ืžืขืŸ ืกื˜ืึทื˜ื™ืกื˜ื™ืง ืื•ืŸ ืžืขื˜ืจื™ืงืก ื•ื•ืขื’ืŸ ื“ืขื ืฆื•ืฉื˜ืึทื ื“ ืคื•ืŸ ื“ื™ ื“ื•ืจื›ืคื™ืจื•ื ื’ ืžืึธื“ืข.
    • ืจืขืึทืงืฆื™ืข ืฆื™ื™ื˜ ื•ื•ื™ื™ื ื™ืงืขืจ ื•ื•ื™ 10 ืžืก.

    MQTT ื’ืขืฉืขืขื ื™ืฉ ืกื˜ืจื™ืžื™ื ื’.

    • MQTT ื•ื•ืขืจื˜ ื’ืขื ื•ืฆื˜ ืฆื• ืคื•ื‘ืœื™ืงื™ืจืŸ ื ืึธื“ืข ืฉื˜ืึทื˜ ืขื ื“ืขืจื•ื ื’ืขืŸ, ืคื™ื™ืœืึธื•ื•ื•ืขืจ, ืื•ืŸ ืจืขืึทืœ-ืฆื™ื™ื˜ ืจืขืกื•ืจืก ื’ืขื–ื•ื ื˜ื”ื™ื™ื˜ ื˜ืฉืขืงืก.
    • ืื™ืจ ืงืขื ื˜ ืงืึธื ืคื™ื’ื•ืจื™ืจืŸ MQTT ื˜ืขืžืขืก ืคึฟืึทืจ ืคึฟืึทืจืฉื™ื“ืขื ืข ื’ืขืฉืขืขื ื™ืฉ ื˜ื™ืคึผืŸ.
    • ืื™ื ื˜ืขื’ืจืึทืฆื™ืข ืžื™ื˜ Mosquitto, EMQX ืื“ืขืจ ื™ืขื“ืŸ MQTT ื‘ืจืึธืงืขืจ.
    • ื’ื™ื˜ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉืข ืึธื ื–ืึธื’ ืคื•ืŸ ืึทื‘ื ืึธืจืžืึทืœืข ื’ืขืฉืขืขื ื™ืฉืŸ ืื•ืŸ ื’ื™ื˜ ืึท ื˜ืจืึทื ืกืคึผืึธืจื˜ ืงืึทื ืึทืœ ืคึฟืึทืจ ืงืœืึทืกื˜ืขืจ ืึธืจืงืขืกื˜ืจื™ื™ืฉืึทืŸ.
  • bctl ืงืืžืื ื“ ืœื™ื ื™ืข ื ื•ืฆืŸ:
    • ืืŸ ืื™ื™ื ืฆื™ืงืข ืื™ื ื˜ืขืจืคื™ื™ืก ื•ื•ืืก ืคืืจื˜ืจืขื˜ ืื™ื‘ืขืจ 10 ื‘ืื–ื•ื ื“ืขืจืข "pcp_*" ื‘ืืคืขืœืŸ.
    • 3 ืจืขื–ื•ืœื˜ืึทื˜ ืคึฟืึธืจืžืึทื˜ืŸ: ื˜ืึทื‘ืขืœืขืก, JSON ืึธื“ืขืจ ื ื™ืฉื˜-ืžืึธื“ื™ืคึฟื™ืฆื™ืจื˜ ืคึฟืึธืจืžืึทื˜.
    • ืจืขื–ื•ืœื˜ืึทื˜ ืคื•ืŸ ืคึฟืึธืจืžืึทื˜ื™ืจื˜ืข ื˜ืึทื‘ืขืœืขืก ืžื™ื˜ ืจืึธืžืขืŸ ืคึฟืึทืจ pgbalancer ืจืึทื ื˜ื™ื™ื ื“ืึทื˜ืŸ.
    • ื•ื•ืฒึทื˜ ืงืึธื ื˜ืจืึธืœ ืื•ืŸ ืคึฟืึทืจืœืขื ื’ืขืจื˜ืข ืจืขื–ื•ืœื˜ืึทื˜ ืžืึธื“ืข.
  • ื’ื™ื˜ื”ืื‘ ืืงืฆื™ืขืก ื•ื•ืึธืจืงืคืœืึธื•:
    • build-matrix.yml: ะกะฑะพั€ะบะธ ะฝะฐ ะฝะตัะบะพะปัŒะบะธั… ะฟะปะฐั‚ั„ะพั€ะผะฐั… (Ubuntu, macOS, Rocky Linux).
    • ืคึผืึธืกื˜ื’ืจืขืกืงื™ื•-ืขืœ 13-18 ืฉื˜ื™ืฆืข.
    • DEB-ะฟะฐะบะตั‚ั‹ ะดะปั Ubuntu ืงืกื ื•ืžืงืก / ืงืกื ื•ืžืงืก, Debian ืงืกื ื•ืžืงืก / ืงืกื ื•ืžืงืก.
    • RPM-ะฟะฐะบะตั‚ั‹ ะดะปั Rocky 9, AlmaLinux 9, CentOS ืกื˜ืจื™ื 9.
    • ืื•ื™ื˜ืึธื˜ื•ืœืก ืฉื˜ื™ืฆืข ืžื™ื˜ ืื•ื™ื˜ืึธืจืขืงืึธื ืฃ ืื™ื ื˜ืขื’ืจืึทืฆื™ืข
    • docs.yml: ื“ื™ืคึผืœื•ื™ืžืึทื ื˜ ืคื•ืŸ ื’ื™ื˜ื”ืื‘ ื‘ืœืขื˜ืขืจ ื“ืึธืงื•ืžืขื ื˜ืึทืฆื™ืข.

ืžืงื•ืจ: opennet.ru

ืงื•ื™ืคืŸ ืคืึทืจืœืึธื–ืœืขืš ื”ืึธืกื˜ื™ื ื’ ืคึฟืึทืจ ื–ื™ื™ื˜ืœืขืš ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก ๐Ÿ”ฅ ืงื•ื™ืคื˜ ืคืึทืจืœืขืกืœืขื›ืข ื•ื•ืขื‘ื–ื™ื™ื˜ืœ ื”ืึธืกื˜ื™ื ื’ ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก | ProHoster