Luis Manson Posted February 12, 2013 Posted February 12, 2013 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 Posted February 14, 2013 Posted February 14, 2013 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 Posted February 14, 2013 Posted February 14, 2013 replicate all tables, the exclusion of just those listed tables will not make much difference in terms of loads !
Luis Manson Posted February 15, 2013 Author Posted February 15, 2013 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
Ohio Riders Posted February 19, 2013 Posted February 19, 2013 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 Posted February 19, 2013 Author Posted February 19, 2013 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 ;)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.