Member Avatar for devat

hi dear all

give me some details for which one of best suitable server for PHP+ mysql ?

Thanks

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 8 Months Discussion Span
  • Latest Post Latest Post by ian_422

Dani AI

Generated

asked a very common question but left out the use-case details; correctly nudged for clarification and brought up OS choice. The single best answer depends on three things: the app (CMS, custom PHP framework, number of sites), expected traffic/peak concurrency, and what the ops team already knows. Before choosing, answer: shared vs VPS vs dedicated vs cloud, estimated daily visitors and concurrent users, and whether Windows-specific features are required.

For practical, commonly used combos: pick a stable server distro your team can maintain (Ubuntu LTS or Debian Stable for fast updates and wide package availability; Rocky/AlmaLinux if you need RHEL-compatible stability). Pair with PHP-FPM plus either Nginx (better for high concurrency) or Apache (easier if you rely on .htaccess). For the DB, MariaDB is a drop-in MySQL replacement many prefer; managed DB services (RDS, DigitalOcean Managed DB) remove operational overhead if you want that.

Operational tips to avoid common pitfalls: run a supported PHP release (see PHP supported versions), enable OPcache, use InnoDB for transactional reliability, enable slow-query logging and tune buffer sizes rather than default configs, and automate backups (binary logs or physical backups for larger datasets). Use Docker or local VMs to keep dev and prod environments consistent. For small sites, a single VPS with SSD and 2–4GB RAM is often enough; scale to separate DB hosts and a load balancer when you hit sustained load.

Quick checklist for next steps: decide hosting model, pick an OS your team can patch, choose PHP-FPM + OPcache, use InnoDB/MariaDB, automate backups and monitoring, and start with realistic capacity planning. PHP supported versions: https://www.php.net/supported-versions.php. MySQL official: https://www.mysql.com/.

Recommended Answers

All 2 Replies

Member Avatar for sibir1us

what do you mean?

Member Avatar for ian_422

If your thinking of a OS choice Linux is preferable, although PHP will run on IIS it can be a bit of a pain to setup if you dont know what your doing

If your thinking hardware then that would depend on what the websties going to be doing

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.