On Thu, Jun 12, 2003 at 09:51:06AM +0800, MaFai wrote: > Hello, mysql, > > 2 Mysql 4.0.12 windows version with INNODB replciate > sucessfully,both in myisam and innodb table.
> According to mysql manual(PDF),there is only one master database in > the same time,but with many slave server. Right. > Master for query,and slave for update or insert operation. Right. > Therefore,while programming with JAVA tech,I must write 2 connection > pool? one for query,other for update? If you're using pooling, yes. > That's not very proper.Coze the programe switch the connection > frequently.It really slow down the web application performance. Can you explain how? I know of many people and companies doing this. They've never found the swtiching connections to be an expensive operation. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 8 days, processed 287,018,968 queries (370/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
