Download the PHP package zero1/magento2-splitdb without Composer
On this page you can find all versions of the php package zero1/magento2-splitdb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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 magento2-splitdb
magento2-splitdb
Ability to split database traffic to 1 or more readers. Allowing you to take advantage of an AWS reader endpoint for example.
Installation
These steps are intended to be carried out in a staging/development environment. If you don't have, look at MDOQ which can provide multiple development environments quickly and cheaply.
composer require zero1/magento2-splitdbphp bin/magento module:enable Zero1_SplitDbphp bin/magento setup:upgradephp bin/magento deploy:mode:set production
Configuration
To use separate endpoints for reading and writing to the database. You need to configure the endpoints in app/etc/env.php
Before
After
slaves: you can configure as many as you want. (Though with AWS you would only need to specify the single reader endpoint). The configuration for each slave is merged over the base config. So each slave will inherit all config values not defined. Each request will be locked to a single reader. (This is to stop multiple connections being opened)-
excluded_areas: you can also enforce the use of the writer endpoint for specific urls. By default this will be'/checkout'and'/customer'. If you don't want enforce for any areas supply an empty areaIf you want to enforce different or more areas, supply them in an array
N.B: Don't forget to flush cache after updating the app/etc/env.php file and clear opache.
TODO
- Reader exclusions DB/Adapter/Pdo/MysqlProxy.php:114 this is required because Magento saves the model, then instantly tries to load it. Need to locate the offending code or find another way around.
Debug
To debug which queries are going to which endpoint while the platform is in production mode add
to the default node
then run tail -f var/log/system.log | grep Zero1_SplitDb an request some pages.
