
Mysql-HA
zbdba
live in oracle
展开
-
Mysql HA-Install DRBD+HeartBeat+Mysql On Redhat 6.3
配置信息:Primary:Name:zbdba1OS:redhat 6.3IP:192.168.56.220drbd:8.4.0heartbeat:3.0.4Standby:Name:zbdba2OS:Redhat 6.3IP:192.168.56.221drbd:8.4.0heartbeat:3.0.4主要分为如下步骤:1、安装DRBD2、安装Mysql原创 2015-01-21 10:14:08 · 1863 阅读 · 0 评论 -
Mysql高性能之Memcached(1)
本文将介绍Memcached的安装与使用What is Memcached?Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applica原创 2014-12-19 09:22:56 · 1090 阅读 · 0 评论 -
Mysql基于binlog主从复制配置
上次配置mysql的主从复制还是年初的时候,没想到现在又开始使用mysql了。话不多说,进入正题Master-Slave 搭建环境:Master:Os: rhel-server-6.3-x86_64Mysql: MySQL -5.5.35-1虚拟机:Virtual BOXIp:192.168.56.12Slave:Os: rhel-server-6.3-x86_64Mysql原创 2014-12-10 14:17:54 · 1630 阅读 · 0 评论 -
Mysql高性能之Memcached(2)
本文将介绍在部署Memcached中需要注意的问题以及Memcached的分布式算法无论你是新上线的系统还是已经上线很久的系统。我们都可以很简单的对Memcached进行配置,但是配置之前我们需要注意如下问题:1.memcached is only a caching mechanism. It shouldn't be used to store information原创 2014-12-19 14:37:53 · 1159 阅读 · 0 评论 -
Install Mysql MHA On Redhat6.3
官方介绍:MHA performs automating master failover and slave promotion with minimal downtime, usually within 10-30 seconds. MHA prevents replication consistency problems and saves on expenses of having to原创 2015-02-12 09:38:04 · 1831 阅读 · 0 评论 -
Mysql HA-Install Keepalived+LVS+Mysql(双主) On Redhat 6.3
主机信息:调度节点:Name:lvsOS:Redhat 6.3IP:192.168.56.235VIP:192.168.56.236数据节点1:Name:zbdba1OS:Redhat 6.3IP:192.168.56.230数据节点2:Name:zbdba2OS:Redhat 6.3IP:192.168.56.231客户端:Name:ogg2OS:Redh原创 2015-01-28 09:40:41 · 1791 阅读 · 0 评论 -
Install Mysql MMM On Redhat6.3
哈哈,年底最后一篇文章。写完今天下午放假。MMM官方介绍:MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configur原创 2015-02-13 14:11:35 · 1205 阅读 · 0 评论 -
Migration from classic replication to GTID replication(Online)
从mysql 5.6.5版本开始支持GTID,现在大部分生产环境也开始慢慢切换到GTID模式。为什么要切换到GTID复制模式?●Setting up MySQL replication is so simple now!● Consistency is guaranteed between master and slaves.● Simple to determine incons原创 2015-08-10 10:45:15 · 1822 阅读 · 0 评论