#!/bin/bash#Remotemonitoring.Ifthenetworkisbroken,emailme~ ping-c10www.baidu.com>33.logwhile ["1"="1"]dot=$(awk ‘{print$1}‘33.log)if[!-z$($t)];thenecho""sleep30elsebreak;fidoneecho"DiaoXianLe"|mail-s"down"[emailprotected]This article is from the It Dick thread blog, so be sure to keep this source http://68686789.blog.51cto.com/10438688/1694908Design a script that monitors the surviving state of a remote machine (assuming IP 123.23.11.21) and sends a message to yourself when it finds an
second method is to use a docker temp directory.Specific issue Reference HTTPS://GITHUB.COM/COREOS/COREOS-VAGRANT/ISSUES/49Therefore, we recommend that you do not dynamically expand the container disk space, try to use volume to mount.Another 1.3 and above I test is unable to dynamic expansion of the container space, to the official issue also no one answered, the address is https://github.com/docker/docker/issues/11153This article is from the "Yin-Technical Exchange" blog, please be sure to ke
Only available for physical machines1. First view iptables-l-n View rules2. Cancel all rules with Iptables-f3. Execute SH Script and drop some IP3. Block the specified IPSometimes we find that an IP is being sent to the server, and we can discard the packets from the specified IP using the following command:block_this_ip="x.x.x.x""$BLOCK _this_ip"-j DROP The above command sets the TCP packet that will be sent by the x.x.x.x IP to the eth0 network port.Simulated HTTP service
table contains indexes that this version of the engine
doesn ' t-support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html How
can resolve the problem(1) Use phpMyAdmin to see the hint is in use, repair tips unknown storage engine ' InnoDB ' error.(2) MySQL command console input show engines; view, nor InnoDB engine.5. Solutions(1) Use the drop tables table name;, delete the InnoDB table(2) Stop services related to MySQL service(3) Use show processlist; command to see if t
Tags: mysql master-slave synchronous master-slave version related business MySQL master-slave galera no data1) MySQL versions have been optimized for master-slave synchronization2) 5.7 is loss less, but not zero loss, when switching the data will be lost3) 5.7 True concurrent replication reduces master-slave delay, 5.6 No (based on the schema level)4) PG has a full synchronous replication mode, MySQL native version is not (only semi-synchronous). The Galera,phxsql,alisql solves the problem of sw
Oracel startup failure resolved due to power outage1 attempt to recover database failed2. Create a control fileSql>alter database backup Controlfile to trace$ls-LRT trace/Find the latest. TRC, and copy Resetlog to create the control fileSql>shutdown immediate;Sql>startup Nomountsql> Paste Control FileStarted to mountSql>recover database until CancelSql>recover DatabaseSql>alter database open;This article from "Oraclelinux" blog, declined reprint!ORA-600 processing after Oracle power
Tags: mysql startingStart the Times error message:Starting MySQL ... error! The server quit without updating PID file (/usr/local/mysql/data/qkzhi-appzookeeper-1.novalocal.pid).2017-08-25t09:14:20.974876z mysqld_safe mysqld from PID FILE/USR/LOCAL/MYSQL/DATA/QKZHI-APPZOOKEEPER-2.NOVALOCAL.P ID EndedWorkaround:Delete the/usr/local/mysql/data/mysql-bin.index file and start the success again.Why is this, I haven't researched it yet.This article is from the "Technology Change Destiny" blog, please b
full of memory, but this server's disk and memory are sufficient.
Some say is to delete the data directory under the Ibdata and Ib_logfile files, and then restart the OK, but after the test will still not start. Refer to a few links: Analysis connection: Http://qkxue.net/info/155788/MySQL feeling analysis is quite reasonable, but there is no solution!If any friend has met and successfully resolved, please advise, greatly appreciated!This article is from the "Knowledge System" blog, please be su
pos.--that way, slave will have a bit more data than master.It can be seen that the Binlog POS (130484169) Read on the slave is larger than the POS (130407973) after the master Binlog recovery, even larger than recovery (130408448) before Binlog!Slave received Binlog and does not rollback, and the slave SQL thread performs a write to cause slave data to be newer than Master!!!At the same time can see Master's Binlog Dump thread pushes Binlog content, no brush disk has been pushed to slave. MySQ
.dbf1TEMP304087043712ONLINE1YES34359721984419430280293601283584Autoextensible is yes, the data file can be automatically extended, the maximum space is 34359721984,31GB.When IO is written, it is found that no space has been written, instance abort!Query this ora-63999 in Bing, and it turns out that Oracle 11g has this problem, which is determined by a hidden startup parameter,The hidden parameter ' _datafile_write_errors_crash_instance ' was imported at Oracle 11.2.0.1,The main function is to ma
service.Or do not restart the use command to turn off read-only, but the next reboot expires: set globalread_only=off;Mysql> Show master Status \g;Note: The Reset slave All command removes the replication parameter from the library, and then the show slave status\g information is returned as empty.5) Turn the original master into slaveTo create a synchronization user on the new master:Grant Replication Slave on * * [email protected] ' IP of slave ' identified by ' replpwd ';To reset the Binlog
-fork child process, waiting until server was ready for connections.Forked process:14495Error:child process failed, exited with error number 1Because the child process failed to prompt[Email protected] ~]#/usr/local/mongodb/bin/mongod--dbpath=/data/mongodb2/db--logpath=/data/mongodb2/log/ Mongo.log--fork--port 27017--logappend--replset rep1--rest--httpinterface--maxconns=8000--keyfile=/data/mongodb2 /keyfile/securityAbout-to-fork child process, waiting until server was ready for connections.Fork
Because of the project needs, in the CentOS6.3 system, using the shell script I wrote to update the software, the operator will habitually immediately restart the power. However, after rebooting, the software is not working properly. Party a variety and I want reason ah ... It really made me miserable.All kinds of asked Niang have Ah, there is no solution.I did a few scripts upgrade experiments in the virtual machine, and there was no problem. Later, I think they update the device immediately af
what happens when Win7 shuts down without a full power outage?
Win7 the solution of the system without a complete power outage after shutdown the graphics and text tutorial:
1. Start-run (input msconfig)---Select advanced in the System Configuration Utility panel to select "Disable Fast shutdown" and restart the computer;
2, change the registry: Start-run (input regedit)--OK, in the registry found
Because of the sudden power outage caused the company's internal computer room XenServer host hung up, the system can not start, downtime before the system configuration isCpu:e5 2630 v3Memory: 128GBStorage: 3T West number Purple Plate 5 blockArray Card: LSI 9361-8iThe disk took 5 blocks to do RAID5, and when the outage failed to start, I took a lsi9361-8i card and 6 3T disks (the importance of hardware spa
Because the damn windows are automatically updated, Vmplayer is often forced to shut down.However, after restarting, a situation that does not connect to the network will occur:for-for -Network configuration ... booting system without full network configuration ...This is very hurtful. Toss for a long time have not done, finally still from the Netizen side found the solution.1. In administrator mode, locate the/etc/network/interfaces file.2. There may be many IP addresses and other information,
the returned information and its location in binary log;3. After the Slave IO thread receives the information, it writes the received log content to the end of the relay log file (mysql-relay-bin.xxxxxx) on the Slave side, And the read to the master side of the Bin-log's file name and location to the Master-info file, so that the next time you read the high-speed master "I need to start from somewhere in the Bin-log log content, please send me"4. When the Slave SQL thread detects a new addition
segment of the call is Oracle;See instructions for REMOVEIPC:Removeipc=Controls whether System V and POSIX IPC objects belonging to the user shall is removed when the user fully logs out. Takes a Boolean argument. If enabled, the userMay isn't consume IPC resources after the last of the user's sessions terminated. This covers System V semaphores, shared memory and message queues, as well as POSIXShared memory and message queues. Note that IPC objects of the root user is excluded from the effect
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.