Installing docker desktop on windows 11
Installing docker desktop on windows 11 Install Start-Process 'E:\Downloads\Docker Desktop Installer.exe' -Wait -ArgumentList 'install', '--accept-license', '--installation-dir="D:\Program Files\Docker"', '--wsl-default-data-root="D:\Program Files\Docker-data"' Migrate docker-desktop [deprecated] PS C:\Windows\system32> wsl -l -v NAME STATE VERSION* Ubuntu Running 2 docker-desktop-data Stopped 2 docker-desktop Sto...
Master-Slave Semisynchronous Replication on MySQL 5.7.13
Master-Slave Semisynchronous Replication on MySQL 5.7.13 Prerequisites 检查 have_dynamic_loading 系统变量值为 YES。 复制已经在正常运行。 不能配置多复制通道，半同步复制只能兼容默认的复制通道。 Procedure 检查动态加载插件要求。 mysql> show variables like 'have_dynamic_loading';+----------------------+-------+| Variable_name | Value |+----------------------+-------+| have_dynamic_loading | YES |+----------------------+-------+1 row in set (0.02 sec) 安装插件。 源端 mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';...
ERROR 1356
ERROR 1356 APPLIES TO: 5.7.x SYMPTOMS mysqldump 全备恢复后，无法查询 sys 库。 mysql> select * from sys.processlist; ERROR 1356 (HY000): View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them CASE mysql> SELECT * FROM mysql.proc;Empty set (0.00 sec)mysql> SHOW PROCEDURE STATUS WHERE Db = 'sys';Empty set (0.00 sec)mysql> SHOW FUNCTION STATUS WHERE Db = 'sys';Empty set (0.00 sec) sys 库 functions 和 procedures 丢失了，mysq...
Master-Slave GTID Replication on MySQL 5.7.13
Master-Slave GTID Replication on MySQL 5.7.13 Architecture All database operations are copied to the master’s binary log. Salves connect to the master and asks for the data. The slave servers get the masters binary log. Slaves then apply the binary log to its realy log. The relay log is read by the SQL thread process and it applies all the operations/data to the slave’s database and its binary log. Setup on Master 配置主机名解析。 "/etc/hosts"172.17.0.3 38a497b84982 # master172.17.0.4 ...
ERROR 1396
ERROR 1396 APPLIES TO: mysql> show variables like '%version%'; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.7.13 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version ...
MySQL Database Performance Tuning
MySQL Database Performance Tuning Locks select * from information_schema.innodb_locks;select * from information_schema.innodb_lock_waits;select concat('KILL ',id,';') from information_schema.processlist where user='DBuser' and DB='app_dc';select * from information_schema.processlist where user='DBuser' and DB='app_dc'; Recreate Tables select table_rows,table_name,table_schema from information_schema.TABLES where table_name='XXX_COMMAND';use app_dc;create table XXX_COMMAND_new like XXX_COMM...
MySQL Database Inspection Commands
MySQL Database Inspection Commands
DellEMC Unity 380,480,680,880 Service Manual
DellEMC Unity 380,480,680,880 Service Manual DellEMC Unity/XT 380/F,480/F,680/F,880/F Port IP Username/Password Management dhcp admin/Password123# Maintenance 128.221.1.250-251/255.255.255.248 service/service Dynamic Pools a. Expand pool by a single drive unless crossing a Drive Partnership Group. b. The maximum number of drives contained within a drive partnership group is 64. Replacing a System Drive with traditional pools ・ Dell Unity_ With traditional pools, when a sys...
Hitachi VSP Gx00,Fx00 Service Manual
Hitachi VSP Gx00,Fx00 Service Manual VSP Gx00,Fx00 Product Type IP Username/Password SVP Management 10.0.0.100/255.255.255.0 SVP-PC\SVP/raid-login VSP Management(Customer) 192.168.0.16-17/255.255.255.0 maintenance/raid-maintenance VSP Maintenance 10.0.0.16-17/255.255.255.0 maintenance/raid-maintenance SVP network configuration CBSS/CBSL BKMs Replacement BKM 模块电池寿命到期告警： 此时 BKM 状态灯橙色闪烁。 1. 电池寿命到期告警时，可直接更换电池，无需将 BKM 模块置为 Blocked 状态。预维护更换电池时，则需将 BKM 模块置为 Blocked 状态。 此时 BK...
Inspur AS18000 Service Manual
Inspur AS18000 Service Manual Port IP Username/Password FST 192.168.1.1/255.255.255.0 root/root 查看维护用户 f.ce 登陆密码： "system" - "system settings" - Box ID 中 #号之间是密码，字母加数字，其中数字是设备的 SN 号。如下图所示。 BBU Replacement BBU 会提前 6 个月进行电池过期警示，警示期间虽然不影响存储正常运行，但是需要尽快进行电池更换。 BBU 电池模块位置视图，移除前面板罩，可以看到 3 个 BBU 电池模块。 更换步骤 用 f.ce 账号登陆存储管理界面，进入维护模式 [Start/End Maintenance]。 选择电池进行预维护 [Preventive Maintenance]，执行完毕后，电池 BCA/BTA 状态灯会变橙色。 关闭电池开关，拧下左侧螺丝，抽出整个 BBU 模块，更换 BTU 模块。 更换完毕后，将 BBU 模块插回原位置，4...
