One of the key application table has a column adid (Varchar(50)) as unique key, which has following format (uuid+ a character string). This column is used for heavy batch updaes (millions of updates, 100 updates are done with one commit). This causes slave and it is also a scalability concern for future.
0000015c-aae9-46f0-ac23-f3d188ca1686-0-us_gse
00000161-cefd-4c56-bd99-d3ba716d6acf-0-cts_gsb
Table has auto-increment primary key.
Is there more efficient way to store this data? For uuid it is recommended to convert into binary(16) ? What can we do here ? Can this string be also be converted into binary? Or any other design idea?