… those problems with UUID’s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store the values as binary… capable of generating random UUID’s with an option to store them in Base64 rather than hex. Since the length of the UUID…, I realized the Base64 encoding was inefficient for a 128-bit number. In order to get maximum efficiency out of Base64, the number…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…in the binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64…MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL…
Comment: Idea: Couple of more string types
April 18, 2008 By 12 Comments
… storage would be binary and to store 128 and 160 bits respectively. What is REALLY needed in MySQL is a mechanism to take binary data and encode it when using the MySQL command line application or… NOT space efficient. Base64+filesafe is the most efficient and portable storage format IMO. We store binary data in MySQL and it’s very…
