update to MariaDB charm

[Daniel Bartholomew]

This is an update to the MariaDB charm. The charm installs MariaDB Enterprise from the official mariadb.com repositories. The previous version of the charm no longer works because of changes to the MariaDB Enterprise repositories.

[Review Queue (review-queue)]

The results (PASS) are in and available here: http://juju-ci.vapour.ws:8080/job/charm-bundle-test-lxc/1453/

[Review Queue (review-queue)]

The results (PASS) are in and available here: http://juju-ci.vapour.ws:8080/job/charm-bundle-test-aws/1438/

[Review Queue (review-queue)]

This item has failed automated testing! Results available here http://juju-ci.vapour.ws:8080/job/charm-bundle-test-lxc/1724/

[Review Queue (review-queue)]

This item has failed automated testing! Results available here http://juju-ci.vapour.ws:8080/job/charm-bundle-test-aws/1701/

[Kevin W Monroe (kwmonroe)]

Hey dbart, I'd like your thoughts on something.. You mentioned the previous charm no longer works because of an enterprise repo change, and I see that issue when running 'juju deploy mariadb' on ppc64le:

unit-mariadb-0[10642]: 2015-12-10 17:17:55 INFO unit.mariadb/0.config-changed logger.go:40 W: Failed to fetch http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/dists/trusty/InRelease Unable to find expected entry 'main/binary-ppc64el/Packages' in Release file (Wrong sources.list entry or malformed file)

However, install continues and the charm installs mariadb from the archive instead of the maria enterprise repo:

$ apt-cache madison mariadb-server
mariadb-server | 5.5.46-1ubuntu0.14.04.2 | http://ports.ubuntu.com/ubuntu-ports/ trusty-updates/universe ppc64el Packages

My question for you: can we support a non-enterprise deployment of mariadb? Based on this current MP, the charm could check for 'token' and 'enterprise-eula', and if they look legit, install/enable the enterprise repo. If not, install from the ubuntu archives.

This would allow for the same charm to be used to install both 'consumer grade' and 'enterprise grade' mariadb, depending on how the user configured the deployment. Thoughts?

[Kevin W Monroe (kwmonroe)]

Setting status to 'Incomplete' awaiting dbart's thoughts on offering both consumer and enterprise versions of mariadb in this charm.

[Daniel Bartholomew (dbart)]

On Thu, Dec 10, 2015 at 12:46 PM, Kevin W Monroe
<email address hidden> wrote:
> Hey dbart, I'd like your thoughts on something.. You mentioned the
> previous charm no longer works because of an enterprise repo change, and
> I see that issue when running 'juju deploy mariadb' on ppc64le:
>
> unit-mariadb-0[10642]: 2015-12-10 17:17:55 INFO unit.mariadb/0.config-
> changed logger.go:40 W: Failed to fetch
> http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/dists/trusty/InRelease
>
> Unable to find expected entry 'main/binary-ppc64el/Packages' in Release
> file (Wrong sources.list entry or malformed file)
>
> However, install continues and the charm installs mariadb from the
> archive instead of the maria enterprise repo:
>
> $ apt-cache madison mariadb-server
> mariadb-server | 5.5.46-1ubuntu0.14.04.2 | http://ports.ubuntu.com/ubuntu-ports/
>
> trusty-updates/universe ppc64el Packages
>
> My question for you: can we support a non-enterprise deployment of
> mariadb? Based on this current MP, the charm could check for 'token'
> and 'enterprise-eula', and if they look legit, install/enable the
> enterprise repo. If not, install from the ubuntu archives.
>
> This would allow for the same charm to be used to install both 'consumer
> grade' and 'enterprise grade' mariadb, depending on how the user
> configured the deployment. Thoughts?

Sure, we could update the charm to do this.

The only issue I see is that users will get MariaDB 5.5 instead of
10.0 on Trusty. MariaDB 5.5 does not have the POWER8 optimizations
MariaDB Enterprise 10.0 has. Even non-enterprise MariaDB 10.0 in newer
versions of Ubuntu doesn't have all of the optimizations. The first
non-enterprise version of MariaDB with all POWER8 optimizations is
MariaDB 10.1. But at least the charm will work even when no token or
eula are set.

Thanks.

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

[shilpa (shilkaul)]

Hi,

I tried deploying the Turbo Lamp charm (Zend Server , MariaDB ,HA and Mellanox)in my Power 8 Local containers and I also faced the issue regarding MariaDB as shown below:

2015-11-23 10:05:57 INFO install Hit http://ports.ubuntu.comtrusty/main Translation-en
2015-11-23 10:05:57 INFO install Hit http://ports.ubuntu.comtrusty/universe Translation-en
2015-11-23 10:05:59 INFO install W: Failed to fetch http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/dists/trusty/InRelease Unable to find expected entry 'main/binary-ppc64el/Packages' in Release file (Wrong sources.list entry or malformed file)
2015-11-23 10:05:59 INFO install
2015-11-23 10:05:59 INFO install E: Some index files failed to download. They have been ignored, or old ones used instead.
2015-11-23 10:05:59 ERROR juju.worker.uniter.operation runhook.go:107 hook "install" failed: exit status 100

MariaDB charm deploy did not failed as it took it from archives and deployed version 5.But Mellanox subordinate charm failed on MariaDB Unit at install hook.

Thanks
Shilpa

[Daniel Bartholomew (dbart)]

On Wed, Dec 16, 2015 at 1:13 AM, shilpa <email address hidden> wrote:
> I tried deploying the Turbo Lamp charm (Zend Server , MariaDB ,HA and
> Mellanox)in my Power 8 Local containers and I also faced the issue
> regarding MariaDB as shown below:
>
> 2015-11-23 10:05:57 INFO install Hit http://ports.ubuntu.comtrusty/main
>
> Translation-en
> 2015-11-23 10:05:57 INFO install Hit http://ports.ubuntu.comtrusty/universe
>
> Translation-en
> 2015-11-23 10:05:59 INFO install W: Failed to fetch http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/dists/trusty/InRelease
>
> Unable to find expected entry 'main/binary-ppc64el/Packages' in Release file (Wrong sources.list entry or malformed file)
> 2015-11-23 10:05:59 INFO install
> 2015-11-23 10:05:59 INFO install E: Some index files failed to download. They have been ignored, or old ones used instead.
> 2015-11-23 10:05:59 ERROR juju.worker.uniter.operation runhook.go:107 hook "install" failed: exit status 100
>
> MariaDB charm deploy did not failed as it took it from archives and
> deployed version 5.But Mellanox subordinate charm failed on MariaDB Unit
> at install hook.

The current version of the charm at
lp:~dbart/charms/trusty/mariadb/trunk fixes this issue. MariaDB
packages for POWER8 (ppc64el) packages are only available from MariaDB
Enterprise, not from the community MariaDB repositories.

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

[Antonio Rosales (arosales)]

Daniel,

Are you ready for a review of this charm. The last update I see to the code branch is on 2015-11-03, and it looked like there may outstanding work per your comment 7. Did you want to enable a non-enterprise mode and have that be 5.5 and make that explicit in the readme and then when a non-enterprise 10 version is ready update the charm?

-thanks,
Antonio

[Daniel Bartholomew (dbart)]

On Fri, Jan 22, 2016 at 8:25 PM, Antonio Rosales
<email address hidden> wrote:
> Are you ready for a review of this charm. The last update I see to the
> code branch is on 2015-11-03, and it looked like there may outstanding
> work per your comment 7. Did you want to enable a non-enterprise mode
> and have that be 5.5 and make that explicit in the readme and then when
> a non-enterprise 10 version is ready update the charm?

I was planning on adding the non-enterprise option in the next version
of the charm, not the current one.

Thanks.

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

[Launchpad Janitor (janitor)]

[Expired for Juju Charms Collection because there has been no activity for 60 days.]