lizongbo 的 編程學習

     摘要: 新注冊了個獨立域名，使用獨立的blog了。

http://618119.com

新的blog rss訂閱地址： http://feed.feedsky.com/lizongbo

從最早的 http://blog.csdn.net/lizongbo,

到 http://blog.donews.com/lizongbo

再到http://m.tkk7.com/lizongbo

現在終于擁有自己的域名和獨立的blog了。  閱讀全文

mysql 雙機熱備配置

1.下載mysql-noinstall-5.0.45-win32.zip
2.解壓到E:\mysql,然后將文件夾E:\mysql\mysql-noinstall-5.0.45-win32改為E:\mysql\master
3.再解壓到E:\mysql,然后將文件夾E:\mysql\mysql-noinstall-5.0.45-win32改為E:\mysql\slave
4.復制E:\mysql\master\my-small.ini為E:\mysql\master\my.ini
編輯內容:,增加log-bin和binlog-do-db參數
示例如下:
#skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

log-bin=mysql-bin
binlog-do-db = testdb1 #需同步數據庫  testdb1
binlog-do-db = testdb2 #需同步數據庫  testdb2

5.復制E:\mysql\slave\my-small.ini為E:\mysql\slave\my.ini
編輯內容:,修改端口,
port  = 3310

示例如下:

[client]
#password = your_password
port  = 3310
socket  = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port  = 3310
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

#skip-networking
server-id = 2

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

master-host=127.0.0.1
master-user=root
master-password=
master-port=3306
replicate-do-db=testdb1
replicate-do-db=testdb2

6.保存 E:\mysql\master\my.ini.和E:\mysql\slave\my.ini

7.在命令行下運行E:\mysql\master\bin\mysqld.exe,

Microsoft Windows XP [版本 5.1.2600]
(C) 版權所有 1985-2001 Microsoft Corp.

E:\mysql\master\bin>mysqld

8.再新開命令行,運行E:\mysql\slave\bin\mysqld.exe

Microsoft Windows XP [版本 5.1.2600]
(C) 版權所有 1985-2001 Microsoft Corp.

E:\mysql\slave\bin>mysqld
071013 21:41:06 [Warning] The syntax for replication startup options is deprecat
ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.

9.用mysql 客戶端 HeidiSQL連接到 127.0.0.1的3306,創建數據庫testdb1和testdb2,
并在數據庫中新建表,然后插入一些數據.

10.客戶端連接 到 127.0.0.1的3310,可以看見數據庫testdb1和testdb2,且數據庫中的數據與master的數據庫數據一致.

11.t查看 E:\mysql\master\data\mysql-bin.000001 和E:\mysql\master\data\mysql-bin.index,可以看到被記錄的sql操作,

 

4.4.6  Tomcat HTTPS配置
在server.xml里配置：
tomcat普通的https配置
    <Connector port="8443"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" disableUploadTimeout="true"
               acceptCount="100" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS"
           keystoreFile="conf/.keystore"
           keystorePass="lizongbo">
    </Connector>

Tomcat使用apr之后的ssl雙向認證配置如下:

   <Connector port="8443" maxHttpHeaderSize="8192" protocol="HTTP/1.1"
              maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
              enableLookups="false" disableUploadTimeout="true"
              acceptCount="100" scheme="https" secure="true"
              clientAuth="true" <!--雙向驗證-->
              SSLEngine="on" bufferSize="8192"
              SSLEnabled="true"
              SSLProtocol="all"
              SSLCipherSuite="ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL"
              SSLCertificateFile="..\conf\ca\www.crt"
              SSLCertificateKeyFile="..\conf\ca\www.key"
              SSLCACertificateFile="..\conf\ca\ca.crt"
              SSLCACertificatePath="..\conf\ca"
              SSLVerifyDepth="15"
              SSLVerifyClient="require"
               />

 

4.6.6  Squid HTTPS
squid.conf中加上：
https_port 3443 cert=D:/ca/www.crt key=D:/ca/www.key

4.7.6  LightTPD HTTPS
首先使用copy命令把 key和crt合并為一個文件，
D:\ca>copy /b www.key+www.crt www.pem

然后配置如下：
$SERVER["socket"] == ":443" {
ssl.engine = "enable"
ssl.pemfile = "D:/ca/www.pem"
ssl.ca-file = "D:/ca/ca.crt"
server.name = "www"
server.document-root = "D:/httpsdosc"
server.errorlog = "httpserror.log"
accesslog.filename = "httpsaccess.log"
}
(下面的雙向驗證沒有測試是否可用)
如需啟用雙向驗證，則還需下面的配置參數：
ssl.verify-peer = "enable"
ssl.verify-depth  = 1
參考：http://trac.lighttpd.net/trac/ticket/921