tag:blogger.com,1999:blog-31421954.post598936087416058187..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : replicate-rewrite-dbDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-31421954.post-67077331865196126772008-10-24T06:57:00.000-07:002008-10-24T06:57:00.000-07:00Try this: I believe it works well. You should be r...Try this: I believe it works well. <BR/>You should be replicating using the new database name.<BR/><BR/>[mysqld]replicate-rewrite-db="Olddb->NewDB"<BR/>replicate-do-table=NewDB.TABLEAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-57120130321964210172007-04-06T17:35:00.000-07:002007-04-06T17:35:00.000-07:00I have not worked with DRBD specifically, but with...I have not worked with DRBD specifically, but with similar products and I can say that since there is cached indexes, and unflushed tables replicating the data underneath the mysql process will replicate data that will appear corrupt to another mysql process from a restore. For instance a lot of companies use LVM snapshot to make backups but report that the restore of these backups are unusable for a myriad of reasons. In theory it should work, yet a lot of info is tied to what's in mysql memory and has not made it to disk - so use with caution.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-53831325264036061842007-04-06T15:18:00.000-07:002007-04-06T15:18:00.000-07:00So, in my environment, we're planning a migration ...So, in my environment, we're planning a migration and upgrade. Getting all our old 4.0 and 4.1 systems bumped to 5.0. And one of the sustaining engineering people has latched onto DRBD with all the strength his jaws can muster.<BR/><BR/>This is the first I'd heard of it. It's block level replication, so how well does it deal with cached indexes, unflushed tables, all that fun stuff? Have you worked with it at all?Anonymousnoreply@blogger.com