• Skip to main navigation
  • Skip to main content
  • Skip to footer
  • Portfolio
    • Java
    • PHP
    • Web shop
    • Web site
    • HTML5
    • Data mining
    • Games
  • Applications
  • online games
  • Services
  • Posts
    • Author: QubeDron
    • Author: SnailDog
  • Experiments
  • Contacts
  • Skip to menu toggle button

ScAlAn

Scientific Algorythms 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

  • Java: Encrypt and encode string with public key
  • Java: Prepare pem keys objects from strings
  • Java: Find first file in the directory and return its name
  • How to execute SQLs in the docker Postgres db
  • How to Set all directories to 755 and all files to 644
  • Service to gather sports data
  • JPA SpringBoot Find by id of related object
  • Script to scrape data from panoramafirm.pl 2022
  • Python get wind speed and direction and display them on the clock
  • Install Java on Raspberry Pi
  • Monitor periodically linux ordered processes
  • Linux check if server exists by IP and port
  • AWS get list of ec2 ids by beanstalk environment name

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
Skype: scalan75
© 2022 ScAlAn | Using Modern WordPress theme. | Back to top ↑