[MCOL-660] SSH for mariadb-user fails everytime after reboot Created: 2017-04-11  Updated: 2017-05-08  Resolved: 2017-05-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.7
Fix Version/s: Icebox

Type: Bug Priority: Critical
Reporter: Abhinav santi Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Hello,

We are moving from InfiniDB 4.6 to Mariadb 1.7.0. I've used an AMI to deploy the DB and have been facing the issue from day 1 of my deployment. Every time I reboot the server my keys in mariadb-user/authorized key gets deleted. I had to ssh as ec2-user and add my keys manually in mariadb-user to ssh. Is this behaviour expected/ a bug?

Thanks



 Comments   
Comment by David Hill (Inactive) [ 2017-04-11 ]

You dont need to place your key onto the instance, it will be automatically done each tome the instance gets lsuched. You would need to always use the key that you used when you originally lauched the instance. With the user of mariadb-user.

Is there a need to try to run with a different key than was used to launch with?

David Hill

Comment by Abhinav santi [ 2017-04-11 ]

Thank you so much for the reply David.

I have another guy in my team who needs access to the instance. Is sharing the private key with him the only way to give access to instance?

Comment by David Hill (Inactive) [ 2017-04-11 ]

In this case, you could look into setting up and using the Amazon IAM users and roles. This is the best and most secure way to allow multiple users accessing the same system. There is a bit of learning and setup to do this, but its the recommended option.

But you could also allow them the use of your key, or setup a group key to be shared.

David Hill

Comment by Abhinav santi [ 2017-04-11 ]

Thank you so much. I will look at setting up the role. . You can close this ticket

Comment by Abhinav santi [ 2017-04-11 ]

In the documentation #[here it says about data migration from a multi PM installation to another multi server.

We had a single server with both PM and UM on the same (InfiniDB). Now the requirement is to use multi PMs (currently 2PM 1 UM). How should the data migration done across PMs now?

Comment by David Hill (Inactive) [ 2017-04-11 ]

This documents the recommended procedure

https://mariadb.com/kb/en/mariadb/migrating-from-infinidb-4x-to-mariadb-columnstore/

Comment by Abhinav santi [ 2017-04-12 ]

Thanks.
The documentation says "Now replace the data<N> directories with the backup on each PM as appropriate for each directory:"

Earlier Infini DB Installation had only single PM and the new Column store has 2PMs and an UM. Is the documentation still applicable here?

If there is any doc which says about migrating the data from a single server INfinidb Installation to Multi Server Maria Columnstore that will be of great help. Thanks!

Comment by David Hill (Inactive) [ 2017-04-12 ]

Another option is to run the select into file on each table to a file. Then run cpimport on the new system usimg the files.

Here is an example of how it is used together, you would just break it apart

https://mariadb.com/kb/en/mariadb/columnstore-bulk-data-loading/#bulk-loading-output-of-select-from-tables

Comment by David Hill (Inactive) [ 2017-04-12 ]

Another option is start new system with 1um and 1pm, add the data giles from old system. Then do the addmodule/adddbroot to get to your 2pm system. And then run data redistribute command via the mcsadmin command

Comment by David Thompson (Inactive) [ 2017-05-08 ]

Believe that this is resolved, please re-open if not.

Generated at Thu Feb 08 02:22:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.