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'.