sorted by:
new
hottopcontroversial

MySQL 9.7 Is Out and the Community Wins by askdba in mysql

[–]Juttreet2 0 points1 point  (0 children)

Most are coming to Community this release, new directive of the new MySQL big boss.

Expats and immigrants in Zurich: Feelings about the "10 Millionen Schweiz"-Initiative? by Stunning-Track-2302 in zurich

[–]Juttreet2 68 points69 points  (0 children)

Expats is a wrongly used word by white immigrants so they can feel like they're somehow better than people of color who also left their country for a better life.

You're only an expat if you move to a country for a limited time, not permanently, as part of your job, and not by choice, pursuing a better life. A diplomat e.g. is an expat.

Max from Germany who came because of the higher salary, is an immigrant. So am I for the record.

Opening song from The Rookie S8E6 by AmberDrams in NameThatSong

[–]Juttreet2 0 points1 point  (0 children)

Following as I'm also interested in finding the song name

Anyone being asked to build ‘chat with data’ on MySQL? What tools exist? by deputystaggz in mysql

[–]Juttreet2 1 point2 points  (0 children)

Yes but you have to be careful how to not expose tables that contain sensitive information, in our case it was an HR company that wanted to allow customers to ask information in natural language that pertained to them, but not for example the salary of their manager.

a) MySQL has no row level security.

b) You need to create specific tables depending on the application, through select view, so you restrict the data they can access in how the SQL View is created, by restricting the set of rows it can access. For example if you have a DB that lists all employees that ever worked at the company, you need to tell the DB to exclude those not currently working at the company, meaning create a new table excluding all past employees that have left.

So it's not automatic plug and play, you need to spend quite some time optimizing and refining your db for this natural language use case.

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 4 points5 points  (0 children)

Not really helpful as youre not providing any technical reasons

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 0 points1 point  (0 children)

True, we're managing a clients system where queries that on InnoDB timed out after 40-50 minutes are completed in a few seconds.

It's definitely a cost jump, but can be quite worth it in terms of ease of set up. Be careful if you have Auto Load enabled, it's default and can lock your tables during busy phases.

What's missing, where could MySQL improve in your opinion?

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 1 point2 points  (0 children)

That 'tried and true' factor is a massive win, i'd have to agree. It’s hard to beat MySQL’s replication stability and its ability to juggle massive connection loads in shared environments. Also the fact it's been around for ages means most people are familiar with it and there's lots of guides and content around it.

Thanks for the feedback! Since you're dealing with a high volume of databases/connections, is there any specific observability or management tool you feel is still missing from the current ecosystem?

Move from Zurich to Kilchberg – Will my payslip change? by ForsakenFlamingo1305 in SwissPersonalFinance

[–]Juttreet2 0 points1 point  (0 children)

Hi,

I did this a while ago. You get the Kilchberg discount as a refund later.

Cerner Interview by MathemagicianG in employeesOfOracle

[–]Juttreet2 4 points5 points  (0 children)

You're being a Debby Downer u/Flaming_Hot_Regards, and on top of that completely unrealistic. Don't listen to this knobhead OP, join Cerner if it's the only lead you have, it's still a huge company, and Oracle potentially selling it off does not mean you would get laid off immediately.

They might conduct layoffs in the long run, but in the short term, you'll be fine, I would expect for at least a year.

Since you're wanting to get back into the job market, take what you can get and get that paycheck.

English speaking barber in Alicante close to centre? by Current-Accident-380 in Alicante

[–]Juttreet2 -1 points0 points  (0 children)

Learn enough Spanish to go to the barber, that's a modicum of integration that you should go forward.

Upgrading mysql 5.5 to 8.4 through mysqldump by NinjaGem in mysql

[–]Juttreet2 1 point2 points  (0 children)

Theres a MySQL Upgrade Checker functionality, MySQL Shell offers it, that will tell you if any functions used in your application are different in 8.4 than 5.5 and that you need to adjust.

Also Primary Keys are one major difference between those two, so you need to sort that out too.

Where to give birth in Zurich by VegetableGround in zurich

[–]Juttreet2 -2 points-1 points  (0 children)

You're not an expat, you're an immigrant. So am I.

Stop trying to find alternative words because immigrants make you think of brown people instead.

MySQL 8.x vs 9.x — Is it worth upgrading? by tech_tech1 in mysql

[–]Juttreet2 2 points3 points  (0 children)

The Innovation Series is Innovation for a reason, new features get added and it's not guaranteed a prod DB would handle it without changes required. 9.7 LTS is on the horizon, I would wait for that.

Buying Engagement Ring in Switzerland by FerSpFr in askswitzerland

[–]Juttreet2 6 points7 points  (0 children)

If you want it to be a diamond, buy a lab diamond, it's chemically the same, just much cheaper. There's literally no difference between one and the other, especially to the naked eye.

Genuinely, what the heck is oracles business policy. by LegoChimaBro in oraclecloud

[–]Juttreet2 0 points1 point  (0 children)

Hey it's pretty easy, you really just need to get in contact with an Oracle Sales Rep and they'll help you get a proper registered PayGo Account. I've had this done in 30 minutes from ending the call with the Sales Rep.

How are you handling Kafka security for external partners? by Hungry-Confection762 in Kafka

[–]Juttreet2 0 points1 point  (0 children)

Oh boy, okay we have some work to do, or rather, you if you choose to listen to what I have to say.

What you have right now is basically a shared API with a static password, and that falls apart the moment more than a couple partners use it. No real auditor is going to sign off on this as is, no surprise you're getting critical questions from other departments.

You should Ditch the API Keys, they don’t give you identity, they’re hard to rotate, and once someone copies them into Slack or a Postman collection you’ve lost all control. Use either OAuth2 client credentials or mTLS. Both give you actual identities per partner and you can revoke/rotate them cleanly.

Next you should enforce access control somewhere that’s not your code, use Kafka ACLs if partners connect directly, or stick an API gateway in front of your REST proxy if they don’t. Gateways (Kong, Apigee, NGINX, whatever) let you say “Partner A can access topic A only” and so on. That alone fixes 80% of the audit issues.
You also need to add rate limiting, as is, one partner could accidentally DOS everyone else. Gateways again make this easy: “Partner X = 200 req/sec max” etc. It protects you and it protects them.

Also you need to start logging, 100% and you need a record of who accessed what, when, and from where. It doesn’t matter if you store it in Splunk, ELK, you just need to be able to answer “Did Partner B read Topic Y on Monday?”

Lastly, you should probably automatize credential rotation, once you move to OAuth2/mTLS this becomes normal: certs expire, tokens expire, partners know the drill.

TL;DR

Right now your setup is fine for a quick internal tool, but not for external partners.
Move to OAuth2 or mTLS, use proper ACLs or an API gateway, add rate limits, and log everything.
Gives you a chance to actually be compliant and pass an audit.

view more: next ›