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…
Category: Database
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,…
Mongo DB: Sharding scripts
Configuration of few mongoDB servers to work as one:
Bank bills database (Pro) application
PP (Pro): Application for preparing bank bills with addition functions
