PHPackages ridibooks/php-binlog-collector - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ridibooks/php-binlog-collector ActiveLibrary[Database & ORM](/categories/database) ridibooks/php-binlog-collector ============================== Ridibooks PHP Binlog Collector 1.4.0(6y ago)12742[1 PRs](https://github.com/ridi/php-binlog-collector/pulls)MITPHP Since Dec 28Pushed 1y ago4 watchersCompare [ Source](https://github.com/ridi/php-binlog-collector)[ Packagist](https://packagist.org/packages/ridibooks/php-binlog-collector)[ RSS](/packages/ridibooks-php-binlog-collector/feed)WikiDiscussions master Synced 2w ago READMEChangelog (10)Dependencies (7)Versions (12)Used By (0) php-binlog-collector ==================== [](#php-binlog-collector) [![Build Status](https://camo.githubusercontent.com/e31bd4755d6c74dd6df4d483a20c1dc2b44d5f8ebff0143628192aa15009cae4/68747470733a2f2f7472617669732d63692e6f72672f726964692f7068702d62696e6c6f672d636f6c6c6563746f722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/ridi/php-binlog-collector)[![Latest Stable Version](https://camo.githubusercontent.com/e745932783087991eb69bdf207cc0a8c488fd8c15baf6766936119290b4fb827/68747470733a2f2f706f7365722e707567782e6f72672f72696469626f6f6b732f7068702d62696e6c6f672d636f6c6c6563746f722f762f737461626c65)](https://packagist.org/packages/ridibooks/php-binlog-collector)[![License](https://camo.githubusercontent.com/97cb1628923887d4f9d05fd26934946c2b217cc05f6145bd1f65cbd0dad9e9f7/68747470733a2f2f706f7365722e707567782e6f72672f72696469626f6f6b732f7068702d62696e6c6f672d636f6c6c6563746f722f6c6963656e7365)](https://packagist.org/packages/ridibooks/php-binlog-collector) PHP로 만들어진 MySQL/MariaDB 복제 프로토콜 라이브러리를 이용한, MariaDB Binlog 기반의 변경사항 수집 응용 어플리케이션으로 분석 범위를 분할하는 Partitioner와 실제 변경사항 데이터를 수집하는 Worker로 구성되어 있습니다. 주요 사용 라이브러리: [php-mysql-replication](https://github.com/krowinski/php-mysql-replication) Installation ============ [](#installation) 1. Composer 사용 ``` composer require ridibooks/php-binlog-collector ``` 2. 직접 Github 사용 ``` git clone https://github.com/ridi/php-binlog-collector.git composer install -o ``` MariaDB 사용 제약 ============= [](#mariadb-사용-제약) [php-mysql-replication](https://github.com/krowinski/php-mysql-replication) 와 동일합니다. TARGET\_DB는 **binlog-format: row** 로 설정되어 운영중이여야 합니다. TARGET\_DB 접근 권한은 **REPLICATION SLAVE, REPLICATION CLIENT, SELECT** 가 필요합니다. DB 연결 설정 ======== [](#db-연결-설정) [.env.local](https://github.com/ridi/php-binlog-collector/tree/master/demo/include/.env.local)는 아래와 같습니다. BINLOG\_MYSQL\_TARGET는 분석할 DB, BINLOG\_MYSQL\_HISTORY\_WRITE는 분석 위치 및 이력 데이터를 저장할 DB 입니다. ``` BINLOG_ENABLE_SENTRY=0 BINLOG_SENTRY_KEY= BINLOG_MYSQL_TARGET_HOST=127.0.0.1 BINLOG_MYSQL_TARGET_USER=repl BINLOG_MYSQL_TARGET_PORT=3307 BINLOG_MYSQL_TARGET_PASSWORD=1234 BINLOG_MYSQL_TARGET_DBNAME=php_mysql_replication BINLOG_MYSQL_TARGET_DRIVER=pdo_mysql BINLOG_MYSQL_TARGET_CHARSET=utf8 BINLOG_MYSQL_HISTORY_WRITE_HOST=127.0.0.1 BINLOG_MYSQL_HISTORY_WRITE_USER=testUser BINLOG_MYSQL_HISTORY_WRITE_PORT=3308 BINLOG_MYSQL_HISTORY_WRITE_PASSWORD=testUser BINLOG_MYSQL_HISTORY_WRITE_DBNAME=platform BINLOG_MYSQL_HISTORY_WRITE_DRIVER=pdo_mysql BINLOG_MYSQL_HISTORY_WRITE_CHARSET=utf8 ``` 해당 설정 정보는 demo에 docker 기반 환경에 들어 있는 기본 연결 정보입니다. 만약 .env 파일이 있으면 해당 파일로 교체됩니다. Partitioner/Worker 설정 ===================== [](#partitionerworker-설정) default 설정정보이며, 외부에서 설정을 변경할 수 있습니다. 설정 정보디폴트 값사용설명gtid\_partition\_max\_count1000Partitioner파티션 최대 개수jump\_offset\_for\_next\_partition10000Partitioner파티션을 나누기 위한 값tables\_onlyXWorker타겟 테이블명들databases\_onlyXWorker타겟 데이터베이스명들child\_process\_max\_count10Worker동시에 실행할 워커 수once\_processed\_max\_event\_count\_in\_gtid100Worker한 트랜잭션에 한 번에 저장할 이벤트 수gtid\_count\_for\_persist\_per\_partition500Worker분석시 위치 갱신을 위한 Gtid 갯수is\_all\_print\_eventfalseALL디버깅 사용여부Partitioner/Worker 실행 ===================== [](#partitionerworker-실행) 1. Binlog Collector Partitioner에서 최초에 분석을 시작할 위치를 입력하여 분석할 범위를 나눕니다. ``` php [every]binlog_collect_partitioner.php change_pos [binLogFileName] [binLogPosition] 'ex) php [every]binlog_collect_partitioner.php change_pos mariadb-bin.000003 36755' ``` 2. 이미 분석을 시작했다면, 아래 명령어로 DB에 저장된 위치로부터 계속 분석 범위를 나눕니다. ``` php [every]binlog_collect_partitioner.php continue ``` 3. Partitioner가 나눈 범위에 대해서 Binlog Collector Worker가 병렬적으로 처리합니다. ``` php [every]binlog_collector_worker.php ``` 데모 == [](#데모) 모든 데모들은 [demo directory](https://github.com/ridi/php-binlog-collector/tree/master/demo) 에서 이용할 수 있고, docker 기반의 mariadb 환경 및 실제 구동은 travis-ci를 통해서 테스트 해볼 수 있습니다. [MariaDB Binlog을 이용한 변경사항 추적](https://www.ridicorp.com/blog/2017/10/30/binlog-collector) 에서 설계 내용을 확인 할 수 있습니다. ### Health Score 35 — LowBetter than 77% of packages Maintenance30 Infrequent updates — may be unmaintained Popularity17 Limited adoption so far Community12 Small or concentrated contributor base Maturity70 Established project with proven stability Bus Factor1 Top contributor holds 94.3% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~93 days Recently: every ~154 days Total 10 Last Release 2261d ago Major Versions v0.9.3 → v1.0.02017-12-28 ### Community Maintainers ![](https://www.gravatar.com/avatar/8260c131d6a3a12a327d78328de6f99203187abacd4571ec2cfd4dfeb4a1b2cb?d=identicon)[ridi](/maintainers/ridi) --- Top Contributors [![kobi97](https://avatars.githubusercontent.com/u/3581089?v=4)](https://github.com/kobi97 "kobi97 (50 commits)")[![ssaifriend](https://avatars.githubusercontent.com/u/1916350?v=4)](https://github.com/ssaifriend "ssaifriend (3 commits)") --- Tags binlogmysql ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/ridibooks-php-binlog-collector/health.svg) ``` [![Health](https://phpackages.com/badges/ridibooks-php-binlog-collector/health.svg)](https://phpackages.com/packages/ridibooks-php-binlog-collector) ``` ### Alternatives [laravel/framework The Laravel Framework. 34.8k532.1M19.5k](/packages/laravel-framework)[craftcms/cms Craft CMS 3.6k3.6M2.9k](/packages/craftcms-cms)[tempest/framework The PHP framework that gets out of your way. 2.2k31.1k12](/packages/tempest-framework)[pressbooks/pressbooks Pressbooks is an open source book publishing tool built on a WordPress multisite platform. Pressbooks outputs books in multiple formats, including PDF, EPUB, web, and a variety of XML flavours, using a theming/templating system, driven by CSS. 45344.0k1](/packages/pressbooks-pressbooks)[mateusjunges/laravel-kafka A kafka driver for laravel 7243.4M20](/packages/mateusjunges-laravel-kafka)[lemaur/eloquent-publishing 207.8k1](/packages/lemaur-eloquent-publishing) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)