← Back to team overview

maria-discuss team mailing list archive

New Question: Migrating mysql 5.5.19 to mariadb with encryption

 

Hello,

A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
I am currently running mysql 5.5.19 64bit, Innodb, on Sparc Solaris and looking to move to mariadb on linux.   Our ultimate goal is to have encrypted data-at-rest.  I have 2 questions please.

1)  So from my research I see I should be able to install mariadb 10.0 and run mysql_upgrade.  Since the database exists already, do you just specify the location of the database when you install and it will upgrade it to mysqldb 10.0 when I run mysql_upgrade?

2)  To achieve encryption, do I just install 10.1.4 on the same machine and run mysql_upgrade after making the changes to my.cnf.  I know there are other my.cnf options but will this encrypt all the tables and logs?  Does it do system tables please?

[mysqld]
plugin-load-add=file_key_management.so
file-key-management
file-key-management-filename = /mount/usb1/keys.txt
innodb-encrypt-tables
innodb-encrypt-log
innodb-encryption-threads=4

I have just started to research so I appreciate the help.
Christine
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/