I have a mysql db on serverA. ServerB C D E etc connect to the db on serverA to retrieve data but it is very slow. Is there anyway to cache the data on each individual server? Or somehow share/propagate the mysql db between multiple servers?
jatar_k
6:40 pm on Jul 15, 2005 (gmt 0)
export to local instances of mysql. You could export in a schedule to the other four servers from sevrer A using a shell script doing tar gz of the files and then ssh'ing them over and the other server can untar them to the proper location and restart mysql.
There is also clustering for mysql where A could be set up as the master and the rest could run as slaves. [dev.mysql.com...]
