High-Availability with Fedora, DRBD, Heartbeat and Mon [and Xen]
Prerequisites: You must not be an idiot. make, gcc, the glibc development libraries, and the flex scanner generator must be installed on your target systems.
Now that we’ve gotten that out of the way, let’s get started. Remember to perform each step on BOTH your machines.
Do everything as your own user, not as root, unless otherwise noted.
DRBD:
This was a pain in the ass. I followed Chapter 4 of the DRBD User Guide, somewhat.
Ordering individual results in a UNION statement, or “Oh UNION/ORDER BY, how do I hate thee? Let me count the ways.”
Suppose we have the following columns in a table:
+-----+-----------------+ | id | name | +-----+-----------------+ | 85 | Medicine | | 156 | Social Sciences | | 166 | Other Fields | | 184 | Business | +-----+-----------------+ 4 rows in set (0.00 sec)read on
Posted at 11am on 04/08/08 | no comments | Filed Under: SQL
