Re: Need info for deploying Mariadb as xenial
On Mon, Jun 27, 2016, 7:40 AM Rajith P Venkata <rajith...@in.ibm.com> wrote: > > Hi > > I am deploying mariadb5.5 on juju 2.0, I am getting error . Mariadb charm > supports only trusty , is there a way we can have Mariadb charm deployed > with series xenial MariaDB 5.5 is entirely unsupported on Ubuntu Xenial. The Ubuntu repository for Xenial only has MariaDB 10.0 in it and the MariaDB repositories for Xenial only have MariaDB 10.0 and higher in them. The MariaDB Ubuntu repository for MariaDB 5.5 only supports Ubuntu Trusty and Precise. My guess is that that is why the charm is failing, the packages you are trying to install don't exist. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for performing housekeeping tasks on mariadb from a remote machine
On Tue, Jun 14, 2016 at 2:01 PM, Rajith P Venkata <rajith...@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 -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: error with mariadb
On Mon, Jun 6, 2016 at 11:48 AM, Jay Wren <jay.w...@canonical.com> wrote: > Clicking that URL and reading the InRelease file, you can see that the > mirror at http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu/ > > does not have ppc64el packages. > > A quick search at packages.ubuntu.com > > shows that trusty has mariadb 5.5 packaged. > http://packages.ubuntu.com/search?keywords=mariadb=names=trusty=all > > > I took a quick look at the mariadb charm at https://jujucharms.com/mariadb/ > > and I do not see a PPA or other repository config value. Are you using that > charm or some other charm? > > In Daniel's reply he wrote "I can confirm that the MariaDB Foundation > repositories do have > packages for MariaDB 5.5 for Trusty on Power 8 Little Endian." > > It does not sound like http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu/ > is a full mirror of the MariaDB Foundation repositories. > > A list of mirrors is here: > https://downloads.mariadb.org/mariadb/repositories/#mirror=jaleco=Ubuntu_release=trusty--ubuntu_trusty=5.5 > > I selected each mirror and each one appears to only mirror > [arch=amd64,i386]. > > I'm afraid I don't know the next step to help you, but I hope this > information is helpful. Maybe Daniel could reply with the location of the > Maria DB Foundation repositories which include ppc64le trusty packages. Yes, that was an error. I've now fixed it. The osuosl mirror is actually the primary mirror (all other mirrors pull from it). I suggested that one because if it's not there, none of the other mirrors will have it either. Power8 packages for 5.5 in the community repositories are a new thing and when they were added the complete updated repository never made it over from the staging server for some reason. With the re-deploy I just did they are all there now. http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu/dists/trusty/InRelease Sorry about that. Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: error with mariadb
On Fri, Jun 3, 2016 at 6:18 AM, Rajith P Venkata <rajith...@in.ibm.com> wrote: > I am trying to use Mariadb 5.5 on Ubuntu 14.x on Power 8 Little Endian > with this we are getting error as unexpected token, > Token I have used form https://mariadb.com/my_portal > > With verision Mariadb 10.05 we do not get this error but the plugin we are > installing needs Mariadb 5.5. > > Please refer the logs below and let us know if Mariadb 5.5 works on Ubuntu > 14.x on Power 8 Little Endian MariaDB 5.5 does work on Ubuntu 14.x on Power 8 Little Endian. However, after looking at the logs, I'm not sure what your error is. In the unit-mariadb-5.log file, I see one error where something is trying to connect to MariaDB when MariaDB isn't running, but I'm not sure exactly what is trying to connect. A few lines further down in the log MariaDB is started again, so if whatever was trying to access MariaDB had waited a few seconds I would assume the connection attempt would have succeeded. During installation and upgrades MariaDB is stopped and started at various points as needed to apply updates to internal system tables and other tasks. In the unit-ibm-platform-rtm-4.log I see that line 203 of the ibm-prtm.sh script has a syntax error, but I don't know anything about that script that would enable me to comment further. I also see that the script runs a ibm-prtm-mariadb.available test several times, but again I don't know anything about that test or what it is checking for. I don't know if it will help you or not, but I recently pushed some updates to my personal launchpad tree - lp:~dbart/charms/trusty/mariadb/trunk - that sets the MariaDB charm to use the MariaDB Foundation repositories by default if the MariaDB Inc EULA and token are not provided as specified in the README. This new version of the charm is not in the charm store yet, but hopefully it will be soon. I can confirm that the MariaDB Foundation repositories do have packages for MariaDB 5.5 for Trusty on Power 8 Little Endian. The only caveat I would add is that you'll get much better performance on Power 8 using MariaDB 10.0 or 10.1. Also, the choice of which series to use should be changed using a local config.yaml file with the series variable set to one of "5.5", "10.0", or "10.1" (the default in the charm store is currently 10.0, but my new update bumps the default up to 10.1). For example: mariadb: series: "5.5" When using my repository locally I can then deploy MariaDB 5.5 with: juju deploy --config ./mariadb.yaml --repository="/home/${USER}/src/charms/" local:trusty/mariadb And FYI, using something like: juju set mariadb series="5.5" ...after the initial deployment to downgrade MariaDB from the default series to 5.5 does not work. It has to be set using a yaml file as described above and used during the initial deployment. Using the set command to upgrade MariaDB, from say 5.5 to 10.0, does work, it's just downgrades that don't work. I'm not sure if any of the above will be of help, but hopefully some of it will. If you have additional questions or comments, please let me know. Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: information needed for Mariadb Enterprise edition
On Tue, May 24, 2016 at 6:38 PM, Daniel Bartholomew <db...@mariadb.com> wrote: > On Thu, May 19, 2016 at 7:46 PM, Kevin Monroe > <kevin.mon...@canonical.com> wrote: >> I recently took a look at the mariadb charm on ppc64le and ran across some >> interesting bits. I'm looping in the charm maintainer (dbart) for extra >> insights. >> >> First, MariaDB has both enterprise and community versions available for this >> charm to deploy. Rajith, as you saw in the readme, you should be able to >> obtain credentials from the MariaDB Portal >> (https://mariadb.com/user/login?destination=my_portal/download). However, >> there was a recent change in the package signing key [0] that >> may affect installation. Daniel, are these "enterprise.yaml" creation >> instructions in the charm readme still valid?: >> >> http://bazaar.launchpad.net/~charmers/charms/trusty/mariadb/trunk/view/head:/README.md#L46 >> > No. Those are old instructions. I submitted an updated version of the > charm way back in November, but it looks like it never made it into > the charm store. As a first step, the version of the charm currently > in my repo (revision 28) should immediately be pushed to the charm > store: lp:~dbart/charms/trusty/mariadb/trunk > > The correct readme is here: > > http://bazaar.launchpad.net/~dbart/charms/trusty/mariadb/trunk/view/head:/README.md#L24 > > ...but the instructions there won't work unless the charm in the store > is updated. > After looking into the issues some more, I've uncovered some new ones relating to deployment of MariaDB Enterprise on POWER8 with the updated version of the charm my launchpad repo. It's probably best to keep the old charm in the store as-is until I have the new version I'm working on ready. I should have it done early next week. POWER8 deployment issues with the old charm, as long as you don't configure the enterprise.yaml file, and just 'juju deploy mariadb' are now resolved AFAIK thanks to some modifications I made today to the community MariaDB repositories. Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju