Monthly Archives: February 2014

360-Atlas中间件-测试及使用说明

By | 2014/02/11

概要说明 https://github.com/Qihoo360/Atlas Atlas作为中间件存在于应用和DB之间,为应用提供统一的服务接口,中间件实现读写和分离功能,避免开发人员的额外开发操作,就可以达到读写分离的目的,多slave可实现按权重均衡负载,如果应用端够强壮,可以忽略掉Atlas的sql注入检测功能。管理接口以lua语言实现,易扩展,方便问题的排查和追踪。 Atlas为360公司在MySQl-Proxy 0.8.2版本所作的而次开发二开源出来的软件,有商业公司的支持,不必担心没有技术支持,异常问题得不到解决等因素。 架构说明 – | master | / | app | –> |z6 (Atlas)| – | slave1 | \ – | slave2 |

Enable multiport for mysql cacti template of the percona monitor plugin

By | 2014/02/11

Modified cacti.tables records to archive the goal that percona plugin for mysql can monitor more than one instance with diffrenet port.All changes are based on ‘Data Input Methods’ and ‘Data template’. The flow we also used to create custom template is : ‘sctipts’ –> ‘Data Input Methods’ –> ‘Data Template’ –> ‘Graph Template’ Vaiables connect… Read More »

What happened when too small innodb_log_file_size meet a too big transaction in Percona MySQL server.

By | 2014/02/11

ENV # Percona Toolkit System Summary Report ###################### Platform | Linux Release | CentOS release 5.5 (Final) Kernel | 2.6.35.5.R610.CentOS5.5-x64.OpenBeta.KVM.MPT Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.5 Compiler | GNU CC version 4.1.2 20080704 (Red Hat 4.1.2-48). # Processor ################################################## Processors | physical = 2, cores = 4, virtual =… Read More »