Portal Home > Knowledgebase > Articles Database > MySQL Question
MySQL Question
| Posted by SixtyTech, 08-17-2008, 10:36 PM |
| Hello,
I currently have my apache & mysql load seperated over two servers. They are connected NIC to NIC for the mysql connection from PHP etc.
I am coming to a point where I need another MySQL server. I was wondering if it would be fine to have the new mysql server in the same datacenter, though not with a direct local connection. Is it fine to connect to it if it's a few racks away? For speed this is.
From what I can tell, a ping from NIC to NIC is around 0.05MS, where over the network it's around 1-2MS. Will this cause a slow down? Or is it perfectly normal to use a DB server on the other side of the DC?
Thanks.
|
| Posted by Steven, 08-17-2008, 10:38 PM |
| You shouldn't be seeing that kind of latency in the same datacenter. Generally in the same datacenter regardless if its local or on the net I see under 1ms.
|
| Posted by SixtyTech, 08-17-2008, 10:42 PM |
| Hmm well I am. Pinging a "net" IP returns 1-2MS. Usually closer to 1MS.
|
| Posted by datums, 08-17-2008, 10:46 PM |
| If you expect to do replication you need to move your mysql server to the switch level. I would keep them in the same datacenter. If scaling your reads is what you're trying to accomplish. Set up another DC for disaster recovery.
|
| Posted by Panopta, 08-18-2008, 09:46 AM |
| A 1ms latency within the datacenter is possible, depending on how the network is layed out. You might try a traceroute to the other server to see how many hops your going through, and then talk to your hosting provider. They might be able to relocate your other server so it uses the same switch, which should improve your latency as well as the available bandwidth between the servers. If you grow further, looking into your own VLAN or physical switch might make sense as well.
|
Add to Favourites 
Print this Article
Also Read
Datahosts.com (Views: 815)