Posts Tagged mysql

Install ZeroMQ plugin for MySQL

Following steps in CentOS 6.x

Download cmake , use the binary one. such as: cmake-3.2.3-Linux-x86_64.sh
http://www.cmake.org/download/

Install Cmake
chmod +x cmake-3.2.3-Linux-x86_64.sh
./cmake-3.2.3-Linux-x86_64.sh

Get mysql zeromq plugin:
git clone https://github.com/netkiller/mysql-zmq-plugin.git
Read the rest of this entry »

No Comments

focus on security of Linux this weekend

focus on security of Linux this weekend.

APF (Advanced Policy Firewall) and more tools
http://www.rfxn.com/projects/
there are all written in shell, such as APF based on iptables. good example in sys admin with shell.

OSSEC is an Open Source Host-based Intrusion Detection System.
It performs log analysis, file integrity checking, policy monitoring, rootkit detection, real-time alerting and active response.It runs on most operating systems, including Linux, MacOS, Solaris, HP-UX, AIX and Windows.
it is C/S model, just one server and server agentd, can monitor the system.
http://www.ossec.net/


Some tips on optimize the MySQL database

MySQL Performance Tuning Primer Script – http://www.day32.com/MySQL/

MySQLTuner – http://rackerhacker.com/mysqltuner/

MONyog – MySQL Monitor and Advisor – http://www.webyog.com/en/

More links:
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB
http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php
http://hackmysql.com/mysqlreport
http://www.mysqlperformanceblog.com/tools/
http://video.google.com/videoplay?docid=2524524540025172110

,

No Comments

mysqlbinlog的日志

mysql的一些事件都以binary的格式存贮,通过mysqlbinlog这个工具来实现的。
mysqlbinlog可以用于Replication和数据库的恢复
这里主要是说一下mysqlbinlog日志的清理

mysqlbinlog日志的清除
mysql -uroot
PURGE {MASTER | BINARY} LOGS TO ‘log_name’
PURGE {MASTER | BINARY} LOGS BEFORE ‘date’
用于删除列于在指定的日志或日期之前的日志索引中的所有二进制日志。这些日志也会从记录在日志索引文件中的清单中被删除,这样被给定的日志成为第一个。
eg:
PURGE MASTER LOGS TO ‘mysql-bin.030’;
PURGE MASTER LOGS BEFORE ‘2009-01-10 11:00:00’; Read the rest of this entry »

No Comments