This documentation site is no longer maintained. For the latest Delphix product documentation, please visit help.delphix.com
Continuous Data
Continuous Data
Breadcrumbs

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.