运维文档开机

运维文档开机

cd /home/activeMQ/apache-activemq-5.15.9/bin/linux-x86-64

./activemq start

cd /home/nginx/sbin
./nginx

cd /home/redis/bin

./redis-server &

cd /home/zookeeper/zookeeper-3.4.8/bin

./zkServer.sh start 

cd /home/emqx/emqx/bin  
 

./emqx restart

qrtz_blob_triggers   QRTZ_BLOB_TRIGGERS
qrtz_calendars         QRTZ_CALENDARS
qrtz_cron_triggers   QRTZ_CRON_TRIGGERS
qrtz_fired_triggers  QRTZ_FIRDE_TRIGGERS
qrtz_job_details     QRTZ_JOB_DETAILS
qrtz_locks           QRTZ_LOCKS
qrtz_paused_trigger_grps  QRTZ_PAUSED_TRIGGER_GRPS
qrtz_scheduler_state QRTZ_SCHEDULER_STATE
qrtz_simple_triggers QRTZ_SIMPLE_TRIGGERS
qrtz_simprop_triggers QRTZ_SIMPROP_TRIGGERS
qrtz_triggers        QRTZ_TRIGGERS

0 1 0 * * ?
0 0 7-23/1 * * ?
0 0 1 1/1 * ?
0 20 0 * * ?
0 52 13 * * ?

select @@GLOBAL.sql_mode;

 set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

 set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

set @@GLOBAL.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

set GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

 flush privileges;