使用强大的 DBPack 处理分布式事务（PHP 使用教程）

07 00 00 // 前 3 个字节表示 payload 的长度为 7 个字节01 // sequence 响应的序号，前 4 个字节一起构成了 OKPacket 的 header00 // 标识 payload 为 OKPacket00 // affected row00 // last insert id03 00 // 状态标志位00 00 // warning 数量

ETCD_VER=v3.5.3
# choose either URLGOOGLE_URL=https://storage.googleapis.com/etcdGITHUB_URL=https://github.com/etcd-io/etcd/releases/downloadDOWNLOAD_URL=${GOOGLE_URL}
rm -f /tmp/etcd-${ETCD_VER}-linux-amd64.tar.gzrm -rf /tmp/etcd-download-test && mkdir -p /tmp/etcd-download-test
curl -L ${DOWNLOAD_URL}/${ETCD_VER}/etcd-${ETCD_VER}-linux-amd64.tar.gz -o /tmp/etcd-${ETCD_VER}-linux-amd64.tar.gztar xzvf /tmp/etcd-${ETCD_VER}-linux-amd64.tar.gz -C /tmp/etcd-download-test --strip-components=1rm -f /tmp/etcd-${ETCD_VER}-linux-amd64.tar.gz
/tmp/etcd-download-test/etcd --version/tmp/etcd-download-test/etcdctl version/tmp/etcd-download-test/etcdutl version

-- ------------------------------ Table structure for undo_log-- ----------------------------DROP TABLE IF EXISTS `undo_log`;CREATE TABLE `undo_log` (  `id` bigint(20) NOT NULL AUTO_INCREMENT,  `branch_id` bigint(20) NOT NULL,  `xid` varchar(100) NOT NULL,  `context` varchar(128) NOT NULL,  `rollback_info` longblob NOT NULL,  `log_status` int(11) NOT NULL,  `log_created` datetime NOT NULL,  `log_modified` datetime NOT NULL,  `ext` varchar(100) DEFAULT NULL,  PRIMARY KEY (`id`),  KEY `idx_unionkey` (`xid`,`branch_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# 更新distributed_transaction.etcd_config.endpoints# 更新listeners配置项，调整为实际聚合层服务的地址和端口# 更新filters配置项，配置聚合层服务的API endpointvim /path/to/your/aggregation-service/config-aggregation.yaml
# 更新distributed_transaction.etcd_config.endpoints# 更新listeners配置项，配置业务数据库信息，包括dbpack代理的端口# 更新data_source_cluster.dsnvim /path/to/your/business-service/config-service.yaml

git clone git@github.com:cectc/dbpack.git
cd dbpack# build on local envmake build-local# build on production envmake build
./dist/dbpack start --config /path/to/your/config-aggregation.yaml
./dist/dbpack start --config /path/to/your/config-service.yaml

server {    listen 3001; # 暴露的服务端口    index index.php index.html;    root /var/www/code/; # 业务代码根目录
    location / {        try_files $uri /index.php?$args;    }
    location ~ \.php$ {        fastcgi_split_path_info ^(.+\.php)(/.+)$;        fastcgi_pass order-svc-app:9000; # php-fpm 端口        fastcgi_index index.php;        include fastcgi_params;        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;        fastcgi_param PATH_INFO $fastcgi_path_info;    }}

<?php
class AggregationSvc{
    public function CreateSo(string $xid, bool $rollback): bool    {        $createSoSuccess = $this->createSoRequest($xid);        if (!$createSoSuccess) {            return false;        }        $allocateInventorySuccess = $this->allocateInventoryRequest($xid);        if (!$allocateInventorySuccess) {            return false;        }        if ($rollback) {            return false;        }        return true;    }
    // private function createSoRequest(string $xid) ...    // private function allocateInventoryRequest(string $xid) ...}
$reqPath = strtok($_SERVER["REQUEST_URI"], '?');$reaHeaders = getallheaders();
$xid = $reaHeaders['X-Dbpack-Xid'] ?? '';
if (empty($xid)) {    die('xid is not provided!');}
$aggregationSvc = new AggregationSvc();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {    switch ($reqPath) {        case '/v1/order/create':            if ($aggregationSvc->CreateOrder($xid, false)) {                responseOK();            } else {                responseError();            }        case '/v1/order/create2':            if ($aggregationSvc->CreateSo($xid, true)) {                responseOK();            } else {                responseError();            }            break;        default:            die('api not found');    }}
function responseOK() {    http_response_code(200);    echo json_encode([        'success' => true,        'message' => 'success',    ]);}
function responseError() {    http_response_code(400);    echo json_encode([        'success' => false,        'message' => 'fail',    ]);}

<?php
class OrderDB{    private PDO $_connection;    private static OrderDB $_instance;    private string $_host = 'dbpack-order';    private int $_port = 13308;    private string $_username = 'dksl';    private string $_password = '123456';    private string $_database = 'order';
    const insertSoMaster = "INSERT /*+ XID('%s') */ INTO order.so_master (sysno, so_id, buyer_user_sysno, seller_company_code, 		receive_division_sysno, receive_address, receive_zip, receive_contact, receive_contact_phone, stock_sysno,         payment_type, so_amt, status, order_date, appid, memo) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,now(),?,?)";
    const insertSoItem = "INSERT /*+ XID('%s') */ INTO order.so_item(sysno, so_sysno, product_sysno, product_name, cost_price, 		original_price, deal_price, quantity) VALUES (?,?,?,?,?,?,?,?)";
    public static function getInstance(): OrderDB    {        if (empty(self::$_instance)) {            self::$_instance = new self();        }        return self::$_instance;    }
    private function __construct()    {        try {            $this->_connection = new PDO(                "mysql:host=$this->_host;port=$this->_port;dbname=$this->_database;charset=utf8",                $this->_username,                $this->_password,                [                    PDO::ATTR_PERSISTENT => true,                    PDO::ATTR_EMULATE_PREPARES => false, // to let DBPack handle prepread sql                ]            );        } catch (PDOException $e) {            die($e->getMessage());        }    }
    private function __clone()    {    }
    public function getConnection(): PDO    {        return $this->_connection;    }
    public function createSo(string $xid, array $soMasters): bool    {        $this->getConnection()->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);        try {            $this->getConnection()->beginTransaction();            foreach ($soMasters as $master) {                if (!$this->insertSo($xid, $master)) {                    throw new PDOException("failed to insert soMaster");                }            }            $this->getConnection()->commit();        } catch (PDOException $e) {            $this->getConnection()->rollBack();            return false;        }        return true;    }
    private function insertSo(string $xid, array $soMaster): bool    {        // insert into so_master, so_item ...    }}
$reqPath = strtok($_SERVER["REQUEST_URI"], '?');$reqHeaders = getallheaders();
$xid = $reqHeaders['Xid'] ?? '';
if (empty($xid)) {    die('xid is not provided!');}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {    if ($reqPath === '/createSo') {        $reqBody = file_get_contents('php://input');        $soMasters = json_decode($reqBody, true);
        $orderDB = OrderDB::getInstance();        $result = $orderDB->createSo($xid, $soMasters);
        if ($result) {            responseOK();        } else {            responseError();        }    }}
function responseOK() {    http_response_code(200);    echo json_encode([        'success' => true,        'message' => 'success',    ]);}
function responseError() {    http_response_code(400);    echo json_encode([        'success' => false,        'message' => 'fail',    ]);}

curl -X{HTTP Method} http://localhost:{DBPack监听的聚合层服务端口}/{聚合层服务的API endpoint}