<\/span><\/h2>\n\n\n\n95\u7248\u672c\u5982\u679c\u542f\u7528\u4e86\u591aVC\u6a21\u5f0f\uff0c\u5219\u5404\u79cd\u547d\u4ee4\u9700\u8981\u6307\u5b9a\u5177\u4f53\u7684vc\u3002\u5982\u679c\u4ece86\u5347\u7ea7\u4e0a\u6765\uff0c\u6216\u8005\u91c7\u7528\u4e86\u517c\u5bb9\u6a21\u5f0f\uff0c\u5219\u65e0\u9700\u6307\u5b9avc\u3002<\/p>\n\n\n\n
\u6267\u884cgcadmin\u547d\u4ee4\uff0c\u5982\u679c\u80fd\u770b\u5230gnode\u8282\u70b9\uff0c\u5219\u4e3a\u517c\u5bb9\u6a21\u5f0f\u3002\u5982\u679c\u5982\u4e0b\u9762\u7684\u8f93\u51fa\uff0c\u53d8\u6210\u4e86vcName\u5217\u8868\uff0c\u5219\u662f\u591avc\u6a21\u5f0f\u3002<\/p>\n\n\n\n
\u517c\u5bb9\u6a21\u5f0f\u7684vcname\u9ed8\u8ba4\u4e3avcname000001<\/p>\n\n\n\n
\u53ef\u4ee5gccli\u767b\u5f55\u96c6\u7fa4\uff0c\u8fd0\u884c show vcs\u67e5\u770b\u5f53\u524d\u6240\u6709vc\u3002<\/p>\n\n\n\n
gbase> show vcs;\r\n+---------+------+---------+\r\n| id | name | default |\r\n+---------+------+---------+\r\n| vc00001 | vc_a | |\r\n+---------+------+---------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n[gbase@vm151 ~]$ gcadmin\r\nCLUSTER STATE: ACTIVE\r\n\r\n====================================\r\n| GBASE GCWARE CLUSTER INFORMATION |\r\n====================================\r\n| NodeName | IpAddress | gcware |\r\n------------------------------------\r\n| gcware1 | 10.0.2.151 | OPEN |\r\n------------------------------------\r\n====================================================\r\n| GBASE COORDINATOR CLUSTER INFORMATION |\r\n====================================================\r\n| NodeName | IpAddress | gcluster | DataState |\r\n----------------------------------------------------\r\n| coordinator1 | 10.0.2.151 | OPEN | 0 |\r\n----------------------------------------------------\r\n====================================================\r\n| GBASE VIRTUAL CLUSTER INFORMATION |\r\n====================================================\r\n| VcName<\/span> | DistributionId | comment |\r\n----------------------------------------------------\r\n| vc_a | 1 | vc a for example |\r\n----------------------------------------------------\r\n\r\n1 virtual cluster: vc_a\r\n1 coordinator node\r\n0 free data node\r\n\r\n[gbase@vm151 ~]$\r\n<\/code><\/pre>\n\n\n\n<\/span>gcadmin\u5de5\u5177<\/span><\/h2>\n\n\n\n<\/span>\u6e05\u7406\u6307\u5b9aIP\u8282\u70b9\u7684\u6240\u6709event<\/span><\/h3>\n\n\n\n\u65b0\u529f\u80fd\u63d0\u9192\uff1a\u5982\u679c\u662f862Build43R35.5patch10\u53ca\u7248\u672c\uff0c\u53ef\u4ee5\u67e5\u770b\u540e\u9762gcware\u63a5\u53e3\u5feb\u901f\u6309IP\u6e05\u7406\u7684\u65b9\u6848\u3002<\/span><\/p>\n\n\n\n\u6ce8\u610f\uff1a\u672c\u547d\u4ee4\u5728V95\u7248\u672c\u624d\u6709\uff0cV8\u7cfb\u5217\u8bf7\u7528\u540e\u9762\u7ae0\u8282\u7684\u547d\u4ee4\u505a\u6e05\u7406\u3002<\/p>\n\n\n\n
gcadmin rmfeventlog ip<\/p>\n\n\n\n
\u5176\u4e2dip\u662f\u6e05\u9664event\u7684\u8282\u70b9IP\u5730\u5740\u3002<\/p>\n\n\n\n![\"\"](\"http:\/\/www.gbase8.cn\/wp-content\/uploads\/2020\/06\/image-57.png\")
<\/figure>\n\n\n\n<\/span>\u6307\u5b9a\u6761\u4ef6\u6e05\u7406<\/span><\/h3>\n\n\n\n\u5982\u4e0b\u4e09\u4e2a\u547d\u4ee4\uff0c\u5206\u522b\u6e05\u7406dml,ddl\u548cdmlstorage\u7684event. \u5176\u4e2d\u53c2\u6570\u548c\u7528\u6cd5\u5b8c\u5168\u76f8\u540c\u3002<\/p>\n\n\n\n
\u539f\u5219\u4e0a\u6e05\u7406\u4f18\u5148\u7ea7\uff0cdmlstorag > ddl > dml\u3002<\/p>\n\n\n\n
type<\/strong> \uff1a\u6e05\u7406\u65b9\u6cd5\uff0c\u6309\u7167\u8fd9\u4e2a\u65b9\u6848\u6e05\u7406event,\u5305\u542b\u540e\u9762\u7684\u56db\u79cd\u65b9\u6cd5:<\/p>\n\n\n\n- 0 = eventid \u6309\u7167\u5177\u4f53\u7684\u4e8b\u4ef6\u7f16\u53f7\u6e05\u7406<\/li>
- 1 = tablename \u6e05\u7406\u6307\u5b9a\u8868\u540d\u5b57\u7684\u6240\u6709\u4e8b\u4ef6<\/li>
- 2 = nodeip \u6e05\u7406\u6307\u5b9aIP\u4e0a\u7684\u6240\u6709\u4e8b\u4ef6<\/li>
- 3 = tablename nodeip \u6e05\u7406\u6307\u5b9a\u8868\u540d\u5b57\uff0c\u6307\u5b9aIP\u4e0a\u7684\u6240\u6709\u4e8b\u4ef6<\/li><\/ul>\n\n\n\n
\u6bd4\u5982\u6e05\u7406\u6307\u5b9a\u8282\u70b9\u7684\u6240\u6709dmlevevt<\/p>\n\n\n\n
gcadmin rmdmlevent 2 192.168.0.2<\/code><\/p>\n\n\n\n\u5176\u4e2d2\u4ee3\u8868\u6309\u7167IP\u6e05\u7406\uff0c\u540e\u9762\u7684\u53c2\u6570\u662fIP\u5730\u5740<\/p>\n\n\n\n
<\/span>gcadmin rmdmlevent<\/span><\/h4>\n\n\n\n\u6e05\u7406dmlevent\u3002<\/p>\n\n\n\n
\u5b8c\u6574\u547d\u4ee4<\/p>\n\n\n\n
gcadmin rmdmlevent type [eventid | tablename | nodeip | tablename nodeip] <\/p>\n\n\n\n
gcadmin rmdmlevent 0 10234\ngcadmin rmdmlevent 1 testdb.t1\ngcadmin rmdmlevent 2 192.168.0.3\ngcadmin rmdmlevent 3 testdb.t1 192.168.0.3<\/code><\/pre>\n\n\n\n\u5728V95\u7248\u672c\u589e\u52a0\u4e86VC\u53c2\u6570,\u672a\u5f00\u542fvc\u529f\u80fd\u7684\u53ef\u4ee5\u5ffd\u7565\u3002<\/p>\n\n\n\n
gcadmin rmdmlevent type [eventid | tablename | nodeip | tablename nodeip] [vc vc_name]<\/p>\n\n\n\n
<\/span>gcadmin rmddlevent<\/span><\/h4>\n\n\n\n\u6e05\u7406ddlevent\u3002<\/p>\n\n\n\n
\u5b8c\u6574\u547d\u4ee4<\/p>\n\n\n\n
gcadmin rmddlevent type [eventid | tablename | nodeip | tablename nodeip] <\/p>\n\n\n\n
gcadmin rmddlevent 0 10234\ngcadmin rmddlevent 1 testdb.t1\ngcadmin rmddlevent 2 192.168.0.3\ngcadmin rmddlevent 3 testdb.t1 192.168.0.3<\/code><\/pre>\n\n\n\n\u5728V95\u7248\u672c\u589e\u52a0\u4e86VC\u53c2\u6570<\/p>\n\n\n\n
gcadmin rmddlevent type [eventid | tablename | nodeip | tablename nodeip] [vc vc_name]<\/p>\n\n\n\n
<\/span>gcadmin rmdmlstorageevent<\/span><\/h4>\n\n\n\n\u6e05\u7406dmlstorageevent\u3002<\/p>\n\n\n\n
\u5b8c\u6574\u547d\u4ee4<\/p>\n\n\n\n
gcadmin rmdmlstorageevent type [eventid | tablename | nodeip | tablename nodeip] <\/p>\n\n\n\n
gcadmin rmdmlstorageevent 0 10234\ngcadmin rmdmlstorageevent 1 testdb.t1\ngcadmin rmdmlstorageevent 2 192.168.0.3\ngcadmin rmdmlstorageevent 3 testdb.t1 192.168.0.3<\/code><\/pre>\n\n\n\n\u5728V95\u7248\u672c\u589e\u52a0\u4e86VC\u53c2\u6570<\/p>\n\n\n\n
gcadmin rmdmlstorageevent type [eventid | tablename | nodeip | tablename nodeip] [vc vc_name]<\/p>\n\n\n\n
gcadmin rmdmlstorageevent 0 10234 vc vcname000001\r\ngcadmin rmdmlstorageevent 1 testdb.t1 vc vcname000001\r\ngcadmin rmdmlstorageevent 2 192.168.0.3 vc vcname000001\r\ngcadmin rmdmlstorageevent 3 testdb.t1 192.168.0.3 vc vcname000001<\/code><\/pre>\n\n\n\n<\/span>gcware\u63a5\u53e3<\/span><\/h2>\n\n\n\n\u5982\u679c\u662f95\u7248\u672c\uff0c\u5404\u79cd\u547d\u4ee4\u90fd\u9700\u8981\u6307\u5b9avcname, \u5373\u4f7f\u662f\u517c\u5bb9\u6a21\u5f0f\u3002 \u9ed8\u8ba4\u517c\u5bb9\u6a21\u5f0f\u4e3a\uff1avcname000001<\/p>\n\n\n\n
<\/span>\u5feb\u901f\u6e05\u7406\u6307\u5b9aIP\u7684\u5927\u91cfevent<\/span><\/h3>\n\n\n\n\u8be5\u529f\u80fd\u5728862Build43R35.5Patch10\u53ca\u4e4b\u540e\u7248\u672c\u63d0\u4f9b\u3002<\/p>\n\n\n\n
\u8b66\u544a\uff1a\u8be5\u65b9\u6cd5\u9002\u7528\u4e8e\u8282\u70b9\u65e0\u6cd5\u6062\u590d\uff0c\u8981\u8282\u70b9\u66ff\u6362\u624d\u80fd\u6062\u590d\u60c5\u51b5\u4e0b\u7684event\u6e05\u7406\u3002<\/span><\/p>\n\n\n\n\u8be5\u529f\u80fd\u53ef\u4ee5\u5feb\u901f\u6e05\u7406\u6307\u5b9a\u8282\u70b9\u7684dml,ddl,dmlstorage\u4e09\u7c7bevent. \u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u6570\u91cf\uff0c\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u6e05\u7406\u901f\u5ea6\u586b\u5199\u3002\u5982\u679c\u4e0d\u786e\u8ba4\uff0c\u53ef\u4ee5\u5148\u6d4b\u8bd5\u6e05\u74061000\u4e2a\u8bc4\u4f30\u8017\u65f6\u3002\u4e00\u822c\u4e07\u4e00\u7ea7\u7684\u5e94\u79d2\u7ea7\u5b8c\u6210\u3002<\/p>\n\n\n\n
\u63d0\u793a\uff1aIPV4\u5730\u5740\u5982\u679c\u6e05\u7406\u65e0\u4efb\u4f55\u6548\u679c\uff0c\u5219\u53ef\u4ee5\u5728IP\u524d\u9762\u52a0\u4e0a::ffff:\u7684IPV6\u6837\u5f0f\u8bd5\u8bd5\uff0c\u6bd4\u5982<\/span>
192.168.0.1 \u53d8\u6210
::ffff:192.168.0.1<\/p>\n\n\n\n[gbase@localhost gcinstall_8624335.5p10]$ python\nPython 2.7.5 (default, Oct 14 2020, 14:45:30)\n[GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] on linux2\nType \"help\", \"copyright\", \"credits\" or \"license\" for more information.\n>>> import gcware\n>>> help('gcware')\n\n86\u7248\u672c\n>>> gcware.cleardmlfeventbyip('::ffff:10.0.2.201',100);\n0\n>>> gcware.clearddlfeventbyip('::ffff:10.0.2.201',100);\n0\n>>> gcware.cleardmlstoragefeventbyip('::ffff:10.0.2.201',100);\n0\n>>> exit\n\n\u5982\u679c\u662f95\u7248\u672c\uff0c\u5219\u9700\u8981\u989d\u5916\u6307\u5b9avcname\u53c2\u6570\u3002 \u517c\u5bb9\u6a21\u5f0f\u4e3avcname000001\n>>> gcware.cleardmlfeventbyip('vcname000001','::ffff:10.0.2.201',100);\r\n0\r\n>>> gcware.clearddlfeventbyip('vcname000001','::ffff:10.0.2.201',100);\r\n0\r\n>>> gcware.cleardmlstoragefeventbyip('vcname000001','::ffff:10.0.2.201',100);\r\n0<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
<\/span>\u901a\u914d\u7b26\u5f62\u5f0f\u6e05\u7406\u6240\u6709event<\/span><\/h3>\n\n\n\n\u6ce8\u610f\uff1a\u8be5\u65b9\u6848\u4e00\u822c\u5728\u524d\u9762\u65b9\u6848\u65e0\u6cd5\u6ee1\u8db3\u65f6\u4f7f\u7528\uff0c\u5c3d\u91cf\u907f\u514d\u3002<\/p>\n\n\n\n
\u5e38\u89c1\u573a\u666f\uff1a\u3010\u5355\u8282\u70b9<\/strong>\u3011\u96c6\u7fa4\uff0c\u7531\u4e8e\u6ca1\u6709\u9ad8\u53ef\u7528\uff0cevent\u4e5f\u4e0d\u4f1a\u81ea\u52a8\u6062\u590d\uff0c\u9700\u8981\u624b\u5de5\u6e05\u7406\u3002<\/p>\n\n\n\n[root@node1\u00a0trace]#\u00a0python
Python\u00a02.6.6\u00a0(r266:84292,\u00a0Sep\u00a012\u00a02011,\u00a014:03:14)
[GCC\u00a04.4.5\u00a020110214\u00a0(Red\u00a0Hat\u00a04.4.5-6)]\u00a0on\u00a0linux2
Type\u00a0\"help\",\u00a0\"copyright\",\u00a0\"credits\"\u00a0or\u00a0\"license\"\u00a0for\u00a0more\u00a0information.
>>>\u00a0import\u00a0gcware<\/p>\n\n\n\n
\u5982\u4e0b\u4e09\u4e2a\u547d\u4ee4\u5bf9\u5e94\u4e09\u79cdevent\u7c7b\u578b\uff0c\u6b63\u5219\u7684\u65b9\u5f0f\u5339\u914d\u3002\u5982\u4e0b\u6837\u4f8b\u7684\u6b63\u5219\u662f\u5339\u914d\u5168\u90e8\u3002<\/p>\n\n\n\n
86\u7248\u672c\ngcware.clearddlfevent('.*')\ngcware.cleardmlfevent('.*')\ngcware.cleardmlstoragefevent('.*')\n\n\u572895\u7248\u672c\uff0c\u53c2\u6570\u589e\u52a0\u4e86vcname\ngcware.clearddlfevent('vcname000001','.*')\ngcware.cleardmlfevent('vcname000001','.*')\ngcware.cleardmlstoragefevent('vcname000001','.*')<\/code><\/pre>\n\n\n\n\u6b63\u5219\u7cbe\u786e\u5339\u914d\u65b9\u5f0f\uff0c\u5982\u679c\u662f95\uff0c\u540c\u6837\u8981\u6307\u5b9avcname\u53c2\u6570\u3002<\/p>\n\n\n\n
\u5982\u679c\u60f3\u6e05\u7406\u6389\u548c\u67d0\u4e2a\u8868\u76f8\u5173\u7684\u65e5\u5fd7\uff0c\u53ef\u4ee5\u8c03\u7528\uff1a<\/p>\n\n\n\n
86\u7248\u672c\nclearXXXXfevent(\"^test.t$\");\n95\u7248\u672c\nclearXXXXfevent('vcname000001',\"^test.t$\");<\/code><\/pre>\n\n\n\n\u5982\u679c\u60f3\u6e05\u7406\u6389\u548c\u4e00\u4e2a\u5e93\u76f8\u5173\u7684\u6240\u6709\u65e5\u5fd7\uff0c\u53ef\u4ee5\u8c03\u7528\uff1a<\/p>\n\n\n\n
clearXXXXfevent(\"^database$| ^database\\..*\")<\/p>\n\n\n\n
\u9000\u51fa\u65b9\u6cd5<\/p>\n\n\n\n
Use\u00a0exit()\u00a0or\u00a0Ctrl-D\u00a0(i.e.\u00a0EOF)\u00a0to\u00a0exit
>>>\u00a0exit();<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5f53\u4e00\u4e9b\u6545\u969c\u8282\u70b9event\u65e0\u6cd5\u81ea\u52a8\u540c\u6b65\u6210\u529f\u65f6\uff0c\u9700\u8981\u5f3a\u884c\u5220\u9664\u3002\u6bd4\u5982\u5355\u8282\u70b9\u96c6\u7fa4\uff0c\u6545\u969c\u8282\u70b9\u66ff\u6362\u64cd\u4f5c\u65f6\uff0c\u90fd\u8981\u5f3a\u884c\u6e05\u7406\u6545\u969c\u8282\u70b9\u7684\u6240\u6709event\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[95],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-event"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":20,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"predecessor-version":[{"id":13313,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/209\/revisions\/13313"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}