OK,
So I'm thoroughly pissed I have to revert back to 1.0.8.0 because hosting providers want to cater to the WordPress crowd.
I have a Lenovo server with dual xeon processors, 32GB RAM, 2-4TB Hds at home running Centos 8 Stream.
I saw where I could install MySQL 5.7.28 but that likely to kill Zoneminder, so I though about setting up a MySQL on a VirtualBox VM. Guess I could set up a Debian instance but I'm more familiar with Centos/RHEL. I run Debian on a couple RPis, Octoprint and PiHole.
Can Phoenix Cart run with a remote DB server and how would I set that up in the config files, const DB_SERVER = 'http://myvm.myhomedomain.com:3306'; ??
MySQL 5.7.28 on a remote/VM server
-
zipurman
- Builder
- Posts: 540
- Joined: Tue Oct 13, 2020 5:20 pm
- Phoenix Version: v
- Has thanked: 93 times
- Been thanked: 162 times
Re: MySQL 5.7.28 on a remote/VM server
I’d avoid running mysql offprem for a ecomm website due to speed.
Have you tried something like:
https://ubiq.co/database-blog/how-to-ru ... e-machine/
Have you tried something like:
https://ubiq.co/database-blog/how-to-ru ... e-machine/
zipurman
-----------
-----------
-
tedukes
- Member
- Posts: 87
- Joined: Wed Oct 27, 2021 11:27 pm
- Phoenix Version:
- Has thanked: 17 times
- Been thanked: 1 time
Re: MySQL 5.7.28 on a remote/VM server
Got it done!!
Had to do most of the set up of the VM via console. Couldn't get VirtualBox Guest Additions installed so copy and paste didn't work. MySQL 8 is tricky. Then I forgot to bridge my NIC. Got firewall and DNS going easily.
Went with MySQL 8.0.28 Community Edition. Took forever for MySQL to update everything. Also have to fix some datetime issues in the .sql for my 1.0.8.0 db.
Admin side works, shop side not so much. I can click on any link except a product. If I click on a product, I get a Down for Maintenance page. Not what's up with that!!
Had to do most of the set up of the VM via console. Couldn't get VirtualBox Guest Additions installed so copy and paste didn't work. MySQL 8 is tricky. Then I forgot to bridge my NIC. Got firewall and DNS going easily.
Went with MySQL 8.0.28 Community Edition. Took forever for MySQL to update everything. Also have to fix some datetime issues in the .sql for my 1.0.8.0 db.
Admin side works, shop side not so much. I can click on any link except a product. If I click on a product, I get a Down for Maintenance page. Not what's up with that!!