Download the PHP package yerofey/replicator without Composer
On this page you can find all versions of the php package yerofey/replicator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download yerofey/replicator
More information about yerofey/replicator
Files in yerofey/replicator
Package replicator
Short Description PHP MySQL Replication
License MIT
Homepage https://packagist.org/packages/yerofey/replicator
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package replicator
Features
- [x] Cloning table columns
- [x] Cloning table indexes
- [x] Cloning table data
- [ ] Cloning table collation
Why not use a default built-in replication methods
The default replication has some weak points:
- It creates a big binlog file (if you have a big database) - so you need a large amount of disk space to handle those binlogs
- It does not supports the triggers - triggers will be saved as SQL-query in binlog, but if you want to have a copy of just a few tables - some data will be incorrect.
How to setup
First of all you'll need a Composer
If you don't have it yet installed, - checkout this guide.
Then add the library to your project
If you want to replicate on the same server:
- You can create a worker that will do the job for example every minute (examples/worker.php) It can be setted up with crontab.
- You can create a daemon that will work always and do the job every n seconds (examples/daemon.php)
If you want to replicate on another server:
On secondary server (Linux):
Navigate to the line that begins with the bind-address directive. By default, this value is set to 127.0.0.1, meaning that the server will only look for local connections. You will need to change this directive to reference an external IP address. For the purposes of troubleshooting, you could set this directive to a wildcard IP address, either *, ::, or 0.0.0.0:
After changing this line, save and close the file (CTRL + X, Y, then ENTER if you edited it with nano).
Assuming you’ve configured a firewall on your database server, you will also need to open port 3306 — MySQL’s default port — to allow traffic to MySQL. If you only plan to access the database server from one specific machine, you can grant that machine exclusive permission to connect to the database remotely with the following command. Make sure to replace remote_IP_address with the actual IP address of the machine you plan to connect with:
Alternatively, you can allow connections to your MySQL database from any IP address with the following command:
Lastly, restart the MySQL service to put the changes you made to mysqld.cnf into effect:
MySQL setup guide source: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
Then create a folder for a worker scripts
Then create a DB configuration file
config.php example
Then create a worker script (one time job)
Or create a daemon (that will work always)
Then just run your script
If you've done everything right replication should now work.
Author
License
This library licensed under MIT.
