How to exclude some tables from RDS Mysql replication

Question

i have a cluster structure on RDS (master/slave)...and all the temporary tables created on the master are replicated on the slave. I don't want that....

I want that statements like:

create temporary table tmp as (select * from tb);

...do not gets replicated.

I would want that NO temporary table were replicated. I realize now that i must user the option "replicate-ignore-table=name" ...

But any one knows how t do that on RDS? I think i have to user the client tool right?

Someone has an example?

Answer 1

Indeed, RDS contains a section call Parameter Groups.

(UPDATE)

For RDS Mysql, there is no such options. Although SHOW SLAVE STATUS\G or SHOW MASTER STATUS\G will show those parameter.

For Mariadb 10, you can select those allowed custom RDS parameter e.g. replicate_ignore_db and create a parameter group, then attach to RDS instance DB Parameter Group.