[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. |
| 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. 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 |
| 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. |