Ryan Kienstra

  • Reducing Cloud SQL DB Sizes
    Databases

    Reducing Cloud SQL DB Sizes

    Cloud SQL is a good place for waste to hide. You pay for what you provision, not what you use. So here’s how to reduce what you provision. For Google Cloud SQL instances, CPU Utilization and Memory Utilization are good indicators of whether they’re the right size. Here’s a script that shows which Cloud SQL…

    Read more: Reducing Cloud SQL DB Sizes
  • Optimizing Google Cloud Storage
    Storage

    Optimizing Google Cloud Storage

    Here’s how to save money on Google Standard Cloud Buckets: This script shows recommendations based on the flow chart above: Lines 2, 3, and 9 are candidates for savings: Let’s verify the first recommendation of “Move to COLDLINE” by looking at Metrics Explorer. If there was no read or write in the last 90 days,…

    Read more: Optimizing Google Cloud Storage
  • How To Delete Cloud SQL DBs You Don’t Need
    Databases

    How To Delete Cloud SQL DBs You Don’t Need

    Deleting even a db-n1-standard-2 Cloud SQL database will save $97 a month. So you could save hundreds a month by looking at unused Cloud SQL DBs. These will usually be dev or staging databases, though they won’t always be in a dev or staging project. If they’re still running, it means it wasn’t easy to…

    Read more: How To Delete Cloud SQL DBs You Don’t Need

Ryan Kienstra

Powered by Ollie

Notifications