Nick Reinking wrote:
I'm not sure how running two copies of MySQL on a machine is going to be faster than running one. Plus, I don't think MySQL can even work in this configuration.
I am not saying running two copies per se will be faster. Just that running a copy from a database file in ramdisk will be much faster. One instance of Mysql whose data file is on the mechanical disk, one instance being a replication slave whose data is on the ram disk. Data served from the ram disk, not the hard disk.
I am almost certain multiple instances of MySQL will co-exist on the same machine. If not directly, then through a chrooted environment. Sockets can span chrooted environments using 'mount --bind'.