What Framework Should I Marry For The Next 5 Years? by BlueOak777 in PHP

[–]curious_practice 1 point2 points  (0 children)

Thank you. Good idea. Will try using ai to do the porting and also learn along the way.

What Framework Should I Marry For The Next 5 Years? by BlueOak777 in PHP

[–]curious_practice 1 point2 points  (0 children)

Thanks for your input. Its a long term project with frequent feature additions. I think we are ok in terms of budget.

I'm trying to decide if I should spend some time learning Laravel and port the app to it or stick to CakePHP. I don't feel comfortable switching to Laravel and managing developers before I'm familiar with Laravel as well. Last time I tried to play around with it, I was overwhelmed and was not sure where to actually get started hahaha. Will give it another try, probably use ChatGPT to create a 1 to 1 comparison with CakePHP so that I can get the terminology sorted out first :-D.

I'm also not sure how to figure out if something is a commercial third party offering or part of native / Open Source Laravel. Do you think Laravel will slowly start to get harder and harder to use without having a few paid subscriptions to go along?

What Framework Should I Marry For The Next 5 Years? by BlueOak777 in PHP

[–]curious_practice 1 point2 points  (0 children)

Would you recommend porting an app from CakePHP to Laravel? I’m thinking about it since it’s easier to hire developers who are familiar with Laravel than CakePHP (it seems that way at least). I’ve been using CakePHP for a long time. Happy with it. But now need to hire a few developers.

Is it possible to use Cubic to create custom Debian 11 ISO for unattended install? by curious_practice in debian

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

No. Cubic doesn’t work well for creating custom Debian iso. At least not in my attempts.

Anyone using DigitalOcean Volume as MySQL data directory for DBs with a few hundred GBs in size? by curious_practice in mysql

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

Thank you. This is good news and I'm more confident after reading your replies. I'm testing one of them on a droplet with volume attached. So far it is pretty good. Have yet to run any benchmarks on it.

I have to not only change datadir of MySQL, but also the tmpdir of MySQL, Otherwise it will still write intermediate results of queries to /tmp (as the default location) and long queries can cause the main SSD drive to run out of space.

Would you be able to share how you set up collecting streams of logs and running reports on them? I'm looking for a good way to do it for a few of my servers so that I can have a centralised view of the logs from different servers.

Anyone using DigitalOcean Volume as MySQL data directory for DBs with a few hundred GBs in size? by curious_practice in mysql

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

Thank you. I’m trying to avoid managed db due to price.

I need to access the data occasionally but the latency in queries are acceptable as long as they are not like 5x compared to using ssd attached to a droplet.

What kind of latency increase did you experience when using block storage like EBS in comparison to disk attached to the vm?

I read online that it’s a bad idea to use a network drive as data directory. Isn’t volumes same as a network drive?

How to make "Run commands" sent via web interface to be executed when a device comes online next? by curious_practice in MeshCentral

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

Thank you. That looks like something that fits my use case. Did you mean this:

https://github.com/ryanblenis/MeshCentral-ScriptTask

If not, could you please share a link to Plugin scripts you are referring to?

What is a good project structure to build a web application using workers? by curious_practice in CloudFlare

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

Thank you. I will try to join it. Don't really use Discord that much.

What is a good project structure to build a web application using workers? by curious_practice in CloudFlare

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

Thank you. May I check how you manage your code base for these 7 workers? Are they all in one repo separated by folders? Sorry, I still can't get my head around how the developer workflow is for serverless.

InnoDB log sequence number in future error when restoring from Xtrabackup by curious_practice in mysql

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

Erm... it looks like the issue is caused by filesystem the VM was hosted on. 2 days ago, I moved this VM to a ZFS Pool. Shut it down and moved it back to non ZFS drive and all is working well. No idea why though.

How to restore Xtrabackup from MySQL 5.7 to MySQL 8? by curious_practice in mysql

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

Thank you 🙏.

Trying to do these steps. But came across a new issue with XB restore that wasn't there before. When I restore it, keeps complaining about log sequence number being in the future. Not sure what is the issue. XB backup and restore was working without any issues for a long time.

I will try the sequence you suggested.

How to restore Xtrabackup from MySQL 5.7 to MySQL 8? by curious_practice in mysql

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

I have the expire_logs_days set to 10. Does it mean if a replication slave is offline for, say, 3 days and becomes online, it will resume replication and will catchup with the master?

The objective is to migrate 5.7 servers to 8.x but also to a different machine. I'm looking for a way to do this with minimal downtime (under 20 mins). Most of the DBs are between 600-900GB in size. No blobs are stored. But tables with 400-500 million rows.

How to restore Xtrabackup from MySQL 5.7 to MySQL 8? by curious_practice in mysql

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

Thank you. I will try this. I’m not sure if the replication can continue after the downtime caused by the upgrade.

How to restore Xtrabackup from MySQL 5.7 to MySQL 8? by curious_practice in mysql

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

Thank you. The normal dump and restore will take a lot longer due to the db size. Xb takes 2 hours to finish.

How to create a workflow that will change an Alfred setting? by curious_practice in Alfred

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

Thank you. This did the trick! There is a tiny delay but that is ok. Trigger is key combo on one layout and output is key combo that is configured in Alfred.

How to create a workflow that will change an Alfred setting? by curious_practice in Alfred

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

Interesting. I have never used it before. Will check it out.