Java Heap Size Options
You achieve best performance by individually tuning each of your applications. Configuring the JVM heap size options listed in Table 2-2 increases performance for most applications.
The options listed in Table 2-2 may differ depending on your architecture and operating system. See your vendor’s documentation for platform-specific JVM tuning options.
Table 2-2 Java Heap [...]
Posted on 10月 25th, 2005 作者： Mars
Filed under: 旧的回忆 | No Comments »
2台mysql server：192.168.0.11 (master)192.168.0.12 (slave)
如果要在master-slave之间复制bbs库，首先
在master上创建replication用户(赋予‘复制’权限)：mysql>GRANT REPLICATION SLAVE ON *.*TO ‘repl’@’%’ IDENTIFIED BY ’slavepass’;
mysql>GRANT FILE ON *.* TO ‘repl’@’%’ IDENTIFIED BY ’slavepass’;
锁定只能操作读权限mysql>FLUSH TABLES WITH READ LOCK;
在master上创建bbs库的快照（snapshot）tar -cvf /tmp/bbs.tar ./bbs
在slave上还原快照:tar -xvf /tmp/bbs.tar
mysql> UNLOCK TABLES;
修改slave上/etc/my.cnf[mysqld]master-host=192.168.0.11master-user=replmaster-password=slavepassmaster-port=3306server-id=2master-connect-retry=60replicate-do-db=bbslog-slave-updates
master服务器修改my.cnf文件，一般路径在/etc/my.cnf，添加如下内容:[mysqld]log-binserver-id=1 #分配一个idsql-bin-update-same binlog-do-db=bbs #要同步的库名
mastermysql > SHOW MASTER STATUS;
slavemysql > SHOW SLAVE STATUS;
Posted on 10月 24th, 2005 作者： Mars
Filed under: 旧的回忆 | No Comments »