• Skip to main navigation
  • Skip to main content
  • Skip to footer
  • Portfolio
    • Java
    • DevOps
    • Data mining
  • Online games
  • Posts
    • Author: QubeDron
    • Author: SnailDog
  • Experiments
  • Contacts
  • Skip to menu toggle button

ScAlAn

Scientific Algorithms and Analytics

Tag: mySQL

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…
Continue reading “Docker: Setup MySQL master-slave”…
Posted on: March 6, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

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…
Continue reading “Docker MySQL Stress test”…
Posted on: February 28, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

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……
Continue reading “Fix import huge database into Docker MySQL container”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 1 Written by: Alex

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` =…
Continue reading “WP fix run site locally”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

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,…
Continue reading “WP set category to post within SQL”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

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…
Continue reading “Docker php+mysql+xdebug”…
Posted on: August 22, 2019 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

Recent Posts

  • Alternative js log from devices without access to console
  • Configure .htaccess file for React app located in the subdirectory
  • Write jUnit test to check service with json files
  • Setup FTP server on Paspberry PI
  • Add autoformat java sources into your maven project
  • Add autoformat java sources into your gradle project
  • Create Accordion on html and js
  • Adding and removing users version 2.0
  • Adding and removing user
  • Java Script summer
  • Java Script summer weekend day № 1: Finding the largest word
  • Freecad: fasteners for curtains in the bathroom
  • Java Script Array modification and output

What’s ScAlAn?

Main activity of our co-working team is service to develop and support IT solutions.

Can we help?

We can offer professional development and support for your business.

You have an idea?
You want to make some improvement?
You want to implement?

Contacts

Email: info@scalan.com
Phone: +38 (067) 573-24-19
© 2025 ScAlAn | Using Modern WordPress theme. | Back to top ↑