MySQL Forums - MySQL & Virtualization

Mysql Host with ESXi 5.1 (no replies)

Pedro Afonso Guerrato Guerrato — Wed, 16 Jan 2013 16:11:43 +0000

Hello to all,

I'm new in this forum, in MySql and in virtualization, then i call here to help me!

I have a native a host for testing with VMware vSphere ESXi 5.1, Intel core i3 processor, 4GB RAM memory and 500GB SATA HD. i have too a VM with 512MB RAM memory,160GB of HD and Ubuntu 12.10 Server like a MySQL Server correctly installed and running.

But when i try do a remote access, the server return this message: "Error No. 2003. Can´t connect to MySQL server on 'x.x.x.x' (10060)".

I haven´t a Firewall and sometimes i have success when i try in interval of 5 minutes between the first and the second try in the access the server in the internal network, but the access from external network does not nothing in any time .

Please, sorry my fake english... I don´t speak english, and please help me.

Thanks to everybody.

MySQL Licensing under VMWare (no replies)

Manuel Donoso Gomez — Thu, 28 Jun 2012 11:26:16 +0000

We’re thinking of virtualize a MySQL Enterprise database on VMware and we’d like to know the correct way to license it.

There are four servers running the VMware environment, and one VM (with MySQL Enterprise) that can run on any of the servers, depending on the circumstances. Should we have to purchase four licenses (one for each server the VM can run in), or just one for the VM?

Thanks in advance

mysql always crash recovery on windows vm (no replies)

Matthew Boehm — Thu, 25 Aug 2011 17:16:37 +0000

Hi,
We have a Windows 2008 R2 VM. We also have MySQL setup properly as a Windows Service.

Whenever we have to restart this VM, when it starts back up and starts MySQL, we always see "starting crash recovery" in the mysql error log.

Why would we always see this?

Is windows not properly shutting down MySQL? If I manually stop/start the service using the Services control panel, I don't see this message. I only see it when I have to restart the VM.

Thanks!

MySQL on Oracle VM (no replies)

Edwin DeSouza — Mon, 11 Jul 2011 22:36:53 +0000

MySQL on Oracle VM:
http://mysql.com/why-mysql/virtualization/index.html
http://www.clusterdb.com/mysql/new-oracle-vm-template-for-mysql-enterprise-edition/
http://www.clusterdb.com/mysql/white-paper-oracle-vm-template-for-mysql-enterprise-edition/

How to install MySql for Windows 7 on MAC VM (no replies)

Vishant Sanghavi — Tue, 05 Apr 2011 13:14:27 +0000

Can any one give me steps or link to install MySql 5.X for Windows7 on MAC VM. When I am installing it just get stuck when it try to write mysql.ini file..

Thanks

MySQL Cluster support on virtualization platform (1 reply)

Laehremet Mistry — Tue, 17 May 2011 10:09:01 +0000

Hi Everybody

The link mentions that MySQL Cluster is not supported on a virtualization platform

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-ndb-innodb-engines.html

However I have implemented the cluster and it works fine on the VmWARE ESX

In case I buy a licensed version of the MySQL Cluster will I get support for the setup which is on Virtualization??

Thanks and Regards
Laehremet

Clustering / Hot Backup Solution (no replies)

Ben Sewell — Thu, 03 Mar 2011 15:47:26 +0000

Just thinking up some project ideas and thought i'd think out loud and put them onto this forum.

We have a number of MySQL applications running and all have their different ways of backing up usually a shutdown of the database. Copying the relevant files and restarting the MySQL service or just snapshotting the machine as their virtual. What i was thinking of was to have a central VmWare based MySQL server that would act as a kind of hot swap / fault tolerance server that would communicate with all the other MySQL servers that were connected to it acting a bit like a data hub.

Then when the backups on the servers were to take place using tools like MySQL dump or other tools then as the database has two nodes, one would be down for backup then the other server would take the load from the primary server until the backup was complete then when that was finished the primary server would come back up online, sync its data and then fully use this server instead of the fail back server.

Is this kind of thing possible with the MySQL community edition? We have lots of systems and are thinking of converting some to MySQl.

Choice hosting (no replies)

Dmitry Sh — Wed, 19 Jan 2011 03:03:46 +0000

Hello, a wont create massege board, bad a don`t know what hosting plan choice? This is hosting, or vps. system requirements for normaly working board,

Thank.
Продвижение сайта

VMware hosting (no replies)

pete mardon — Tue, 11 Jan 2011 19:56:14 +0000

Hi all,
I've got a dedicated server running mysql on centos that I've had for a couple of years now. The performance is not brilliant and I'd like to bring the solution more up to date with some cloud hosting. I'm quite happy to run my application server in the cloud but am concerned about performance on the mysql box. I've been looking at a hosted VMware option - would anyone here care to share their experiences with VMware?

The company I'm looking at is stratogen http://www.stratogen.net/products/vmware-hosting.html
Does this look any good?

Thanks in advance for your replies.

Pete.

high cpu load on mysql vm (no replies)

mark rose — Thu, 16 Dec 2010 22:24:47 +0000

hi,

i'm using mysql 5.0.77-3 on centos 5.2 32 bit, on esxi v4.0.
my vm has 4vcpu(intel E5420 on DL360G5) and 3GB of RAM.
i've started with 1 vcpu, then moved to 2 vcpu, and lately due to high load on the vm, i've reached to the limit of 4 vcpu on the vm.

i see in top that mysql consumes all 4 vcpus and half of it goes to user time, and half to kernel time.
i do not has any IO load on the vm or memory shortage, the cpu is just dead.
i've read on some forums that mysql does not deal well with multiple CPUs.
when adding extra vcpu to a machine should i add any configuration to the vm's OS or mysql config ?

thanks.

Manager Win7 -> it' easy (no replies)

son ha — Wed, 17 Nov 2010 15:23:17 +0000

What is Windows 7 Manager?

Windows 7 Manager is a system utility that helps you optimize, tweak, and clean up Windows 7. It will increase your system speed, improve system security, and meet all of your expectations.

Why Should I use Windows 7 Manager?

Windows 7 is the newest Operating System for home users and professionals alike. Windows 7 brings clarity to your world, so you can more safely and easily accomplish everyday tasks and instantly find what you want on your PC.

Windows 7 Manager is the powerful software tool to tweak and optimize your Windows 7, it bundles more than 30 different utilities in one and help your system faster and more stable, secure and personal!
Features and Benefits of Windows 7 Manager

* Information
Get detailed system and all hardware information on your system; help you find out the installation key of Windows, Office products; show all detailed information of running processes and threads on your machine; Windows 7 Manager offers 1-clicking cleans your system automatically.
* Optimizer
Tweak your system to improve windows startup and shutdown speed; tweak your hardware to increase system speed and performance; Optimize Task Schedule to turn off unnecessary system tasks.
* Cleaner
Find out which files or folders engross your disk space and shown with chart; Find and clean junk files to increase Hard Disk space; Duplicate Files Finder can scan your computer for files with the same size, name and modification time; Registry Cleaner can easily checks your registry and repair incorrectly linked registry entries, automatically remove invalid entries; Registry Defrag rebuilds and re-indexes your registry to reduce registry access time and therefore improve application responsiveness.
* Customization
Control what is started on Windows startup; Create the quick startup items on Taskbar with the Jump List quick launcher; Tune up Windows 7 boot menu; edit context menus of mouse Right-Clicking; customize system desktop, menus, toolbar and notifications settings; customize the look of your system.
* Security
You can improve desktop, menus, Windows logon securities, and enable numerous hidden performance options of system, disable system updates and error reports; hide and restrict to access drives, specify which applications are not allowed to be executed on your computer; encrypt/decrypt and shred files, change the location of system folders; Privacy Protector can maintain your personal privacy by eliminating the tracks that you leave behind; create lots of randomization password once.
* Network
Optimize your Internet connection speed, manage all shares items; tweak your Internet Explorer easily.
* Misc. Utilities
Show the collection of Windows utilities; split and merge any file; Copy and move files neatly, you can also automatically back up files regularly.

And download to link:
http://hotfile.com/dl/82277039/5ed12cc/win7_manager_full__code.rar

VMWare MySQL very slow (2 replies)

Rich Jones — Tue, 09 Nov 2010 06:02:34 +0000

Hi all,

I have Windows 7, VMWare Worstation 7 and Ubunto Hardy 8.04 client (I tried 64 bit client and 32). I have got phpmyadmin running on the host under apache. I have changed the config.inc.php to add multiple hosts and so I can access my MySQL instance running on a VMWare Ubunto Hardy client.

It is terribly slow. It takes 13 seconds to switch from one table to another. I have tried different instances of Ubunto running different instances of MySQL. I have allocated 512Mb and also tried 1Gb memory. Top says the system is doing nothing.

Same problem on all. I tried changing from NAT to Host Network to Bridged Network. They all work but they are all equally as slow. I saw someone saying they had problems with non matching names in /etc/hostname and /etc/hosts so I have checked them. I access the host with hostname:

taer12

I have that in hostname and also in /etc/hosts.

top - 15:52:55 up 30 min, 2 users, load average: 0.00, 0.00, 0.00 Tasks: 55 total, 1 running, 54 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 515432k total, 110748k used, 404684k free, 4980k buffers Swap: 915664k total, 0k used, 915664k free, 64720k cached

Has anyone got any other ideas?

Thanks in advance

Rich

MySQL on EC2 Pricing. (no replies)

Vishal Soni — Tue, 19 Oct 2010 12:53:32 +0000

Hi,

i am currently using MySQL Enterprise Gold Edition to run several applications in my premise. Now i want to move those applications to cloud via Amazon's EC2. Regarding this, i had several doubts as mentioned below:

1) Can i use the same license of MySQL to move onto cloud, or do i need to pay separately for moving on to cloud?

2) I would like to use some of the preconfigured AMI having MySQL 9 avalable on it. For that, is there any seperate charge for using such AMI?

3) Where can i get the pricing details about various AMIs available with MySQL installed on them?

adding cpus (no replies)

Jonny Doh — Wed, 01 Sep 2010 17:07:09 +0000

I'm using ESX4 and are upping the cpu count (from 1 to maybe 2 or 4) for a Linux machine.

Do I have to edit any mysql config for mysqld to take advantage of the new cpus?

Do I have to restart mysqld an additional time after machine is rebooted?

Using Centos 5.5 and MySql 5.1.48.

MySQL Segmentation fault (core dumped) (no replies)

Aldo Zavala — Wed, 28 Jul 2010 18:49:34 +0000

Hello, I have five Virtual Machines running in one vSphere 4.1 / ESXi 4.1 Server, two of them have FreeBSD 8.1 64-bit, and the MySQL client machine crashes once is connected to MySQL Server machine, is there a known issue with this setup?

Here the debug log of my software that crashes when mysql client connects:

2010-07-27 16:14:04 [76029] [0] INFO: Debug_lvl = 0, log_file = , log_lvl = 0
2010-07-27 16:14:04 [76029] [0] DEBUG: Kannel sqlbox version `svn-r4833'.
Build `Jul 26 2010 16:54:17', compiler `4.2.1 20070719 [FreeBSD]'.
System FreeBSD, release 8.1-RELEASE, version FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010 root@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC, machine amd64.
Hostname localhost, IP 127.0.0.1.
Libxml version 2.7.7.
Using OpenSSL 0.9.8n 24 Mar 2010.
Compiled with MySQL 5.1.48, using MySQL 5.1.48.
Using native malloc.

2010-07-27 16:14:04 [76029] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0
2010-07-27 16:14:04 [76029] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'.
2010-07-27 16:14:04 [76029] [0] INFO: MYSQL: Connected to server at 192.168.8.188.
2010-07-27 16:14:04 [76029] [0] INFO: MYSQL: server version 5.1.48, client version 5.1.48.
Segmentation fault (core dumped)

Any help will be sincerely appreciated

Thanks!

Aldo Zavala

Speed Mysql With XEN? (no replies)

Alberto Moreno — Fri, 09 Jul 2010 06:53:18 +0000

Hi.

I wondering, soon I will need to setup MySQL 5.1.x for a ERP project we have. We are going to buy a new server to build virtual machines with Xen on Centos 5.5 and run MySQL on.

I have been running MySQL for a while but not one with the characteristics of a ERP.

I was reading some docs about mysql and exist a topic that took my attention.

Replica.

It say that we can have a Master + N Slaves and we can use the Master for writing to the DB(Insert, Update, Delete, etc) and use the Slave for Select querys, is say that this will make my DB faster.

If this is correct, I was wondering, is a good practice to make this with VM on the same Host?

vm1 ---> Master
vm2 ---> Slave

Or is better to be on different physical machines?

What other topic do u recommend me to read and have Ideas about how to speed up my DB, we have been working hard in normalization, now is time to see the server side.

Thanks!!!

Need a partner for optimizing MySQL on a VM server (1 reply)

Don Andrzejczak — Sat, 05 Jun 2010 12:39:53 +0000

We have a VM server running PHP 5.2.11, Apache 2.2.11, and MySQL 5.0.51a and several of our 'out of house' developers have commented about the speed and performance of our server.

We would like to talk to some partners to find someone to look over our setup and config, and see if they can recommend some tweaks.

Does anyone have any partner resources that would fit our needs.

Regards,
Don

MySQL seems to increase ping at VPS (tried with FreeBSD and CentOS) (no replies)

Anton S — Mon, 15 Feb 2010 17:13:57 +0000

Hello. I have got a website and some weeks ago the ping to it suddenly increased from about 25ms to 600-1000ms. When I shut the mysql down it comes back to norm.
After that I migrated to another host, and took the database intact with me. After I placed the database files, the new host which had ping of about 10ms got its ping as high as 250-350 ms. What in MySQL can cause this, how to check it? The system is not loaded at all (none of the abovementioned) but pings are very high.

MySQL on VMware Workstation/DRBD vs. VMWare ESX Server/SAN (no replies)

Edwin DeSouza — Fri, 22 Jan 2010 18:24:21 +0000

MySQL on VMware Workstation/DRBD vs. VMWare ESX Server/SAN
http://shinguz.blogspot.com/2010/01/mysql-on-vmware-workstationdrbd-vs.html

Installation of MySql on Windows XP (1 reply)

Vivek Kapoor — Wed, 03 Mar 2010 22:18:43 +0000

Hi,
I'm trying to install MySQL on my PC. I'm using mysql-5.1.41-win64.msi as the install package; My PC is running Windows XP and the processor is AMD Athlon 64 X2 Dual Core Processor 4200+ running at 991 Mhz.
When I double click to start the package I get, "This installation package is not supported by this processor type".
Can anyone advise as to what may be the problem? Is this the right package I'm running, or should I be using the 32 bit package for X86 processors?
Thanks,
Vivek Kapoor

select now(); doesn't change (3 replies)

Dirk Müller — Wed, 06 Jan 2010 22:55:35 +0000

hi,

we have a mysql replication (master-master) set up on two VMs (VMware server).
after some days suddenly select now(); doesn't change any more, as if time would stand still. local time using date / time on the console changes as usual.
mysql is 5.1.40, OS is Solaris 10/5.

i was not able to find anything similar in the forum, if i missed it please point me to the post.

thanks,
dirk

MySQL and advanced Vitualization Features (no replies)

Edwin DeSouza — Tue, 10 Nov 2009 22:04:57 +0000

MySQL and advanced Vitualization Features
http://mikefrank.wordpress.com/2009/11/10/mysql-and-advanced-vitualization-features/

VMWare & Xen: mysql memory usage differs greatly (1 reply)

Clayton Bell — Fri, 08 Jan 2010 17:31:38 +0000

Hello forum

I have two identical Red Hat EL 5.2 virtual machines - one running under Xen and the other using VMWare.

The VMWare virtual server swaps out a large amount of memory despite it having enough RAM to hold MySQL and is correctly configured.

The Xen Virtual machine works just fine and is an identical disk image copy of the VMWare virtual machine. The virtual servers have 8G of RAM and MySQL has 6G allocated to it.

I need to use VMWare though... has any one seen this before?

Details of issue:

VMWare issue:
- The resident set size (RSS) of MySQL is 3.5G bytes.
- MySQL virtual size is 6.7G
.. yet free memory is < 100M and swap in use is >800M

Under Xen:
- Virt memory size 6.7G, RSS is 3.5G
- free memory is about 3G - ie total RAM minus total RSS memory

Both the Xen & VMware VM's:have
- 8G ram
- Red Hat EL 5.2 x86_64
- MySQL 5.1.34
- identical disk copies of each other
- only run MySQL and few essential OS processes that don't use much RAM
- physical server has 32G RAM and only one 8G virtual server

Key settings from VM's:
my.cnf: innodb_buffer_pool_size=6000M
sysctl.conf: vm.swappiness = 0
limits.conf: * soft memlock 7340032 # which is 7G
* hard memlock 7340032

does any one know how to tune VMWare accordingly?

Clayton

Mysql service problem with VCB (no replies)

Andrea Comandini — Mon, 19 Oct 2009 14:45:11 +0000

Hello to all,
I have a big problem with MySql service when VCB script starts: i have noticed that when vcb script starts, the Mysql service doesn't work....(the state of this service is started but I didn't connect to the databases....So I insert a new row in my VCB script for restart Mysql service but the problem is that when mysql service doesn't work,the applications didn't save the new data into DBs and it's a big problem....For me it's a VCB problem...How can i solve it? Thank's to all for the answers..

Help on server host (no replies)

cheng zhou — Thu, 13 Aug 2009 04:52:13 +0000

I just installed mysql 5.0, but i don't know what server host name I should use when I try to use can't go into the administrator application in mysql GUI tools. I have an tomcat running on my pc, and wonder if tomcat should be the server host.

By the way, how to configure tomcat and mysql so that they can work together.

Many thanks.

Installing MySQL on vmware fusion (mac os) Windows XP (no replies)

Gonzalo Floria — Mon, 20 Jul 2009 08:06:27 +0000

Hi

Im trying to create a replica of my working environment on my virtual XP running on my Mac OS vmWare fusion.
I first tried installing MySQL 5.0 but I got this error:"This installation package is not supported by this processor type. Contract your product vendor".
Then I tried installing 5.1, but it fails when it tries to configure the local instance. Looks like the service cannot be created, and even if I try to manually start it up, root password is not accepted.

What am I doing wrong?
Is there a guide to MySQL over vmWare fusion/XP?

Thanks in advance.
Gonso

Best virtualization tech for mysql server on linux (1 reply)

Max Ods — Fri, 14 Aug 2009 02:10:25 +0000

Hi,
i'am wondering what is the best virtualizacion technology for mysql over linux? KVM? XEN?

thanks
best regards.

Maximize MySQL Performance on DBT2 Benchmark with Virtualization Technology on T5240 Server (no replies)

Edwin DeSouza — Tue, 07 Apr 2009 23:06:09 +0000

Maximize MySQL Performance on DBT2 Benchmark with Virtualization Technology on T5240 Server
http://blogs.sun.com/luojiach/entry/maximize_mysql_performance_on_dbt2

Virtualizing MySQL, are you stupid? (no replies)

Edwin DeSouza — Tue, 28 Oct 2008 20:04:08 +0000

Virtualizing MySQL, are you stupid?
http://www.krisbuytaert.be/blog/node/757

Virtualizing MySQL (no replies)

Edwin DeSouza — Tue, 28 Oct 2008 15:53:00 +0000

Virtualizing MySQL
http://www.pythian.com/blogs/1321/virtualizing-mysql