similar to: mysql & xen - is anyone using this combination successfully?

Hello, I've only had experience with PostgreSQL sofar, but have now to install MySQL (and WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin -u root password 'xxxxx' # /usr/bin/mysql_secure_installation Then I've noticed that

Hello. I would like to ask about having mysql data hosted on glusterfs. Please see my issue below. I have posted DEBUG log information on pastebin. I am using GlusterFS version: glusterfs 1.4.0rc7 FUSE Version :fuse-2.7.3glfs10 my ISSUE is: When hosting mysql data on glusterfs I have an issue: The first time I start the glusterfsd server using [root at mohan ~]#

I have set up an cluster with ocfs2 on top of drbd in primary/primary mode. As long as the datadir is in /var/lib/mysql, everything works fine. But as soon as I put the datadir on the ocfs2 filesystem /mnt/data/mysql mysql fails with: [Ubuntu] root at fs2:/etc# mysqld --safe-mode 090930 18:08:14 [Warning] Can't create test file /mnt/data/mysql/fs2.lower-test 090930 18:08:14 [Warning]

Hey all, I've been having some trouble creating a mysql user that can connect to the database from localhost. It's always been a straight forward thing to do in the past, so its time for a sanity check, if you guys don't mind. Ok, so here's the actual command with actual simplified password that I'm using. It's on localhost so I don't think it's a security threat

I'm having some problems getting two nodes to mount a shared gluster volume where I have the MySQL data files stored. The databases are Innodb. Creating the volume on the master server works fine and it mounts, and when I mount that on the first mysql node it works fine, too. However, when I try to mount it with the second node I get this error: InnoDB: Unable to lock ./ibdata1, error: 11

Hi, i''ve a big problem in a xenU (256M RAM, 2.6.11.12-xenU, in 3 LVM partition (/, swap and /home) This xenU freeze and crash with this messages in syslog. This xenU work very fine since 2005 september. Is it serious ? What could be the solution ? Regards Franck ############ SYSLOG ...................... Jun 18 08:45:21 lemodev kernel: oom-killer: gfp_mask=0x1d2 Jun 18 08:45:21

Hi Guys, I installed CentOS 6 and installed 'yum install mysql mysql-devel mysql-server' When I try and start MySQL I get: 120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120206

Hi, yesterday there was obviously a problem in one virtual server. Host centos uname -rm: 2.6.18-128.1.6.el5 x86_64 Guest: centos uname -rm: 2.6.18-128.4.1.el5 x86_64 Vmware server : VMware-server-2.0.1-156745.x86_64.rpm Logwatch in guest: --------------------- Kernel Begin ------------------------ WARNING: Kernel Errors Present [<ffffffff8005dde9>]

looking through logs I noticed this today: grep mysql /var/log/maillog | grep fail Aug 3 17:35:25 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:35:57 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:02 dovecot: auth-worker(28335): Error:

Hello. This is my mysql-server.pp file, both master and client are runing ubuntu. -------------------- class mysql-server { package { "mysql-server": ensure => installed } package { "mysql-client": ensure => installed } service { "mysql": enable => true, ensure => running, require => Package["mysql-server"], } file

Hello friends, I've got a strange problem with my cluster-setup. I've got two nodes called www1 and www2 running Ubuntu Linux 8.10. The have a 50G volume which is replicated in primary/primary mode with DRBD. On this volume there is an OCSF2 filesystem with this two nodes. Everything is working really fine, files are perfectly mirrored, really nice. On one of the

Hi,all I did some test about MySQL''s Insert performance on ZFS, and met a big performance problem,*i''m not sure what''s the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1 ~600 qps when sync_binlog=10

I'm currently re-installing db41 port. Earlier using 'innodb_force_recovery = 6' seemed to fix that PANIC error. But I don't understand this permission error. I've tried various permissions as well 777, 766, 666, 760, etc etc. I've also ran mysqld_safe as root user, but with same permission error. Also tried different directories without luck. When I log in to the

i was trying to setup an application checked out from svnin my local machine. i managed to do all that is required except when it came to the step of creating databases for the application, when i tried to connect to mysql i got this error ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock'' (2) i have spent more than 5

It appears that you cannot use migrations (out of the box) with mysql 4.0.16, because when creating a table, the statement says "ENGINE=InnoDb", instead of "TYPE=InnoDB". Looking at the source code for the adapter, this appears to be hard coded. Is there any supported way to make this work with older versions of MySQL? David

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

For those of you familiar with InstantRails or even MySQL I guess, I''m working through the Agile Depot tutorial, and when I tried to create the DB I got the following: C:\work\depot>mysqladmin -u root create depot_development mysqladmin: connect to server at ''localhost'' failed error: ''Can''t connect to MySQL server on ''localhost''

> > No: /etc/pki/CA should NOT be group writeable. Ditto for > /etc/pki/tls/cernts and private Ok, yeah I can understand that. I'll correct it. Still need a way to get SSL enabled however. Any suggestions there? Thanks Tim On Thu, Mar 12, 2015 at 11:40 AM, <m.roth at 5-cent.us> wrote: > Tim Dunphy wrote: > >> > >> The mysqld process runs as the mysql

Ok, to keep things short. Im wondering if I need a secondary relationship table to handle my many-to-one relationships. Here is an example of what I''ve written down. For instance say I want to find all of the people in a given location. class Location < AR:Base has_many :people end class Person < AR:Base belongs_to :location end My SQL tables look like: CREATE TABLE

Hi. I am developing an industry specific crm that allows busineses to track customers in a particular way. Each customer will be assigned a customer number. The first customer will have a customer number of 1, the second customer_number = 2, etc... Note that this customer number is not global but particular to the account that created the customer (see schema snip below). I need to have a