MySQL FAQs

How to use the Delphix Continuous Data Engine key pair?

Perform the following steps to use the Delphix Continuous Data Engine key pair:

1. Select Public Key for the Login Type.

2. Click View Public Key.

3. Copy the public key that is displayed, and append it to the end of your ~/.ssh/authorized_keys file. If this file does not exist, you must create it. 

   1. Run chmod 600 ~/.ssh/authorized_keys to allow only the file's owner to read and write to it (make sure the file is owned by you).

   2. Run chmod 755 ~ to restrict access to your home directory so that no other may write to it.

   3. Run chmod 700 ~/.ssh so that others cannot write to it. The ~/.ssh directory is not writable by group or others. Otherwise, authentication will fail.

Why is the BLOB limited to 1GB in size?

32-bit binaries cannot address more than 4 Gbyte of memory. This is not a MySQL limitation, this is a technical limitation. BLOB's are limited to 1 Gbyte in size even though you use LONGBLOB because of a limitation in the MySQL protocol: The protocol limit for max_allowed_packet is 1GB.

Even though the LONGBLOB Field in the table can hold 4GB of data , technically it is not possible to add more than 1GB.  Even mysqldump will fail if it has data more than 1GB in a single LONGBLOB field.