I am attempting my first large scale database project on my own. I have a myisam mysql db on server 1 with a php app consuming large amount of various data. I have mysql myisam on server 2 with php app selecting and displaying data.

I want to replicate this data on server 2.

Questions:

  1. Should I change server 1 mysql db to innodb
  2. Can you replicate server1 innodb to server2 myisam
  3. I'm storing media as blobs with intention of using cache to offload stress on live server. Should I use filesystem storage and rsync.
  4. Any general advice from other experienced people ?
php mysql replication innodb myisam
Edit
Report