Digital Marketing

Loading...

Monitor MySQL replication

The most important variables are Slave_IO_Running, Slave_SQL_Running and Seconds_Behind_Master. Two first variables should be equal to ‘Yes’, and Seconds_Behind_Master should be 0 or close to it. These variables indicate that both replication threads are running and slave is up to date with master.

Comments

Post a Comment

Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

Encountered:  $  sudo service ssh --full-restart  * Stopping OpenBSD Secure Shell server sshd                                                                     [ OK ]  * Starting OpenBSD Secure Shell server sshd                                                                            sshd: no hostkeys available -- exiting. Run ssh-keygen -A In the /etc/ssh/ folder, and then restart the server by: $  sudo service ssh --full-restart  * Stopping OpenBSD Secure Shell server sshd                                                                     [ OK ]  * Starting OpenBSD Secure Shell server sshd                                                                     [ OK ]
Read more

PowerMTA pmta command

Usage: pmta [options] command where 'options' are:     --help                display this message     --xml                 display result in XML     --dom                 display result as DOM-like "variables" and where 'command' is one of:     clear dnscache domainname     check mfrom [--tcp] [--dumppackets] mfrom ip     check spf [--tcp] [--dumppackets] ip heloDomain [mailFrom]     delete [--dsn] [--queue=domain[/vmta]] [--orig=addr] [--rcpt=addr] [--jobId=id] [--envId=id] [--older-than=time-interval] [--no-accounting]     deregister [--user=name] [--local-only] [--retain-unloaded]     disable source [--reenable-after=interval] ip domain[/vmta]     enable source ip domain[/vmta]     list [--queue=domain[/vmta]] [--orig=addr] [--rcpt=addr] [--jobId=id] [--envId=id] [--maxitems=n] [--older-than=time-interval] [--pause] [--priority] [--schedule]     pause queue domain[/vmta]     pause job jobid     register [--user=name] [--label=name] [--webmon-ip=ip] [--webm
Read more