networking - Using 2 servers for MySQL -

I have 2 servers for my website

• Web server
  • Many RAM and a fast processor are sending dynamic content with only some GB hard drive space.

    and

    • File server
      • to send static content, pictures, video etc.
      • Not as a TB hard drive location, very RAM and a slow processor.

        I want to use the speed of the web server, but the location of the file server. But I have heard that the overhead of NFS will slow down, it will not make any difference ...

        I am using MySQL and I want to know how to optimize the database so that I File server can be kept on data, but questions generated by web server are processed and processed.

        The advice you got in my experience is correct ... running mysqld on a box and storing the file Is not very fast via an NFS remote server (if the remote storage was a SAN that would be different)

        You can reduce the number of times when your database hits and caching at that level takes advantage of the RAM on the web server.

        If some of your tables are small but are often used, then you can consider running MySQL second instance on your web server for your hosts. Keep in mind, though, you will have two separate points of database failure, which need to be managed (appropriate backup, security update, etc.).