Mysql-HA
zbdba
live in oracle
展开
-
Mysql HA-Install DRBD+HeartBeat+Mysql On Redhat 6.3
配置信息: Primary: Name:zbdba1 OS:redhat 6.3 IP:192.168.56.220 drbd:8.4.0 heartbeat:3.0.4 Standby: Name:zbdba2 OS:Redhat 6.3 IP:192.168.56.221 drbd:8.4.0 heartbeat:3.0.4 主要分为如下步骤: 1、安装DRBD 2、安装Mysql原创 2015-01-21 10:14:08 · 1783 阅读 · 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 · 1026 阅读 · 0 评论 -
Mysql基于binlog主从复制配置
上次配置mysql的主从复制还是年初的时候,没想到现在又开始使用mysql了。话不多说,进入正题 Master-Slave 搭建环境: Master: Os: rhel-server-6.3-x86_64 Mysql: MySQL -5.5.35-1 虚拟机:Virtual BOX Ip:192.168.56.12 Slave: Os: rhel-server-6.3-x86_64 Mysql原创 2014-12-10 14:17:54 · 1565 阅读 · 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 · 1101 阅读 · 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 · 1776 阅读 · 0 评论 -
Mysql HA-Install Keepalived+LVS+Mysql(双主) On Redhat 6.3
主机信息: 调度节点: Name:lvs OS:Redhat 6.3 IP:192.168.56.235 VIP:192.168.56.236 数据节点1: Name:zbdba1 OS:Redhat 6.3 IP:192.168.56.230 数据节点2: Name:zbdba2 OS:Redhat 6.3 IP:192.168.56.231 客户端: Name:ogg2 OS:Redh原创 2015-01-28 09:40:41 · 1724 阅读 · 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 · 1132 阅读 · 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 · 1748 阅读 · 0 评论