[DRBD-user] read-only access on Secondary for MySQL (InnoDB) Raw Partition?

Lars Marowsky-Bree lmb at suse.de
Tue Jun 22 11:02:36 CEST 2004


On 2004-06-21T12:12:02,
   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.
> 
> Thoughts?

I'd not bother, as MySQL can do read-only slaves internally and
consistently in a supported fashion.


Sincerely,
    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 mailing list