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@xxxxxxxxxxxxxxx Internet: www.tropenklinik.de "Der Mensch ist die Medizin des Menschen" -----Ursprüngliche Nachricht----- Von: gluster-users-bounces@xxxxxxxxxxx [mailto:gluster-users-bounces@xxxxxxxxxxx] Im Auftrag von cvb@xxxxxxxxxxx Gesendet: Dienstag, 19. August 2014 08:10 An: gluster-users@xxxxxxxxxxx Betreff: 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@xxxxxxxxxxx http://supercolony.gluster.org/mailman/listinfo/gluster-users _______________________________________________ Gluster-users mailing list Gluster-users@xxxxxxxxxxx http://supercolony.gluster.org/mailman/listinfo/gluster-users
