MySQL replication - ignoring tables

[Luis Manson]

Hello, i had setup replication again, this time i had chosen to ignore some tables, but im not 100% sure if its ok to ignore them or i should add others. I do this to reduce some load on the slave and have a smaller backup.

replicate-wild-ignore-table=MyIPBdb.gacontent_cache_posts%
replicate-wild-ignore-table=MyIPBdb.gasearch_keywords%
replicate-wild-ignore-table=MyIPBdb.gasearch_visitors%
replicate-wild-ignore-table=MyIPBdb.gasessions%

[Ohio Riders]

Personally, I replicate and backup all tables. Instead of trying to shrink the backup size, maybe look at better backup solutions? For instance, I'm guessing you're using mysqldump? Here are some other (possibly better) backup solutions for you:

http://www.percona.com/software/percona-xtrabackup

http://www.zmanda.com/backup-mysql.html

[p4guru]

replicate all tables, the exclusion of just those listed tables will not make much difference in terms of loads !

[Luis Manson]

Personally, I replicate and backup all tables. Instead of trying to shrink the backup size, maybe look at better backup solutions? For instance, I'm guessing you're using mysqldump? Here are some other (possibly better) backup solutions for you:

http://www.percona.com/software/percona-xtrabackup
http://www.zmanda.com/backup-mysql.html

i want something very compressible, i do have xtrabackup, which is also used by zmanda AFAIK, the problem is i was not able to be sure if with xtrabackup i can backup only the board database, and its not very portable if you are not the root on the SQL server. My setup involves a slave which is stopped while i lock all tables and do a mysqldump

replicate all tables, the exclusion of just those listed tables will not make much difference in terms of loads !

My problem is not load but backup size, transfer and restore time

sorry by the quoting mess, i have bbcode disabled and get this :S

[Ohio Riders]

sorry by the quoting mess, i have bbcode disabled and get this :S

Which is why you want a better backup solution that allows incremental backups. You backups are large because you're backing up everything every time. Not much help for restore time though.

[Luis Manson]

incremental is good if you have a good full, and since i dont want to loose all my forum nor test daily if the backup is good i prefer a daily full ;) with no uneeded data ;)