[DRBD-user] read-only access on Secondary for MySQL (InnoDB) Raw Partition?
lmb at suse.de
Tue Jun 22 11:02:36 CEST 2004
Josh McAllister <josh at bluehornet.com> said:
> I understand why we can't do read only access of ext2/3 partitions as we
> need the file system to recognize that the underlying device is changing
> even though it's read-only. I'm wondering though if anyone has tried
> accessing a drbd device from MySQL as an InnoDB raw partition (for
> read-only of course)? If this can be accomplished it would be a great
> way to do some load balancing using the secondary machine for selects
> and the primary for all write operations.
I'd not bother, as MySQL can do read-only slaves internally and
consistently in a supported fashion.
Lars Marowsky-Brée <lmb at suse.de>
High Availability & Clustering \ ever tried. ever failed. no matter.
SUSE Labs | try again. fail again. fail better.
Research & Development, SUSE LINUX AG \ -- Samuel Beckett
More information about the drbd-user