Migrating Database

Re: Migrating Database

by Ken Task -
Number of replies: 0
Picture of Particularly helpful Moodlers

Well, we've been in private communication ... but no response yet.   So for others that might interested in trying Google Compute Engine ...

First, **don't** install Bitnami's + Moodle offering from Googles MarketPlace.   While it sounds good, it ends up being one off for things like updating/upgrading Moodle + it provides their vision of apache/mysql/php and provide no native (yum) way of updating/upgrading any of those.  

Not really needed as yum with some added repos will be much much easier to update/upgrade all the parts a pieces that run Moodle.   One is much better off using yum with 3rd party repos ... webtatic or remi or epel to acquire PHP and MySQL's own repo to acquire/maintain MySQL.

https://webtatic.com/projects/yum-repository/

https://dev.mysql.com/downloads/repo/yum/

Google Compute Engine doesn't provide cPanel nor Plesk but one can install Webmin via command line.

Just don't use Webmin default for port 10000 ... GCE projects have a firewall of their own and it's much easier to use port 8080 (Firewall issue) for Webmin.

Webmin is perl based and has a web service of it's own ... + Webmin can update itself ... either via Webmin or via command line. http://www.webmin.com/ + it also has a rather weak terminal via browser but it can be used without having to use the GCE ssh link.

htttp://www.webmin.com/download.html find the link to the .tar.gz download, and use wget in a shell on the GCE instance to xfer the .tar.gz to your Google instance:

https://downloads.sourceforge.net/project/webadmin/webmin/1.900/webmin-1.900.tar.gz?r=https%3A%2F%2Fsourceforge.net%2Fprojects%2Fwebadmin%2Ffiles%2Fwebmin%2F1.900%2Fwebmin-1.900.tar.gz%2Fdownload%3Fuse_mirror%3Dnewcontinuum&ts=1553194868

The 'trick' to GCE is getting things setup via command line.   But, in the GCE Cloud/Project Console there is ssh/open in browser window ssh/terminal access to the instance.

To use root one must use sudo -s.

Once one has access, and sets up the public ip address for site and installs those 3rd party repo's mentioned + Webmin .. it is no different than VPS's on RackSpace, or LiquidWeb, or Host-Ed, or HostGator etc.

GCE can install and use git.   So initial install of the moodle via git best.

Already have one there installed the old way?  No problem ... side load:

https://sos.sosoftexas.org/blog/?s=side+load

'spirit of sharing', Ken

Above is very brief and the reason I mentioned 'not for the tech challenged' ... does require some server admin but it's stuff one will be very glad they learned, IMHO!

Average of ratings: Useful (1)