I don't have a specific solution for you, but I also run a domain with some thousands of subdomains and is always a fight to not be banned from Google, Meta, internet operators etc. Sometimes is enough one bad actor under one of your subdomains to have a full ban on the whole domain.
What I suggest is for your and your clients to contact Meta through the Business Center support. Their support for paying clients is much better. I would also recommend you become a Meta Business Partner if Facebook/Instagram is important for your SaaS.
> Sometimes is enough one bad actor under one of your subdomains to have a full ban on the whole domain.
If you're running independent subdomains where a bad actor on one should not affect the reputation of the rest, you probably should add your domain to the public suffix list: https://publicsuffix.org
Note that adding your domain to the PSL changes how browsers interact with it, so don't do it lightly. In particular, no more cookies for the parent domain.
> Their support for paying clients is much better.
Perhaps worth it in this situation, but isn't that basically paying protection money? "Nice domain you've got there. Shame if anything happened to it."
If you are using their services for something important you should pay for it. I use fastmail not gmail for this reason: email is too important for me to risk on an account I don't pay for. I don't pay for youtube, because I don't care if they go out of business. I probably would pay for facebook if possible (but only if they make it FACEbook - not political memes, offensive jokes, and cat pictures) as it is a good way to keep in touch with distant friends.
They workout the issues like everyone else, and at a certain size the issue is minimized as you are either in several whitelists or human moderators recognise your domain.
Most of those services also let clients setup their own domain name, so a ban is a more of a inconvenience to deal, than business critical like in OP case.
There are a few options for migrating or synchronizing data from MySQL - I'd recommend starting with this page in the ClickHouse Docs - there is a nice video there that explains some of those options:
Depending on what you are trying to achieve, you could use clickhouse-local with the MySQL engine to move data, or could use an ETL/ETL tool to migrate/sync
Good point. If you just want to copy data far and away the easiest way to transfer data is using MySQLDatabaseEngine. You can even copy table definitions. Watch for issues with Decimal datatypes if you do this.
Be careful with this engine, it's easy to accidentally expose the password as you only need table read permissions if it wasn't set up using an external credential file.
I also had some pretty bad join performance (CH table joined to MySQL table), the quick solution to both of these is that we instead use the table function (https://clickhouse.com/docs/en/sql-reference/table-functions...) to copy the data periodically.
Check out the Altinity Sink Connector for ClickHouse [0]. This is advancing quite quickly and already has prod deployments. Please feel free to try it out.
I think that's one of the reasons, but the main one is economical.
For a long time they dealt with the free accounts, so in a way they have already a lot of protections in place, and if they wanted they could keep the existing free accounts and just not accept further signups for this account type.
If you need to access the client IPs for several reasons (throttling, analytics, security etc), be aware that AWS Global Accelerator still only supports IP preservation in some specific setups: https://docs.aws.amazon.com/global-accelerator/latest/dg/pre...
There are a lot of options in e-commerce, all of them with thousands of shops: WooCommerce, Magento, Jumpseller, Bigcommerce, Prestashop, Wix WooCommerce etc...
In small business stores most users checkout as guests, so the website only has enough info to provide a shipping estimate after they have your address.
At least let me pick a country or something and give me a ballpark.
With a lot of US-only retailers the only way to find out they won’t ship outside the US is to try and checkout and look for a country drop down.
And the ones that will ship, shipping for a small parcel can range from inconsequential (free/$10) through punishing ($80) to absurd ($300).
I don’t need an exact amount, but there can be a couple order of magnitude difference between stores when trying to ship to Canada and often no way to determine they even will at all without going through the checkout flow.
You're saying that email, text messages and phone calls don't work as well as WhatsApp for small businesses? I wouldn't have expected that, so I'm curious if you have examples to share.
It's a country specific thing. I find that my clients in the US generally prefer email, Slack, and Zoom/Google Meet. Clients in India, South East Asia and Africa, and some parts of Europe (Italy comes to mind) very strongly prefer WhatsApp even for business communications.
I noticed a similar thing happens with their regional offices, while Google and other companies show their branding outside the buildings, in buildings with FB offices most of the times you don't know there is one just by looking outside or even at the building reception. At least this was the perception I had from the ones I have seen.
As a current FB employee this matches what I've seen of the offices I've visited. In fact, all swag I've received in the year I've been here also doesn't have FB branding on the exterior.
Regarding the original article, I've received no warnings about wearing FB branded stuff outside, so the warning may have been specific to DC or specific locations.
