Moodle in English: MySql on new openSUSE 10.2 install

MySql on new openSUSE 10.2 install

by Eric Henson - Monday, December 11, 2006, 3:16 PM

Hello,

I am about to setup a new openSUSE 10.2 server and I read from some on this forum that we should set MySql to use InnodDB tables and to change the max_connections on the configuration file. My question is, should MySql be installed during the install of openSUSE, or should I install it seperate from the RPM file on the MySql website so that I can configure these settings during the install of MySql?

If those settings can be configured on the MySql that comes on the openSUSE CD, then where can these settings be configured?

I currently run many MySql databases, but they all run on a Windows server, so I was able to tune the settings for these using the configuratin wizard during the database installation, but I have not seen this on MySql in Linux.

Any help would be appreciated, thank you

Re: MySql on new openSUSE 10.2 install

by Visvanath Ratnaweera - Thursday, December 14, 2006, 7:27 PM

> My question is, should MySql be installed during the install of openSUSE, or should I install it seperate from the RPM file on the MySql website so that I can configure these settings during the install of MySql?

Definitely you can install, uninstall, reconfigure MySQL an any time! Since you are familier with databases, I don't have to tell the obvious: During a reinstallation you have to think about data migration!

Provided that SuSE packages are relatively new. Moodle 1-7+ for example need MySQL > 4.1.16 (haven't checked).

> If those settings can be configured on the MySql that comes on the openSUSE CD, then where can these settings be configured?

That is a SuSE-specific question. I'll do a search for my.cnf in the system. (Hope somebody else can give a more helpfull answer ;-()

Average of ratings: -

Re: MySql on new openSUSE 10.2 install

by Eric Henson - Saturday, December 16, 2006, 11:32 AM

Thanks for your response, openSUSE 10.2 comes with MySql 5.0.26, but I am probably going to install it afterward so that I can set all of the configurations that you do during the MySql installation. I have only supported MySql on Windows servers in the past, so I am guessing that the RPM install on Linux will be similar to the windows install.

If you feel that the default install of MySql on openSUSE is sufficient, then I will just use the one that comes on the distribution disk.

Average of ratings: -

Re: MySql on new openSUSE 10.2 install

by Visvanath Ratnaweera - Sunday, December 17, 2006, 3:31 AM

I hope, you are not going to install a production machine on your first try ;-(

If your main interest is Moodle, then install first the all the LAMP components your distribution brings, in this case SuSE, and run a rest site!

In other words, my advice is to install MySQL (and PHP and ...) from the OpenSuSE 10.1 installation system you use.

Only if they give problems (too old, which I don't think or missing important features) then come back.

Average of ratings: -

Re: MySql on new openSUSE 10.2 install

by Eric Henson - Sunday, December 17, 2006, 4:59 AM

I have been testing Moodle on many different configurations using VMWARE to create different senarios and instelation configurations for that last few months. Currently, I have 3 test installs of Moodle running differnt configurations to help narrow down settings and packages to use on the server. My goal is to just make the most simple install possible, simple Apache, PHP, MySql install using the provided applications with the openSUSE distribution. The versions that come in openSUSE 10.2 are:

Apache 2.2.3
PHP 5.2
MySql 5.0.26
GD 2
spell .6
zip and unzip (latest)
CLAMAV (latest) with easy online update engine in Yast for the CLAMAV software

I am choosing SUSE for many reasons, one is that I have many more hours invested in supporting it in a production environment than any other distribution. SUSE has been very easy to troubleshoot and work with, which I consider ease of troubleshooting makes for more reliable system.

I will be running it in "run level 3", but with the option to "startx" if I need it for anything that I dont know how to do in console. I am also considering using Webmin for an extra admin tool for certain tasks.

So far, the default software in openSUSE has given me very nicely running Moodle systems, and with the GUI not loaded, the OS is using very little RAM. <150 MB using the "free" command after initial bootup.

I am currently starting an "open source users group" in my area and I plan to promote Moodle use in my area, but my install will be providing most of the teacher class pages for more than 12 high schools and about 15 middle schools. I am starting out with one server, but when the demand goes up, I will have plans to add more servers in the future when needed.

My server will be a Dell PowerEdge 2950 with 2 - Dual core Zeon's, 4 GB RAM, and 6 - 146 GB SCSI drives in a RAID 5 array. This should be enough server for at least the first year or two while people start to learn how to use it.

Thanks for all of your advice, you have been a great help while learning how to setup a large production server.

Average of ratings: -

Re: MySql on new openSUSE 10.2 install

by James Tremblay - Tuesday, December 19, 2006, 9:43 PM

would you care to share you openSUSE experience with us.
en.opensuse.org/education
thanks James

Average of ratings: -

Re: MySql on new openSUSE 10.2 install

by Eric Henson - Wednesday, January 10, 2007, 6:48 AM

James,

So far, my openSUSE 10.2 server has given me no problems at all, and I highly recommend openSUSE 10.2 for a LAMP server as long as you run it in "run level 3" during normal operation.

Currently, I am tweaking the user policies, and skin design which are taking allot of time, but will be worth it when the skin design is finished.

I am currently working with a few other Counties that are rolling out Moodle also, but we are all basically coming up with use procedures by trial and error. If anyone is using Moodle in a K12 environment, I would be very interested in hearing more about how you manage users, classes, and security.

Average of ratings: -

Hardware and performance

MySql on new openSUSE 10.2 install