- \u5b89\u88c5OpenJDK<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u914d\u7f6eNTP<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u5b89\u88c5VoltDB<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u914d\u7f6eVoltDB<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u521b\u5efa\u6a21\u5f0f<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u521b\u5efa\u548c\u7f16\u8bd1\u8fc7\u7a0b<\/ol>\n<\/li>\n<\/ol>\n
<\/p>\n
- \u542f\u52a8VoltDB<\/ol>\n
\u5efa\u9020\u6b65\u9aa4<\/h1>\n
\u5b89\u88c5OpenJDK<\/h2>\n
\u5b89\u88c5OpenJDK 8\u6216OracleJDK 8\u3002
\n\u672c\u6b21\u5b89\u88c5\u4e86OpenJDK\uff0c\u4f46\u63a8\u8350\u4f7f\u7528OracleJDK\u3002
\n[2018\/10\/4\u66f4\u65b0]
\n\u867d\u7136\u63a8\u8350\u4f7f\u7528OracleJDK\uff0c\u4f46\u4e5f\u652f\u6301OpenJDK\u3002<\/p>\n# yum install java-1.8.0-openjdk-devel\r\n\r\n# java -version\r\nopenjdk version \"1.8.0_191\"\r\nOpenJDK Runtime Environment (build 1.8.0_191-b12)\r\nOpenJDK 64-Bit Server VM (build 25.191-b12, mixed mode)\r\n<\/code><\/pre>\n\u6211\u6b63\u5728\u8a2d\u7f6eJAVA_HOME\u4e26\u5728PATH\u4e2d\u6dfb\u52a0Java\u7684\u8def\u5f91\u3002<\/p>\n
#<\/span> echo<\/span> \"export JAVA_HOME=<\/span>$(<\/span>readlink<\/span> -e<\/span> $(<\/span>which java)<\/span>|sed 's:\/bin\/java::'<\/span>)<\/span>\"<\/span> ><\/span> \/etc\/profile.d\/java.sh\r\n#<\/span> echo<\/span> \"PATH=<\/span>\\$<\/span>PATH:<\/span>\\$<\/span>JAVA_HOME\/bin\"<\/span> >><\/span> \/etc\/profile.d\/java.sh\r\n#<\/span> source<\/span> \/etc\/profile\r\n<\/code><\/pre>\nNTP\u7684\u914d\u7f6e<\/h2>\n
\u5728\u96c6\u7fa4\u914d\u7f6e\u4e2d\uff0c\u7531\u4e8eVoltDB\u670d\u52a1\u5668\u4e4b\u95f4\u7684\u65f6\u95f4\u5dee\u9700\u8981\u4fdd\u6301\u5728100\u6beb\u79d2\u4ee5\u4e0b\uff0c\u56e0\u6b64\u9700\u8981\u4f7f\u7528NTP\u8fdb\u884c\u65f6\u95f4\u540c\u6b65\u3002<\/p>\n
\u5728\u6211\u7684\u73af\u5883\u4e2d\uff0c\u6211\u5c06”volt1\uff1a192.168.10.122″\u8bbe\u5b9a\u4e3aNTP\u670d\u52a1\u5668\uff0c\u5e76\u5c06\u5176\u4ed6\u4e24\u53f0\u8bbe\u5907\u8bbe\u7f6e\u4e3aNTP\u5ba2\u6237\u7aef\u3002<\/p>\n
\u7531\u4e8e\u8fd9\u662f\u6d4b\u8bd5\u73af\u5883\uff0c\u6240\u4ee5\u8bbe\u7f6e\u5f88\u7b80\u7565\u3002<\/p>\n
\u2460\u7b2c\u4e00\u53f0\u7684VoltDB\u670d\u52a1\u5668\uff08NTP\u670d\u52a1\u5668\uff09<\/p>\n
\u7531\u4e8e\u8fd0\u884c\u7684\u662fCentOS 7\uff0c\u56e0\u6b64\u5df2\u7ecf\u5b89\u88c5\u4e86chrony\u3002<\/p>\n
vi \/etc\/chrony.conf\r\n<\/code><\/pre>\n\u5728\u4e0b\u9762\u8fdb\u884c\u8865\u5145\u3002<\/p>\n
# \u4ee5\u4e0b\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3059\u308b\r\n#server 0.centos.pool.ntp.org iburst\r\n#server 1.centos.pool.ntp.org iburst\r\n#server 2.centos.pool.ntp.org iburst\r\n#server 3.centos.pool.ntp.org iburst\r\n\r\n# \u4ee5\u4e0b\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u5916\u3059\r\nallow 192.168.0.0\/16\r\nlocal stratum 10\r\n\r\n<\/code><\/pre>\n\u91cd\u542fchronyd\u3002<\/p>\n
systemctl restart chronyd\r\n<\/code><\/pre>\n\u7b2c\u4e8c\u53f0\u4ee5\u53ca\u4e4b\u540e\u7684VoltDB\u670d\u52a1\u5668\uff08NTP\u5ba2\u6237\u7aef\uff09<\/p>\n
NTP\u5ba2\u6237\u7aef\u5c06\u76f4\u63a5\u4f7f\u7528chrony\u3002<\/p>\n
vi \/etc\/chrony.conf\r\n<\/code><\/pre>\n\u6211\u4f1a\u5728\u4e0b\u9762\u6dfb\u52a0\u8865\u5145\u5185\u5bb9\u3002<\/p>\n
#server 0.centos.pool.ntp.org iburst\r\n#server 1.centos.pool.ntp.org iburst\r\n#server 2.centos.pool.ntp.org iburst\r\n#server 3.centos.pool.ntp.org iburst\r\n#server 192.168.10.121 iburst\r\nserver volt1 iburst minpoll 4 maxpoll 4\r\n\r\npeer volt2 minpoll 4 maxpoll 4\r\npeer volt3 minpoll 4 maxpoll 4\r\n<\/code><\/pre>\n\u91cd\u542fchronyd\u3002<\/p>\n
systemctl restart chronyd\r\n<\/code><\/pre>\n\u786e\u8ba4\u7b2c2\u53f0\u3001\u7b2c3\u53f0\u670d\u52a1\u5668\uff08volt1\u3001volt2\uff09\u662f\u5426\u901a\u8fc7”chronyc sources”\u8fdb\u884c\u4e86\u65f6\u95f4\u540c\u6b65\u3002<\/p>\n
# chronyc sources\r\n210 Number of sources = 3\r\nMS Name\/IP address Stratum Poll Reach LastRx Last sample \r\n===============================================================================\r\n^* volt1 10 4 37 5 -42us[-1569us] +\/- 387us\r\n=? volt2 0 4 0 - +0ns[ +0ns] +\/- 0ns\r\n=? volt3 11 4 1 10 -7673us[-9201us] +\/- 12ms\r\n\r\n\r\n<\/code><\/pre>\n\u9632\u706b\u5899\u7684\u8bbe\u7f6e<\/h2>\n
[2018\u5e7410\u67088\u65e5\u66f4\u65b0]<\/p>\n
VoltDB\u9ed8\u8ba4\u4f7f\u7528\u7684\u7aef\u53e3\u5217\u8868\u5982\u4e0b\u3002<\/p>\n
\u5ba2\u6237\u7aef\u7aef\u53e3\u53f7\uff1a21212
\n\u7ba1\u7406\u5458\u7aef\u53e3\u53f7\uff1a21211
\nWeb\u754c\u9762\u7aef\u53e3\u53f7\uff08httpd\uff09\uff1a8080
\n\u542f\u7528TSL\/SSL\u7684Web\u754c\u9762\u7aef\u53e3\u53f7\uff1a8443
\n\u5185\u90e8\u670d\u52a1\u5668\u7aef\u53e3\u53f7\uff1a3021
\n\u590d\u5236\u7aef\u53e3\u53f7\uff1a5555
\nZookeeper\u7aef\u53e3\u53f7\uff1a7181<\/p>\n\u5728\u8fd9\u4e9b\u4e2d\uff0c\u53ea\u6709\u5728\u4f7f\u7528\u65f6\u9700\u8981\u6253\u5f00\u7aef\u53e3\u7684\u662f\u201cWeb Interface Port\uff08\u542f\u7528TSL\/SSL\uff09\u201d\u548c\u201cReplication Port\u201d\u3002<\/p>\n
firewall-cmd --add-port=21212\/tcp --permanent\r\nfirewall-cmd --add-port=21211\/tcp --permanent\r\nfirewall-cmd --add-port=8080\/tcp --permanent\r\nfirewall-cmd --add-port=3021\/tcp --permanent\r\nfirewall-cmd --add-port=5555\/tcp --permanent\r\nfirewall-cmd --add-port=7181\/tcp --permanent\r\nfirewall-cmd --add-port=123\/udp --permanent\r\nfirewall-cmd --add-port=22\/tcp --permanent\r\nfirewall-cmd --reload\r\n<\/code><\/pre>\n\u203b123 \u662f\u7528\u4e8eNTP \u7684<\/p>\n
\u4f7f\u7528\u4e0b\u5217\u6307\u4ee4\u6765\u786e\u8ba4\u8bbe\u7f6e\u3002<\/p>\n
firewall-cmd --list-ports --zone=public\r\n21212\/tcp 21211\/tcp 8080\/tcp 3021\/tcp 5555\/tcp 7181\/tcp 22\/tcp\r\n<\/code><\/pre>\nSSH\u7684\u914d\u7f6e\u3002<\/h2>\n
\u9700\u8981\u5728\u6ca1\u6709\u5bc6\u7801\u7684\u60c5\u51b5\u4e0b\u4f7f\u7528SSH\u767b\u5f55\u5f7c\u6b64\u7684\u670d\u52a1\u5668\u3002\u4e4b\u540e\u5c06\u4f1a\u5199\u4e0b\u6b65\u9aa4\u3002<\/p>\n
\u5b89\u88c5VoltDB<\/h2>\n
\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u5b98\u65b9\u7f51\u7ad9\u4e0b\u8f7dVoltDB\u6a21\u5757\u7684\u201cCOMMUNITY EDITION\u201d\u3002\u5c3d\u7ba1\u67d0\u4e9b\u529f\u80fd\u53ef\u80fd\u4e0d\u53ef\u7528\uff0c\u4f46\u6211\u8ba4\u4e3a\u5b83\u5df2\u7ecf\u8986\u76d6\u4e86\u8db3\u591f\u7684\u529f\u80fd\uff0c\u53ef\u4ee5\u5728\u751f\u4ea7\u73af\u5883\u4e2d\u4f7f\u7528\u3002<\/p>\n
\u5982\u679c\u8981\u4f7f\u7528\u65e7\u7248\u672c\uff0c\u8bf7\u901a\u8fc7\u6587\u4ef6\u6307\u5b9a\u8fdb\u884c\u4e0b\u8f7d\uff0c\u56e0\u4e3a\u4e0a\u8ff0URL\u5c06\u59cb\u7ec8\u4e0b\u8f7d\u6700\u65b0\u7248\u672c\u3002<\/p>\n
![\"image.png\"](\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d90cb913a08637a6dd3e1\/64-0.png\" "\\"\\"")
<\/div>\n\u9996\u5148\uff0c\u5c06voltdb-community-8.3.1.tar.gz\u6587\u4ef6\u89e3\u538b\u5230\/opt\u76ee\u5f55\u4e0b\uff0c\u5e76\u521b\u5efa\u7b26\u53f7\u94fe\u63a5\u3002<\/p>\n
# tar xvzf voltdb-community-8.3.1.tar.gz -C \/opt\/\r\n# ln -s \/opt\/voltdb-community-8.3.1\/ \/opt\/voltdb\r\n<\/code><\/pre>\n\u5728VoltDB\u4e2d\uff0c\u9700\u8981\u7981\u7528\u900f\u660e\u5927\u9875\uff08Transparent HugePages\uff09\u3002\u5982\u679c\u4e0d\u6267\u884c\u6b64\u64cd\u4f5c\uff0cVoltDB\u5c06\u65e0\u6cd5\u542f\u52a8\u3002\u8fd9\u610f\u5473\u7740\u6bcf\u6b21\u64cd\u4f5c\u7cfb\u7edf\u542f\u52a8\u540e\u90fd\u5fc5\u987b\u6267\u884c\u6b64\u64cd\u4f5c\u3002<\/p>\n
# echo never > \/sys\/kernel\/mm\/transparent_hugepage\/enabled\r\n# echo never > \/sys\/kernel\/mm\/transparent_hugepage\/defrag\r\n<\/code><\/pre>\n\u8981\u5728\u64cd\u4f5c\u7cfb\u7edf\u542f\u52a8\u65f6\u81ea\u52a8\u6267\u884c\uff0c\u9700\u8981\u7f16\u8f91rc.local\u6587\u4ef6\u3002[2018\/10\/7\u66f4\u65b0]
\n\u5728\/etc\/rc.local\u6587\u4ef6\u4e2d\u8ffd\u52a0\u4ee5\u4e0b\u5185\u5bb9\u3002\uff08\u9002\u7528\u4e8eCentOS 7.4\uff09<\/p>\nif test -f \/sys\/kernel\/mm\/transparent_hugepage\/enabled; then\r\n echo never > \/sys\/kernel\/mm\/transparent_hugepage\/enabled\r\nfi\r\nif test -f \/sys\/kernel\/mm\/transparent_hugepage\/defrag; then\r\n echo never > \/sys\/kernel\/mm\/transparent_hugepage\/defrag\r\nfi\r\n<\/code><\/pre>\n\u53e6\u5916\uff0c\u8bf7\u4e3arc.local\u6587\u4ef6\u8d4b\u4e88\u6267\u884c\u6743\u9650\u3002<\/p>\n
# chmod u+x \/etc\/rc.d\/rc.local\r\n<\/code><\/pre>\n\u6700\u540e\u91cd\u542f\u64cd\u4f5c\u7cfb\u7edf\uff0c\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u4ee5\u786e\u4fdd\u4e24\u8005\u90fd\u8bbe\u4e3a”never”\u3002<\/p>\n
# cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled\r\nalways madvise [never]\r\n# cat \/sys\/kernel\/mm\/transparent_hugepage\/defrag\r\nalways madvise [never]\r\n<\/code><\/pre>\n\u5c06\u672c\u6b21\u4f7f\u7528\u7684\u4e09\u53f0\u670d\u52a1\u5668\u653e\u5165hosts\u4e2d\u3002<\/p>\n
vi \/etc\/hosts\r\n<\/code><\/pre>\n\u5c06\u8981\u6dfb\u52a0\u5230\u300c\/etc\/hosts\u300d\u7684\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n
192.168.10.121 volt1\r\n192.168.10.122 volt2\r\n192.168.10.123 volt3\r\n\r\n<\/code><\/pre>\n\u63a5\u4e0b\u6765\uff0c\u5c06”\/opt\/voltdb\/bin”\u6dfb\u52a0\u5230\u8def\u5f84\u4e2d\u3002<\/p>\n
vi \/etc\/profile.d\/voltdb.sh\r\n<\/code><\/pre>\n\u8ffd\u52a0\u7684\u5185\u5bb9\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
export PATH=\"$PATH:\/opt\/voltdb\/bin\"\r\n<\/code><\/pre>\n\u4e3a\u4e86\u7acb\u5373\u751f\u6548\uff0c\u8bf7\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u3002<\/p>\n
source \/etc\/profile\r\n<\/code><\/pre>\n\u5185\u5b58\u7ba1\u7406\u76f8\u5173\u8bbe\u7f6e<\/h2>\n
- 2.3. Configure Memory Management<\/ul>\n
# vi \/etc\/sysctl.conf\r\n\r\nvm.swappiness=0\r\nvm.overcommit_memory=1\r\nvm.max_map_count=1048576\r\n\r\n# sysctl -p\r\nvm.swappiness = 0\r\nvm.overcommit_memory = 1\r\nvm.max_map_count = 1048576\r\n<\/code><\/pre>\nTCP\u5206\u6bb5\u529f\u80fd\u5173\u95ed<\/h2>\n
$ vi \/etc\/rc.d\/rc.local\r\n\r\nethtool -K enp0s8 tso off\r\nethtool -K enp0s8 gro off\r\n\r\n\u78ba\u8a8d\r\n$ ethtool --show-features eth0\r\n<\/code><\/pre>\n\u203benp0s8\u5728\u4e0d\u540c\u7684\u73af\u5883\u4e0b\u4f1a\u6709\u6240\u4e0d\u540c\u3002<\/p>\n
\u7981\u7528JVM\u7684\u7edf\u8ba1\u6570\u636e\u6536\u96c6<\/h2>\n
\u7981\u7528JVM\u7684\u7edf\u8ba1\u6536\u96c6\u3002<\/p>\n
# vi \/etc\/profile.d\/voltdb.sh\r\nexport VOLTDB_OPTS='-XX:+PerfDisableSharedMem'\r\n<\/code><\/pre>\nVoltDB\u7684\u914d\u7f6e<\/h2>\n
\u65b0\u5efa\u4e00\u4e2a\u914d\u7f6e\u6587\u4ef6\uff0c\u5176\u4e2d\u5305\u542b\u4e86VoltDB\u7684\u96c6\u7fa4\u914d\u7f6e\u7b49\u8bbe\u7f6e\u3002\u521b\u5efa\u540d\u4e3a”\/opt\/voltdb\/deployment.xml”\u7684\u6587\u4ef6\uff0c\u5185\u5bb9\u5982\u4e0b\u3002<\/p>\n
“kfactor=”1″” \u662f\u5907\u4efd\u6570\u91cf\u3002\u8bbe\u7f6e\u4e3a”1″\u65f6\uff0c\u6bcf\u4e2a\u6570\u636e\u90fd\u4f1a\u521b\u5efa\u4e00\u4e2a\u5907\u4efd\uff0c\u5373\u4f7f\u6709\u4e00\u53f0\u670d\u52a1\u5668\u5b95\u673a\u4e5f\u80fd\u4fdd\u6301\u96c6\u7fa4\u8fd0\u884c\u3002\u5982\u679c\u6709\u4e24\u53f0\u670d\u52a1\u5668\u5b95\u673a\uff0c\u96c6\u7fa4\u5c06\u4f1a\u505c\u6b62\u8fd0\u884c\u3002
\n\u5f53\u96c6\u7fa4\u505c\u6b62\u8fd0\u884c\u65f6\uff0c\u9700\u8981\u4ece\u9884\u5148\u521b\u5efa\u7684\u5feb\u7167\u6587\u4ef6\u4e2d\u6062\u590d\u3002
\n\u6b64\u6b21\u6211\u4eec\u5c06\u5feb\u7167\u8bbe\u7f6e\u4e3a””\uff0c\u5373\u5173\u95ed\u5feb\u7167\u529f\u80fd\u3002<\/p>\n<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><\/span>\r\n<deployment><\/span>\r\n <cluster<\/span> sitesperhost=<\/span>\"8\"<\/span> kfactor=<\/span>\"1\"<\/span> schema=<\/span>\"ddl\"<\/span>\/><\/span>\r\n <paths><\/span>\r\n <!-- <voltdbroot path=\"\/opt\/voltdb\/voltdbroot\"\/> --><\/span>\r\n <snapshots<\/span> path=<\/span>\"snapshots\"<\/span>\/><\/span>\r\n <exportoverflow<\/span> path=<\/span>\"export_overflow\"<\/span>\/><\/span>\r\n <droverflow<\/span> path=<\/span>\"dr_overflow\"<\/span>\/><\/span>\r\n <commandlog<\/span> path=<\/span>\"command_log\"<\/span>\/><\/span>\r\n <commandlogsnapshot<\/span> path=<\/span>\"command_log_snapshot\"<\/span>\/><\/span>\r\n <largequeryswap<\/span> path=<\/span>\"large_query_swap\"<\/span>\/><\/span>\r\n <\/paths><\/span>\r\n <partition-detection\/><\/span>\r\n <heartbeat\/><\/span>\r\n <ssl\/><\/span>\r\n <httpd<\/span> enabled=<\/span>\"true\"<\/span>><\/span>\r\n <jsonapi<\/span> enabled=<\/span>\"true\"<\/span>\/><\/span>\r\n <\/httpd><\/span>\r\n <snapshot<\/span> enabled=<\/span>\"false\"<\/span>\/><\/span>\r\n <commandlog<\/span> enabled=<\/span>\"false\"<\/span>><\/span>\r\n <frequency\/><\/span>\r\n <\/commandlog><\/span>\r\n <systemsettings><\/span>\r\n <temptables\/><\/span>\r\n <snapshot\/><\/span>\r\n <elastic\/><\/span>\r\n <query\/><\/span>\r\n <procedure\/><\/span>\r\n <resourcemonitor><\/span>\r\n <memorylimit\/><\/span>\r\n <\/resourcemonitor><\/span>\r\n <\/systemsettings><\/span>\r\n <security\/><\/span>\r\n<\/deployment><\/span>\r\n<\/code><\/pre>\n\u521b\u5efa\u6a21\u5f0f<\/h2>\n
\u5728\u300c\/opt\/voltdb\u300d\u4e0b\u521b\u5efaschema.sql\u6587\u4ef6\u3002
\nVoltDB4.9\u7684DDL\u8bed\u6cd5\u6709\u4e9b\u53d8\u5316\u3002
\n\u8868\u683c\u548c\u5b58\u50a8\u8fc7\u7a0b\u4e5f\u53ef\u4ee5\u5728\u5b89\u88c5\u540e\u521b\u5efa\uff0c\u6240\u4ee5\u4e0d\u4e00\u5b9a\u9700\u8981\u5728\u5b89\u88c5\u524d\u8fdb\u884c\u51c6\u5907\u3002<\/p>\n\u6211\u4eec\u6b63\u5728\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aTEST_DATA\u7684\u8868\uff0c\u5e76\u4e14\u521b\u5efa\u4e86\u4e24\u4e2a\u540d\u4e3aGetData\u548cInsertData\u7684\u5b58\u50a8\u8fc7\u7a0b\u3002<\/p>\n
CREATE<\/span> TABLE<\/span> TEST_DATA<\/span> (<\/span>\r\n NAME<\/span> varchar<\/span>(<\/span>50<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n DATA<\/span> smallint<\/span>,<\/span>\r\n UNIQUE<\/span> (<\/span>NAME<\/span>),<\/span>\r\n PRIMARY<\/span> KEY<\/span> (<\/span>NAME<\/span>)<\/span>\r\n);<\/span>\r\nPARTITION<\/span> TABLE<\/span> TEST_DATA<\/span> ON<\/span> COLUMN<\/span> NAME<\/span>;<\/span>\r\n\r\nCREATE<\/span> PROCEDURE<\/span>\r\n PARTITION<\/span> ON<\/span> TABLE<\/span> TEST_DATA<\/span> COLUMN<\/span> NAME<\/span>\r\n FROM<\/span> CLASS<\/span> test<\/span>.<\/span>GetData<\/span>;<\/span>\r\n\r\nCREATE<\/span> PROCEDURE<\/span>\r\n PARTITION<\/span> ON<\/span> TABLE<\/span> TEST_DATA<\/span> COLUMN<\/span> NAME<\/span>\r\n FROM<\/span> CLASS<\/span> test<\/span>.<\/span>InsertData<\/span>;<\/span>\r\n<\/code><\/pre>\n\u521b\u5efa\u548c\u7f16\u8bd1\u7a0b\u5e8f<\/h2>\n
\u4ee5\u4e0b\u662f\u4e00\u4e2a\u7528\u4e8e\u641c\u7d22TEST_DATA\u5e76\u63d2\u5165GetData\u548cInsertData\u7684\u793a\u4f8b\u7a0b\u5e8f\uff08\u8fc7\u7a0b\uff09\u3002<\/p>\n
\u8fd9\u6b21\u6211\u4eec\u6b63\u5728\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\uff0c\u4f46\u5b9e\u9645\u4e0a\uff0c\u5728VoltDB\u4e2d\u5df2\u7ecf\u6709\u9ed8\u8ba4\u7684\u5b58\u50a8\u8fc7\u7a0b\uff0c\u53ef\u4ee5\u8fdb\u884c\u63d2\u5165\/\u66f4\u65b0\/\u5220\u9664\/\u9009\u62e9\u64cd\u4f5c\u3002\u53ea\u6709\u5728\u9700\u8981\u5b9e\u73b0\u9ed8\u8ba4\u65e0\u6cd5\u5b9e\u73b0\u7684\u5b58\u50a8\u8fc7\u7a0b\u65f6\uff0c\u624d\u9700\u8981\u521b\u5efa\u81ea\u5b9a\u4e49\u5b58\u50a8\u8fc7\u7a0b\u3002<\/p>\n
package<\/span> test<\/span>;<\/span>\r\n\r\nimport<\/span> org.voltdb.SQLStmt<\/span>;<\/span>\r\nimport<\/span> org.voltdb.VoltProcedure<\/span>;<\/span>\r\nimport<\/span> org.voltdb.VoltTable<\/span>;<\/span>\r\n\r\npublic<\/span> class<\/span> GetData<\/span> extends<\/span> VoltProcedure<\/span> {<\/span>\r\n\r\n public<\/span> final<\/span> SQLStmt<\/span> selectData<\/span> =<\/span> new<\/span> SQLStmt<\/span>
<\/p>\n
- \n
- \n
<\/p>\n
- \n
- \n
<\/p>\n
- \n
- \n
<\/p>\n
- \n
- \n
<\/p>\n
- \n