Gluster users - Aug 2014 - mysql on gluster storage

Hi, I'm seeing some strange errors running mysql on gluster:

I'm sharing Gluster volumes from a storage server to a virtual machine 
running on the storage server. The VM runs mysql. I have mounted 
/var/lib/mysql via glusterfs. /var/lib/mysql is mounted before mysql 
starts, and unmounted after it has ended (did that manually to be sure).

Starting up the VM (from the first reboot after installation on), I get 
for every database:

140819  7:24:29  InnoDB: Error: table `test`.`test_cache` does not exist 
in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: 
http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html

I can then feed my database backup into mysql, and everything is running 
fine until I reboot.

My guess is that some files are not written properly, some buffers are 
not flushed properly, ... before reboot, even when manually unmounting 
after manually stopping mysql.

Would I need to do a manual flush or something before 
unmounting/rebooting?

Technical details: Storage server an VM both run Ubuntu 12.04. glusterfs 
3.4.2 installed from ppa:semiosis/ubuntu-glusterfs-3.4.

The resource was created on the storage server with

gluster volume create mysql transport tcp machine:/mnt/raid/mysql

Chris

I know this issue if you are running proxmox for virt. machine and you store
it on gluster then you need to set "write through" in you settings of
your
hdd (vmdk or else).



EDV Daniel M?ller

Leitung EDV
Tropenklinik Paul-Lechler-Krankenhaus
Paul-Lechler-Str. 24
72076 T?bingen 
Tel.: 07071/206-463, Fax: 07071/206-499
eMail: mueller at tropenklinik.de
Internet: www.tropenklinik.de

"Der Mensch ist die Medizin des Menschen" 




-----Urspr?ngliche Nachricht-----
Von: gluster-users-bounces at gluster.org
[mailto:gluster-users-bounces at gluster.org] Im Auftrag von cvb at kruemel.org
Gesendet: Dienstag, 19. August 2014 08:10
An: gluster-users at gluster.org
Betreff: [Gluster-users] mysql on gluster storage

Hi, I'm seeing some strange errors running mysql on gluster:

I'm sharing Gluster volumes from a storage server to a virtual machine
running on the storage server. The VM runs mysql. I have mounted
/var/lib/mysql via glusterfs. /var/lib/mysql is mounted before mysql starts,
and unmounted after it has ended (did that manually to be sure).

Starting up the VM (from the first reboot after installation on), I get for
every database:

140819  7:24:29  InnoDB: Error: table `test`.`test_cache` does not exist in
the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: 
http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html

I can then feed my database backup into mysql, and everything is running
fine until I reboot.

My guess is that some files are not written properly, some buffers are not
flushed properly, ... before reboot, even when manually unmounting after
manually stopping mysql.

Would I need to do a manual flush or something before unmounting/rebooting?

Technical details: Storage server an VM both run Ubuntu 12.04. glusterfs
3.4.2 installed from ppa:semiosis/ubuntu-glusterfs-3.4.

The resource was created on the storage server with

gluster volume create mysql transport tcp machine:/mnt/raid/mysql

Chris
_______________________________________________
Gluster-users mailing list
Gluster-users at gluster.org
http://supercolony.gluster.org/mailman/listinfo/gluster-users

On 19/08/2014, at 7:09 AM, cvb at kruemel.org wrote:
<snip>
> Technical details: Storage server an VM both run Ubuntu 12.04. glusterfs
3.4.2 installed from ppa:semiosis/ubuntu-glusterfs-3.4.

As a general thought, it's a good idea to upgrade to GlusterFS
3.4.5 as well, as there have been a lot of bug fixes since
3.4.2. :)

Regards and best wishes,

Justin Clift

--
GlusterFS - http://www.gluster.org

An open source, distributed file system scaling to several
petabytes, and handling thousands of clients.

My personal twitter: twitter.com/realjustinclift