Published at 08.02.2019
anynines is pleased to announce the release of a9s MySQL Data Service, ready to bind your applications in its traditional Cloud Foundry way. Our a9s MySQL enables on-demand provisioning of VM-based, dedicated MySQL server instances. You can create instances of MySQL servers using Cloud Foundry Command Line Interface (CF CLI).
Table of Contents
a9s MySQL service instances are created with dedicated VM’s on our a9s PaaS environment. You can use cf create-service command for service instance creation.
a9s MySQL service instances are highly isolated and shielded by infrastructure virtualization mechanisms. Since then, the provision of instances along with VM orchestration is completely automated.
Due to the on-demand provisioning of VMs, only existing service instances allocate infrastructure resources and these resources are released only when they are destroyed. Using on-demand provisioning, we end up in an unlimited number of service instance creation capability by its design.
The current version of a9s MySQL includes the following key features:
On-Demand Service Instance Provisioning
a9s MySQL deploys MySQL instances automatically. Developers can provision a single-VM MySQL server using a single command.
Service Instance Isolation
Each MySQL server runs on a dedicated VM to ensure bad neighborhood protection in order to be aligned with enterprise security requirements.
a9s MySQL uses Cloud Foundry security groups to prevent network connections being established by unauthorized apps.
Service Instance Capacity Upgrade
Cloud Foundry Service Plan updates allow upgrades to the RAM, CPU, and storage capacity for your MySQL instances.
Logging and Monitoring
Each MySQL service instance provides log messages and MySQL-specific metrics to one or more syslog/graphite endpoints. You can configure the syslog/graphite endpoint to receive logging and monitoring information.
This errand automatically updates the stemcell and all provisioned a9s MySQL service instances to their latest version.
The Service Guard creates Cloud Foundry security groups for your service instance VMs.
When the IP address of a service instance changes, the guard updates the security group. The Service Guard also restarts the application instances bound to the affected service instance. The instances of one app are restarted one by one to avoid downtime.
a9s MySQL ensures high availability.
The Consul-based internal DNS system provided by a9s- Consul DNS ensures that the connected application always connects to a working node.
Connect with MySQL Client and MySQL Workbench.
a9s MySQL service instances can be connected from MySQL Command line client and also accessible from MySQL Workbench. For detailed instructions, please do follow our blog post “How to connect a9s MySQL with MySQL Client and Workbench”
To use our a9s MySQL with an application, you need the following prerequisites:
To view our a9s MySQL plans, one should use the below command.
$ cf marketplace -s a9s-mysql101
Getting service plan information for service a9s-mysql101 as your_username…
free or paid
a medium replica set
a small replica set
a medium single instance
a small single instance
We have allocated resources for our a9s MySQL as per the below table:
Please note: All cluster plans will include three nodes and on-request, we can add upon resources based on the customer request. For any customizations, please feel free to contact: https://www.anynines.com/contact or through email to email@example.com
Once created, you can upgrade your service instance to another, larger service plan. A larger service plan provides more CPU, RAM, and storage. For more information, see the Update a Service Instance of the Managing Service Instances with the cf CLI topic.
1<strong>$ cf update-service my-mysql-service -p mysql-single-medium</strong>
Here are the plans you can upgrade to, depending on the one you are currently using:
a9s MySQL Data Service is a very useful service to build up web portals and blogging platforms. In future, we can expect features like dashboard, providing support for backup trigger and restore facilities and so on.