Re: Announcing cf-mysql-release v35

Juan Pablo Genovese


I think I'll be there, and sure! Let me buy you a beer and discuss this.

Thank you! :)

2017-05-10 11:28 GMT-03:00 Marco Nicosia <mnicosia(a)>:

Hi Juan Pablo,

At the time we chose to go with MariaDB, our goal was to provide a
"MySQL-compatible" relational DB for CF. Also at the time, MariaDB claimed
to be a drop-in replacement; and to some extent, it still is.

We chose to stick with the name MySQL for three reasons:

1. Our commitment was MySQL, not necessarily MariaDB. We wanted to reserve
the right to change our minds on which "engine" to include in the future.
2. Name recognition: people new to CF are usually looking for "what's a
good DB to start with," and not necessarily thinking about the about the
small differences in the MySQL community. Especially at the time, but still
today, MySQL is universally known. MariaDB, less so.
3. We weren't even sure we wanted to call it MySQL in the first place. We
were considering something even more generic, like "relational database for
Cloud Foundry." The reason for this is that cf-MySQL-release is more than
just a thin packaging of MySQL, it's most everything you need to run a DB
with CF. That was unrealistic - people need to know what kind of DB is
running. So we stuck with a generic MySQL as a compromise.

Love to chat more over a beer at CF Summit if you happen to be attending!

-- Marco N.

On Wed, May 10, 2017 at 05:54 Juan Pablo Genovese <juanpgenovese(a)>

Great news, and great work!

OTOH, was there ever a discussion about changing the name of the release?
I feel it is a little unfair (and can be even misleading technologically
speaking) to still be calling it a "MySQL" release when in fact is using
Maybe that discussion already took place and I missed it.

Thank you!

2017-05-10 1:09 GMT-03:00 Marco Nicosia <mnicosia(a)>:

On behalf of the Core Services team, I'm happy to announce that we've
recently published cf-mysql-release v35

The major motivation for this release is to switch the manifest to use
BOSH links. This supports the work going on in cf-deployment
<>. We've also swapped out
our fork of route-registrar, preferring instead the official one in
<>. Due to the
nature of the cf-deployment integration work, we may need to spin a small
release or two as we tweak how to expose those links.

Based on the results of the poll included with v34, few of you are
locked into using spiff. As a result of that, we continued to update spiff
templates in v35, but will no longer include them in future releases. To
deploy v35, I recommend you try cf-mysql-deployment v35
<>. Like
cf-deployment, we're learning as we go. Please send us lots of feedback.

Stay tuned for coming epics which will include tightening security and
tuning tweaks!

Marco Nicosia
Product Manager
Pivotal Software, Inc.

---------- Forwarded message ----------
Date: Wed, May 3, 2017 at 7:20 PM
Subject: [cloudfoundry/cf-mysql-release] v35
Cc: Subscribed <subscribed(a)>

cf-mysql-release v35

*Notice:* Based on your responses to the v34 poll
this will be the last release in which we include updated spiff templates.
That means that starting with v36, you'll want to check out
<> or continue
building your manifest by other means.

Also, using cf-mysql-deployment
<> just got easier
with the official GA
of the bosh v2 CLI <>!
Dependency Updates


cf-mysql-release should use MariaDB 10.1.22 [#141072891

Use routing-release instead of our own fork of route-registrar [
#135377279 <>]

For a long time, cf-mysql-release has used a fork of the
route-registrar library. To stay current, we now require
<>. Please
note the
<http:///cloudfoundry/cf-mysql-release/blob/v35/> now
covers this prerequisite.

*Note:* When switching to the canonical distribution of
route-registrar, we had to change the URL of the proxy. Where once
you'd visit https://proxy-0-p-mysql.SYSTEM-DOMAIN/, now the instance
index is pre-pended: https://0-proxy-p-mysql.SYSTEM-DOMAIN/.
- As an operator I can navigate to a well-known URL to discover a
list of URLs to the proxy dashboards [#138180969

If you use cf-mysql-deployment, and include the
operations file, the deployment will automatically include a proxy
aggregator: https://proxy-p-mysql.SYSTEM-DOMAIN/ which will include
links to the proxy dashboards, regardless of the naming scheme. This
feature is only available when using BOSH links.
- As an Operator, I'd like the docs to cover how to upgrade from v34
to v35 which uses routing-release [#144161787
- cloudfoundry/cf-mysql-release #157
Unused nats properties [#143997101

Some nats properties are no longer used by our jobs directly, but
routing-release still uses the same properties so deployment manifests do
not need to change.

Providing and Consuming BOSH links

Using BOSH links <> simplifies manifests
and manifest generation - every time a BOSH release uses a link, that's
less copying and pasting via template.

- cloudfoundry/cf-mysql-release #154
<>: Provide
database links for mysql and proxy jobs [#143086033
- cloudfoundry/cf-mysql-release #149
Optionally consume cc link for app_domains in smoke tests [#140458283

Bug Fixes and Minor Improvements

- [BUG] Upgrading from older releases fails to start mariadb [
#139334661 <>]
- [BUG] Logs not draining to syslog [#143069405
- Fixes a regression in v34 that logs were not sent to syslog.
- [BUG] mysql_release fails to deploy to a BOSH director using
local_dns [#143221877
- [BUG] pre-start hangs indefinitely when cluster is not healthy [
#141824537 <>]
- [BUG] If a node is failing, mariadb_ctrl waits for mysql forever [
#140517205 <>]
- [BUG] roadmin user doesn't have read privs for admin operations? [
#139594503 <>]
- cloudfoundry/cf-mysql-release #155
<>: Allow
innodb_flush_log_at_trx_commit to be configurable [#143693837
- cloudfoundry/cf-mysql-release #158
<>: Nil the
consul link in the example stub [#144138871
- cloudfoundry/cf-mysql-release #159
<>: add
private key option to download-logs script [#144411627
- As an Operator, if an errand is a no-op, it's better to exit 0
than error [#139054911
- Stop attaching the tarball to the release notes of
cf-mysql-release [#139611695


- Proxy startup and shutdown delay descriptions are backwards in
spec [#139996733
- NOTICE files on various repositories are out of date [#141360157

Manifest Changes

- New: cf.mysql.innodb_flush_log_at_trx_commit, optional, defaults
to 1.
- New: cf_mysql.proxy.api_aggregator_port: optional, defaults to
- New: cf_mysql.proxy.api_uri, required when deploying the proxy
- Removed: cf_mysql.external_host
- Removed: cf_mysql.standalone

You are receiving this because you are subscribed to this thread.
View it on GitHub
<> or mute
the thread

Mis mejores deseos,
Best wishes,
Meilleurs vœux,

Juan Pablo
Marco Nicosia
Product Manager
Pivotal Software, Inc.
c: 650-796-2948

Mis mejores deseos,
Best wishes,
Meilleurs vœux,

Juan Pablo

Join { to automatically receive all group messages.