View Single Post
02-07-2008, 02:20 AM
Join Date: Nov 2007
Yo can do replication in MySQL 5 so no need to spend a fortune on Oracle. It might be a little easier to manage in Oracle though!
Dependant on the application needs, you can setup the slave to read only and have server pull some of the data it needs from it to spread the load. All updates should go thru the master though.
Depending on what other hardware you have you can setup a load balancer port to automatically redirect the traffic to the slave if the master goes down, or some people prefer the switch to be a manual process the operations team controls.
If you're going to have multiple webserver the one thing you have to look out for is how you handle sessions. Most sites I've worked with have what you'd call sticky sessions, when you first visit the website you get routed to one of the server in the farm, all subsequent request go back to that same server, so if you have a site that requires logins, you don't have to worry about sharing sessions between the webserver. The other way to handle this is to move the session information to MySQL or some other kind of shared location.
I haven't read Cal Henderson's book, but I've seen some of his presentations from conferences and he definitely knows what he's talking about :)
View Public Profile
Send a private message to iisbum
Find More Posts by iisbum