Trying to do high availability

Hi,

I am trying to complete this library article and am not getting the same result at the "Configure Cluster Resources" section.

http://library.linode.com/linux-ha/high … untu-10.04">http://library.linode.com/linux-ha/highly-available-file-database-server-ubuntu-10.04

I get the following:

node $id="f1225930-62b5-4158-a350-e7309b5124c3" ha1-db
property $id="cib-bootstrap-options" \
dc-version="1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd" \
cluster-infrastructure="Heartbeat"

rather than what is described in the article of:

node $id="1a0e5ce2-1787-433a-9ffc-64badc4c5994" ha2-db
node $id="ec7c37eb-c7fc-4eb4-b7dc-2f9dc6c9483b" ha1-db
property $id="cib-bootstrap-options" \
dc-version="1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd" \
cluster-infrastructure="Heartbeat"

Mine is missing the ha2-db line at the top. Can anyone explain what I might have done wrong? I skipped the NFS and PostgreSQL portions as I just want to run a MySQL server.

Thanks, Josh

4 Replies

josh, if you just want to setup a HA-mySql server, why not just use master-slave or master-master replication that is supported natively with mysql.

It is much simpler to setup.

I am planning to do about the same thing for my webserver/appserver and figured maintaining one way of doing this would be best. Also, I plan to have more servers in other data centers in the future, and figured this was a good way to have more replication.

If I am wrong, please let me know. And if so, can you could point me to any tutorials for HA-mySQL servers?

Most HA guides will assume you have all your nodes in one data center.

If you want geographically separated HA, that is a whole other ballpark and will be expensive to implement.

Figured it out. I was using iptables, and was blocking UDP port 694 needed for Heartbeat.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct