I've read about not being able to use Statement-base replication when using uuid_short() function to produce unique ids for the primary key column. My question is whether I can use replication with Amazon RDS when I use uuid_short() function on my table as primary key?
Update:
I've found and answer here on Amazon documentation.
Amazon RDS replication is set to mixed-format, which includes both row-based and statement-based replication. However, it's possible to change that by using session basis SQL command to set the binlog_format for a DB instance to "row".
So if you decide to use UUID_SHORT() in your table, it's possible to use replication with Amazon RDS.
You can read how to do this on the replication formats page on mysql.com.
Update:
I've found and answer here on Amazon documentation.
Amazon RDS replication is set to mixed-format, which includes both row-based and statement-based replication. However, it's possible to change that by using session basis SQL command to set the binlog_format for a DB instance to "row".
So if you decide to use UUID_SHORT() in your table, it's possible to use replication with Amazon RDS.
You can read how to do this on the replication formats page on mysql.com.
No comments:
Post a Comment