PlanetMysql.ru — информация о СУБД MySQL

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 he did it a bit more prominently ... an upfront chapter outlining the different approaches and when which approach is a match could have been better. The avid reader now might be 80 pages into MySQL cluster before he realizes it's not going to be a match for his problem.

I really loved the part where Alex correcly mentions that you should probably be using Puppet or so to manage the config files of your environment, rather than scp them around your different boxes ..

Alex then goes on to describe setting up MySQL replication and Multi Master replicataion with the different approaches one can take here, he gives some nice tips on using LVM to reduce the downtime of your MySQL when having to transfer the dataset of an already existing MySQL setup, good stuff.

He then goes on to describe MySQL with shared storage ... if you only mount your redundant sandisk once on your MySQL nodes my preference would probably be a Pacemaker stack rather than a RedHat Cluster based setup, but his setup seems to work too. Alex quickly touches on using GFS to have your data disk mounted simultaneously on both nodes (keep in mind with only 1 active MySQLd) and then goes on to describe a full DRBD based MySQL HA setup

The last chapter titled Performance tuning gives some very nice tips on both tuning your regular storae, as your
GFS setup but also the tuning parameters for MySQL Cluster

I was also really happy to see the Appendixes on the basic installation where he advocates the use of Cobbler , Kickstart and LVM ..

One of the better books I read the past couple of years .. certainly the best book from Packt so far , I hope there is more quality stuff coming from that direction !

Technorati Tags: cobbler drbd ha heartbeat linux-ha mysql pacemaker puppet

Share with Shareomatic!

Thanks primarily to the efforts of Senko Rašić and Ante Karamatić, the Pacemaker cluster stack is being augmented with support for Upstart services. This is in addition to support for OCF resource agents and LSB/SysV init scripts, both of which have been supported in Pacemaker for years.

This is functionality now present in the upstream Mercurial trees, and we need testers to get in shape for release. Yes, that means you can help!

This is primarily relevant to you if you use a distribution with upstart as its default init daemon. This includes Ubuntu lucid, OpenSuSE 11.3, recent Fedora releases, and others. To enable upstart support, you will need an upstream hg tip for the cluster-glue libraries, and for Pacemaker.

Here’s how I build cluster-glue with upstart support from local hg checkouts:

hg clone http://hg.linux-ha.org/glue cluster-glue
cd cluster-glue
./autogen.sh
# Next step is important: must include --enable-upstart to enable upstart support
./configure --enable-upstart
make
sudo make install

… and then I simply continue like I normally would for a Pacemaker from-source install, as illustrated here.

When I’m done, and have configured my Heartbeat/Pacemaker cluster as shown here, I can proceed with adding an Upstart based job to my cluster configuration:

crm configure
primitive mysql upstart:mysql \
  op start timeout=120s
  op stop timeout=120s
  op monitor interval=30s
commit

And that’s it! Now I can use the mysql upstart job like any other cluster resource. Try it out — and please report back any issues you encounter!

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 is your chance to get involved!

So if you plan to attend Plumbers or just happen to be in the area, please submit your talk! Miniconference talks are not expected to be full-blown presentations. Instead, you can float an idea in just a 5-10 minute talk and then stimulate a vibrant group discussion.

Even if you are not attending, you can still help! We are always eager to hear from our user community. What HA problems are you currently facing that the existing Linux clustering stack does not solve? How well does your application integrate with HA? Where can we improve? What’s already good, and can be made better? What sucks?

Feel free to comment below. Or send us an email on one of the mailing lists. Or grab us in #linux-ha or #linux-cluster on freenode. Make yourself heard!

A little while back we did a webinar on using Pacemaker to fully automate MySQL replication. We now have a recording of that webinar available from our web site.

A couple of new webinar recordings are available from our web site:

• Upgrading to Pacemaker on Debian squeeze tells you all there is to know about upgrading to the Pacemaker cluster manager on the upcoming Debian release, “squeeze”.
• High Availability for Oracle databases shows you how to leverage the Linux cluster stack to deploy highly available Oracle databases.

Like our live webinars, the recordings are of course free of charge. Enjoy!

While Yves presents a valid approach for managing NDB with Pacemaker and the anything Linux-HA resource agent (a generic wrapper for any daemon based application), the XML configuration shown is likely to have people running away screaming. This is how we had to do things back in the Heartbeat 2 days, which meant that as a cluster admin you would permanently run around with a loaded cocked shotgun with the muzzle pressed firmly against your foot.

Those days are long gone. Please don’t do this anymore. You also no longer need to use the low-level tools such as cibadmin or crm_attribute.

We have the crm shell for those things now. So instead of

crm_attribute -t crm_config -n stonith-enabled -v false
crm_attribute --attr-name symmetric-cluster --attr-value false

we now simply write

crm configure property stonith-enabled=false symmetric-cluster=false

Can’t remember a property name or supported value? Interactive mode and tab completion to the rescue:

# crm configure
crm(live)configure# property sto<tab>
stonith-action=   stonith-enabled=  stonith-timeout=
crm(live)configure# property stonith-enabled=<tab>
stonith-enabled (boolean, [true]):
Failed nodes are STONITH'd
crm(live)configure# property stonith-enabled=false symmetric-cluster=false
crm(live)configure# commit

A bit more convenient, isn’t it? Now let’s get rid of dealing with XML. Instead of a horrific avalanche of tags and attributes that we then have to feed into the system with cibadmin -Q, let’s do this!

# crm configure
crm(live)configure# primitive mgmd ocf:heartbeat:anything \
	params binfile="/usr/local/bin/fake_ndb_mgmd"
crm(live)configure# primitive ndbcluster ocf:heartbeat:anything \
	params binfile="/usr/local/bin/fake_ndb_cluster_start"
crm(live)configure# primitive ndbd ocf:heartbeat:anything \
	params binfile="/usr/local/bin/fake_ndbd"
crm(live)configure# clone ndbdclone ndbd \
	meta clone-max=2
crm(live)configure# location loc-1 mgmd inf: testvirtbox
crm(live)configure# location loc-2 ndbcluster inf: testvirtbox
crm(live)configure# location loc-3 ndbdclone -inf: testvirtbox
crm(live)configure# order ordered-set-1 inf: mgmd ndbdclone ndbcluster
crm(live)configure# commit 

And of course, we get tab completion and online help there too. Give it a shot!

Just in case you haven’t noticed, Ubuntu 10.04 “Lucid Lynx” has arrived. I upgraded my personal box over the weekend, and am happy to report that things went pretty flawlessly for me. So I’m now a happy lucid user.

What’s more important for the ever-growing cluster community is the fact that this LTS release comes with built-in support for the Pacemaker cluster stack — and indeed, it’s the first commercially-supported distribution that comes with support for both the Heartbeat and the Corosync cluster messaging layer. And it’s easy, too!

Here’s how I install the Pacemaker stack with Heartbeat (which I prefer) on an Ubuntu box:

aptitude install heartbeat pacemaker

And if you choose to go with Corosync, here’s how.

aptitude install corosync pacemaker

… and you’re good to go!

Credit for Ubuntu cluster stack packaging goes to Ante Karamatić (ivoks) and Andres Rodriguez (roaksoax), along with the rest of the ubuntu-ha team. Their work builds on Debian packaging by Martin Loschwitz, Guido Günther, Frederik Schüler and others.

MySQL replication support for the Pacemaker cluster manager (the stuff that we explained in this webinar) has made it into the Linux-HA resource agents default branch. If you are interested in testing — and you should! — please read the extended announcement. Feedback is extremely welcome on the linux-ha-dev mailing list.

We are expecting to release this as part of resource-agents 1.0.4, in late May/early June.

We’re sticking with databases for our current round of webinars. Up next is an overview of Oracle high availability clustering on Linux.

In this 45-minute presentation, we will show you how to quickly and easily configure an Oracle database with an associated TNS Listener in a failover configuration, how to monitor both your database and your listener for failures, and how to have Pacemaker automatically intervene and recover from outages.

Brought to you in association with our friends over at Novell, we’ll showcase Oracle in combination with SUSE Linux Enterprise High Availability Extension.

This webinar is scheduled for April 28, 2010 at 1500 UTC.

As all of our webinars, this one requires registration — but we’ve made things easier for you. Just fill in the registration form right here and you’re good to go!

By the way: if you want to be notified of future webinar announcements, you can add the categorized RSS feed for webinars to your feed reader. This is the RSS 2.0 URL: http://blogs.linbit.com/florian/category/webinar/feed/



Yesterday’s webcast is now available for playback.

If you want a PDF of the slides, drop me an email or leave a note on our web site.