Need information for performing housekeeping tasks on mariadb from a remote machine

[Daniel Bartholomew]

On Tue, Jun 14, 2016 at 2:01 PM, Rajith P Venkata <rajith.pv at in.ibm.com> wrote:
> I have deployed mariadb in unit 1 and want to perform following tasks from
> RTM charm which is in unit 2
>
> rm -f /var/lib/mysql/ib_logfile*
>         service mysql stop
>         rm -f /var/lib/mysql/ibdata*
>
> Please let me know how I can perform this housekeeping tasks.


I use the juju ssh command to ssh into my deployed MariaDB units. For example:

juju ssh mariadb/0

Once logged in commands like you list can be easily run.

I haven't tried ssh'ing from one unit to another unit, but I assume
it's perfectly possible to do so.

I imagine you would need to generate and ssh key on the unit you want
to ssh from (the source unit), and then copy the public part of the
key into the ~/.ssh/authorized_keys file on the unit you want to ssh
to (the destination unit). You should then be able to ssh from the
source unit to the destination unit using the ip address of the
destination unit.

There might be a better way to set it up, but I'm not enough of a juju
expert to know.

Thanks.

-- 
Daniel Bartholomew, MariaDB Release Manager
MariaDB | http://mariadb.com