Hi,
I have this 3-tier architecture in mind:
1. Persistence: Hibernate with MySQL
2. Business: Spring 2.5
3. Presentation: Wicket
I want my application to have high availability and scalability, so I
want to cluster it with load-balancing, fail-over and synchronization.
I wonder if you know of
Can mysql really load balance like that? How does it work with
transactions and so on?
Normally you scale the webservers and have 1 big database server thats
serves all of them.
For wicket you just need tomcat with sticky sessions. Then you only
have to take care of the hibernate caching on each
Can mysql really load balance like that? How does it work with transactions
and so on?
I think so, but I don't know much about it as I haven't read the white
paper yet. Here is a link:
http://www.mysql.com/products/database/cluster/
Normally you scale the webservers and have 1 big database