Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
Am 12.06.2013 um 15:44 schrieb Robinson, Eric: > 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? It says nothing, because DRBD does not essentially the same thing as rsync. DRBD does "essentially the same thing" as RAID-1. We run a dozen servers with Xen+DRBD+heartbeat+pacemaker, running some 100++ Mysql-schemas (each of them with 100++ tables), some MyIsam, most innodb. Failover or migrate was never a problem for the databases. The three most time-consuming problems with databases are: - character encoding - character encoding - character encoding caused by developers of applications and data maintainers. Helmut Wollmersdorfer