Skip to content

Instantly share code, notes, and snippets.

View kopigreenx's full-sized avatar

Mokhamad Rizkianto kopigreenx

13 followers · 16 following
  • ivosights
  • jakarta
  • 08:07 (UTC +07:00)
View GitHub Profile
@kopigreenx
kopigreenx / my.cnf
Created November 1, 2024 15:58 — forked from fevangelou/my.cnf
Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers)
# === Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers) ===
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
#
# ~ Updated September 2024 ~
#
#
# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
#
@kopigreenx
kopigreenx / Laravel and Soketi locally(with Valet) and production(with nginx).md
Created September 22, 2024 12:43 — forked from omego/Laravel and Soketi locally(with Valet) and production(with nginx).md

Laravel and Soketi locally(with Valet) and production(with nginx reverse proxy)

locally (Valet)

Soketi

install soketi:

npm install -g @soketi/soketi

Create a JSON file to run with Soketi. Create a file named soketi_config.json for example and add the following content:

@kopigreenx
kopigreenx / index.html
Created September 11, 2024 05:36 — forked from redgeoff/index.html
Image Paste Textarea
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Paste Image Example</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/bluebird/3.4.6/bluebird.min.js"></script>
</head>
<body>
@kopigreenx
kopigreenx / 2019-https-localhost.md
Created January 17, 2024 11:32 — forked from cecilemuller/2019-https-localhost.md
How to create an HTTPS certificate for localhost domains

How to create an HTTPS certificate for localhost domains

This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.

Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).

@kopigreenx
kopigreenx / navicat_premium_reset_trial.sh
Created January 5, 2024 09:10
Reset Navicat Premium 15/16 remaining trial days
#!/bin/bash
set -e
file=$(defaults read /Applications/Navicat\ Premium.app/Contents/Info.plist)
regex="CFBundleShortVersionString = \"([^\.]+)"
[[ $file =~ $regex ]]
version=${BASH_REMATCH[1]}
@kopigreenx
kopigreenx / smartReadFile.php
Created January 5, 2024 09:01 — forked from benvium/smartReadFile.php
PHP File to allow seeking in HTML5 <audio> tag. NOTE: I did not write this, check links in code for credits.
<?php
/**
* Reads the requested portion of a file and sends its contents to the client with the appropriate headers.
*
* This HTTP_RANGE compatible read file function is necessary for allowing streaming media to be skipped around in.
*
* @param string $location
* @param string $filename
* @param string $mimeType
* @return void
@kopigreenx
kopigreenx / enterprise_token.rb
Created October 9, 2023 06:26 — forked from markasoftware/enterprise_token.rb
OpenProject Enterprise mode for free
############ REPLACE app/models/enterprise_token.rb in the source code with this file! ################
############ also be sure to RESTART OpenProject after replacing the file. ################
############ it doesn't show that enterprise mode is enabled in the settings, but all ################
############ enterprise mode features, such as KanBan boards, are enabled. ################
#-- copyright
# OpenProject is an open source project management software.
# Copyright (C) 2012-2023 the OpenProject GmbH
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License version 3.
@kopigreenx
kopigreenx / nginx-tuning.md
Created November 3, 2022 05:53 — forked from denji/nginx-tuning.md
NGINX tuning for best performance

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.