队列的数据持久化和高可用性在PHP与MySQL中的实现方法

CREATE TABLE `queue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `data` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

<?php
function enqueue($data) {
    $mysqli = new mysqli("localhost", "username", "password", "database");
    $stmt = $mysqli->prepare("INSERT INTO queue (data) VALUES (?)");
    $stmt->bind_param("s", $data);
    $stmt->execute();
    $stmt->close();
    $mysqli->close();
}
?>

<?php
function dequeue() {
    $mysqli = new mysqli("localhost", "username", "password", "database");
    $stmt = $mysqli->prepare("SELECT id, data FROM queue ORDER BY id ASC LIMIT 1");
    $stmt->execute();
    $stmt->bind_result($id, $data);
    $stmt->fetch();
    $stmt->close();
    
    // 处理数据
    // ...

    // 删除已处理的数据
    $stmt = $mysqli->prepare("DELETE FROM queue WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $stmt->close();
    $mysqli->close();
}
?>

<?php
function dequeue() {
    $mysqli = new mysqli("localhost", "username", "password", "database");
    $mysqli->autocommit(FALSE); // 开启事务
    
    $stmt = $mysqli->prepare("SELECT id, data FROM queue ORDER BY id ASC LIMIT 1");
    $stmt->execute();
    $stmt->bind_result($id, $data);
    $stmt->fetch();
    
    // 处理数据
    // ...
    
    // 删除已处理的数据
    $stmt = $mysqli->prepare("DELETE FROM queue WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    
    // 提交事务
    $mysqli->commit();
    
    $stmt->close();
    $mysqli->close();
}
?>