Recommend this page to a friend! |
Download |
Info | Example | Files | Install with Composer | Download | Reputation | Support forum | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
Not yet rated by the users | Total: 47 | All time: 10,756 This week: 455 |
Version | License | PHP version | Categories | |||
php-mysql-replicatio 1.0.0 | MIT/X Consortium ... | 5 | PHP 5, Databases, Systems administration |
I need a PHP class for perform tally data synchronization
Tally data synchronization service
#!/usr/bin/env php |
Moves mysql replication events to kafka docker.
Env:
REPLICATOR_DEBUG: "false"
print worker action to log
REPLICATOR_USER: "root"
your mysql user (mandatory)
REPLICATOR_HOST: "r2k-mysql"
your mysql host/ip (mandatory)
REPLICATOR_PASSWORD: "root"
your mysql password (mandatory)
REPLICATOR_PORT: "3306"
our mysql host port (default 3306)
REPLICATOR_SLAVE_ID: "100"
script slave id for identification (SHOW SLAVE HOSTS)
REPLICATOR_START_FROM_GTID: ""
GTID marker(s) to start from
REPLICATOR_START_BIN_LOG_FILE_NAME: ""
bin log file name to start from
REPLICATOR_START_BIN_LOG_POSITION: "0"
bin log position to start from
REPLICATOR_START_FROM_MARIA_DB_GTID: ""
MariaDB GTID marker(s) to start from
REPLICATOR_TABLE_CACHE: "1024"
some data are collected from information schema, this data is cached.
REPLICATOR_HEARTBEAT: "0.0"
sets the interval in seconds between replication heartbeats.
REPLICATOR_LISTEN_ON_TABLES: "foo,bar"
only listen on given tables (default all tables)
REPLICATOR_LISTEN_ON_DATABASES: "foo,bar"
only listen on given databases (default all tables)
only listen for given events, look for ids in MySQLReplication\Definitions\ConstEventType::class`
REPLICATOR_IGNORE_EVENT_IDS: "73,32"
ignore given events, look for ids in MySQLReplication\Definitions\ConstEventType::class`
KAFKA_DEBUG: "false"
shows rdkafka events
KAFKA_BROKER: "r2k-kafka:9092"
brokers host:port
KAFKA_TOPIC: "test"
topic name to publish mysql events
KAFKA_RETRIES: "3"
how many tries worker should have before giving up and throw exception
KAFKA_TIMEOUT: "10000"
rdkafa flush timeout ms
Also, you can look and docker-compose.yml in repo.
Files (12) |
File | Role | Description | ||
---|---|---|---|---|
.github (1 directory) | ||||
bin (1 file) | ||||
src (4 files) | ||||
composer.json | Data | Auxiliary data | ||
composer.lock | Data | Auxiliary data | ||
docker-compose.yml | Data | Auxiliary data | ||
Dockerfile | Data | Auxiliary data | ||
LICENSE | Lic. | License text | ||
README.md | Doc. | Documentation |
Files (12) | / | src |
File | Role | Description |
---|---|---|
KafkaSubscriber.php | Class | Class source |
ReplicationToKafkaCommand.php | Class | Class source |
ReplicatorResume.php | Class | Class source |
Tools.php | Class | Class source |
The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page. |
Install with Composer |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.