Best server environment for my newest client

So this morning I received some great news, a contract I have been trying to get looks like it is coming my way.
I need to rebuild an existing website with an 84000 page front end, and a backend that controls the entire thing.
It is obviously a very dynamic website, where there are really only about 10 page templates that will pull different content to create the end result.
The existing site shows 244gb of data on disk with a 13gb database.

So I am going to be doing all this Wappler, question is if @George, @Teodor and @patrick had to advise what would be the most compatible or rather fastest components / packages to use.

The server is theirs for now so i have to start off using that, the choices i do have though are
PHP 5.4
PHP 5.5
PHP 5.6
PHP 7.0
PHP 7.1
PHP 7.2

MariaDB 10.0
MariaDB 10.1
MariaDB 10.2
MySQL 5.7
MySQL 5.6

While I am inclined to imagine that the fastest versions would be the latest versions, and inclined to think that the latest Wappler would be most compatible with the latest of each package, I figured I best check before I begin to make sure this works flawlessly with Wappler.

Any advice is welcome, I have never dealt with such a large website or database for that matter so really want to make sure it is stable, fast, secure, etc.

Hi Paul,
PHP 7.2 and mysql 5.7 would be perfect.

1 Like

13GB of data, what on earth are they storing, must be more than just text data
I agree with Teodor PHP 7.2 and MySql 5.7 is the way to go

Thanks so much, appreciate the version advice.

One more thing is the entire website will also work with GeoLocalisation, the only one I have ever used is GeoPlugin which works very well for my needs of altering currency based on user location as well as content to some degree, the concern i have with the plugin is that to get to the functions i need i have to use the php API they provide and that means I have to enable
allow_url_include and allow_url_fopen
Does Wappler have any concerns with turning on those in my php configuration?

@Teodor, it’s been over a year since your post on this thread so I’m curious to know if your go to recommendation for server environment is still PHP 7.2 and MySQL 5.7?

I’m asking because I notice that, in the latest version of Wappler, PHP 7.3 and MySQL 8.0 seem to be the default options when creating a Docker container.

In my case I’ll be creating a file sharing web app that allows users to upload, store and download files with varying levels of admin access.

Would love to hear from @Hyperbytes and @psweb on this as well.

Much appreciated!

Hi @eddie5
It’s up to you whether to use PHP 7.2 or 7.3 - we just packed the latest version in Docker, so whatever version you choose you it’s perfectly fine!

1 Like

Thanks, @Teodor!

In regards to the database, would you recommend MySQL 5.7 or 8.0?

You can safely use Mysql 8, again we integrated the latest version there :slight_smile:

1 Like

Great…thanks again, @Teodor

Does Wappler recommend (or better support) one database type over another. For example, would you recommend MySQL over PostgreSQL or visa versa?

My advice is simple, use the most recent release of both

P.S. i am on PHP 7.4