mariadb : user log & logrotate Hint

# vi /etc/my.cnf   [mysqld] general-log general-log-file=/var/log/mariadb/queries.log log-output=table,file     [mysqld_safe] long_query_time = 3 #log=/var/log/mariadb/mysqld.log log-slow-queries=/var/log/mariadb/mysqld-slow.log log-error=/var/log/mariadb/mariadb.log     [mysqladmin] password = XXXXXXX user = root     # vi /etc/logrotate.d/mariadb     /var/log/mariadb/mariadb.log {         create 640 mysql mysql         notifempty         daily     […]

Read More

centos 7 : set multi gateway Hint

vi /etc/sysconfig/network-scripts/ifcfg-eth0 TYPE=Ethernet BOOTPROTO=none DEFROUTE=yes PEERDNS=yes PEERROUTES=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_PEERDNS=yes IPV6_PEERROUTES=yes IPV6_FAILURE_FATAL=no UUID=XXXX-XXXX-XXXX-XXXX-XXXXXXXXX NAME=eth0 DEVICE=eth0 ONBOOT=yes DNS1=XXX.XXX.XXX.XXX IPADDR=222.222.222.123 NETMASK=255.255.255.0 GATEWAY=222.222.222.1   vi /etc/sysconfig/network-scripts/ifcfg-eth1 HWADDR=XX:XX:XX:XX:XX:0C TYPE=Ethernet BOOTPROTO=none DNS1=114.141.2.92 DNS2=218.234.21.41 DEFROUTE=no IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME=eth1 UUID=XXXX-XXXX-XXXX-XXXX-XXXXXXXXX IPV6_PEERDNS=yes   IPV6_PEERROUTES=yes ONBOOT=yes IPADDR=192.168.0.10 PREFIX=24 GATEWAY=192.168.0.1   vi /etc/sysconfig/network ip rule add from 222.222.222.0/24 pref 200 lookup […]

Read More