Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 12, 201312 yr 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%
February 14, 201312 yr 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
February 14, 201312 yr replicate all tables, the exclusion of just those listed tables will not make much difference in terms of loads !
February 15, 201312 yr Author 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-xtrabackuphttp://www.zmanda.com/backup-mysql.htmli 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 mysqldumpreplicate 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 timesorry by the quoting mess, i have bbcode disabled and get this :S
February 19, 201312 yr 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.
February 19, 201312 yr Author 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 ;)
Archived
This topic is now archived and is closed to further replies.