{"id":318,"date":"2022-06-10T11:35:24","date_gmt":"2022-06-10T03:35:24","guid":{"rendered":"https:\/\/www.anger.ltd\/?p=318"},"modified":"2023-09-14T10:25:09","modified_gmt":"2023-09-14T02:25:09","slug":"%e5%9f%ba%e4%ba%8edocker%e6%90%ad%e5%bb%bamysql%e5%b9%b6%e9%83%a8%e7%bd%b2mycat%e5%ae%9e%e7%8e%b0%e5%88%86%e5%ba%93%e5%88%86%e8%a1%a8%ef%bc%88%e6%b0%b4%e5%b9%b3%e6%8b%86%e5%88%86%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.anger.ltd\/index.php\/2022\/06\/10\/%e5%9f%ba%e4%ba%8edocker%e6%90%ad%e5%bb%bamysql%e5%b9%b6%e9%83%a8%e7%bd%b2mycat%e5%ae%9e%e7%8e%b0%e5%88%86%e5%ba%93%e5%88%86%e8%a1%a8%ef%bc%88%e6%b0%b4%e5%b9%b3%e6%8b%86%e5%88%86%ef%bc%89\/","title":{"rendered":"\u57fa\u4e8eDocker\u642d\u5efaMySQL\u5e76\u90e8\u7f72MyCat\u5b9e\u73b0\u5206\u5e93\u5206\u8868\uff08\u6c34\u5e73\u62c6\u5206\uff09\u3001\u8bfb\u5199\u5206\u79bb"},"content":{"rendered":"\n

\u5199\u5728\u524d\u9762<\/h4>\n\n\n\n

\u56e0\u4e3a\u6700\u8fd1\u8981\u7528\u5230MySQL\u7684\u5206\u5e93\u5206\u8868\uff0c\u6240\u4ee5\u81ea\u5df1\u5c1d\u8bd5\u5728\u6d4b\u8bd5\u673a\u5668\u91cc\u642d\u5efa\u4e00\u5957\u5206\u5e93\u5206\u8868\u7684MySQL\u6570\u636e\u5e93\uff0c\u6211\u8fd9\u91cc\u662f\u901a\u8fc7Docker\u8fd0\u884c\u4e863\u53f0MySQL 5.7 \uff0c\u7136\u540e\u5b98\u65b9\u4e0b\u8f7dMyCat\u7684\u7a0b\u5e8f\u5305\u8fdb\u884c\u90e8\u7f72\u7684\uff0c\u5206\u5e93\u5206\u8868\u505a\u7684\u662f\u6c34\u5e73\u62c6\u5206<\/p>\n\n\n\n

\u6784\u5efaMySQL<\/h4>\n\n\n\n

\u9996\u5148\u62c9\u53d6MySQL\u955c\u50cf<\/p>\n\n\n\n

docker pull mysql:5.7<\/code><\/pre>\n\n\n\n
\u7136\u540e\u521b\u5efa\u6570\u636e\u5e93\u6570\u636e\u7684\u6301\u4e45\u5316\u76ee\u5f55<\/p>\n\n\n\n
mkdir -p \/data\/mysqlone\/log \/data\/mysqlone\/data \/data\/mysqlone\/conf\nmkdir -p \/data\/mysqltwo\/log \/data\/mysqltwo\/data \/data\/mysqltwo\/conf\nmkdir -p \/data\/mysqlthree\/log \/data\/mysqlthree\/data \/data\/mysqlthree\/conf<\/code><\/pre>\n\n\n\n
\u8fd0\u884c\u7b2c\u4e00\u4e2a\u5bb9\u5668\u7136\u540e\u67e5\u770b\u662f\u5426\u80fd\u6b63\u5e38\u8fd0\u884c<\/p>\n\n\n\n
docker run -p 3307:3306 --name mysqlone -v \/data\/mysqlone\/log:\/var\/log\/mysql -v \/data\/mysqlone\/data:\/var\/lib\/mysql -v \/data\/mysqlone\/conf:\/etc\/mysql -e MYSQL_ROOT_PASSWORD=123456 -e TZ=Asia\/Shanghai -d mysql:5.7\n\n#\u7aef\u53e3\u6211\u6539\u4e3a\u4e863307\uff0c\u56e0\u4e3a\u672c\u673a\u4e5f\u6709mysql\uff0c\u4e3a\u4e86\u9632\u6b62\u7aef\u53e3\u51b2\u7a81\u5bfc\u81f4\u5bb9\u5668\u8fd0\u884c\u5931\u8d25\u5c31\u6539\u4e86\u4e00\u4e0b\uff0c\u4e5f\u662f\u4e3a\u4e86\u533a\u5206\n#root\u5bc6\u7801\u4e3a123456\uff0c\u53ef\u4ee5\u6839\u636e\u9700\u6c42\u66f4\u6539\uff0c\u8fd9\u91cc\u4e3a\u4e86\u6d4b\u8bd5\u65b9\u4fbf\u5c31\u5f04\u6210\u4e86\u7b80\u5355\u7684\n\n#\u901a\u8fc7\u547d\u4ee4\u67e5\u770b\u5bb9\u5668\u72b6\u6001\uff0c\u5982\u679c\u8fd0\u884c\u6b63\u5e38\u5c31\u53ef\u4ee5\u8fdb\u884c\u81ea\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6\u4e86\ndocker ps -a\n#\u81ea\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6\uff0c\u56e0\u4e3a\u5df2\u7ecf\u628a\u914d\u7f6e\u6587\u4ef6\u76ee\u5f55\u6302\u8f7d\u51fa\u6765\u4e86\uff0c\u6240\u4ee5\u76f4\u63a5\u5728\u5bbf\u4e3b\u673a\u521b\u5efa\u5373\u53ef\nvim \/data\/mysqlone\/conf\/my.conf\n\n[mysqld]\nport = 3306\nsocket = \/var\/lib\/mysql\/mysql.sock\n\n#basedir = \/var\/lib\/mysql\ndatadir = \/var\/lib\/mysql\npid-file = \/var\/run\/mysqld\/mysqld.pid\nuser = mysql\nbind-address = 0.0.0.0\nserver-id = 1 #\u53e6\u5916\u4e24\u53f0\u6570\u636e\u5e93\u53ef\u4ee5\u8003\u8651\u6539\u6210\u4e0d\u4e00\u6837\u7684\uff0c\u65b9\u4fbf\u4ee5\u540e\u505a\u4e3b\u4ece\u590d\u5236\u548c\u8bfb\u5199\u5206\u79bb\ndefault-time-zone = '+8:00'\n\ncharacter-set-server = utf8mb4\n\nskip-name-resolve\n#skip-networking\nback_log = 300\n\nmax_connections = 1000\nmax_connect_errors = 6000\nopen_files_limit = 65535\ntable_open_cache = 128\nmax_allowed_packet = 500M\nbinlog_cache_size = 1M\nmax_heap_table_size = 8M\ntmp_table_size = 16M\n\nread_buffer_size = 2M\nread_rnd_buffer_size = 8M\nsort_buffer_size = 8M\njoin_buffer_size = 8M\nkey_buffer_size = 4M\n\nthread_cache_size = 8\n\nquery_cache_type = 1\nquery_cache_size = 8M\nquery_cache_limit = 2M\n\nft_min_word_len = 4\n\nlog_bin = mysql-bin\nbinlog_format = mixed\nexpire_logs_days = 7\n\nlog_error = \/var\/log\/mysql\/mysqld.log\nslow_query_log = 1\nlong_query_time = 1\nslow_query_log_file = \/var\/log\/mysql\/mysql-slow.log\n\nperformance_schema = 0\nexplicit_defaults_for_timestamp\n\nskip-external-locking\n\ndefault_storage_engine = InnoDB\ninnodb_file_per_table = 1\ninnodb_open_files = 500\ninnodb_buffer_pool_size = 64M\ninnodb_write_io_threads = 4\ninnodb_read_io_threads = 4\ninnodb_thread_concurrency = 0\ninnodb_purge_threads = 1\ninnodb_flush_log_at_trx_commit = 2\ninnodb_log_buffer_size = 2M\ninnodb_log_file_size = 32M\ninnodb_log_files_in_group = 3\ninnodb_max_dirty_pages_pct = 90\ninnodb_lock_wait_timeout = 120\n\nbulk_insert_buffer_size = 8M\nmyisam_sort_buffer_size = 8M\nmyisam_max_sort_file_size = 10G\nmyisam_repair_threads = 1\n\ninteractive_timeout = 28800\nwait_timeout = 28800\n\nsql_mode = \n\n[mysqldump]\nquick<\/code><\/pre>\n\n\n\n
\u7136\u540e\u91cd\u542f\u5bb9\u5668\u67e5\u770b\u662f\u5426\u6b63\u5e38<\/p>\n\n\n\n
#\u91cd\u542f\u5bb9\u5668\ndocker restart mysqlone\n#\u67e5\u770b\u72b6\u6001\ndocker inspect mysqlone\n#\u5982\u679c\u8fd0\u884c\u6b63\u5e38\uff0c\u8868\u793a\u914d\u7f6e\u6587\u4ef6\u53ef\u7528\uff0c\u590d\u5236\u5230\u5176\u4ed6\u4e24\u4e2a\u76ee\u5f55\ncp \/data\/mysqlone\/conf\/my.conf \/data\/mysqltwo\/conf\/\ncp \/data\/mysqlone\/conf\/my.conf \/data\/mysqlthree\/conf\/<\/code><\/pre>\n\n\n\n
\u542f\u52a8\u53e6\u5916\u4e24\u53f0\u6570\u636e\u5e93<\/p>\n\n\n\n
docker run -p 3308:3306 --name mysqltwo -v \/data\/mysqltwo\/log:\/var\/log\/mysql -v \/data\/mysqltwo\/data:\/var\/lib\/mysql -v \/data\/mysqltwo\/conf:\/etc\/mysql -e MYSQL_ROOT_PASSWORD=123456 -e TZ=Asia\/Shanghai -d mysql:5.7<\/code><\/pre>\n\n\n\n
docker run -p 3309:3306 --name mysqlthree -v \/data\/mysqlthree\/log:\/var\/log\/mysql -v \/data\/mysqlthree\/data:\/var\/lib\/mysql -v \/data\/mysqlthree\/conf:\/etc\/mysql -e MYSQL_ROOT_PASSWORD=123456 -e TZ=Asia\/Shanghai -d mysql:5.7<\/code><\/pre>\n\n\n\n
\u8fd0\u884c\u6210\u529f\u540eMySQL\u5c31\u90e8\u7f72\u5b8c\u6210\u4e86<\/p>\n\n\n\n
\u90e8\u7f72MyCat<\/h4>\n\n\n\n
\u4e0b\u8f7d\u5e76\u90e8\u7f72MyCat<\/p>\n\n\n\n
#\u4e0b\u8f7d\u7a0b\u5e8f\u5305\uff0c\u4e3a\u8fd9\u91cc\u4e0b\u8f7d\u5230\u662f1.6.6\uff0c\u6700\u9ad8\u7248\u672c\u597d\u50cf\u5230\u4e862.0\uff0c\u6839\u636e\u9700\u6c42\u4e0b\u8f7d\u5373\u53ef\nwget http:\/\/dl.mycat.org.cn\/1.6.6\/Mycat-server-1.6.6.1-test-20180709095126-linux.tar.gz\n#\u89e3\u538b\ntar zxvf Mycat-server-1.6.6.1-test-20180709095126-linux.tar.gz -C \/usr\/local\/<\/code><\/pre>\n\n\n\n
\u7f16\u8f91\u914d\u7f6e\u6587\u4ef6<\/p>\n\n\n\n
#\u8fd9\u91cc\u53ea\u9700\u6c42\u4fee\u6539server\u548cschema\u4e24\u4e2a\u6587\u4ef6\u5c31\u53ef\u4ee5\uff0c\u5176\u4ed6\u6587\u4ef6\u7528\u7684\u5230\u5230\u65f6\u5019\u4e0d\u591a\uff0c\u9996\u5148\u4fee\u6539server\ncd \/usr\/local\/mycat\/conf\nvim server.xml\n\n#\u4e0a\u9762\u5176\u5b9e\u4e0d\u7528\u4fee\u6539\u76f4\u63a5\u5230\u6700\u4e0b\u9762\u4fee\u6539\u8d26\u6237\u540d\u5bc6\u7801\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!-- - - Licensed under the Apache License, Version 2.0 (the \"License\"); \n        - you may not use this file except in compliance with the License. - You \n        may obtain a copy of the License at - - http:\/\/www.apache.org\/licenses\/LICENSE-2.0 \n        - - Unless required by applicable law or agreed to in writing, software - \n        distributed under the License is distributed on an \"AS IS\" BASIS, - WITHOUT \n        WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the \n        License for the specific language governing permissions and - limitations \n        under the License. -->\n<!DOCTYPE mycat:server SYSTEM \"server.dtd\">\n<mycat:server xmlns:mycat=\"http:\/\/io.mycat\/\">\n        <system>\n        <property name=\"nonePasswordLogin\">0<\/property> <!-- 0\u4e3a\u9700\u8981\u5bc6\u7801\u767b\u9646\u30011\u4e3a\u4e0d\u9700\u8981\u5bc6\u7801\u767b\u9646 ,\u9ed8\u8ba4\u4e3a0\uff0c\u8bbe\u7f6e\u4e3a1\u5219\u9700\u8981\u6307\u5b9a\u9ed8\u8ba4\u8d26\u6237-->\n        <property name=\"useHandshakeV10\">1<\/property>\n        <property name=\"useSqlStat\">0<\/property>  <!-- 1\u4e3a\u5f00\u542f\u5b9e\u65f6\u7edf\u8ba1\u30010\u4e3a\u5173\u95ed -->\n        <property name=\"useGlobleTableCheck\">0<\/property>  <!-- 1\u4e3a\u5f00\u542f\u5168\u52a0\u73ed\u4e00\u81f4\u6027\u68c0\u6d4b\u30010\u4e3a\u5173\u95ed -->\n\n                <property name=\"sequnceHandlerType\">0<\/property>\n        <property name=\"subqueryRelationshipCheck\">false<\/property> <!-- \u5b50\u67e5\u8be2\u4e2d\u5b58\u5728\u5173\u8054\u67e5\u8be2\u7684\u60c5\u51b5\u4e0b,\u68c0\u67e5\u5173\u8054\u5b57\u6bb5\u4e2d\u662f\u5426\u6709\u5206\u7247\u5b57\u6bb5 .\u9ed8\u8ba4 false -->\n      <!--  <property name=\"useCompression\">1<\/property>--> <!--1\u4e3a\u5f00\u542fmysql\u538b\u7f29\u534f\u8bae-->\n        <!--  <property name=\"fakeMySQLVersion\">5.6.20<\/property>--> <!--\u8bbe\u7f6e\u6a21\u62df\u7684MySQL\u7248\u672c\u53f7-->\n        <!-- <property name=\"processorBufferChunk\">40960<\/property> -->\n        <!-- \n        <property name=\"processors\">1<\/property> \n        <property name=\"processorExecutor\">32<\/property> \n         -->\n        <!--\u9ed8\u8ba4\u4e3atype 0: DirectByteBufferPool | type 1 ByteBufferArena | type 2 NettyBufferPool -->\n                <property name=\"processorBufferPoolType\">0<\/property>\n                <!--\u9ed8\u8ba4\u662f65535 64K \u7528\u4e8esql\u89e3\u6790\u65f6\u6700\u5927\u6587\u672c\u957f\u5ea6 -->\n                <!--<property name=\"maxStringLiteralLength\">65535<\/property>-->\n                <!--<property name=\"sequnceHandlerType\">0<\/property>-->\n                <!--<property name=\"backSocketNoDelay\">1<\/property>-->\n                <!--<property name=\"frontSocketNoDelay\">1<\/property>-->\n                <!--<property name=\"processorExecutor\">16<\/property>-->\n                <!--\n                        <property name=\"serverPort\">8066<\/property> <property name=\"managerPort\">9066<\/property> \n                        <property name=\"idleTimeout\">300000<\/property> <property name=\"bindIp\">0.0.0.0<\/property> \n                        <property name=\"frontWriteQueueSize\">4096<\/property> <property name=\"processors\">32<\/property> -->\n                <!--\u5206\u5e03\u5f0f\u4e8b\u52a1\u5f00\u5173\uff0c0\u4e3a\u4e0d\u8fc7\u6ee4\u5206\u5e03\u5f0f\u4e8b\u52a1\uff0c1\u4e3a\u8fc7\u6ee4\u5206\u5e03\u5f0f\u4e8b\u52a1\uff08\u5982\u679c\u5206\u5e03\u5f0f\u4e8b\u52a1\u5185\u53ea\u6d89\u53ca\u5168\u5c40\u8868\uff0c\u5219\u4e0d\u8fc7\u6ee4\uff09\uff0c2\u4e3a\u4e0d\u8fc7\u6ee4\u5206\u5e03\u5f0f\u4e8b\u52a1,\u4f46\u662f\u8bb0\u5f55\u5206\u5e03\u5f0f\u4e8b\u52a1\u65e5\u5fd7-->\n                <property name=\"handleDistributedTransactions\">0<\/property>\n                \n                        <!--\n                        off heap for merge\/order\/group\/limit      1\u5f00\u542f   0\u5173\u95ed\n                -->\n                <property name=\"useOffHeapForMerge\">1<\/property>\n\n                <!--\n                        \u5355\u4f4d\u4e3am\n                -->\n        <property name=\"memoryPageSize\">64k<\/property>\n\n                <!--\n                        \u5355\u4f4d\u4e3ak\n                -->\n                <property name=\"spillsFileBufferSize\">1k<\/property>\n\n                <property name=\"useStreamOutput\">0<\/property>\n\n                <!--\n                        \u5355\u4f4d\u4e3am\n                -->\n                <property name=\"systemReserveMemorySize\">384m<\/property>\n\n\n                <!--\u662f\u5426\u91c7\u7528zookeeper\u534f\u8c03\u5207\u6362  -->\n                <property name=\"useZKSwitch\">false<\/property>\n\n                <!-- XA Recovery Log\u65e5\u5fd7\u8def\u5f84 -->\n                <!--<property name=\"XARecoveryLogBaseDir\">.\/<\/property>-->\n\n                <!-- XA Recovery Log\u65e5\u5fd7\u540d\u79f0 -->\n                <!--<property name=\"XARecoveryLogBaseName\">tmlog<\/property>-->\n                <!--\u5982\u679c\u4e3a true\u7684\u8bdd \u4e25\u683c\u9075\u5b88\u9694\u79bb\u7ea7\u522b,\u4e0d\u4f1a\u5728\u4ec5\u4ec5\u53ea\u6709select\u8bed\u53e5\u7684\u65f6\u5019\u5728\u4e8b\u52a1\u4e2d\u5207\u6362\u8fde\u63a5-->\n                <property name=\"strictTxIsolation\">false<\/property>\n                \n                <property name=\"useZKSwitch\">true<\/property>\n                \n        <\/system>\n        \n        <!-- \u5168\u5c40SQL\u9632\u706b\u5899\u8bbe\u7f6e -->\n        <!--\u767d\u540d\u5355\u53ef\u4ee5\u4f7f\u7528\u901a\u914d\u7b26%\u6216\u7740*-->\n        <!--\u4f8b\u5982<host host=\"127.0.0.*\" user=\"root\"\/>-->\n        <!--\u4f8b\u5982<host host=\"127.0.*\" user=\"root\"\/>-->\n        <!--\u4f8b\u5982<host host=\"127.*\" user=\"root\"\/>-->\n        <!--\u4f8b\u5982<host host=\"1*7.*\" user=\"root\"\/>-->\n        <!--\u8fd9\u4e9b\u914d\u7f6e\u60c5\u51b5\u4e0b\u5bf9\u4e8e127.0.0.1\u90fd\u80fd\u4ee5root\u8d26\u6237\u767b\u5f55-->\n        <!--\n        <firewall>\n           <whitehost>\n              <host host=\"1*7.0.0.*\" user=\"root\"\/>\n           <\/whitehost>\n       <blacklist check=\"false\">\n       <\/blacklist>\n        <\/firewall>\n        -->\n\t\t\t\t<!--  **  \u4fee\u6539\u8fd9\u91cc\u5c31\u53ef\u4ee5\u4e86  ** --><\/mark>\n        <user name=\"sheep\" defaultAccount=\"true\">\n                <property name=\"password\">123456<\/property>\n                <property name=\"schemas\">sheepdb<\/property>\n                \n                <!-- \u8868\u7ea7 DML \u6743\u9650\u8bbe\u7f6e -->\n                <!--            \n                <privileges check=\"false\">\n                        <schema name=\"TESTDB\" dml=\"0110\" >\n                                <table name=\"tb01\" dml=\"0000\"><\/table>\n                                <table name=\"tb02\" dml=\"1111\"><\/table>\n                        <\/schema>\n                <\/privileges>           \n                 -->\n        <\/user>\n\n        <user name=\"user\">\n                <property name=\"password\">user<\/property>\n                <property name=\"schemas\">sheepdb<\/property>\n                <property name=\"readOnly\">true<\/property>\n        <\/user>\n\n<\/mycat:server>\n\n#user \u4e2dname\u4e3a\u8fde\u63a5MyCat\u7684\u7528\u6237\u540d\uff0cpassword\u4e3a\u5bc6\u7801\uff0cschemas\u540e\u9762\u7684\u6570\u636e\u5e93\u5982\u679c\u4fee\u6539\uff0c\u4e00\u5b9a\u8981\u548cschemas\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u5e93\u5bf9\u5e94\uff0c\u5e76\u4e14\u4e5f\u8981\u4fee\u6539\u4e0b\u9762user\u7528\u6237\u7684\u6570\u636e\u5e93\n<\/code><\/pre>\n\n\n\n
\u63a5\u7740\u4fee\u6539schemas\u6587\u4ef6<\/p>\n\n\n\n
vim schemas.xml\n\n<?xml version=\"1.0\"?>\n<!DOCTYPE mycat:schema SYSTEM \"schema.dtd\">\n<mycat:schema xmlns:mycat=\"http:\/\/io.mycat\/\">\n\t\t\t\t<!-- ** \u8fd9\u91cc\u7684name\u540d\u5b57\u8981\u548cserver\u91cc\u6570\u636e\u5e93\u540d\u4e00\u81f4 ** --><\/mark>\n        <schema name=\"sheepdb\" checkSQLschema=\"false\" sqlMaxLimit=\"100\">\n                <!-- auto sharding by id (long) -->\n\t\t\t\t<!-- ** \u8fd9\u91cc\u8868\u7684\u540d\u5b57\u8981\u5728\u5e93\u91cc\u5b58\u5728 ** --><\/mark>\n                <table name=\"user\" primaryKey=\"id\" dataNode=\"dn1,dn2,dn3\" rule=\"mod-long\" autoIncrement=\"true\" \/>\n        <\/schema>\n        <!-- ** \u540e\u9762database\u7684\u540d\u5b57\u7684\u5e93\u8981\u5728\u6570\u636e\u5e93\u91cc\u5b58\u5728 ** -->\n        <dataNode name=\"dn1\" dataHost=\"localhost1\" database=\"sheepdb\" \/>\n        <dataNode name=\"dn2\" dataHost=\"localhost2\" database=\"sheepdb\" \/>\n        <dataNode name=\"dn3\" dataHost=\"localhost3\" database=\"sheepdb\" \/>\n\n\t\t\t\t<!-- ** balance\u8981\u6539\u4e3a0\u4e0d\u505a\u8d1f\u8f7d\u5747\u8861 ** --><\/mark>\n        <dataHost name=\"localhost1\" maxCon=\"1000\" minCon=\"10\" balance=\"0\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n\t\t\t\t\t\t\t\t<!-- ** \u586b\u5199\u6570\u636e\u5e93\u5730\u5740\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801\uff0c\u6ce8\u610fhost\u540d\u5b57\u4e0d\u8981\u90fd\u4e00\u6837 ** --><\/mark>\n                <writeHost host=\"hostM1\" url=\"192.168.1.212:3307\" user=\"root\" password=\"123456\">\n                        <!--<readHost host=\"hostS1\" url=\"192.168.1.212:3306\" user=\"sheep\" password=\"Ming456!\" \/>-->\n                <\/writeHost>\n        <\/dataHost>\n        <dataHost name=\"localhost2\" maxCon=\"1000\" minCon=\"10\" balance=\"0\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n\t\t\t\t\t\t\t\t<!-- ** \u6ce8\u610fhost\u540d\u5b57 ** --><\/mark>\n                <writeHost host=\"hostM2\" url=\"192.168.1.212:3308\" user=\"root\" password=\"123456\">\n                        <!--<readHost host=\"hostS1\" url=\"192.168.1.212:3306\" user=\"sheep\" password=\"Ming456!\" \/>-->\n                <\/writeHost>\n        <\/dataHost>\n        <dataHost name=\"localhost3\" maxCon=\"1000\" minCon=\"10\" balance=\"0\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n\t\t\t\t\t\t\t\t<!-- ** \u6ce8\u610fhost\u540d\u5b57 ** --><\/mark>\n                <writeHost host=\"hostM3\" url=\"192.168.1.212:3309\" user=\"root\" password=\"123456\">\n                        <!--<readHost host=\"hostS1\" url=\"192.168.1.212:3306\" user=\"sheep\" password=\"Ming456!\" \/>-->\n                <\/writeHost>\n        <\/dataHost>\n\n<\/mycat:schema><\/code><\/pre>\n\n\n\n
\u4fee\u6539\u5b8c\u6210\u5c31\u53ef\u4ee5\u542f\u52a8MyCat\u4e86<\/p>\n\n\n\n
#\u542f\u52a8\n\/usr\/local\/mycat\/bin\/mycat start\n#\u67e5\u770b\u65e5\u5fd7\ncd \/usr\/local\/mycat\/logs\ntail -f wrapper.log<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u65e5\u5fd7\u6ca1\u6709\u62a5\u9519\u7684\u8bdd\u670d\u52a1\u5c31\u5df2\u7ecf\u542f\u52a8\u4e86\uff0c\u5982\u679c\u542f\u52a8\u6709\u62a5\u9519\u4f1a\u5728\u8fd9\u4e2a\u65e5\u5fd7\u4e2d\u4f53\u73b0\uff0c\u518d\u53bb\u67e5\u770b\u8fd0\u884c\u65e5\u5fd7<\/p>\n\n\n\n
tail -f mycat.log<\/code><\/pre>\n\n\n\n
\u5982\u679c\u6ca1\u6709\u4efb\u4f55\u62a5\u9519\u4fe1\u606f\uff0cMyCat\u5c31\u5df2\u7ecf\u542f\u52a8\u5b8c\u6210\uff0c\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u6216\u8005\u5de5\u5177\u8fde\u63a5\u4e86\uff0c\u7528\u6237\u540d\u5bc6\u7801\u4e3aserver\u6587\u4ef6\u4e2d\u7684\u4fe1\u606f\uff0c\u9ed8\u8ba4\u7aef\u53e38066<\/p>\n\n\n
\n
\"\"<\/figure><\/div>\n\n\n
\u914d\u7f6e\u8bfb\u5199\u5206\u79bb<\/h4>\n\n\n\n
\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u524d\u9762\u7684\u5e93\uff0c\u5148\u5f00\u542fMySQL\u7684\u4e3b\u4ece\u590d\u5236\u529f\u80fd<\/p>\n\n\n\n
#\u628amysqlone\u4f5c\u4e3a\u4e3b\u5e93\uff0c\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\nvim \/data\/mysqlone\/conf\/my.cnf\n\n#\u5728[mysqld]\u6a21\u5757\u5185\u589e\u52a0\u4ee5\u4e0b\u914d\u7f6e\n\n#\u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7\u529f\u80fd\nlog-bin=mysql-bin\n#\u590d\u5236\u8fc7\u6ee4\uff1a\u4e0d\u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\uff0c\u4e0d\u8f93\u51fa\uff08mysql\u5e93\u4e00\u822c\u4e0d\u540c\u6b65\uff09\nbinlog-ignore-db=mysql\n#\u65e5\u5fd7\u4fdd\u7559\u65f6\u95f4\uff08\u5929\uff09\nexpire-logs-days=10\n#\u8df3\u8fc7\u4e3b\u4ece\u590d\u5236\u4e2d\u9047\u5230\u7684\u6240\u6709\u9519\u8bef\u6216\u6307\u5b9a\u7c7b\u578b\u7684\u9519\u8bef\uff0c\u907f\u514dslave\u7aef\u590d\u5236\u4e2d\u65ad\n#\u5982\uff1a1062\u9519\u8bef\u662f\u6307\u4e00\u4e9b\u4e3b\u952e\u91cd\u590d\uff0c1032\u9519\u8bef\u662f\u56e0\u4e3a\u4e3b\u4ece\u6570\u636e\u5e93\u6570\u636e\u4e0d\u4e00\u81f4\nslave_skip_errors=1062<\/code><\/pre>\n\n\n\n
\u7136\u540e\u91cd\u542fmysqlone\u5bb9\u5668<\/p>\n\n\n\n
docker restart mysqlone<\/code><\/pre>\n\n\n\n
\u63a5\u7740\u4fee\u6539\u4ece\u5e93<\/p>\n\n\n\n
#\u540c\u6837\u5728[mysqld]\u6a21\u5757\u5185\u589e\u52a0\u4e0b\u9762\u7684\u914d\u7f6e\n\nbinlog-ignore-db=mysql\nlog-bin=mysql-slave1-bin\nslave_skip_errors=1062\nlog_slave_updates=1\n# relay_log\u914d\u7f6e\u4e2d\u7ee7\u65e5\u5fd7\nrelay-log=relay-log-bin\nrelay-log-index=slave-relay-bin.index<\/code><\/pre>\n\n\n\n
\u914d\u7f6e\u5b8c\u6210\u540e\u91cd\u542fmysqltwo<\/p>\n\n\n\n
docker restart mysqltwo<\/code><\/pre>\n\n\n\n
\u5230\u8fd9\u91cc\u914d\u7f6e\u6587\u4ef6\u5c31\u5df2\u7ecf\u4fee\u6539\u5b8c\u6210\u4e86\uff0c\u7136\u540e\u767b\u9646mysql\u8fdb\u884c\u914d\u7f6e<\/p>\n\n\n\n
#\u5982\u679c\u672c\u673a\u5b89\u88c5\u4e86mysql\u5ba2\u6237\u7aef\u7a0b\u5e8f\u53ef\u4ee5\u5728\u672c\u673a\u767b\u9646\uff0c\u5982\u679c\u6ca1\u6709\u5c31\u8981\u8fdb\u5230\u5bb9\u5668\u5185\u767b\u9646\n#\u672c\u673a\u767b\u9646\u4e3b\u5e93\uff0c\u4e00\u5b9a\u8981\u52a0-h \u4e0d\u7136\u662f\u4ee5localhost\u767b\u9646\uff0c\u4f1a\u63d0\u793a\u65e0\u6cd5\u767b\u9646\nmysql -h127.0.0.1 -uroot -p123456 -P3307\n\n#\u589e\u52a0\u4e00\u4e2a\u7528\u4e8e\u540c\u6b65\u7684\u8d26\u6237\uff08\u53ef\u4e0d\u521b\u5efa\uff0c\u76f4\u63a5\u4f7f\u7528root\uff09\nGRANT REPLICATION SLAVE ON *.* to 'slave'@'%' identified by '123456';\nFLUSH PRIVILEGES;\n\n#\u67e5\u770bbinlog\u65e5\u5fd7\u662f\u5426\u5df2\u7ecf\u5f00\u542f\nshow variables like '%log_bin%';<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
#\u67e5\u770b\u5f53\u524dbinlog\u65e5\u5fd7\u7684\u4fe1\u606f\nshow master status;<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u6211\u4eec\u8981\u7684\u662fbinlong\u6587\u4ef6\u540d\u548c\u504f\u79fb\uff0c\u8ba9\u4ece\u5e93\u4e00\u4f1a\u901a\u8fc7\u8fd9\u4e2a\u4e24\u4e2a\u4fe1\u606f\u5f00\u542f\u4e3b\u4ece\u590d\u5236\u529f\u80fd<\/p>\n\n\n\n
#\u767b\u9646\u4ece\u5e93mysqltwo\nmysql -h 127.0.0.1 -uroot -p123456 -P3308\n\n#\u7ed1\u5b9a\u4e3b\u5e93\uff08\u5982\u679c\u6570\u636e\u5e93\u6709\u4eba\u4f7f\u7528\uff0c\u504f\u79fb\u53ef\u80fd\u53d8\u5316\u5f88\u5feb\uff0c\u5efa\u8bae\u4f7f\u7528\u91cf\u5c11\u6216\u8005\u65e0\u4eba\u4f7f\u7528\u65f6\u914d\u7f6e\uff09\nchange master to master_host='192.168.1.212', master_user='root', master_password='123456', master_port=3307, master_log_file='mysql-bin.000001',master_log_pos=35861;\n#\u89e3\u91ca\n#master_host\u4e3a\u4e3b\u5e93\u7684IP\u5730\u5740\n#master_user\u4e3a\u8fde\u63a5\u4e3b\u5e93\u7528\u7684\u7528\u6237\u540d,\u53ef\u4ee5\u662f\u4e4b\u524d\u521b\u5efa\u7684\uff0c\u4e5f\u53ef\u4ee5\u7528root\n#master_password\u5bf9\u5e94\u7528\u6237\u7684\u5bc6\u7801\n#master_port\u4e3b\u5e93\u7684\u7aef\u53e3\n#master_log_file\u4e3b\u5e93binlog\u65e5\u5fd7\u6587\u4ef6\u540d\uff0c\u5c31\u662f\u4e0a\u9762\u622a\u56fe\u4e2d\u7684file\n#master_log_pos\u4e3a\u504f\u79fb\u6570\uff0c\u4e0a\u9762\u622a\u56fe\u4e2dPosition<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u7136\u540e\u5f00\u542f\u4e3b\u4ece\u590d\u5236\u529f\u80fd\uff08\u4ece\u5e93\u64cd\u4f5c\uff09<\/p>\n\n\n\n
start slave;\n#\u67e5\u770b\u4e3b\u4ece\u590d\u5236\u72b6\u6001\nshow slave status\\G;<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u4e24\u4e2a\u4f4d\u7f6e\u5747\u4e3aYes\u8868\u793a\u5df2\u7ecf\u5f00\u542f\u6210\u529f\uff0c\u5982\u679c\u6ca1\u6709\u6210\u529f\u53ef\u4ee5\u91cd\u7f6e\u4ee5\u540e\u518d\u5f00\u542f<\/p>\n\n\n\n
#\u5148\u505c\u6389\u4e3b\u4ece\u590d\u5236\nstop slave;\n#\u91cd\u7f6e\nreset slave;\n#\u91cd\u65b0\u914d\u7f6e\u7ed1\u5b9a\uff0c\u67e5\u770b\u65b0\u7684\u504f\u79fb\u6570\u540e\u8fdb\u884c\u914d\u7f6e\uff0c\u518d\u6b21\u542f\u52a8\u67e5\u770b\u4fe1\u606f\uff0c\u76f4\u5230\u6210\u529f<\/code><\/pre>\n\n\n\n
\u5230\u8fd9\u91cc\u4e3b\u4ece\u590d\u5236\u5c31\u5df2\u7ecf\u914d\u7f6e\u5b8c\u6210\uff0c\u63a5\u7740\u53bb\u914dMyCat\u5f00\u542f\u8bfb\u5199\u5206\u79bb\uff08\u8bfb\u5199\u5206\u79bb\u548c\u6c34\u5e73\u62c6\u5206\u53ef\u540c\u65f6\u4f7f\u7528\uff09<\/p>\n\n\n\n
\u5148\u4fee\u6539server\u6587\u4ef6\uff0c\u8fd9\u91cc\u4e3a\u4e86\u6f14\u793a\u6240\u4ee5\u4fee\u6539\u4e86\u4e4b\u524d\u7684\u914d\u7f6e\uff0c\u8bfb\u5199\u5206\u79bb\u548c\u5206\u5e93\u5206\u8868\u53ef\u5728\u4e00\u4e2a\u914d\u7f6e\u5185<\/p>\n\n\n\n
cd \/usr\/local\/mycat\/conf\/\n#\u4fee\u6539\u914d\u7f6e,\u53ea\u9700\u8981\u4fee\u6539user\u90e8\u5206\nvim server.xml\n\n\n<user name=\"mycat\" defaultAccount=\"true\">\n                <property name=\"password\">123456<\/property>\n\t\t\t\t\t\t\t\t<!-- \u6211\u8fd9\u91cc\u6dfb\u52a0\u4e862\u4e2a\u5e93\u505a\u8bfb\u5199\u5206\u79bb\uff0c\u591a\u4e2a\u5e93\u53ef\u4ee5\u7528\u9017\u53f7\u9694\u5f00 --><\/mark>\n                <property name=\"schemas\">account,money_record<\/property>\n\n                <!-- \u8868\u7ea7 DML \u6743\u9650\u8bbe\u7f6e -->\n                <!-- \n                <privileges check=\"false\">\n                        <schema name=\"TESTDB\" dml=\"0110\" >\n                                <table name=\"tb01\" dml=\"0000\"><\/table>\n                                <table name=\"tb02\" dml=\"1111\"><\/table>\n                        <\/schema>\n                <\/privileges>\n                 -->\n        <\/user>\n\n        <user name=\"user\">\n                <property name=\"password\">user<\/property>\n\t\t\t\t\t\t\t\t<!-- \u8fd9\u91cc\u8981\u5199\u6210\u4e00\u6837\u7684\uff0c\u4e0d\u7136\u65e0\u6cd5\u542f\u52a8 --><\/mark>\n                <property name=\"schemas\">account,money_record<\/property>\n                <property name=\"readOnly\">true<\/property>\n        <\/user><\/code><\/pre>\n\n\n\n
\u7136\u540e\u4fee\u6539schema.xml<\/p>\n\n\n\n
#\u6211\u8fd9\u91cc\u505a\u4e86\u7cbe\u7b80\uff0c\u5982\u679c\u60f3\u8ba9\u8bfb\u5199\u5206\u79bb\u548c\u5206\u5e93\u5206\u8868\u540c\u65f6\u4f7f\u7528\uff0c\u6dfb\u52a0\u591a\u4e2aschema\u6a21\u5757\u5373\u53ef<\/mark>\n\n<?xml version=\"1.0\"?>\n<!DOCTYPE mycat:schema SYSTEM \"schema.dtd\">\n<mycat:schema xmlns:mycat=\"http:\/\/io.mycat\/\">\n\n\n        <schema name=\"account\" dataNode=\"dn1\" checkSQLschema=\"false\" sqlMaxLimit=\"100\"><\/schema>\n        <schema name=\"money_record\" dataNode=\"dn2\" checkSQLschema=\"false\" sqlMaxLimit=\"100\"><\/schema>\n        <dataNode name=\"dn1\" dataHost=\"localhost1\" database=\"account\" \/>\n        <dataNode name=\"dn2\" dataHost=\"localhost1\" database=\"money_record\" \/>\n\t\t\t\t<!-- balance\u914d\u7f6e\u4e3a1 \u6027\u80fd\u76f8\u5bf9\u66f4\u597d\u4e00\u4e9b --><\/mark>\n        <dataHost name=\"localhost1\" maxCon=\"1000\" minCon=\"10\" balance=\"1\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n                <writeHost host=\"hostM1\" url=\"192.168.1.212:3307\" user=\"root\" password=\"123456\">\n                        <readHost host=\"hostS1\" url=\"192.168.1.212:3308\" user=\"root\" password=\"123456\" \/>\n                <\/writeHost>\n        <\/dataHost>\n<\/mycat:schema><\/code><\/pre>\n\n\n\n
\u6587\u6863\u987a\u5e8f\u4e00\u5b9a\u662fschema \u2014> dataNode \u2014> dataHost \u987a\u5e8f\u9519\u8bef\u4f1a\u65e0\u6cd5\u542f\u52a8\uff0c\u8bfb\u5199\u5206\u79bb\u56e0\u4e3a\u6ca1\u6709\u914d\u7f6etable\uff0c\u6240\u4ee5\u4e00\u5b9a\u8981\u5728schema\u4e2d\u914d\u7f6edataNode\uff0c\u800c\u4e14\u5fc5\u987b\u6dfb\u52a0\u5199\u8282\u70b9\u548c\u8bfb\u8282\u70b9\uff0c\u5199\u8282\u70b9\u5185\u6dfb\u52a0\u8bfb\u8282\u70b9\uff0c\u5199\u4e3a\u4e3b\u5e93\u8bfb\u4e3a\u4ece\u5e93\uff0c\u4e0d\u7136\u6570\u636e\u4f1a\u4e0d\u4e00\u81f4<\/p>\n\n\n\n
\u63a5\u7740\u5f00\u542fMyCat<\/p>\n\n\n\n
\/usr\/local\/mycat\/bin\/mycat start<\/code><\/pre>\n\n\n\n
\u67e5\u770b\u542f\u52a8\u65e5\u5fd7\u72b6\u6001<\/p>\n\n\n\n
tail -f \/usr\/local\/mycat\/logs\/wrapper.log<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u6ca1\u6709\u9519\u8bef\u5c31\u5df2\u7ecf\u542f\u52a8\u6210\u529f\u4e86\uff0c\u5230\u6b64\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u5b8c\u6210<\/p>\n\n\n\n
\u793a\u4f8b<\/p>\n\n\n\n
#\u8bfb\u5199\u5206\u79bb\u548c\u5206\u5e93\u5206\u8868\u540c\u65f6\u4f7f\u7528\u793a\u4f8b<\/mark>\n\n<?xml version=\"1.0\"?>\n<!DOCTYPE mycat:schema SYSTEM \"schema.dtd\">\n<mycat:schema xmlns:mycat=\"http:\/\/io.mycat\/\">\n\t\t\t\t<! -- \u5206\u5e93\u5206\u8868<\/mark> -->\n\t\t\t\t<schema name=\"sheepdb\" dataNode=\"dn1\" checkSQLschema=\"false\" sqlMaxLimit=\"100\"><\/schema>\n\t\t\t\t<table name=\"user\" primaryKey=\"id\" dataNode=\"dn1,dn2\" rule=\"mod-long\" autoIncrement=\"true\" \/>\n        <\/schema>\n\t\t\t\t<!-- \u8bfb\u5199\u5206\u79bb<\/mark> -->\n\t\t\t\t<schema name=\"Mingdb\" dataNode=\"dn3\" checkSQLschema=\"false\" sqlMaxLimit=\"100\"><\/schema>\n\n\t\t\t\t<dataNode name=\"dn1\" dataHost=\"localhost1\" database=\"sheepdb\" \/>\n\t\t\t\t<dataNode name=\"dn2\" dataHost=\"localhost2\" database=\"sheepdb\" \/>\n\t\t\t\t<dataNode name=\"dn3\" dataHost=\"localhost3\" database=\"Mingdb\" \/>\n\n\t\t\t\t<!-- \u5206\u5e93\u5206\u8868<\/mark> -->\n\t\t\t\t<dataHost name=\"localhost1\" maxCon=\"1000\" minCon=\"10\" balance=\"0\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n                <writeHost host=\"hostM1\" url=\"192.168.1.212:3307\" user=\"root\" password=\"123456\">                       \n                <\/writeHost>\n        <\/dataHost>\n\t\t\t\t<dataHost name=\"localhost2\" maxCon=\"1000\" minCon=\"10\" balance=\"0\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n                <writeHost host=\"hostM2\" url=\"192.168.1.212:3308\" user=\"root\" password=\"123456\">                       \n                <\/writeHost>\n        <\/dataHost>\n\n\t\t\t\t<!-- \u8bfb\u5199\u5206\u79bb<\/mark> -->\n\t\t\t\t<dataHost name=\"localhost3\" maxCon=\"1000\" minCon=\"10\" balance=\"1\"\n                          writeType=\"0\" dbType=\"mysql\" dbDriver=\"native\" switchType=\"1\"  slaveThreshold=\"100\" maxRetryCount=\"4\">\n                <heartbeat>select user()<\/heartbeat>\n                <writeHost host=\"hostM3\" url=\"192.168.1.212:3307\" user=\"root\" password=\"123456\">\n                        <readHost host=\"hostS3\" url=\"192.168.1.212:3308\" user=\"root\" password=\"123456\" \/>\n                <\/writeHost>\n\t\t\t\t<\/dataHost>\n<\/mycat:schema><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5199\u5728\u524d\u9762 \u56e0\u4e3a\u6700\u8fd1\u8981\u7528\u5230MySQL\u7684\u5206\u5e93\u5206\u8868\uff0c\u6240\u4ee5\u81ea\u5df1\u5c1d\u8bd5\u5728\u6d4b\u8bd5\u673a\u5668\u91cc\u642d\u5efa\u4e00\u5957\u5206\u5e93\u5206\u8868\u7684MySQL\u6570\u636e\u5e93\uff0c\u6211\u8fd9\u91cc\u662f\u901a\u8fc7Docker\u8fd0\u884c\u4e863\u53f0MySQL 5.7 \uff0c\u7136\u540e\u5b98\u65b9\u4e0b\u8f7dMyCat\u7684\u7a0b\u5e8f\u5305\u8fdb\u884c\u90e8\u7f72\u7684\uff0c\u5206\u5e93\u5206 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-318","post","type-post","status-publish","format-standard","hentry","category-3"],"_links":{"self":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/comments?post=318"}],"version-history":[{"count":10,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/318\/revisions"}],"predecessor-version":[{"id":794,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/318\/revisions\/794"}],"wp:attachment":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/media?parent=318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/categories?post=318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/tags?post=318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}