I have a dedicated server on OVH.
Due to high load I think I need to move my database to a dedicated server.
So I will have 1 dedicated server with Apache and PHP and another 1 with only the database.
I am worrying about the latency of the internal connection between these 2 servers.
When I will buy my second server for the db, should I ask to OVH if i can get one into the same rack of my first server?
Or this doesn't make any differences at all?
My actual server is:
Intel Core2Duo 2x 2.33+ GHz 3 MB L2 - FSB 1066 MHz RAM 4 GB DDR2 2x 750 GB - SATA2
I will need 2x mysql table with at least 5.000.000 records one and 10.000.000 the other