Docker: Setup MySQL master-slave
Task: create docker-compose environment to run MySQL master and slave servers. Implementation: docker-compose.yml file: version: ‘2’ services: mysqldb-master: image: mysql:5.7…
Tag: mySQL
Docker MySQL Stress test
Task: Create environment to run series of read/write queries to real MySQL server. Before make real experiments I tried to…
Fix import huge database into Docker MySQL container
When I tried to import dump file using mysql command I saw ‘lost connection’ or ‘server has gone away’ error……
WP fix run site locally
WordPress has option(s) with site URL. To change them to new one use next SQLs: UPDATE `wp_options` SET `option_value` =…
WP set category to post within SQL
I have a stored procedure and want put posts in the MySQL event to some category (such Archive). wp_term_relationships (object_id,…
Docker php+mysql+xdebug
Steps to create configuration: Create docker-compose.yml version: “2” services: web: image: nginx:latest ports: – “80:80” volumes: – ./apps/default:/apps/default – ./logs/nginx:/logs/nginx…