Download the PHP package census/sql without Composer
On this page you can find all versions of the php package census/sql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package sql
census
一个用来解析binlog的到sql的包,主要是之前准备用binlog做恢复的操作,但是后来没有找到合适的插件,有考虑过有考虑过用ali的canal,这个功能介绍的很全,但是使用起来会有些问题,服务端可以跑起来,但是 做数据同步的时候一直有问题,php的客户端没什么问题。可以正常获取到数据。后来找到 krowinski/php-mysql-replication 包,准备加点数据处理的功能在里面。
安装
运行环境要求
使用
基于Laravel框架,在Commands目录下,新建命令BinlogConsumer,代码如下:
如果打算用supervisorctl来执行上面的脚本的话,会有问题,因为上面的程序执行后本身就是守护进程 所以通过nohup方式运行: nohup php artisan binlog-consumer > /var/log/binlog-operate.log 2>&1 &
建议
License
MIT
All versions of sql with dependencies
PHP Build Version
Package Version
Requires
php Version
>=7.3.0
krowinski/php-mysql-replication Version ^7.0
predis/predis Version ^1.1
illuminate/support Version ^5.5|^6.0|^7.0|^8.0
illuminate/database Version ^5.5|^6.0|^7.0|^8.0
illuminate/filesystem Version ^5.5|^6.0|^7.0|^8.0
illuminate/console Version ^5.5|^6.0|^7.0|^8.0
krowinski/php-mysql-replication Version ^7.0
predis/predis Version ^1.1
illuminate/support Version ^5.5|^6.0|^7.0|^8.0
illuminate/database Version ^5.5|^6.0|^7.0|^8.0
illuminate/filesystem Version ^5.5|^6.0|^7.0|^8.0
illuminate/console Version ^5.5|^6.0|^7.0|^8.0
The package census/sql contains the following files
Loading the files please wait ....