cf-mysql-plugin makes it easy to connect the mysql command line client to any MySQL-compatible database used by
Cloud Foundry apps. Use it to
- inspect databases for debugging purposes
- manually adjust schema or contents in development environments
- dump and restore databases
$ cf mysql -h
NAME:
mysql - Connect to a MySQL database service
USAGE:
Open a mysql client to a database:
cf mysql <service-name> [mysql args...]
$ cf mysqldump -h
NAME:
mysqldump - Dump a MySQL database
USAGE:
Dumping all tables in a database:
cf mysqldump <service-name> [mysqldump args...]
Dumping specific tables in a database:
cf mysqldump <service-name> [tables...] [mysqldump args...]Passing the name of a database service will open a MySQL client:
$ cf mysql my-db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 1377314
Server version: 5.5.46-log MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [ad_67fd2577d50deb5]> The mysql child process inherits standard input, output and error. Piping content in and out of cf mysql works
just like it does with plain mysql:
$ cat database-dump.sql | cf mysql my-dbAny parameters after the database name are added to the mysql invocation:
$ echo "select 1 as foo, 2 as bar;" | cf mysql my-db --xml
<?xml version="1.0"?>
<resultset statement="select 1 as foo, 2 as bar" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
<field name="foo">1</field>
<field name="bar">2</field>
</row>
</resultset>Running cf mysqldump with a database name will dump the whole database:
$ cf mysqldump my-db --single-transaction > dump.sqlPassing table names in addition to the database name will just dump those tables:
$ cf mysqldump my-db table1 table2 --single-transaction > two-tables.sqlThe plugin creates a service key called 'cf-mysql' for each service instance a user connects to. The keys are reused when available and never deleted. Keys need to be removed manually before their service instances can be removed:
$ cf delete-service -f somedb
Deleting service somedb in org afleig-org / space acceptance as [email protected]...
FAILED
Cannot delete service instance. Service keys, bindings, and shares must first be deleted.Deleting the service failed. The CLI hints at service keys and app bindings that might still exist.
$ cf service-keys somedb
Getting keys for service instance somedb as [email protected]...
name
cf-mysqlA key called 'cf-mysql' is found for the service instance 'somedb', because we have used the plugin with 'somedb' earlier. After removing the key, the service instance can be deleted:
$ cf delete-service-key -f somedb cf-mysql
Deleting key cf-mysql for service instance somedb as [email protected]...
OK
$ cf delete-service -f somedb
Deleting service somedb in org afleig-org / space acceptance as [email protected]...
OKThis behavior might change in the future as it's not optimal to leave a key around.
The easiest way is to install from the repository:
$ cf install-plugin -r "CF-Community" mysql-pluginYou can also download a binary release or build yourself by running go build. Then, install the plugin with
$ cf install-plugin /path/to/cf-mysql-pluginThe plugin can be uninstalled with:
$ cf uninstall-plugin mysql# download dependencies
go get -v -t ./...
go get github.com/onsi/ginkgo
go get github.com/onsi/gomega
go install github.com/onsi/ginkgo/ginkgo
# run tests and build
ginkgo -r
go buildcf-mysql-plugin creates a service key called 'cf-mysql' to obtain credentials. It no longer retrieves credentials from application environment variables, because with the introduction of CredHub, service brokers can decide to return a CredHub reference instead.
The service key is currently not deleted after closing the connection. It can be deleted by running:
cf delete-service-key service-instance-name cf-mysql
A started application instance is still required in the current space for setting up an SSH tunnel. If you don't have an app running, try the following to start an nginx app:
TEMP_DIR=`mktemp -d`
pushd $TEMP_DIR
touch Staticfile
cf push static-app -m 128M --no-route
popd
rm -r $TEMP_DIR
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent