Re: Announcing cf-mysql-release v34, and a quick poll

Marco Nicosia

Yes, I can do that!

On Sat, Feb 11, 2017 at 12:31 Dr Nic Williams <drnicwilliams(a)>

Can you add spruce to the survey as an option please? We've used it
instead of spiff for a very long time. I'd like to think lots of people
prefer it to spiff.


On Sat, Feb 11, 2017 at 12:35 PM +1000, "Marco Nicosia" <
mnicosia(a)> wrote:

Hi all!

On behalf of the Core Services engineering team, I’m happy to announce
that we’ve recently published cf-mysql-release v34
<>. I
wanted to call attention to a couple of important changes, and take a
moment to ask for some feedback.

First, we’re thinking of dropping spiff manifest templates in favor of
using BOSH’s native features. To learn more, take a peek at our work in
progress, cf-mysql-deployment

- Is this OK? Click: 💚

- Is disaster? Click: 💔

Both links lead to a brief survey where you can tell us more about how you
use and deploy cf-mysql. I’d love to hear from you.

Important Changes


*Retroactively remove lock permissions* from existing
service-broker-created users [#132881499

One major limitation of Galera is that table-level locks are not
replicated. We’ve found that many applications that rely on table locking
never notice this limitation when moving onto cf-mysql. In order to “fail
fast,” starting in v32
new service instances are explicitly disallowed from locking tables. With
release v34 forward, all existing Service Instances will no longer have the
ability to lock tables. Apps that attempt to lock tables will now see an
error of the form:

MariaDB [cf_eedd5768_9c6c_4388_ae0b_dc64f4022bf4]> LOCK TABLES fruit WRITE;

ERROR 1044 (42000): Access denied for user 'uoY64cqdw6qyMtNl'@'%' to database 'cf_eedd5768_9c6c_4388_ae0b_dc64f4022bf4'


Rename broker-deregistrar to *deregister-and-purge-instances* [
#138006305 <>]

Too often, Operators have been burned trying out an innocuously-named
errand. Renaming the errand, deregister-and-purge-instances makes it
clear that this is an errand that should only be run just before bosh

Release Notes

v34 has a ton more inside, I hope you check out the release notes

Thanks, and have a great weekend!

Marco Nicosia
Product Manager
Pivotal Software, Inc.

Join { to automatically receive all group messages.