Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 30 10 Older Entries

Displaying posts with tag: Heartbeat (reset)

The Full Monty – Version 2
+0 Vote Up -0Vote Down

Installing MySQL on CentOS 6.2 with PaceMaker, MHA and more

When I work with High Availability software, I’m reminded of the maze in the original computer adventure game “You are Lost in a maze of twisty-turny passages all alike…”.

If you search the web for HA programs you will find many well maintained projects all related that refer each other. The goal of this document is to give you with a step by step guide to a production worthy MySQL system. It should provide at least 99.999% access to your data and be able to scale read requests as …

  [Read more...]
Busy weeks ahead!
+0 Vote Up -0Vote Down

I’m speaking at Percona Live, LinuxCon Europe, and linux.conf.au. And I just co-founded a new company.

I have a few busy weeks behind me, and even busier weeks ahead. If you’ve been wondering why recently I haven’t been updating this space too frequently, here’s why:

Yours truly and fellow ex-Linbiters Martin Loschwitz and Andreas Kurz have recently founded …

  [Read more...]
The Full Monty – Scientfic Linux 6.1, drbd, PaceMaker, MySQL, Tunsten Replication and more
+0 Vote Up -0Vote Down

PART 1 – This will be a multi part post.

THIS DOCUMENT IS BEING UPDATED – PLEASE WATCH FOR CHANGES!

After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again.
The company:

  • chooses a Database Management System (MySQL)
  • installs the DBMS on a computer with other processes
  • writes many programs to access the data (Without concern on how the queries are written.)
  • moves DBMS to a computer of its own and writes more programs
  • buy bigger computer to run the DBMS and …

  [Read more...]
Quick How-To for DRBD + MySQL + LVS
+0 Vote Up -0Vote Down

I wrote this up a while ago and decided that I didn’t want to lose it in a shuffle of documents during my transition to a new workstation. It’s the basics of setting up Heartbeat (LVS) + DRBD (block replication between active/passive master servers) + MySQL. This should give you the basics of a H/A system without the benefits of SAN but also without the associated cost. The validity of this setup for H/A purposes is highly dependent on your workload and environment. You should know the ins and outs of your H/A solution before deciding to blame the system for not performing as expected. As with all production systems you should test, test, test and test some more …

  [Read more...]
Cluster Stack update for Debian
+1 Vote Up -0Vote Down

Last week, the Linux-HA project made its Heartbeat 3.0.4 and Cluster Glue 1.0.7 release, and Pacemaker released 1.0.10 a few weeks back. Thanks to the amazing Simon Horman (horms to IRC regulars), those releases have been uploaded to Debian unstable (sid) yesterday.

What’s sid?

  [Read more...]
Linux-HA documentation updates
+1 Vote Up -0Vote Down

I’ve just announced a rather large update to the Linux-HA documentation.

We now finally have a Developer’s Guide for OCF resource agent authors and contributors. If you want to write a new resource agent to bundle with your project, or plan to send a patch for an existing resource agent, then this guide is for you.

…  [Read more...]
Howto setup MySQL on a DRBD volume
+2 Vote Up -0Vote Down

One more DRBD tutorial, this time I will describe howto setup MySQL with DRBD (Distributed Replicated Block Device). Purpose This document describes how to to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device). Introduction In this tutorial we will setup two Debian Linux nodes with a DRBD volume. MySQL will be [...]

High Availability MySQL Cookbook , the review
+1 Vote Up -0Vote Down

When I read on the internetz that Alex Davies was about the publish a Packt book on MySQL HA I pinged my contacts at Packt and suggested that I'd review the book .

I've ran into Alex at some UKUUG conferences before and he's got a solid background on MySQL Cluster and other HA alternatives so I was looking forward to reading the book.

Alex starts of with a couple of indepth chapters on MySQL Cluster, he does mention that it's not a fit for all problems, but I'd hoped …

  [Read more...]
Upcoming High Availability Clustering miniconf at Linux Plumbers Conference
+0 Vote Up -0Vote Down

This year’s Linux Plumbers Conference is taking place November 3-5, in Cambridge, MA, United States. The CfP is already closed and the program is due any day now, but the co-located miniconference on high availability clustering is still accepting proposals. This …

  [Read more...]
MySQL HA with DRDB and Heartbeat on CentOS 5.5
+1 Vote Up -1Vote Down

This is one of a few MySQL High Availability strategies.  I have used this for years and found it work great.  If you don’t know about DRBD and MySQL you should read Peter’s comments.

These are step by step instructions for Redhat 5 or CentOS.

If you need more details please refer to:
http://www.drbd.org/users-guide/

Configuring MySQL for DRBD


  [Read more...]
Showing entries 1 to 10 of 30 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.