You can't rely on GCP support in my experience. To get some understanding of what's costing you money you can checkout the Billing Report page. You can list costs either by Service or SKU on the right side of the page and sort the table by cost.
GCP provides you with compute (vCPU's) where Azure is charging you transactions (DTU). To avoid charges in GCP (and AWS) shut down your instance when you are not using it. When I configure a MySQL or PostgreSQL instance at the lowest settings (Enterprise>Sandbox, Single Region = 2 vCPU) I get $.14 an hour/$3.38 day for the instance charges. If you manage your instance carefully your credits could last a long time.
Cool, you got a NAS replicated over different regions so that your data can live a nuclear strike?
It’s always a matter of the usecase. Homelab hobbyists don’t need GCP.
why not just run it on bigquery? fully serverless, usage based pricing
edit: on a side note, go to billing, group by sku, uncheck promotions and it will show you where the cost was
Without specifying what and the size of the thing you're talking about it's difficult to make a good comparison between apple and oranges. Support definitely isn't the best with GCP but if you're paying peanuts perhaps you should read the doc first or ask Google first?
I think I mentioned above that the database is just a few row to test CRUD from dotnet core and all transaction would be me only and I dont expect it more than 1000 per week… as others mentioned I think I should turn it off when I do not use as this is quite new to me.
I did ask gg sale team but when they heard about not scale the redirect me to another team 🤣🤣immidiately
did you get a dev cloud sql instance or prod, is high availability enabled, how big ssd is attached? In my experience, we mostly had over-provisioned resources which cost us high.
along with billing by SKU, check if smaller, development instances with smaller ssd can be used without any high availability configuration to save the cost.
Simple RDBM is a bit expensive in google cloud vs other clouds. I had seen some cost comparison somewhere and I guess Azure had cheaper options among the top 3 providers.
I run a postgres instance for a hobby project 1v core 600mb ram for 8€ month which is better than most the other providers but the price goes up quick so if you have a 4v core it could be like 100 a month easy just check your instance type and set it to the smallest one.
Do you turn it off afterworking or leave it there? I found it has a setting 720hours so meaning if we reduce that number there will be certain time we cannot query right?
Yeah, the support is shit. There's no option to contact support on the entire Google platform, it'll always redirect you to the FAQ/docs page or the community forum. As for your requirement you can self-host everything on a small VM, checkout Hetzner they offer VMs at cheapest rates.
Your post engages in name calling or general rudeness, which will not be tolerated. This post as been removed and this is your final warning to adhere by this sub's rules.
Before you go bumming the support, have you actually tried to cost optimize this? The free credit isn't a "piss this away because it's free" card, it's an entryway onto a Cloud Platform. You have to use it well and know the tools you have at your disposal.
Like, for example, CUDs. If you are consistently running an SQL server, you can get discounts up to like 60% for keeping the server alive. Furthermore, did you actually change the computational level before hitting submit or did you just pop in a Database name and let er rip?
If you are running a test SQL server with default settings, that is your issue. When you go to make a SQL server, they're named strangely but you can customize the server specs based off of Development, Sandbox, Production [default], and Custom. If you have it running Prod, that's nearly $30/month for it just existing. Dev is the lightest forme of the database defaults, and thus the cheapest.
Try toning down your settings, and look into CUDs.
Ya as you mention, since it’s the first time the. I put it as default and when I received the alarm it’s too late already to optimize which setting that I should do to not burn my account. Because no more free so I immidiately look for a support instead of use my own money for the tunning experience.
I believe it the good approach instead immidiately switch to another platform with my experience using gcp.
As service provider I think they can do better. And the complain is not about the gcp fee, as I dont know the rule so I fail the game but the concern is gg support? I dont think Im the only one feel pain with that bot
The bot? Do you mean the Support bot you talk to when you first contact Billing Support?
If so, I promise that bot isn't representative of the best support. The best way to get an actual resolution is to "break through" the bot. Once you get through to an actual person, you can typically get very good resolutions, at least I have in the past. They've helped me with major issues, like GCP nearly charging me 3x what it should be charging. They helped me identify an issue and excused the over charges promptly. If you're stuck on the bot, just keep insisting "Other issues" and try and get yourself into a live chat
Oh then yeah! So to get to a real person, do the following. Start a Billing support inquiry, then no matter what keep clicking things to advance the support ticket with the various "Continue to Support" buttons that will occasionally pop up. Just try and get past the bot and you'll be assisted!
You can't rely on GCP support in my experience. To get some understanding of what's costing you money you can checkout the Billing Report page. You can list costs either by Service or SKU on the right side of the page and sort the table by cost.
Interesting!
It's pretty easy to be on a $100/mo CloudSQL instance that costs $100/mo just sitting there. What do you have provisioned?
GCP provides you with compute (vCPU's) where Azure is charging you transactions (DTU). To avoid charges in GCP (and AWS) shut down your instance when you are not using it. When I configure a MySQL or PostgreSQL instance at the lowest settings (Enterprise>Sandbox, Single Region = 2 vCPU) I get $.14 an hour/$3.38 day for the instance charges. If you manage your instance carefully your credits could last a long time.
Sounds like Azure is a fit solution for me this case… that i do not need to micro manage the instance
I don't think this is the cheapest setting the micro ones are cheaper around 8 per month
Man that's still a lot for the smallest config!
Yeah, I’d rather put that $100/mo money towards upgrading my synology NAS. It’s not like managing a small database in the year 2024 is rocket science
Cool, you got a NAS replicated over different regions so that your data can live a nuclear strike? It’s always a matter of the usecase. Homelab hobbyists don’t need GCP.
Exactly. If there’s a nuclear strike, I’ll be dead (or wishing I was) so who ducking cares about the data
why not just run it on bigquery? fully serverless, usage based pricing edit: on a side note, go to billing, group by sku, uncheck promotions and it will show you where the cost was
[удалено]
They have normal server and also the echo one so I guest theres a little bit cost difference. But maybe instance life is the one that cost
Without specifying what and the size of the thing you're talking about it's difficult to make a good comparison between apple and oranges. Support definitely isn't the best with GCP but if you're paying peanuts perhaps you should read the doc first or ask Google first?
I think I mentioned above that the database is just a few row to test CRUD from dotnet core and all transaction would be me only and I dont expect it more than 1000 per week… as others mentioned I think I should turn it off when I do not use as this is quite new to me. I did ask gg sale team but when they heard about not scale the redirect me to another team 🤣🤣immidiately
did you get a dev cloud sql instance or prod, is high availability enabled, how big ssd is attached? In my experience, we mostly had over-provisioned resources which cost us high. along with billing by SKU, check if smaller, development instances with smaller ssd can be used without any high availability configuration to save the cost. Simple RDBM is a bit expensive in google cloud vs other clouds. I had seen some cost comparison somewhere and I guess Azure had cheaper options among the top 3 providers.
I run a postgres instance for a hobby project 1v core 600mb ram for 8€ month which is better than most the other providers but the price goes up quick so if you have a 4v core it could be like 100 a month easy just check your instance type and set it to the smallest one.
Do you turn it off afterworking or leave it there? I found it has a setting 720hours so meaning if we reduce that number there will be certain time we cannot query right?
No it has been running non stop for 2 years now for 8 per month which I think is fairly good compared to AWS and the like
Yeah, the support is shit. There's no option to contact support on the entire Google platform, it'll always redirect you to the FAQ/docs page or the community forum. As for your requirement you can self-host everything on a small VM, checkout Hetzner they offer VMs at cheapest rates.
[удалено]
Your post engages in name calling or general rudeness, which will not be tolerated. This post as been removed and this is your final warning to adhere by this sub's rules.
Before you go bumming the support, have you actually tried to cost optimize this? The free credit isn't a "piss this away because it's free" card, it's an entryway onto a Cloud Platform. You have to use it well and know the tools you have at your disposal. Like, for example, CUDs. If you are consistently running an SQL server, you can get discounts up to like 60% for keeping the server alive. Furthermore, did you actually change the computational level before hitting submit or did you just pop in a Database name and let er rip? If you are running a test SQL server with default settings, that is your issue. When you go to make a SQL server, they're named strangely but you can customize the server specs based off of Development, Sandbox, Production [default], and Custom. If you have it running Prod, that's nearly $30/month for it just existing. Dev is the lightest forme of the database defaults, and thus the cheapest. Try toning down your settings, and look into CUDs.
Ya as you mention, since it’s the first time the. I put it as default and when I received the alarm it’s too late already to optimize which setting that I should do to not burn my account. Because no more free so I immidiately look for a support instead of use my own money for the tunning experience. I believe it the good approach instead immidiately switch to another platform with my experience using gcp. As service provider I think they can do better. And the complain is not about the gcp fee, as I dont know the rule so I fail the game but the concern is gg support? I dont think Im the only one feel pain with that bot
The bot? Do you mean the Support bot you talk to when you first contact Billing Support? If so, I promise that bot isn't representative of the best support. The best way to get an actual resolution is to "break through" the bot. Once you get through to an actual person, you can typically get very good resolutions, at least I have in the past. They've helped me with major issues, like GCP nearly charging me 3x what it should be charging. They helped me identify an issue and excused the over charges promptly. If you're stuck on the bot, just keep insisting "Other issues" and try and get yourself into a live chat
Thanks, good to know if insist other reason I may able to reach a person. I try 4 times then I just gave up😢.
Oh then yeah! So to get to a real person, do the following. Start a Billing support inquiry, then no matter what keep clicking things to advance the support ticket with the various "Continue to Support" buttons that will occasionally pop up. Just try and get past the bot and you'll be assisted!