Topics

On this page

Amazon AWS
- Amazon ELB and multi-domain SAN/SSL Setup
- Auto Scaling
- Change Instance Type in AutoScaling
Backup
- Duplicity + Amazon S3
Benchmark
- apachebench
- httperf
- Siege
CDN
- Amazon Cloudfront CDN with W3 Total Cache WordPress
- CDN.NET Configuration with W3 Total Cache Wordpress
- CDN77 Configuration with W3 Total Cache WordPress
Composer and WordPress
- Getting Started
- Git and File-System Layout (non-default setup)
- Version Constraints
- Managing Themes and Plugins (for entire WordPress site)
- Updating Themes and Plugins (for entire WordPress site)
- Adding Composer Support to Your Own Themes and Plugins (for developers)
- Using Composer to Manage Own Theme/Plugin Dependencies (for developers)
Docker and WordPress [WIP]
- Docker Compose
- Kubernetes
  - WordPress with Kubernetes using Minikube and Helm on localhost (MacOS)
Git
- Git – Resolve Merge Conflicts
- First time Git setup
- Forking the Git
- Mandatory stages in Git
Gitlab
- Gitlab-CE
- gitlab-ci-multi-runner
KVM
- Convert qcow2 to raw format
- Enable virtio for existing VM's
Mac
- Brew'ing PHP, MySQL & Nginx on Mac OS X
Monitoring
- Latest Monit setup on Ubuntu
- NewRelic Setup for Ubuntu Server with PHP, FPM, Nginx and MySQL
node.js
- Installing ghost with nginx proxy-cache
- Latest node.js & npm installation on Ubuntu 12.04
Plesk
- List Mailboxes Storage and Passwords
Redis
Standards
- PHP
  - Code Sniffer
Vagrant
wpcli
- Finding a faulty plugin
- wp profile command
Linux
- Assigning Multiple IP Addresses to Single LAN Card
- Disable IPv6 on Ubuntu 12.04
- dsh – distributed shell
- fdupes – find & replace duplicate files with hardlinks
- GPG Keys Cheatsheet
- Increase "Open Files Limit"
- kill all php, nginx, mysql or any kind of processes
- Passwordless Authentication for SSH
- Screen
- search replace in multiple files useing grep xargs sed
- Setup sftp
- sysctl.conf
- Timezone Sync
- Using Google Public DNS on Ubuntu Server
- Using openssl to match private key, cerificate and CSR
- Configure Postfix to Use Gmail SMTP on Ubuntu
- Logrotate Example for Custom Logs
- PHP 5.5, MySQL, Postfix, Nginx and WordPress on Ubuntu
- Serverdensity
- Upgrade Ubuntu 10.04 to 12.04
- Using find and sed to replace strings in multiple files
- Webmin
Apache – Turn On/Off Directory Listing
Enabling FastCGI on MediaTemple
Manage SVN Users with htpasswd
Mysql
- .my.cnf – mysql user & password
- Analyse slow-query-log using Anemometer
- Improving MySQL Query Cache
- MySQL Query Profiling
- Reset MySQL root password
- tuning-primer.sh – an alternative for mysqltuner
- Using MariaDB 10
- Install/Upgrade to MySQL 5.6 on Ubuntu 12.04 LTS
- Change WordPress Domain Name
- Character Sets and Collations
- Enable innodb_file_per_table
- Enable Remote Access (Grant)
- Installing Percona Toolkit
- Using tmpfs for temporary folder creation
- YARPP and InnoDB
- Convert MyISAM to InnoDB
- Using tmpfs for mysqldump & mysqlimport
- Convert from INNODB to MYISAM
- Analyse slow-query-log using mysqldumpslow & pt-query-digest
- mysqlcheck with cron to optimize automatically
- Using MySQLTuner to Optimize MySQL configuration
Emails
- Checking FQDN, Reverse-DNS/PTR, MX record
- Clients
  - Apple Mail
  - Mozilla Thunderbird
- DKIM with Postfix
- Postfix Queue Management
- RoundCube
  - Forwarding all mails to other email id
- Server Setup
- Setup OpenDKIM
- SPF Records
- swaks – SMTP test tool
- Using larch for mail transfer between imap/gmail servers
- Debugging Postfix Config, Mail Logs & more
- Increasing Attachment Size in Posfix
Nginx
- Adding $upstream_cache_status in HTTP Response Headers
- Amazon Elastic Load Balancer and Forwarding Real-IP Nginx
- Block wp-login.php bruteforce attack
- Configuring HTTP/2 Server Push
- Enable gzip compression
- fail2ban
- Let's Encrypt with EasyEngine
- Nginx's Open file cache
- Serving fonts with correct mime types
- SSL – PCI compliance and performance optimization
- Troubleshooting
  - Error: pcre_compile() failed: unrecognized character after
  - [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)
- Tweaking fastcgi-buffers
- Using $upstream_cache_status in access.log
- Using Pagespeed
- Weak Diffie Hellman Logjam Attack Fix
- Website access restriction using nginx
- Enable Nginx Status Page
- Forwarding Visitor's Real-IP + Nginx Proxy/Fastcgi backend correctly
- Parsing access.log and error.logs using linux commands
- Debugging Nginx Configuration
- Nginx config for www to non-www and non-www to www redirection
- Optimizing Nginx Configuration
- Rewrite Rules for vBulletin SEO-friendly permalinks
PHP
- Directly connect to PHP-FPM
- Generating core-dump for php5-fpm
- GeoIP
- Having php5 and php7 on same system.
- Install Xdebug and configure it with webgrind
- Installation of PHP Code Review Tools
- memcache
- PHP's Zend Opcache Config & Web Viewer
- Setting Sqlite support with PHP
- Using HHVM with PHP-FPM Fallback
- Using Redis for PHP Sessions on Ubuntu Server
- Installing PhpMyAdmin Quickly
- Moving PHP's session storage to tmpfs
- Install Xdebug and configure it with Netbeans
- Nginx – Enable PHP-FPM Status Page
- PHP-FPM: Socket vs TCP/IP and sysctl tweaking
- APC Cache Optimization & Monitoring Using Web Interface
- Checking if PHP/WordPress can send mails
- Debugging PHP Scripts Using slow_log and more
- Increase file upload size limit in PHP-Nginx
- Increase PHP script execution time with Nginx
ActiveCollab with Nginx + APC Cache
WordPress
- Performance Optimization
- Remove Query string of css/js files
- Setup ElasticSearch with ElasticPress
- Using Redis for WordPress Object-Cache
- WooCommerce Window Shopping Caching Technique
- Moving WordPress To New Server (Faster)
- Better wp-cron using linux's crontab
- 404 error- Page not Found!!!
- Debugging WordPress with Nginx

Last updated on Dec 18, 2020

Mysql