Search code examples
mariadbgaleraswisscomdev

Maria DB storage capacity under Swisscom cloud

According to this page https://developer.swisscom.com/pricing it is possible to define instances count for every plan. Does it mean that if I would need additional GBs for the system I would just need to add more instances and that's it? Nothing to change in code and I could use same connection parameters?

Solution

  • In this graph you see Apps (not services for persistent data). With apps you can add instances and memory very dynamically. Apps are stateless.

    enter image description here

    Please read twelve-factor app for more info about howto develop apps for CF.

    In the modern era, software is commonly delivered as a service: called web apps, or software-as-a-service. The twelve-factor app is a methodology for building software-as-a-service apps.

    For services (with persistent data) you have to choose a plan. For example if you use small and you need more connections/storage (for example large), you can't upgrade with one command.

    $ cf m -s mariadb
Getting service plan information for service mariadb as admin...
OK

service plan   description                                        free or paid
small          Maximum 10 concurrent connections, 1GB storage     paid
medium         Maximum 15 concurrent connections, 8GB storage     paid
large          Maximum 100 concurrent connections, 16GB storage   paid

    You need to

    • dump the database (use service connector plugin and mysqldump on local device)
    • create a new service (cf cs mariadb large ...)
    • restore data to new service (service connector and mysql client)
    • delete old service (cf ds -f...)

    There is no "one-click" upgrade at the moment.