{"id":866,"date":"2020-11-19T11:14:26","date_gmt":"2020-11-19T03:14:26","guid":{"rendered":"https:\/\/www.linuxdevops.cn\/?p=866"},"modified":"2022-06-24T11:10:15","modified_gmt":"2022-06-24T03:10:15","slug":"configuration-of-archery-sql-audit-system","status":"publish","type":"post","link":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/","title":{"rendered":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e"},"content":{"rendered":"<h1>1. docker\u90e8\u7f72<a href=\"https:\/\/archerydms.com\/installation\/docker\/#docker\">\u00b6<\/a><\/h1>\n<h2>\u5b89\u88c5docker<a href=\"https:\/\/archerydms.com\/installation\/docker\/#docker_1\">\u00b6<\/a><\/h2>\n<ul>\n<li><a href=\"https:\/\/yeasy.gitbooks.io\/docker_practice\/install\/\">\u5b89\u88c5 Docker<\/a><\/li>\n<\/ul>\n<pre><code>curl -fsSL https:\/\/get.docker.com -o get-docker.sh | sudo sh<\/code><\/pre>\n<ul>\n<li><a href=\"https:\/\/yeasy.gitbooks.io\/docker_practice\/compose\/install.html\">\u5b89\u88c5 Docker Compose<\/a><\/li>\n<\/ul>\n<pre><code>sudo curl -L &quot;https:\/\/github.com\/docker\/compose\/releases\/download\/1.24.1\/docker-compose-$(uname -s)-$(uname -m)&quot; -o \/usr\/local\/bin\/docker-compose\nsudo chmod +x \/usr\/local\/bin\/docker-compose<\/code><\/pre>\n<h2>\u51c6\u5907\u8fd0\u884c\u914d\u7f6e<a href=\"https:\/\/archerydms.com\/installation\/docker\/#_1\">\u00b6<\/a><\/h2>\n<p>\u5177\u4f53\u53ef\u53c2\u8003\uff1a<a href=\"https:\/\/github.com\/hhyo\/Archery\/tree\/master\/src\/docker-compose\">https:\/\/github.com\/hhyo\/Archery\/tree\/master\/src\/docker-compose<\/a><\/p>\n<p>docker-compose.yml\u6587\u4ef6\u5185\u7684services\u53ef\u6309\u7167\u672c\u8eab\u7684\u8fd0\u884c\u73af\u5883\u6765\u8c03\u6574\uff0c\u540c\u65f6\u6ce8\u610f\u68c0\u67e5\u7248\u672c\u53f7\u662f\u5426\u6b63\u786e\uff0c\u6bd4\u5982\u8bf4\u5916\u90e8\u5df2\u7ecf\u88c5\u597d\u4e86mysql\u3001redis\u3001inception\uff0c\u5c31\u53ef\u4ee5\u5c06\u5bf9\u5e94\u7684services\u5220\u9664\uff0c\u4f46\u662f\u9700\u8981\u6ce8\u610f\u4fee\u6539settings.py\u6587\u4ef6\u7684\u76f8\u5173\u914d\u7f6e\uff0c\u5177\u4f53\u53ef\u4ee5\u53c2\u8003<a href=\"https:\/\/archerydms.com\/installation\/manual\/#_5\">\u4fee\u6539\u914d\u7f6e<\/a><\/p>\n<h2>\u542f\u52a8<a href=\"https:\/\/archerydms.com\/installation\/docker\/#_2\">\u00b6<\/a><\/h2>\n<p>\u4e0b\u8f7d <a href=\"https:\/\/github.com\/hhyo\/archery\/releases\/\">Releases<\/a>\u6587\u4ef6\uff0c\u89e3\u538b\u540e\u8fdb\u5165docker-compose\u6587\u4ef6\u5939<\/p>\n<pre><code># \u542f\u52a8\ndocker-compose -f docker-compose.yml up -d\n\n# \u8868\u7ed3\u6784\u521d\u59cb\u5316\ndocker exec -ti archery \/bin\/bash\ncd \/opt\/archery\nsource \/opt\/venv4archery\/bin\/activate\npython3 manage.py makemigrations sql  \npython3 manage.py migrate \n\n# \u6570\u636e\u521d\u59cb\u5316\npython3 manage.py dbshell&lt;sql\/fixtures\/auth_group.sql\npython3 manage.py dbshell&lt;src\/init_sql\/mysql_slow_query_review.sql\n\n# \u521b\u5efa\u7ba1\u7406\u7528\u6237\npython3 manage.py createsuperuser\n\n# \u91cd\u542f\ndocker restart archery\n\n# \u65e5\u5fd7\u67e5\u770b\u548c\u95ee\u9898\u6392\u67e5\ndocker logs archery -f --tail=50<\/code><\/pre>\n<h2>\u8bbf\u95ee<a href=\"https:\/\/archerydms.com\/installation\/docker\/#_3\">\u00b6<\/a><\/h2>\n<p><a href=\"http:\/\/127.0.0.1:9123\">http:\/\/127.0.0.1:9123<\/a><\/p>\n<h2>\u542f\u52a8\u540e\u914d\u7f6e<a href=\"https:\/\/archerydms.com\/installation\/docker\/#_4\">\u00b6<\/a><\/h2>\n<p>\u5728\u542f\u52a8\u540e Archery \u6709\u4e00\u4e9b\u914d\u7f6e(\u5982Inception , \u8d44\u6e90\u7ec4, \u6743\u9650\u7ec4\u7b49)\u9700\u8981\u6309\u9700\u914d\u7f6e, <\/p>\n<h1>2. \u7cfb\u7edf\u914d\u7f6e<a href=\"https:\/\/archerydms.com\/configuration\/#_1\">\u00b6<\/a><\/h1>\n<p><img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15529177917926.jpg\" alt=\"-w1342\" \/><\/p>\n<h2>Inception\u914d\u7f6e<a href=\"https:\/\/archerydms.com\/configuration\/#inception\">\u00b6<\/a><\/h2>\n<h5>INCEPTION<a href=\"https:\/\/archerydms.com\/configuration\/#inception_1\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u542f\u7528Inception\u66ff\u6362goInception\uff0c\u5f00\u542f\u540e\u9700\u8981\u914d\u7f6eInception\u7684\u8fde\u63a5\u4fe1\u606f\uff0c\u5907\u4efd\u5e93\u7684\u914d\u7f6e\u5730\u5740\u53ef\u590d\u7528\uff0c\u5c06\u4f1a\u4f7f\u7528Inception\u6765\u66ff\u4ee3goInception\u5bf9MySQL\u8fdb\u884c\u5ba1\u6838\u548c\u6267\u884c<\/p>\n<h5>GO_INCEPTION_HOST<a href=\"https:\/\/archerydms.com\/configuration\/#go_inception_host\">\u00b6<\/a><\/h5>\n<p>goInception\u7684\u8fde\u63a5\u5730\u5740\uff0c\u7528\u4e8eMySQL\u5ba1\u6838\u6267\u884c\uff0cdocker-compose\u542f\u52a8\u7684\u8bf7\u914d\u7f6e\u4e3a\u5bb9\u5668\u540d\uff0c\u6bd4\u5982goinception\uff0c\u53c2\u8003\u6587\u6863\uff1a<a href=\"https:\/\/github.com\/hanchuanchuan\/goInception\">https:\/\/github.com\/hanchuanchuan\/goInception<\/a><\/p>\n<h5>GO_INCEPTION_PORT<a href=\"https:\/\/archerydms.com\/configuration\/#go_inception_port\">\u00b6<\/a><\/h5>\n<p>goInception\u7684\u8fde\u63a5\u7aef\u53e3\uff0c\u9ed8\u8ba44000<\/p>\n<h5>INCEPTION_HOST<a href=\"https:\/\/archerydms.com\/configuration\/#inception_host\">\u00b6<\/a><\/h5>\n<p>Inception\u8fde\u63a5HOST\uff0c\u7528\u4e8eSQL\u67e5\u8be2\u8bed\u6cd5\u89e3\u6790\uff0cdocker-compose\u542f\u52a8\u7684\u8bf7\u914d\u7f6e\u4e3a\u5bb9\u5668\u540d\uff0c\u6bd4\u5982inception\uff0c\u53c2\u8003\u6587\u6863 \uff1a<a href=\"https:\/\/github.com\/hhyo\/inception\">https:\/\/github.com\/hhyo\/inception<\/a><\/p>\n<h5>INCEPTION_PORT<a href=\"https:\/\/archerydms.com\/configuration\/#inception_port\">\u00b6<\/a><\/h5>\n<p>Inception\u8fde\u63a5\u7aef\u53e3\uff0c\u5373Inception\u914d\u7f6e\u6587\u4ef6inc.cnf\u5185\u7684port<\/p>\n<h5>REMOTE_BACKUP_HOST<a href=\"https:\/\/archerydms.com\/configuration\/#remote_backup_host\">\u00b6<\/a><\/h5>\n<p>goInception\/Inception\u7684\u5907\u4efd\u5e93\u94fe\u63a5HOST\uff0c\u7528\u4e8e\u9875\u9762\u5c55\u793a\u56de\u6eda\u8bed\u53e5 - goInception\u548c\u914d\u7f6e\u6587\u4ef6config.toml\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/config.toml#L66\">backup_host<\/a>\u4fdd\u6301\u4e00\u81f4 - Inception\u548c\u914d\u7f6e\u6587\u4ef6inc.cnf\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/inc.cnf#L9\">inception_remote_backup_host<\/a>\u4fdd\u6301\u4e00\u81f4\uff0c\u5177\u4f53\u8bf4\u660e\u53ef\u53c2\u8003<a href=\"https:\/\/inception-document.readthedocs.io\/zh_CN\/latest\/backup\/\">Inception \u5907\u4efd\u529f\u80fd\u8bf4\u660e<\/a><\/p>\n<h5>REMOTE_BACKUP_PORT<a href=\"https:\/\/archerydms.com\/configuration\/#remote_backup_port\">\u00b6<\/a><\/h5>\n<p>goInception\/Inception\u7684\u5907\u4efd\u5e93\u94fe\u63a5\u7aef\u53e3 - goInception\u548c\u914d\u7f6e\u6587\u4ef6config.toml\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/config.toml#L67\">backup_port<\/a>\u4fdd\u6301\u4e00\u81f4 - Inception\u548c\u914d\u7f6e\u6587\u4ef6inc.cnf\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/inc.cnf#L9\">inception_remote_backup_port<\/a>\u4fdd\u6301\u4e00\u81f4<\/p>\n<h5>REMOTE_BACKUP_USER<a href=\"https:\/\/archerydms.com\/configuration\/#remote_backup_user\">\u00b6<\/a><\/h5>\n<p>goInception\/Inception\u7684\u5907\u4efd\u5e93\u94fe\u63a5\u7528\u6237 - goInception\u548c\u914d\u7f6e\u6587\u4ef6config.toml\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/config.toml#L68\">backup_user<\/a>\u4fdd\u6301\u4e00\u81f4 - Inception\u548c\u914d\u7f6e\u6587\u4ef6inc.cnf\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/inc.cnf#L9\">inception_remote_system_user<\/a>\u4fdd\u6301\u4e00\u81f4<\/p>\n<pre><code>-- \u5efa\u8bae\u8d4b\u4e88\u7528\u6237\u6743\u9650\nGRANT SELECT, INSERT, CREATE ON *.* TO &#039;inception_bak&#039;<\/code><\/pre>\n<h5>REMOTE_BACKUP_PASSWORD<a href=\"https:\/\/archerydms.com\/configuration\/#remote_backup_password\">\u00b6<\/a><\/h5>\n<p>goInception\/Inception\u7684\u5907\u4efd\u5e93\u94fe\u63a5\u7528\u6237 - goInception\u548c\u914d\u7f6e\u6587\u4ef6config.toml\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/config.toml#L69\">backup_password<\/a>\u4fdd\u6301\u4e00\u81f4 - Inception\u548c\u914d\u7f6e\u6587\u4ef6inc.cnf\u5185\u7684<a href=\"https:\/\/github.com\/hhyo\/Archery\/blob\/master\/src\/docker-compose\/inception\/inc.cnf#L9\">inception_remote_system_password<\/a>\u4fdd\u6301\u4e00\u81f4<\/p>\n<p><strong>\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u8be5\u914d\u7f6e\u4fe1\u606f\uff0c\u4ec5\u4ec5\u7528\u4e8earchery\u4ece\u5907\u4efd\u5e93\u67e5\u8be2\u56de\u6eda\u8bed\u53e5\u4f7f\u7528\uff0c\u8be5\u914d\u7f6e\u4fe1\u606f\u4e0d\u4f1a\u88abgoInception\u670d\u52a1\u4f7f\u7528\uff0cgoInception\u8fde\u63a5\u5907\u4efd\u5e93\u4f7f\u7528\u7684\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u5e94\u5728\u5176\u81ea\u8eab\u7684config.toml\u4e2d\u914d\u7f6e\u3002<\/strong><\/p>\n<h2>SQL\u4e0a\u7ebf<a href=\"https:\/\/archerydms.com\/configuration\/#sql\">\u00b6<\/a><\/h2>\n<h5>CRITICAL_DDL_REGEX<a href=\"https:\/\/archerydms.com\/configuration\/#critical_ddl_regex\">\u00b6<\/a><\/h5>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119101458676.png\" alt=\"image-20201119101458676\" \/><\/p>\n<p>\u9ad8\u5371SQL\u8bed\u53e5\u6b63\u5219\u5224\u65ad\u6761\u4ef6\uff0c\u7528\u4e8e\u63a7\u5236\u7981\u6b62\u63d0\u4ea4\u7684\u8bed\u53e5\uff0c\u5339\u914d\u7684\u8bed\u53e5\u4f1a\u7981\u6b62\u63d0\u4ea4\uff0c\u4f8b\u5982<code>^truncate|^rename|^delete<\/code>\u5219\u4f1a\u7981\u6b62\u63d0\u4ea4\u6e05\u7a7a\u8868\u3001\u4fee\u6539\u8868\u540d\u3001\u5220\u9664\u64cd\u4f5c\u7684SQL\u8bed\u53e5\uff0c\u524d\u7aef\u5c55\u73b0\u5982\u4e0b <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528789299184.jpg\" alt=\"-w1089\" \/><\/p>\n<h5>AUTO_REVIEW_WRONG<a href=\"https:\/\/archerydms.com\/configuration\/#auto_review_wrong\">\u00b6<\/a><\/h5>\n<p>\u7528\u4e8e\u63a7\u5236\u81ea\u52a8\u9a73\u56de\u7684\u7b49\u7ea7\uff0c\u9a73\u56de\u7684\u5de5\u5355\u4e0d\u4f1a\u901a\u77e5\u5ba1\u6838\u4eba\uff0c\u4f1a\u7cfb\u7edf\u76f4\u63a5\u5ba1\u6838\u4e0d\u901a\u8fc7\u30021\u8868\u793aSQL\u4e0a\u7ebf\u5ba1\u6838\u51fa\u73b0\u8b66\u544a\u4fe1\u606f\u5c31\u9a73\u56de\uff0c2\u548c\u7a7a\u8868\u793a\u51fa\u73b0\u9519\u8bef\u624d\u9a73\u56de\uff0c\u5176\u4ed6\u8bbe\u7f6e\u8868\u793a\u4e0d\u9a73\u56de\uff0c\u5ba1\u6838\u89c4\u5219\u8bf7\u53c2\u8003<a href=\"https:\/\/inception-document.readthedocs.io\/zh_CN\/latest\/variables\/\">Inception\u6240\u652f\u6301\u7684\u53c2\u6570\u53d8\u91cf<\/a>\uff0c\u524d\u7aef\u5c55\u73b0\u5982\u4e0b <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528791148226.jpg\" alt=\"-w1129\" \/><\/p>\n<h5>ENABLE_BACKUP_SWITCH<a href=\"https:\/\/archerydms.com\/configuration\/#enable_backup_switch\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u5f00\u542f\u5907\u4efd\u9009\u9879\uff0c\u672a\u5f00\u542f\u65f6\u63d0\u4ea4SQL\u5de5\u5355\uff0c\u5c06\u4e0d\u4f1a\u663e\u793a\u662f\u5426\u5907\u4efd\u9009\u62e9\u9879\uff0c\u7cfb\u7edf\u4f1a\u5f3a\u5236\u5907\u4efd<\/p>\n<h5>AUTO_REVIEW<a href=\"https:\/\/archerydms.com\/configuration\/#auto_review\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u5f00\u542fSQL\u4e0a\u7ebf\u81ea\u52a8\u5ba1\u6279\uff0c\u5f00\u542f\u81ea\u52a8\u5ba1\u6279\u540e\uff0c\u5f53\u63d0\u4ea4\u7684SQL\u8bed\u53e5\u4e0d\u5339\u914dAUTO_REVIEW_REGEX\u89c4\u5219\uff0c\u5e76\u4e14update\u8bed\u53e5\u7684\u603b\u5f71\u54cd\u884c\u6570\u4f4e\u4e8eMAX_UPDATE_ROWS\u65f6\uff0c\u7cfb\u7edf\u5219\u4f1a\u81ea\u52a8\u5ba1\u6279\u901a\u8fc7\uff0c\u524d\u7aef\u5c55\u73b0\u5982\u4e0b <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528795154769.jpg\" alt=\"-w1138\" \/><\/p>\n<h5>AUTO_REVIEW_REGEX<a href=\"https:\/\/archerydms.com\/configuration\/#auto_review_regex\">\u00b6<\/a><\/h5>\n<p>\u6b63\u5219\u6761\u4ef6\uff0c\u7528\u4e8e\u8fc7\u6ee4\u90e8\u5206\u9700\u8981\u4eba\u5de5\u5ba1\u6838\u7684\u8bed\u53e5\uff0c\u5f00\u542f\u81ea\u52a8\u5ba1\u6279\u540e\uff0c\u5f53\u5de5\u5355\u4e2d\u5b58\u5728\u5339\u914d\u7684\u8bed\u53e5\u65f6\u5219\u9700\u8981\u4eba\u5de5\u5ba1\u6279\uff0c\u4f8b\u5982<code>^create<\/code>\u5219\u8868\u793a\u5efa\u8868\u8bed\u53e5\u9700\u8981\u4eba\u5de5\u5ba1\u6279<\/p>\n<h5>MAX_UPDATE_ROWS<a href=\"https:\/\/archerydms.com\/configuration\/#max_update_rows\">\u00b6<\/a><\/h5>\n<p>\u81ea\u52a8\u5ba1\u6279\u5141\u8bb8\u5de5\u5355\u6700\u5927\u66f4\u65b0\u884c\u6570\uff0c\u7cfb\u7edf\u4f1a\u904d\u5386\u5de5\u5355\u5185\u6240\u6709update\u8bed\u53e5\uff0c\u4f7f\u7528explain\u9884\u4f30\u5f71\u54cd\u884c\u6570\uff0c\u5f53\u5f71\u54cd\u51fd\u6570\u8d85\u8fc7\u8be5\u503c\u65f6\u5219\u5de5\u5355\u9700\u8981\u4eba\u5de5\u5ba1\u6279<\/p>\n<h4>MANNUAL<a href=\"https:\/\/archerydms.com\/configuration\/#mannual\">\u00b6<\/a><\/h4>\n<p>\u662f\u5426\u5f00\u542fSQL\u4e0a\u7ebf\u624b\u5de5\u6267\u884c\u786e\u8ba4\uff0c\u5f00\u542f\u540e\u5728\u5ba1\u6838\u901a\u8fc7\u7684\u5de5\u5355\u8be6\u60c5\u4e2d\u4f1a\u51fa\u73b0\u624b\u5de5\u786e\u8ba4\u6309\u94ae\uff0c\u53ef\u4ee5\u4ec5\u4ec5\u4f9d\u9760Archery\u8d70\u5de5\u5355\u6d41\u7a0b\uff0cDBA\u7ebf\u4e0b\u624b\u52a8\u6267\u884c\u8bed\u53e5\u5e76\u4e14\u786e\u8ba4\u6267\u884c\u7ed3\u675f<\/p>\n<h2>SQL\u67e5\u8be2<a href=\"https:\/\/archerydms.com\/configuration\/#sql_1\">\u00b6<\/a><\/h2>\n<h5>QUERY_CHECK<a href=\"https:\/\/archerydms.com\/configuration\/#query_check\">\u00b6<\/a><\/h5>\n<p>\u76f8\u5173issues: <a href=\"https:\/\/github.com\/hhyo\/Archery\/issues\/145\">https:\/\/github.com\/hhyo\/Archery\/issues\/145<\/a><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119101514453.png\" alt=\"image-20201119101514453\" \/><\/p>\n<p>\u662f\u5426\u5f00\u542fSQL\u67e5\u8be2\u8131\u654f\u7684Inception\u68c0\u6d4b\uff0c\u5e73\u53f0\u7684SQL\u67e5\u8be2\u529f\u80fd\u4f9d\u9760<a href=\"https:\/\/inception-document.readthedocs.io\/zh_CN\/latest\/queryprint\/#inception\">Inception\u7684\u8bed\u6cd5\u6811\u6253\u5370<\/a>\u6765\u89e3\u6790\u67e5\u8be2\u8bed\u53e5\u4e2d\u5305\u542b\u7684\u5e93\u3001\u8868\u3001\u5b57\u6bb5\u4fe1\u606f\uff0c\u4ece\u800c\u8fdb\u884c\u6570\u636e\u8131\u654f<\/p>\n<ul>\n<li>\u5f00\u542fQUERY_CHECK\u540e\uff0c\u5982\u679c\u9047\u5230Inception\u65e0\u6cd5\u89e3\u6790\u7684\u8bed\u53e5\uff0c\u5219\u4f1a\u76f4\u63a5\u629b\u51fa\u9519\u8bef\u4fe1\u606f\uff0c\u7981\u6b62\u67e5\u8be2<\/li>\n<li>\u5173\u95edQUERY_CHECK\u540e\uff0c\u5982\u679c\u9047\u5230Inception\u65e0\u6cd5\u89e3\u6790\u7684\u8bed\u53e5\uff0c\u7cfb\u7edf\u4e0d\u518d\u8fdb\u884c\u6570\u636e\u8131\u654f\uff0c\u4f1a\u6709\u6570\u636e\u6cc4\u9732\u7684\u98ce\u9669\uff0c\u8bf7\u8c28\u614e\u9009\u62e9<\/li>\n<li>\u52a8\u6001\u8131\u654f\u4e0d\u652f\u6301\u7684\u8bed\u6cd5\uff1a\u5d4c\u5957\u5b50\u67e5\u8be2\u3001\u90e8\u5206\u975e\u5355\u5b57\u6bb5\u51fd\u6570\uff0c\u5982<code>concat(phone,&#039;,&#039;)\u3001max(id+num)<\/code><\/li>\n<\/ul>\n<h5>DATA_MASKING<a href=\"https:\/\/archerydms.com\/configuration\/#data_masking\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u5f00\u542f\u52a8\u6001\u8131\u654f\uff0c\u4f1a\u5229\u7528inception\u8bed\u6cd5\u6811\u6253\u5370\uff0c\u7ed3\u5408\u540e\u53f0\u8bbe\u7f6e\u7684\u8131\u654f\u5b57\u6bb5\u548c\u8131\u654f\u89c4\u5219\uff0c\u5bf9\u67e5\u8be2\u6570\u636e\u8fdb\u884c\u8131\u654f\u3002\u9047\u5230\u65e0\u6cd5\u89e3\u6790\u7684\u8bed\u53e5\u662f\u62a5\u9519\u8fd8\u662f\u8fd4\u56de\u672a\u8131\u654f\u7684\u6570\u636e\u540c\u6837\u7531QUERY_CHECK\u53c2\u6570\u63a7\u5236 <em> \u6b63\u5e38\u8131\u654f\uff1a <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528896590332.jpg\" alt=\"-w1331\" \/> <\/em> \u5f00\u542fQUERY_CHECK\u540e\u6267\u884c\u4e0d\u652f\u6301\u8bed\u53e5 <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528897578840.jpg\" alt=\"-w1338\" \/> * \u5173\u95edQUERY_CHECK\u540e\u6267\u884c\u4e0d\u652f\u6301\u8bed\u53e5 <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528903610952.jpg\" alt=\"-w1329\" \/><\/p>\n<h5>MAX_EXECUTION_TIME<a href=\"https:\/\/archerydms.com\/configuration\/#max_execution_time\">\u00b6<\/a><\/h5>\n<p>\u5728\u7ebf\u67e5\u8be2\u8d85\u65f6\u65f6\u95f4\u9608\u503c\uff0c\u5355\u4f4d\u79d2\uff0c\u9ed8\u8ba460\uff0c\u8d85\u65f6\u7684\u8bed\u53e5\u4f1a\u88ab\u7ec8\u6b62\u5e76\u8fd4\u56de\u63d0\u793a\u4fe1\u606f\uff0c\u76ee\u524d\u4ec5\u652f\u6301MySQL<\/p>\n<h5>ADMIN_QUERY_LIMIT<a href=\"https:\/\/archerydms.com\/configuration\/#admin_query_limit\">\u00b6<\/a><\/h5>\n<p>\u8d85\u7ea7\u7ba1\u7406\u5458\u7684\u67e5\u8be2\u9650\u5236\u884c\u6570\uff0c\u8d85\u7ea7\u7ba1\u7406\u5458\u67e5\u8be2\u6570\u636e\u65f6\u4e0d\u505a\u6743\u9650\u6821\u9a8c\uff0c\u4ec5\u7531\u8be5\u53c2\u6570\u8bbe\u7f6e\u6700\u5927\u884c\u6570<\/p>\n<h2>SQL\u4f18\u5316<a href=\"https:\/\/archerydms.com\/configuration\/#sql_2\">\u00b6<\/a><\/h2>\n<h5>SQLADVISOR_PATH<a href=\"https:\/\/archerydms.com\/configuration\/#sqladvisor_path\">\u00b6<\/a><\/h5>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119101753203.png\" alt=\"image-20201119101753203\" \/><\/p>\n<p>SQLAdvisor\u7684\u53ef\u6267\u884c\u6587\u4ef6\u8def\u5f84\uff0c\u8def\u5f84\u9700\u8981\u5b8c\u6574\uff0cdocker\u955c\u50cf\u5185\u5df2\u7ecf\u96c6\u6210 <em> 1.4.0\u4ee5\u524d\u7684docker\u7248\u672c\u914d\u7f6e\u6210<code>\/opt\/sqladvisor<\/code> <\/em> 1.4.0\u4ee5\u4ee5\u540e\u7684docker\u7248\u672c\u914d\u7f6e\u6210<code>\/opt\/archery\/src\/plugins\/sqladvisor<\/code><\/p>\n<h5>SOAR_PATH<a href=\"https:\/\/archerydms.com\/configuration\/#soar_path\">\u00b6<\/a><\/h5>\n<p>SOAR\u7684\u53ef\u6267\u884c\u6587\u4ef6\u8def\u5f84\uff0c\u8def\u5f84\u9700\u8981\u5b8c\u6574\uff0cdocker\u955c\u50cf\u5185\u5df2\u7ecf\u96c6\u6210\uff0cdocker\u955c\u50cf\u5185\u5df2\u7ecf\u96c6\u6210 <em> 1.4.0\u4ee5\u524d\u7684docker\u7248\u672c\u914d\u7f6e\u6210<code>\/opt\/soar<\/code> <\/em> 1.4.0\u4ee5\u4ee5\u540e\u7684docker\u7248\u672c\u914d\u7f6e\u6210<code>\/opt\/archery\/src\/plugins\/soar<\/code><\/p>\n<h5>SOAR_TEST_DSN<a href=\"https:\/\/archerydms.com\/configuration\/#soar_test_dsn\">\u00b6<\/a><\/h5>\n<p>\u53c2\u8003SOAR\u6587\u6863\uff1a<a href=\"https:\/\/github.com\/XiaoMi\/soar\/blob\/master\/doc\/config.md#\u547d\u4ee4\u884c\u53c2\u6570\u914d\u7f6edsn\">\u547d\u4ee4\u884c\u53c2\u6570\u914d\u7f6eDSN<\/a><\/p>\n<h2>\u901a\u77e5<a href=\"https:\/\/archerydms.com\/configuration\/#_2\">\u00b6<\/a><\/h2>\n<h5>ARCHERY_BASE_URL<a href=\"https:\/\/archerydms.com\/configuration\/#archery_base_url\">\u00b6<\/a><\/h5>\n<p>\u7cfb\u7edf\u9996\u9875\u5730\u5740, \u7528\u4e8e\u9489\u9489\u548c\u90ae\u4ef6\u53d1\u9001\u94fe\u63a5\u4f7f\u7528\uff0c\u5982https:\/\/archery.xx.com\/<\/p>\n<h5>DDL_NOTIFY_AUTH_GROUP<a href=\"https:\/\/archerydms.com\/configuration\/#ddl_notify_auth_group\">\u00b6<\/a><\/h5>\n<p>DDL\u5de5\u5355\u901a\u77e5\u6743\u9650\u7ec4\u540d\uff0c\u5bf9\u5e94\u6743\u9650\u7ec4\u7ba1\u7406\u9875\u9762\u7684\u540d\u79f0\uff0c\u4e3a\u7a7a\u5219\u4e0d\u901a\u77e5\uff0c\u4ec5DDL\u5de5\u5355\u6267\u884c\u5b8c\u6bd5\u65f6\u4f1a\u8fdb\u884c\u901a\u77e5 <img decoding=\"async\" src=\"https:\/\/archerydms.com\/images\/15528895708114.jpg\" alt=\"-w1311\" \/><\/p>\n<h3>MAIL<a href=\"https:\/\/archerydms.com\/configuration\/#mail\">\u00b6<\/a><\/h3>\n<p>\u662f\u5426\u5f00\u542f\u90ae\u4ef6\u901a\u77e5<\/p>\n<h5>MAIL_SSL<a href=\"https:\/\/archerydms.com\/configuration\/#mail_ssl\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u4f7f\u7528SSL\u8fde\u63a5<\/p>\n<h5>MAIL_SMTP_SERVER<a href=\"https:\/\/archerydms.com\/configuration\/#mail_smtp_server\">\u00b6<\/a><\/h5>\n<p>\u90ae\u4ef6SMTP\u670d\u52a1\u5730\u5740\uff0c\u53ef\u53c2\u8003\u5404\u90ae\u7bb1\u5bf9\u5e94\u7684\u8bbe\u7f6e\u5e2e\u52a9\uff0c\u4f8b\u5982QQ\u90ae\u7bb1\u7684<a href=\"https:\/\/service.mail.qq.com\/cgi-bin\/help?subtype=1&amp;&amp;no=331&amp;&amp;id=28\">\u5982\u4f55\u4f7f\u7528IMAP\u670d\u52a1\uff1f<\/a><\/p>\n<h5>MAIL_SMTP_PORT<a href=\"https:\/\/archerydms.com\/configuration\/#mail_smtp_port\">\u00b6<\/a><\/h5>\n<p>\u90ae\u4ef6SMTP\u670d\u52a1\u7aef\u53e3<\/p>\n<h5>MAIL_SMTP_USER<a href=\"https:\/\/archerydms.com\/configuration\/#mail_smtp_user\">\u00b6<\/a><\/h5>\n<p>\u90ae\u4ef6\u7528\u6237\u540d<\/p>\n<h5>MAIL_SMTP_PASSWORD<a href=\"https:\/\/archerydms.com\/configuration\/#mail_smtp_password\">\u00b6<\/a><\/h5>\n<p>\u90ae\u4ef6\u5bc6\u7801\uff0c\u4e00\u822c\u4e3a\u751f\u6210\u7684\u6388\u6743\u7801<\/p>\n<h3>DING<a href=\"https:\/\/archerydms.com\/configuration\/#ding\">\u00b6<\/a><\/h3>\n<p>\u662f\u5426\u5f00\u542f\u9489\u9489\u901a\u77e5\uff0c\u5f00\u542f\u540e\u9700\u8981\u914d\u7f6e\u8d44\u6e90\u7ec4\u7684\u673a\u5668\u4ebawebhook\u8fde\u63a5\uff0c\u8d44\u6e90\u7ec4\u5185\u7684\u6240\u6709\u901a\u77e5\u90fd\u4f1a\u901a\u8fc7\u673a\u5668\u4eba\u63a8\u9001<\/p>\n<h5>DING_TO_PERSON<a href=\"https:\/\/archerydms.com\/configuration\/#ding_to_person\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u5f00\u542f\u9489\u9489\u4e2a\u4eba\u901a\u77e5\uff0c\u4f7f\u7528\u5fae\u5e94\u7528\uff0b\u5de5\u4f5c\u901a\u77e5\u5b9e\u73b0<\/p>\n<h3>\u4f01\u4e1a\u5fae\u4fe1<a href=\"https:\/\/archerydms.com\/configuration\/#_3\">\u00b6<\/a><\/h3>\n<p>\u53c2\u8003\u4f01\u4e1a\u5fae\u4fe1\u63a5\u5165\u5f00\u53d1\u6587\u6863\uff0c\u914d\u7f6e\u6210\u529f\u540e\u6d88\u606f\u4f1a\u901a\u8fc7\u4f01\u4e1a\u5fae\u4fe1\u901a\u77e5<\/p>\n<h2>\u5176\u4ed6\u914d\u7f6e<a href=\"https:\/\/archerydms.com\/configuration\/#_4\">\u00b6<\/a><\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119101841321.png\" alt=\"image-20201119101841321\" \/><\/p>\n<h3>\u963f\u91cc\u4e91\u8ba4\u8bc1\u4fe1\u606f<a href=\"https:\/\/archerydms.com\/configuration\/#_5\">\u00b6<\/a><\/h3>\n<p>\u5b9e\u4f8b\u5173\u8054RDS\u5b9e\u4f8bID\u540e\uff0c\u4f1a\u8c03\u7528RDS\u63a5\u53e3\u83b7\u53d6\u6162\u65e5\u5fd7\u3001\u8fdb\u7a0b\u3001\u8868\u7a7a\u95f4\uff0c\u5176\u4e2d\u8fdb\u7a0b\u548c\u8868\u7a7a\u95f4\u7684\u83b7\u53d6\u9700\u8981\u7ba1\u7406\u6743\u9650\u7684key<\/p>\n<h5>INDEX_PATH_URL<a href=\"https:\/\/archerydms.com\/configuration\/#index_path_url\">\u00b6<\/a><\/h5>\n<p>\u7cfb\u7edf\u9996\u9875\u8def\u5f84\uff0c\u9ed8\u8ba4\u662fSQL\u5de5\u5355\u9875\u9762<\/p>\n<h5>BINLOG2SQL<a href=\"https:\/\/archerydms.com\/configuration\/#binlog2sql\">\u00b6<\/a><\/h5>\n<p>BINLOG2SQL\u8c03\u7528\u8def\u5f84\uff0c\u7528\u4e8e\u5b9e\u73b0binlog2sql\u89e3\u6790\u7684\u529f\u80fd\uff0cdocker\u955c\u50cf\u5185\u5df2\u7ecf\u96c6\u6210 * docker\u90e8\u7f72\u8bf7\u914d\u7f6e\u4e3a<code>\/opt\/archery\/src\/plugins\/binlog2sql\/binlog2sql.py<\/code><\/p>\n<h5>DEFAULT_AUTH_GROUP<a href=\"https:\/\/archerydms.com\/configuration\/#default_auth_group\">\u00b6<\/a><\/h5>\n<p>\u9ed8\u8ba4\u6743\u9650\u7ec4\u540d\uff0c\u65b0\u7528\u6237\u9996\u6b21\u767b\u5f55\u81ea\u52a8\u5173\u8054, \u8001\u7528\u6237\u8bf7\u624b\u52a8\u914d\u7f6e<\/p>\n<h5>DEFAULT_RESOURCE_GROUP<a href=\"https:\/\/archerydms.com\/configuration\/#default_resource_group\">\u00b6<\/a><\/h5>\n<p>\u9ed8\u8ba4\u8d44\u6e90\u7ec4\u540d\uff0c\u65b0\u7528\u6237\u9996\u6b21\u767b\u5f55\u81ea\u52a8\u5173\u8054, \u8001\u7528\u6237\u8bf7\u624b\u52a8\u914d\u7f6e<\/p>\n<h5>LOCK_TIME_THRESHOLD<a href=\"https:\/\/archerydms.com\/configuration\/#lock_time_threshold\">\u00b6<\/a><\/h5>\n<p>\u8d26\u6237\u767b\u5f55\u5931\u8d25\u9501\u5b9a\u65f6\u95f4(\u79d2)<\/p>\n<h5>LOCK_CNT_THRESHOLD<a href=\"https:\/\/archerydms.com\/configuration\/#lock_cnt_threshold\">\u00b6<\/a><\/h5>\n<p>\u8d26\u6237\u767b\u5f55\u5931\u8d25\u51e0\u6b21\u9501\u8d26\u6237<\/p>\n<h5>SIGN_UP_ENABLED<a href=\"https:\/\/archerydms.com\/configuration\/#sign_up_enabled\">\u00b6<\/a><\/h5>\n<p>\u662f\u5426\u5f00\u542f\u6ce8\u518c\u529f\u80fd\uff0c\u5173\u95ed\u540e\u5c06\u65e0\u6cd5\u81ea\u4e3b\u6ce8\u518c\u7528\u6237<\/p>\n<h2>3. \u914d\u7f6e\u6743\u9650\u7ec4<\/h2>\n<blockquote>\n<p>archery \u6743\u9650\u914d\u7f6e\u601d\u8def\u4e3a\uff0c\u6743\u9650\u7ec4\u9650\u5236\u7528\u6237\u63d0\u4ea4\uff0c\u67e5\u8be2\uff0c\u5ba1\u6279\u7b49\u6743\u9650\uff0c\u8d44\u6e90\u7ec4\u9650\u5236\u7528\u6237\u53ef\u4ee5\u64cd\u4f5c\u54ea\u4e9b\u6570\u636e\u5e93\u8d44\u6e90\u3002\u8fd9\u4e9b\u5728\u6dfb\u52a0\u7528\u6237\u7684\u65f6\u5019\u53ef\u4ee5\u9009\u62e9\u7528\u6237\u6dfb\u52a0\u54ea\u4e9b\u6743\u9650\uff0c\u6570\u636e\u5e93\u8d44\u6e90\u3002<\/p>\n<\/blockquote>\n<ul>\n<li>\u914d\u7f6eDBA\u7ba1\u7406\u5ba1\u6838\u6743\u9650\u7ec4<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119102334042.png\" alt=\"image-20201119102334042\" \/><\/p>\n<ul>\n<li>\u914d\u7f6e\u666e\u901a\u7528\u6237\u7ec4\uff0c\u666e\u901a\u7528\u6237\u5177\u6709\u67e5\u8be2\uff0csql\u4e0a\u7ebf\u6743\u9650<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"C:\\Users\\Dell\\AppData\\Roaming\\Typora\\typora-user-images\\image-20201119102510921.png\" alt=\"image-20201119102510921\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119102529093.png\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119102605895.png\" alt=\"image-20201119102605895\" \/><\/p>\n<h2>4.\u914d\u7f6e\u8d44\u6e90\u7ec4<\/h2>\n<blockquote>\n<p>\u8fd9\u91cc\u6dfb\u52a0\u4e24\u4e2a\u8d44\u6e90\u7ec4\uff0c\u5bf9\u5e94\u751f\u4ea7\u73af\u5883\u548c\u6d4b\u8bd5\u73af\u5883\u6570\u636e\u5e93\u8d44\u6e90\u3002<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119111909428.png\" alt=\"image-20201119111909428\" \/><\/p>\n<h2>5.\u6dfb\u52a0\u6570\u636e\u5e93\u5b9e\u4f8b<\/h2>\n<blockquote>\n<p>\u8d44\u6e90\u7ec4\uff1a\u6dfb\u52a0\u6570\u636e\u5e93\u5b9e\u4f8b\u65f6\u9700\u9009\u62e9\u8d44\u6e90\u7ec4<\/p>\n<p>\u5b9e\u4f8b\u6807\u7b7e\uff1a \u63a7\u5236\u6b64\u5b9e\u4f8b\u4e0a\u7ebf\uff0c\u67e5\u8be2\u6743\u9650\u3002<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119102818592.png\" alt=\"image-20201119102818592\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119103409929.png\" alt=\"image-20201119103409929\" \/><\/p>\n<h2>6.\u6dfb\u52a0\u7528\u6237<\/h2>\n<blockquote>\n<p>\u6743\u9650\u4fe1\u606f\uff1a\u6dfb\u52a0\u666e\u901a\u7528\u6237\u65f6\u52fe\u6743\u9650\u4fe1\u606f\u4e3a\u9009\u4eba\u5458\u72b6\u6001\uff0c\u5426\u5219\u7528\u6237\u767b\u5f55\u540e\u6ca1\u6709\u6743\u9650\u6253\u5f00\u540e\u53f0\u7ba1\u7406\u754c\u9762\u4fee\u4e2a\u4e2a\u4eba\u5bc6\u7801\u3002<\/p>\n<p>\u7ec4\uff1a \u5c06\u7528\u6237\u52a0\u5165\u6743\u9650\u7ec4\uff0c\u9644\u52a0\u7528\u6237\u6743\u9650\u3002<\/p>\n<p>\u7528\u6237\u6743\u9650\uff1a\u672c\u793a\u4f8b\u4e2d\u4f7f\u7528\u6743\u9650\u7ec4\u63a7\u5236\u7528\u6237\u6743\u9650\uff0c\u8fd9\u4e2a\u53ef\u4ee5\u4e0d\u9009\u62e9\u6743\u9650\uff0c\u5982\u679c\u60f3\u9644\u52a0\u67d0\u4e9b\u6743\u9650\u7ed9\u7279\u5b9a\u4eba\u7684\u8bdd\u53ef\u4ee5\u5728\u8fd9\u9009\u62e9\u3002<\/p>\n<p>\u8d44\u6e90\u7ec4\uff1a \u5c06\u7528\u6237\u52a0\u5165\u8d44\u6e90\u7ec4\uff0c\u63a7\u5236\u7528\u6237\u53ef\u4ee5\u64cd\u4f5c\u54ea\u4e9b\u6570\u636e\u5e93\u8d44\u6e90\u3002<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119104219126.png\" alt=\"image-20201119104219126\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119104235835.png\" alt=\"image-20201119104235835\" \/><\/p>\n<h2>7.\u914d\u7f6e\u5de5\u5355\u5ba1\u6279\u6d41\u7a0b<\/h2>\n<blockquote>\n<p>\u89c4\u5219\uff1a<strong>\u9009\u62e9\u591a\u4e2a\u6743\u9650\u7ec4\u5373\u5ba1\u6279\u6d41\u7a0b\u4e3a\u591a\u7ea7\u5ba1\u6838\uff0c\u6309\u7167\u9009\u62e9\u987a\u5e8f\u8fdb\u884c\u6d41\u8f6c\uff0c\u6743\u9650\u7ec4\u5185\u7528\u6237\u90fd\u53ef\u5ba1\u6838<\/strong><\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/image-20201119104557412.png\" alt=\"image-20201119104557412\" \/><\/p>\n<h2>8.\u4f18\u5316\u914d\u7f6e<\/h2>\n<ul>\n<li>\u914d\u7f6eSQL\u4e0a\u7ebf\u65f6\u663e\u793a\u771f\u5b9e\u5f71\u54cd\u884c\u6570<\/li>\n<\/ul>\n<blockquote>\n<p>Inception\u548cgoInception\u5ba1\u6838\u8fd4\u56de\u7684\u5f71\u54cd\u884c\u6570\u9ed8\u8ba4\u90fd\u662fexplain\u7684\u7ed3\u679c\uff0c<br \/>\n\u548cinnodb\u7edf\u8ba1\u6570\u636e\u3001\u8bed\u53e5\u662f\u5426\u547d\u4e2d\u7d22\u5f15\u7b49\u90fd\u6709\u6bd4\u8f83\u5927\u7684\u5173\u7cfb\uff0c<br \/>\ngoInception\u6709\u63d0\u4f9b\u83b7\u53d6\u771f\u5b9e\u884c\u6570\u7684\u9009\u9879\uff0c\u8003\u8651\u5230count\u7684\u6548\u7387\u95ee\u9898\uff0c\u9ed8\u8ba4\u672a\u5f15\u7528\u6b64\u9009\u9879\uff0c<\/p>\n<\/blockquote>\n<pre><code class=\"language-bash\">`archery \u4fee\u6539\u771f\u5b9e\u5f71\u54cd\u884c\u6570 --real_row_count = &quot;true&quot;`\n vim  \/opt\/archery\/sql\/engines\/goinception.py\n   inception_sql = f&quot;&quot;&quot;\/*--user=&#039;{instance.user}&#039;;--password=&#039;{instance.password}&#039;;--host=&#039;{instance.host}&#039;;--port={instance.port};--check=1;--real_row_count = &quot;true&quot;*\/ <\/code><\/pre>\n<ul>\n<li>Redis  \u6267\u884c\u547d\u4ee4\u914d\u7f6e\n<pre><code class=\"language-bash\">#\u6587\u4ef6sql\/engines\/redis.py \u4fee\u6539safe_cmd \u5217\u8868\uff0c\u6dfb\u52a0\u53ef\u6267\u884c\u547d\u4ee4\u3002<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/gitee.com\/wangfeng-1\/images\/raw\/master\/20210325143122.png\" alt=\"\" \/><\/p>\n<\/li>\n<\/ul>\n<h2>\u914d\u7f6eSSH\u96a7\u9053\u540e\u65e0\u6cd5\u8fde\u63a5<a href=\"https:\/\/github.com\/hhyo\/Archery\/issues\/951\">github issues<\/a><\/h2>\n<p>\u9700\u8981\u5728Archery\/src\/docker\/startup.sh  \u6587\u4ef6\u4e2d \uff0c\u4fee\u6539\u5e76\u53d1\u65b9\u5f0f\u4e3async\u6a21\u5f0f\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<pre><code class=\"language-bash\">echo \u542f\u52a8\u670d\u52a1\n#gunicorn -w 4 -k gevent -b 127.0.0.1:8888 --timeout 600 archery.wsgi:application\ngunicorn -w 4 -k sync-b 127.0.0.1:8000 --timeout 600 archery.wsgi:application\n<\/code><\/pre>\n<p>docker-compose  \u670d\u52a1\u8fd0\u884c\u6a21\u5f0f\u6539\u4e3a\u4e3b\u673a\u7f51\u7edc\u6a21\u5f0f\uff0c\u52a0\u4e24\u4e2a\u57df\u540d\u89e3\u6790\u3002<\/p>\n<pre><code class=\"language-yaml\">version: &#039;3&#039;\n\nservices:\n  redis:\n    image: redis:5\n    container_name: redis\n    restart: always\n    network_mode: &quot;host&quot;\n    command: redis-server --requirepass 123456\n    expose:\n      - &quot;6379&quot;\n\n  mysql:\n    image: mysql:5.7\n    container_name: mysql\n    restart: always\n    network_mode: &quot;host&quot;\n    ports:\n      - &quot;3306:3306&quot;\n    volumes:\n      - &quot;.\/mysql\/my.cnf:\/etc\/mysql\/my.cnf&quot;\n      - &quot;.\/mysql\/datadir:\/var\/lib\/mysql&quot;\n    environment:\n      MYSQL_DATABASE: archery\n      MYSQL_ROOT_PASSWORD: 123456\n\n  inception:\n    image: hhyo\/inception\n    container_name: inception\n    restart: always\n    network_mode: &quot;host&quot;\n    expose:\n      - &quot;6669&quot;\n    volumes:\n      - &quot;.\/inception\/inc.cnf:\/etc\/inc.cnf&quot;\n\n  goinception:\n    image: hanchuanchuan\/goinception\n    container_name: goinception\n    restart: always\n    network_mode: &quot;host&quot;\n    expose:\n      - &quot;4000&quot;\n    volumes:\n      - &quot;.\/inception\/config.toml:\/etc\/config.toml&quot;\n  archery:\n    image: hhyo\/archery:1.8.0\n    container_name: archery\n    restart: always\n    network_mode: &quot;host&quot;\n    ports:\n      - &quot;9123:9123&quot;\n    volumes:\n      - &quot;.\/archery\/settings.py:\/opt\/archery\/archery\/settings.py&quot;\n      - &quot;.\/archery\/soar.yaml:\/etc\/soar.yaml&quot;\n      - &quot;.\/archery\/docs.md:\/opt\/archery\/docs\/docs.md&quot;\n      - &quot;.\/archery\/downloads:\/opt\/archery\/downloads&quot;\n      - &quot;.\/archery\/sql\/migrations:\/opt\/archery\/sql\/migrations&quot;\n      - &quot;.\/archery\/logs:\/opt\/archery\/logs&quot;\n    entrypoint: &quot;dockerize -wait tcp:\/\/mysql:3306 -wait tcp:\/\/mysql:6379 -timeout 60s \/opt\/archery\/src\/docker\/startup.sh&quot;\n    environment:\n      NGINX_PORT: 9123\n<\/code><\/pre>\n<p>\u589e\u52a0\u57df\u540d\u89e3\u6790\u7528\u4e8e\u8fde\u63a5\u6570\u636e\u5e93redis (\u6bd4\u6539\u914d\u7f6e\u6587\u4ef6\u7b80\u5355\u3002\u3002\u3002\u3002)<\/p>\n<pre><code class=\"language-bash\">127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\n127.0.0.1  redis\n127.0.0.1  mysql\n127.0.0.1  goinception\n127.0.0.1  inception\n<\/code><\/pre>\n<ul>\n<li>SQL \u4e0a\u7ebf\u5ba1\u6838\u9009\u9879\u4f18\u5316\u914d\u7f6e:  <a href=\"https:\/\/hanchuanchuan.github.io\/goInception\/options.html\">https:\/\/hanchuanchuan.github.io\/goInception\/options.html<\/a><\/li>\n<\/ul>\n<h2><a href=\"https:\/\/archerydms.com\/\">\u5b98\u65b9\u6587\u6863<\/a><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>1. docker\u90e8\u7f72\u00b6 \u5b89\u88c5docker\u00b6 \u5b89\u88c5 Docker curl -fsSL https:\/\/get<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\" \/>\n<meta property=\"og:description\" content=\"1. docker\u90e8\u7f72\u00b6 \u5b89\u88c5docker\u00b6 \u5b89\u88c5 Docker curl -fsSL https:\/\/get\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-19T03:14:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-24T03:10:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/archerydms.com\/images\/15529177917926.jpg\" \/>\n<meta name=\"author\" content=\"\u7ba1\u7406\u5458\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\"},\"author\":{\"name\":\"\u7ba1\u7406\u5458\",\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1\"},\"headline\":\"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e\",\"datePublished\":\"2020-11-19T03:14:26+00:00\",\"dateModified\":\"2022-06-24T03:10:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\"},\"wordCount\":348,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1\"},\"articleSection\":[\"Linux\",\"Linux\u670d\u52a1\"],\"inLanguage\":\"zh-CN\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\",\"url\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\",\"name\":\"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\",\"isPartOf\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/#website\"},\"datePublished\":\"2020-11-19T03:14:26+00:00\",\"dateModified\":\"2022-06-24T03:10:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#breadcrumb\"},\"inLanguage\":\"zh-CN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.linuxdevops.cn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Linux\",\"item\":\"https:\/\/www.linuxdevops.cn\/linux\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.linuxdevops.cn\/#website\",\"url\":\"https:\/\/www.linuxdevops.cn\/\",\"name\":\"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\",\"description\":\"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\u7b14\u8bb0\",\"publisher\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1\"},\"alternateName\":\"linuxdevops\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.linuxdevops.cn\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-CN\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1\",\"name\":\"\u7ba1\u7406\u5458\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.linuxdevops.cn\/wp-content\/uploads\/2019\/07\/cropped-index.jpg\",\"contentUrl\":\"https:\/\/www.linuxdevops.cn\/wp-content\/uploads\/2019\/07\/cropped-index.jpg\",\"width\":512,\"height\":512,\"caption\":\"\u7ba1\u7406\u5458\"},\"logo\":{\"@id\":\"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/image\/\"},\"description\":\"\u7ba1\u7406\u5458\",\"url\":\"https:\/\/www.linuxdevops.cn\/author\/root\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/","og_locale":"zh_CN","og_type":"article","og_title":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4","og_description":"1. docker\u90e8\u7f72\u00b6 \u5b89\u88c5docker\u00b6 \u5b89\u88c5 Docker curl -fsSL https:\/\/get","og_url":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/","og_site_name":"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4","article_published_time":"2020-11-19T03:14:26+00:00","article_modified_time":"2022-06-24T03:10:15+00:00","og_image":[{"url":"https:\/\/archerydms.com\/images\/15529177917926.jpg"}],"author":"\u7ba1\u7406\u5458","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#article","isPartOf":{"@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/"},"author":{"name":"\u7ba1\u7406\u5458","@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1"},"headline":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e","datePublished":"2020-11-19T03:14:26+00:00","dateModified":"2022-06-24T03:10:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1"},"articleSection":["Linux","Linux\u670d\u52a1"],"inLanguage":"zh-CN","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/","url":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/","name":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e - Linux\u81ea\u52a8\u5316\u8fd0\u7ef4","isPartOf":{"@id":"https:\/\/www.linuxdevops.cn\/#website"},"datePublished":"2020-11-19T03:14:26+00:00","dateModified":"2022-06-24T03:10:15+00:00","breadcrumb":{"@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#breadcrumb"},"inLanguage":"zh-CN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxdevops.cn\/2020\/11\/configuration-of-archery-sql-audit-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.linuxdevops.cn\/"},{"@type":"ListItem","position":2,"name":"Linux","item":"https:\/\/www.linuxdevops.cn\/linux\/"},{"@type":"ListItem","position":3,"name":"Archery SQL\u5ba1\u8ba1\u7cfb\u7edf\u642d\u5efa\u914d\u7f6e"}]},{"@type":"WebSite","@id":"https:\/\/www.linuxdevops.cn\/#website","url":"https:\/\/www.linuxdevops.cn\/","name":"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4","description":"Linux\u81ea\u52a8\u5316\u8fd0\u7ef4\u7b14\u8bb0","publisher":{"@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1"},"alternateName":"linuxdevops","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.linuxdevops.cn\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-CN"},{"@type":["Person","Organization"],"@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/3e206335d5796fdd8679e449df72a0d1","name":"\u7ba1\u7406\u5458","image":{"@type":"ImageObject","inLanguage":"zh-CN","@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/image\/","url":"https:\/\/www.linuxdevops.cn\/wp-content\/uploads\/2019\/07\/cropped-index.jpg","contentUrl":"https:\/\/www.linuxdevops.cn\/wp-content\/uploads\/2019\/07\/cropped-index.jpg","width":512,"height":512,"caption":"\u7ba1\u7406\u5458"},"logo":{"@id":"https:\/\/www.linuxdevops.cn\/#\/schema\/person\/image\/"},"description":"\u7ba1\u7406\u5458","url":"https:\/\/www.linuxdevops.cn\/author\/root\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/posts\/866"}],"collection":[{"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/comments?post=866"}],"version-history":[{"count":7,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/posts\/866\/revisions"}],"predecessor-version":[{"id":1158,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/posts\/866\/revisions\/1158"}],"wp:attachment":[{"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/media?parent=866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/categories?post=866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxdevops.cn\/wp-json\/wp\/v2\/tags?post=866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}