New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
unable to install mysql 5.5 on openvz?
Hi,
Can you install MYSQL 5.5 on OPENVZ ?
I tried many way to install MYSQL 5.5 on OPENVZ VPS and get failed. I used XEN / Virtualbox before... not sure if it is a openvz problem or vps host template issue ?..(i'm using ramhost.us TinyVZ)
tried:
- different source & repos (mysql standard, MariaDB, Percona, Dotdeb..etc)
- different OS (CentOS, ubunut, debian..)
Googled error log and tried different solution and not worked. so I guess its maybe a openvz ?
Comments
You sure can. Post your error logs .
http://www.lowendtalk.com/discussion/823/another-set-of-scripts#Item_4
I'm pretty sure it should work on openvz
It does work on OpenVZ.
I recently updated PHP to latest, and Mysql needed an update to 5.5. Here's how it worked on Centos (OpenVZ) and this is how to update both PHP and Mysql, if you want Mysql alone, try skipping steps 1,2 3 and 5, and in step 4 just run "yum update mysql":
Thanks ALL
I tried @TigersWay script. I figure out the problem is.... I enabled innoDB.
111212 11:06:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111212 11:06:18 [Note] Plugin 'FEDERATED' is disabled. 111212 11:06:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111212 11:06:18 InnoDB: Compressed tables use zlib 1.2.3.4 111212 11:06:18 InnoDB: Initializing buffer pool, size = 128.0M 111212 11:06:18 InnoDB: Completed initialization of buffer pool InnoDB: Error: pthread_create returned 11 111212 11:06:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
so why can't enable innoDB ?
Can you tell your vps specs?
@tux
128 MB Dedicated RAM 256 MB Burstable RAM 10 GB Disk Space Kernel 2.6.26
Debian GNU/Linux 6.0 32 bits.
free -m
Mem: 256 44 211 0 0 0
df -h
/dev/simfs 10G 453M 9.6G 5% /
Innodb uses way too much memory to even bother trying to run it on a 128. I don't know how much the memory usage can actually be reduced while keeping innodb enabled, but the default config never runs for me on a 128 either, even with burst.
Added to that yum memory usage (if you will update in Centos), as it needs a bit more RAM than Debian/Ubuntu during update.
And I did it hardly on 384 burst memory, I think it took over 300 Mb for just Mysql 5.5 when innodb was enabled. Maybe 256 ram will work if you try Debian 5 32 bit and kill as much services as you can.
Edit: you are using Debian already, so it may help if you checked my last post for why you are getting an error.
Thanks @NickM & @Go59954,
I will try to figure out how much ram does it needed on VirtualBox.
MySQL 5.5 changed their confinguration syntax. Here is mine for MySQL 5.5:
We had some discussion in this thread as well I believe:
http://www.lowendtalk.com/discussion/460/nginx-1.0.8-on-dotdeb/