similar to: Re : problem with running mysql on glusterfs

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

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]

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

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

------------ Original Message ------------ > Date: Saturday, May 30, 2015 12:27:26 AM -0400 > From: Ted Miller <tedlists at sbcglobal.net> > > On 05/29/2015 07:00 AM, Timothy Murphy wrote: >> Todor Petkov wrote: >> >>>> I'm running CentOS-7, but I left some MySQL databases >>>> on my old CentOS-6.5 partition which I'd like to retrieve.

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

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, I''ve tried running the mysql daemon on a few different servers running Xen, and seen two different sorts of problems. In one case, on two identically configured systems, the mysql daemon segv''s but restarts immediately. This happened with Xen 2.0.5, I haven''t yet seen it with 2.0.6. It seems to be the same problem as this one:

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

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

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:

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>]

Hi; It's been a while since I controlled my own server and I'm rusty. Trying to install mysql yum install mysql All looks well. Here's what happens: [root at 13gems www]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root at 13gems www]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to

I just did an unwanted mysql upgrade and am now unable to start the mysql service. After doing some searching the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start

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

Todor Petkov wrote: >> I'm running CentOS-7, but I left some MySQL databases >> on my old CentOS-6.5 partition which I'd like to retrieve. >> I assume they are contained in the file /var/lib/mysql/ibdata1 ? >> >> Could I just copy this file to /var/lib/mysql in CentOS-7? >> Or is there some way Mariadb or phpMyAdmin can import mysql databases >>

Hi everybody, We use a Dovecot setup with GlusterFS. Dovecot 1.1.2 and GlusterFS 1.3.9. I enabled the following options (I don't have posix-locks translators): lock_method = dotlock dotlock_use_excl = no mmap_disable = yes mail_nfs_index = yes mail_nfs_storage = yes I receive the following error message. Aug 7 09:38:51 mta2 dovecot: POP3(somebody at domain.tld): nfs_flush_fcntl:

Hi, I tried installing 1.4.0rc7 using: ./configure --prefix=/ --disable-bdb --disable-mod_glusterfs The prefix=/ was to make sure that the default paths for configuration and log files are /etc/glusterfs and /var/log/glusterfs. When i try to run make install I get the following error: test -z "//lib" || mkdir -p -- "//lib" /bin/sh ../../libtool --mode=install

In article <f7f6e8a9-5425-78f6-f49b-988ab125b7f6 at gc-24.de>, hwilmer <hw at gc-24.de> wrote: > > Hi, > > somehow phpmyadmin messed things up when I was trying to modify a table. > The table disappeared, and now it's impossible to re-create it: > > > MariaDB [time]> create table etikettend_metainfo (userID integer(6) > unsigned, stationsnummer

I am trying to configure mysql to use a different datadir than default in order to move this to a larger volume. I have copied all mysql data from /var/lib/mysql to my new volume and ran both chown -R mysql:mysql * and chmod -R 660 * in order to setup correct ownership and rights for the data. It was working for a few days until today upon going into mysql and typing show databases, I receive