[DRBD-user] drbd+mysql+innodb

Dirk Bonenkamp - ProActive dirk at proactive.nl
Wed Jun 12 16:24:10 CEST 2013

Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.

Hi Eric,

We did the same conversion about a year ago. We run MySQL with InnoDB on
a DRDB back-end. There's alot of stuff that's different between MyISAM
and InnoDB, but the DRBD thing is the same.

What you say about backups is correct, but this hasn't anything to do
with DRBD. DRDB will do fine, some other quick non-DRDB things:

- MySQL tuning is (even more) essential with InnoDB.
- InnoDB tables use (a lot) more diskspace than MyISAM, our disk usage
was nearly 300% of MyISAM's usage for the same dataset.
- If you want performance, you want to be able to load your dataset in

Kind regards,


Op 12-6-2013 15:44, Robinson, Eric schreef:
> We have been a MyISAM shop forever but we are considering switching to
> innodb. There is scant information available on using innodb with
> drbd. Are there special considerations and pitfalls? I have been told
> that it is not possible to backup innodb by doing a simple rsync of
> the data directory to another server like we can do with myisam. If
> that is true, what does that say about using innodb with drbd, which
> does essentially the same thing?
> --
> Eric Robinson
> Disclaimer - June 12, 2013 This email and any files transmitted with
> it are confidential and intended solely for
> *'drbd-user at lists.linbit.com'*. If you are not the named addressee you
> should not disseminate, distribute, copy or alter this email. Any
> views or opinions presented in this email are solely those of the
> author and might not represent those of Physicians' Managed Care or
> Physician Select Management. Warning: Although Physicians' Managed
> Care or Physician Select Management has taken reasonable precautions
> to ensure no viruses are present in this email, the company cannot
> accept responsibility for any loss or damage arising from the use of
> this email or attachments.
> _______________________________________________
> drbd-user mailing list
> drbd-user at lists.linbit.com
> http://lists.linbit.com/mailman/listinfo/drbd-user

ProActive Software <http://www.proactive.nl>
T 	023 - 5422299
www.proactive.nl <http://www.proactive.nl>
My status <skype:dirkbonenkamp?call>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20130612/e3baf9f6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.gif
Type: image/gif
Size: 3966 bytes
Desc: not available
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20130612/e3baf9f6/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: linkedin.gif
Type: image/gif
Size: 1965 bytes
Desc: not available
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20130612/e3baf9f6/attachment-0001.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dirkbonenkamp
Type: image/png
Size: 755 bytes
Desc: not available
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20130612/e3baf9f6/attachment.png>

More information about the drbd-user mailing list