OK, I am sort of new to clusters and load balancing, but something I am definitely interested in.
Some one PLEASE help me understand this load balancing and clustering thing.
Lets say I have two dedicated servers, say, Server A and Server B, lets say I installed Interworx 2.1 on both.
Let say I have a site mysite.com and that site uses a php script with database for the, say ecommerce package installed.
OK, its my understanding that a install of mysite.com will need to be installed on Server A and Server B, complete with mysql database.
When someone comes to mysite.com and lets say they purchase a blue widget, and that sell is put into the mysql database on server A.
NOW, lets say Server A goes down, crashed, for what ever reason. But Server B will pick up the slack of Server A so my web site mysite.com will not go down. Now lets say the customer that purchased a blue widget came back to mysite.com right after the Server A crash and wanted to make a change to his order, aka, making a change to the mysql database.
Question is, will the mysql database on Server B be up to date with Server A up until the crash?
If I understand the load balance correctly all my files for my web site mysite.com and the associated mysql database’s are kept in “synch” by InterWorx?
And lets say when the Server A comes back up the most up to date mysql database will be on Server B, will Interworx some how “resynch” the two databases?
Thanks for helping me understand what the Interwork “load balancing” will actually do and what I can expect from it.