On Sunday 11 February 2007 2:23 am, Ariz Jacinto wrote: > you should enable the auto-repair feature on the mysql configuration > so that those damaged files will be repaired automatically.
Thanks for the tips, Ariz. Currently, the MySQL setup uses the defaults. I would appreciate what other changes from the default I should make. > replicating the report is one thing while replicating the report generation > process is another. Can you explain further? As I understand replication, all changes to the master are saved to a script as commands, and it is this script which is sent to the slaves. What is this about two types of replication? > and please note, off-shore replicators might even cause a DoS on the > main host especially if the main node is weak and the replicators are > way too much aggressive. there should be some guidelines for those > who wish to mirror the data. We will only have one slave on the network itself. It is this slave, not the master, which will in turn replicated by an off-site slave. All other replications will be done from this off-site slave. This minimizes the load on the master, and on the pipe. Please tell me how to improve this setup. Regards, Obet _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List plug@lists.linux.org.ph (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph