/BlogZero-Cost Cloud
Ranjan 
Quick Answer: To optimize MariaDB or MySQL for a 2GB or 4GB Linux VPS, edit /etc/mysql/my.cnf and allocate 65% to 70% of available RAM to the innodb_buffer_pool_size (1.4GB on a 2GB VPS, 2.8GB on a 4GB VPS), limit max_connections = 80, set innodb_log_file_size = 256M, and increase table_open_cache = 4000 to prevent disk I/O bottlenecks. … Read more
Quick Answer: To increase the phpMyAdmin upload file size limit from the default 2MB to 512MB+, adjust 4 core PHP directives in your active php.ini file: set upload_max_filesize = 512M, post_max_size = 512M, memory_limit = 512M, and max_execution_time = 300. In cPanel, navigate to Select PHP Version > Options or MultiPHP INI Editor to apply … Read more
Quick Answer: To export a large MySQL database without locking production tables, execute mysqldump -u username -p –single-transaction –quick dbname > backup.sql. To import a large SQL dump without web browser timeout errors, execute mysql -u username -p dbname < backup.sql (or pipe through pv backup.sql | mysql -u username -p dbname for live progress … Read more
Quick Answer: By default, Cloudflare only caches static files (images, CSS, JS) and passes all HTML requests to your origin server. Configuring “Cache Everything” Page Rules / Cache Rules caches the entire generated HTML page across Cloudflare’s 300+ edge data centers, delivering instant sub-30ms TTFB worldwide while safely bypassing the cache for logged-in administrators and … Read more
Quick Answer: To create a subdomain in cPanel, navigate to Domains, click Create a New Domain, enter your subdomain (e.g. staging.yourdomain.com), uncheck “Share document root”, and specify a custom directory path (public_html/staging). For Wildcard Subdomains, create a domain named *.yourdomain.com and point DNS A record * to your server IP. ⏱️ 5 min read (934 … Read more
Quick Answer: DNS TTL (Time to Live) is a numerical value (measured in seconds) that tells recursive DNS resolvers and ISP caching servers how long to cache a DNS record before requesting fresh data from the authoritative nameserver. 24 to 48 hours before migrating a website, you should lower your A record TTL to 300 … Read more
Quick Answer: To transfer a domain name between registrars with zero website or email downtime, decouple your DNS by routing through an independent nameserver (like Cloudflare or CpanelFree), unlock the domain at your current registrar, obtain the EPP / Authorization Code, initiate the transfer at the new registrar, and approve the ICANN transfer confirmation email. … Read more
Quick Answer: To check global DNS propagation live, use free web-based lookup tools like WhatsMyDNS.net or DNSChecker.org to query over 50 global geographic nodes simultaneously. For command-line sysadmins, execute dig +trace yourdomain.com or nslookup yourdomain.com 1.1.1.1 to trace DNS resolution directly from root nameservers. ⏱️ 5 min read (924 words) 🛡️ Verified on Ubuntu 24.04 … Read more
Quick Answer: Cloudflare Error 525 (SSL Handshake Failed) indicates that the TLS connection between Cloudflare’s edge proxy servers and your origin web hosting server failed. To fix it, ensure an active SSL certificate is installed on your origin hosting server (via cPanel AutoSSL or Certbot), verify port 443 is open on your origin firewall, and … Read more
Quick Answer: The DNS_PROBE_FINISHED_NXDOMAIN error occurs when the Domain Name System cannot resolve a domain name to an active IP address (Non-Existent Domain). To fix it as a user, flush your local DNS cache (ipconfig /flushdns on Windows or sudo dscacheutil -flushcache on Mac) and switch your DNS to 1.1.1.1 or 8.8.8.8. As a webmaster, … Read more