mycat安装需要的常用命令

mycat安装需要的常用命令

数据库：

mysqladmin -u root password "root"
防火墙：
service iptables status
chkconfig iptables off


jdk安装的环境配置：
export JAVA_HOME=/usr/java/jdk1.7.0_79
export JRE_HOME=$JAVA_HOME/jre
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=./:$JAVA_HOME/lib:$JAVA_HOME/jre/lib


/usr/local/java/jdk1.7.0_79


export JAVA_HOME=/usr/local/java/jdk1.7.0_79
export JRE_HOME=$JAVA_HOME/jre
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=./:$JAVA_HOME/lib:$JAVA_HOME/jre/lib



权限赋值：
chmod +x mycat

chmod +x mycat



系统文件生效：
source /etc/profile


mycat console
/usr/local/mycat/bin








mycat start




wrapper.java.command=/usr/local/jdk/bin/java


wrapper.java.command=/usr/local/java/jdk1.7.0_79/bin/java




CREATE database db1;
CREATE database db2;
CREATE database db3;


mycat start


mysql -utest -ptest -h127.0.0.1 -P8066 -DTESTDB
mysql -utest -ptest -h127.0.0.1 -P8066 -DTESTDB


CREATE database db1;
CREATE database db2;
CREATE database db3;


mysql: Invalid DataSource:0
mycat install


create database db1;






192.168.157.131


mycat install






lower_case_table_names = 1




show database
















mysql-server


mysql-devel






mysqladmin -u root password 123456










































/usr/local/jdk1.7.0_79/bin








export JAVA_HOME=/usr/local/jdk1.7.0_79
export JAVA_BIN=$JAVA_HOME/bin
export JAVA_LIB=$JAVA_HOME/lib
export CLASSPATH=.:$JAVA_LIB/tools.jar:$JAVA_LIB/dt.jar
export PATH=$JAVA_BIN:$PATH






source /etc/profile

解压：
 tar -xvzf jdk-7u79-linux-i586.gz




/usr/local/mycat/bin






mycat install












mysql -utest -ptest -h127.0.0.1 -P8066 -DTESTDB
mysql -utest -ptest -h127.0.0.1 -P8066 -DTESTDB


CREATE database db1;
CREATE database db2;
CREATE database db3;




create table employee (id int not null primary key,name varchar(100),sharding_id int not null);




chmod 777 /usr/local/mycat/

相关文章：

http://bbs.csdn.net/topics/390991946  跟java相关

http://blog.sina.com.cn/s/blog_638b7ebb0102vv80.html