Hello,
I'm in the process of moving my gallery to a subfolder of an existing domain and host it at another host by creating a A Record at current host with the second server's IP.
This works fine already when having the DB hosted at the second server if it's a normal web host. My idea though is to rather use a Cloud host for backups because it is cheaper and they offer more storage. The problem is those kinds of hosts do not provide DBs in those accounts.
Hence my question here: would it be possible to keep the DB at the current host and the whole gallery only at the second one?
Hope my question is clear enough...
Offline
You could try ...
I did something of the kind, not on purpose. I had an hosting contract by Ionos and I took a second one : same hosting provider, but not the same server. When I moved 3 of my sites to the new contract, I forgot to move the data bases and I forgot to modify the setting in the sites for the data bases.
And the 3 sites (among which one Piwigo) are running correctly like that.
But the hosting provider is the same.
Offline
Wow, that sounds incredible! How is that possible?
I cannot try right now because I'll have to move the whole gallery first but will try to create a small test gallery. Thanks!
Offline
The $conf['db_host'] value can specify any ip:port combination (instead of localhost what you may have). But for that to work the database server's mysql must listen, and you very likely do not want that unless in an internal network.
Offline
Oh, I see, many thanks for this.
Although I don't well understand what "listen" stands exactly for a DB, I fully understand that I would not really want this to happen.
Well noted, thanks again!
Offline
erAck wrote:
The $conf['db_host'] value can specify any ip:port combination (instead of localhost what you may have). But for that to work the database server's mysql must listen, and you very likely do not want that unless in an internal network.
I think you mean the mysql database port has to "listen" on port 3306. This is the default port for mysql so it shouldn't be a problem.. On the other hand you might need to open the port 3306 on the firewall to the database host if it is on a different network.
Offline
That I mean, it has to be publicly open, which mostly isn't such a good idea as you'll get hammered with connection attempts (a very strong password on the database account is required anyway).
Offline