mysql數(shù)據(jù)庫高可用性方案-資料下載頁
2025-06-07 07:57本頁面
【正文】 此時(shí)在主機(jī)上面執(zhí)行這個(gè)腳本，如下所示開始往數(shù)據(jù)庫的log表里面插入數(shù)據(jù)了[root@test1 ~] ./add 1 to table logadd 2 to table logadd 3 to table logadd 4 to table logadd 5 to table logadd 6 to table log……add 2026 to table log到了插入到第2026的時(shí)候，斷開主機(jī)的網(wǎng)卡。查看備機(jī)mysql的log日志,看到備機(jī)的mysql的會(huì)有一個(gè)inndb檢查修復(fù)的操作。很快備機(jī)的mysql服務(wù)就起來了。[root@test2 ~]tail –f /var/log/100716 22:12:23 mysqld started100716 22:12:23 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible halfwritten data pages from the doublewriteInnoDB: buffer...100716 22:12:24 InnoDB: Starting log scan based on checkpoint atInnoDB: log sequence number 0 17445609.InnoDB: Doing recovery: scanned up to log sequence number 0 17451961100716 22:12:25 InnoDB: Starting an apply batch of log records to the database...InnoDB: Progress in percents: 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99InnoDB: Apply batch pleted100716 22:12:25 InnoDB: Started。 log sequence number 0 17451961100716 22:12:25 [Note] /usr/libexec/mysqld: ready for connections.Version: 39。39。 socket: 39。/tmp/39。 port: 3306 Source distribution在進(jìn)入到備機(jī)的mysql，查看log表里面的數(shù)據(jù)一共有2027條，正截止到我們?cè)跀嚅_主機(jī)執(zhí)行到的數(shù)字2026。[root@test2 ] mysql socket=/tmp/ e select count(*) from 。++| count(*) |++| 2027 |++總結(jié)：如果使用inndb引擎的話，需要去掉nfs的鎖限制，主機(jī)故障備機(jī)能夠成功的取得資源，并起來相關(guān)的服務(wù)。
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1