MySQL Performance: MySQL => need help with server architecture

need help with server architecture [message #1657]

Tue, 21 August 2007 07:43

edsuit
Messages: 14
Registered: April 2007
Location: The Netherlands

Junior Member

I'm looking for the best way to use MySQL on our servers.

We've got three servers: two external webservers (servers A and B) on two different locations, and one local server (server C), which is configured as a backup webserver. Here are the specs:

Server A
Intel Xeon 2.8 GHz processor
2 GB RAM
Windows 2003
IIS 6.0
MySQL 5.0.37
ASP 3.0

Server B
Intel Pentium 4 2.4 Ghz processor
1 GB RAM
Windows 2003
IIS 6.0
MySQL 5.0.37
ASP 3.0

Server C
Intel Pentium III 733
256 MB RAM
Windows 2003
IIS 6.0
MySQL 5.0.37
ASP 3.0

Server A runs MySQL with one database, for one website, our 'main' website.
Server B runs MySQL with several databases, for several, smaller, websites. Even when put together they still have a lighter load than the main website on its own.
Server C does not run MySQL yet.

I would like to run live replications of both of the MySQL servers (A and B).
Besides that I also want to run a separate MySQL server, with copies of all the databases, which I can use
for testing purposes.

Now I'm not really sure what would be the best way to set this up. My initial idea was to make server B a dedicated webserver and server A a dedicated MySQL server, and then make C the testing server, but my company doesn't want that.
What I'm thinking of now is to run three MySQL instances on server C: a server A replication, a server B replication and a testing server. But that doesn't sound all that great to me..

Does anyone have any better ideas?

[Updated on: Wed, 22 August 2007 04:17]

Report message to a moderator