We are experiencing some issues with performance on a non-MySQL box and are
looking for alternatives (and alternative methods). Once of the issues that
we seem to be facing, is that the pure volume of data which needs to be
pushed out. The other database is pushing out (at peak) 12.5 megabytes
Sorry, I do not have much experience with MySQL on Suns (at least not
in pushing it to the limits). On an Athlon 700Mhz selecting 1
random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
localhost and about 5.5MB/sec via a 100MBit TCP connection using the
mysql command line
We are looking at using replication between two MySQL servers. In our
situation, there might be a firewall between the two servers and we will
need to permit the traffic between the two through the firewall.
From what I have read, it sounds like the Slave connects to the Master (in
stead of