{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/113","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/113/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/113/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/113/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/113","id":55243217,"number":113,"title":"多表配置问题","user":{"login":"yayaw","id":6355766,"avatar_url":"https://avatars.githubusercontent.com/u/6355766?v=3","gravatar_id":"","url":"https://api.github.com/users/yayaw","html_url":"https://github.com/yayaw","followers_url":"https://api.github.com/users/yayaw/followers","following_url":"https://api.github.com/users/yayaw/following{/other_user}","gists_url":"https://api.github.com/users/yayaw/gists{/gist_id}","starred_url":"https://api.github.com/users/yayaw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yayaw/subscriptions","organizations_url":"https://api.github.com/users/yayaw/orgs","repos_url":"https://api.github.com/users/yayaw/repos","events_url":"https://api.github.com/users/yayaw/events{/privacy}","received_events_url":"https://api.github.com/users/yayaw/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-23T04:11:49Z","updated_at":"2015-01-23T05:47:58Z","closed_at":null,"body":"如何实现，不分片的表，默认走指定的datanode"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/71150558","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/113#issuecomment-71150558","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/113","id":71150558,"user":{"login":"apachemycat","id":8221103,"avatar_url":"https://avatars.githubusercontent.com/u/8221103?v=3","gravatar_id":"","url":"https://api.github.com/users/apachemycat","html_url":"https://github.com/apachemycat","followers_url":"https://api.github.com/users/apachemycat/followers","following_url":"https://api.github.com/users/apachemycat/following{/other_user}","gists_url":"https://api.github.com/users/apachemycat/gists{/gist_id}","starred_url":"https://api.github.com/users/apachemycat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apachemycat/subscriptions","organizations_url":"https://api.github.com/users/apachemycat/orgs","repos_url":"https://api.github.com/users/apachemycat/repos","events_url":"https://api.github.com/users/apachemycat/events{/privacy}","received_events_url":"https://api.github.com/users/apachemycat/received_events","type":"User","site_admin":false},"created_at":"2015-01-23T05:47:58Z","updated_at":"2015-01-23T05:47:58Z","body":"若绝大多数表不分片，可以增加一个Schema（逻辑库），指定dataNode ，里面不配置任何表，则这个Schema就是默认不分片的\r\n\t<schema name=\"mydatabase\" checkSQLschema=\"false\" dataNode=\"dn1\"  sqlMaxLimit=\"100\">\r\n         </schema>\r\n\r\nserver.xml里面增加上述Sechema的授权\r\n\r\n<user name=\"test\">\r\n\t\t<property name=\"password\">test</property>\r\n\t\t<property name=\"schemas\">TESTDB,mydatabase</property>\r\n\t</user>\r\n\r\n此时访问 mydatabase就不走分片\r\nmysql -utest -ptest  -h127.0.0.0  -Dmydatabase"}}