[Maria-discuss] 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/
participants (1)
-
AskMonty KB