Hans-Christian Andersen
hans.andersen at phulse.com
Wed Nov 23 19:38:01 CST 2011
Hi John,
I am just forwarding some links I sent someone else the other day regarding the same issue:
Debian:
http://wiki.debian.org/WindowsServerHyperV
CentOS:
http://www.hyper-v-mart.com/Howto/Install_CentOS_5_VM_Step_by_Step.aspx
Ubuntu:
http://social.technet.microsoft.com/wiki/contents/articles/961.aspx
My personal preference is Debian (for more reasons than I can possibly list in a short email) and installing software is pretty easy. To install MySQL, all it takes is to write (as root user on the command line):
# apt-get install mysql-server
You may choose to do some additional configuration after that point. You will find those in the file: /etc/mysql/my.cnf
Then, to start or stop the MySQL server, type either:
# /etc/init.d/mysql start
or
# /etc/init.d/mysql stop
========================
Of course, this is for MySQL, not for MariaDB. Unfortunately, MariaDB has not yet been included into the default software repositories for Debian (or any of the others, I imagine), but you can install the packages from MariaDBs website.
I personally recommend, though, that you set it up in your software repositories, as then you will be informed when there are updates and you can use the systems update mechanism to upgrade/patch things for you, rather than having to do it all manually. It's not hard to add Monty's repositories. If you follow this (http://downloads.askmonty.org/mariadb/repositories/), it will give you some lines to add to the file: /etc/apt/sources.list
Once you add then, run the command:
# apt-get update
This will refresh the repository database. Then search for software package name:
# apt-cache search mariadb
This will list software packages with their name and description. Use that name with the following command:
# apt-get install {name}
Most likely it will be:
#apt-get install mariadb
Pretty trivial.
- Hans
On 2011-11-23, at 2:23 PM, Darryl Collins wrote:
> "I look forward to discussing MySQL with everyone interested in the subject."
>
> Count me as 'interested'. Your posts are usually highly educational John and I appreciate you taking the time and effort to share your experiences with the rest of us.
>
> Cheers
> Darryl.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, 24 November 2011 3:35 AM
> To: Access Developers discussion and problem solving; VBA; Sqlserver-Dba
> Subject: [AccessD] Clearing the decks for MySQL
>
> I run three VMs pretty much 24/7 here at my home office, one which I call vmDev which is my development machine, another is my Accuzip third party software vm and one final machine runs SQL Server Express for Access clients coming in over the internet. I had a dedicated server for VMs which I actually just upgraded to a new motherboard, DDR3 ram etc in preparation for the new AM3+ bulldozer processor. Given the weak performance of the new processor I am hanging out waiting for the next rev / price drops before taking that plunge.
>
> what I did do however is move all three of those VMs off onto my 16 core SQL Server machine. The only VM which truly needs much horsepower is the Accuzip VM and my performance dropped by half when I did the move. Whereas I was getting about 8-9 million records / hour on the dedicated VM Server, on Azul SQL Server machine I am lucky to get 4.5 million per hour. The difference is mostly just the core speed. The Magney-Cours server chips that I could afford run at 2.0 ghz and have ddr3 1300 memory (registered and ECC), whereas the new motherboard has DDR 1600 memory and a quad core Phenom lightly overclocked to 3.3 ghz. The additional clock speed and memory speed apparently makes for significant additional horsepower.
>
> Anyway, I have decided to take the speed hit on the Accuzip VM in order to clean off what was my dedicated VM server and use that for a MySQL machine. As servers go this machine is somewhat wimpy with 4 cores and 16 gigs of memory but for learning MySQL it should suffice.
>
> There has been a bit of interest expressed in MySQL, with some list members already using it and others trying to learn it. I count myself in the trying to learn it crowd.
>
> My intention is to go with MariaDB. Since I have Hyper-V running on this machine I am thinking about running mariaDB itself on a VM which would allow me to move the VM should I decide to keep it.
> I have to say I am not having a lot of luck getting a Linux distro running on a Hyper-V VM, but if I can make that happen that would be my preference.
>
> If anyone out there has experience getting a linux distro running in a Hyper-V VM running MariaDB let me know.
>
> I look forward to discussing MySQL with everyone interested in the subject.
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com