[polska03]

Hello I am running a website which consists of html,css,php, and mysql right now from a laptop. It is running apache and mysql services on it. I know have a problem because the traffic being generated on this site is slowly getting to large for my laptop to handle. I have another computer I would like to hook up to help my laptop. This computer can be set up in my house or in another house with another line. I do not want one server to run the webpage html and php and the other to be a mysql server because the site's work is 95% interacting with the the mysql server so I would prefer to load balance this somehow. I was wondering how you do this and what people's opinion's are on the most efficient way of doing this.

Cheers

o and ps. there are no images or media it is just text being stored in the mysql database.

This post has been edited by polska03: 19 January 2012 - 01:48 AM

[Macjohn]

there are to many variables. LoOl

Let's see.

-Your laptop, is it dedicated to the website or do you work on it?
-Your other computer,is it a good computer or just a random one from 1995?..if it is "new" do you tend on working on it?
-Internet speed?

See what I mean?

There're a lot of solutions to your problem...if you answer those questions I can probably point you in the right direction.

This post has been edited by Macjohn: 19 January 2012 - 02:42 AM

[Macjohn]

So...

1st option- if you use your laptop while using it as a server then stop using your laptop

2nd option- if you cant do that then migrate your website to the spare computer!and don't use it to work!

3rd option- host your website somewhere else, like amazon or something like that.(problem: it costs money)

4th option- Manage traffic by using the 2 computers. ( for that you'll need some engineering)

[polska03]

Hey thanks for the reply. I believe option 4 is the way I would like to go. The laptop which is a few years old is completely dedicated to the website and is running ubuntu. The desktop is another dual core computer also running ubuntu and would also be dedicated to the website. I am running 7mbit internet speed out but I do also have another location where I can put the other server which is also running 7mbit internet speed. As of right now the laptop is doing alright just during some peak hours it is slowing down and I want to prevent as much slowdown as possible. I realize hosting somewhere for very little money is probably the best choice, but I prefer to have access to the servers in-case something goes wrong. There is not a ton of users that connect about 200, but not all of them connect at the same time.

[Atli]

polska03, on 19 January 2012 - 08:47 AM, said:

I do not want one server to run the webpage html and php and the other to be a mysql server because the site's work is 95% interacting with the the mysql server so I would prefer to load balance this somehow.

Do you have any specific reason to believe your local network would not be able to keep up with the database requests, if it was placed on a separate local computer?

It seems a much more straight forward solution to identify which of the two servers (HTTP or Database) requires more power, and then split that one over to the new PC, placing them both on the same network.

If you set up two computers, each with their own database server, and attempt to use load-balancing to distribute the connections between them, two things spring to mind. First, load balancing typically involves at least three machines: one being the load-balance server itself, and the other two the actual servers. (Although I suppose it wouldn't be hard to do it with just two machines.) The second is that, if you have two database servers, you'll have to sync the data between them. That seems a little excessive for this situation.