[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Replication Mysql on new OpenShift Origin



Adding back user list.

Well, if you're creating multiple masters with one shared volume, the behaviour is undefined. That is not supported behaviour.

On Tue, Nov 24, 2015 at 3:55 PM, Lorenz Vanthillo <lorenz vanthillo outlook com> wrote:
Yes, but that is fixed. I'm using NFS and its working for my scenarios:
MySQL: master - slaves
Postgresql: master - slaves

So what has to work, works fine. But I tried to perform this in 'the wrong way' to see the errors.
So creating 3 MySQL masters using 1 shared volume (nfs) and 3 Postgresql Masters using one shared volume (nfs).

For the MySQL masters: there are errors, restarts and the pods are in pending status so this is failing immediatley.
For the Postgresql masters: I seems to work first. There are no errors and all the pods and containers are running.
After I add some table, I can see this in the other containers. But after adding and deleting some other tables in other containers the shard filesystem begins to become corrupt.

But I heard somewhere that Postgresql was able to work like that. So with multiple containers/pods/database-instances on one shared volume.
But probably this isn't true?



Date: Tue, 24 Nov 2015 15:50:38 +0100
Subject: Re: Replication Mysql on new OpenShift Origin
From: mnagy redhat com
To: lorenz vanthillo outlook com
CC: users lists openshift redhat com


This is log from the master I assume? What is your persistent volume setup? Do you use nfs? If so, what's the content of your /etc/exports file?

On Tue, Nov 24, 2015 at 9:17 AM, Lorenz Vanthillo <lorenz vanthillo outlook com> wrote:
I'm following this tutorial: https://github.com/openshift/mysql/tree/master/5.6/examples/replica
I'm performing it on OpenShift Origin (oc version
oc v1.0.8-1-g8f1868d
kubernetes v1.1.0-origin-1107-g4c8e6f4)

I already did this on 1.0.6 and it was working fine.
But now I get this issue:
Back-off restarting failed docker container

I see multiple exited docker containers of my master. When I'm asking for the docker logs I get the following:

Running mysql_install_db ...
2015-11-24 08:08:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-24 08:08:51 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.24-log) starting as process 15 ...
2015-11-24 08:08:51 15 [Warning] Can't create test file /var/lib/mysql/data/mysql-master-1-1yped.lower-test
2015-11-24 08:08:51 15 [Warning] Can't create test file /var/lib/mysql/data/mysql-master-1-1yped.lower-test
/opt/rh/rh-mysql56/root/usr/libexec/mysqld: File '/var/lib/mysql/data/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2015-11-24 08:08:51 15 [ERROR] Aborting

2015-11-24 08:08:51 15 [Note] Binlog end
2015-11-24 08:08:51 15 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: Shutdown complete

Can someone help me?

_______________________________________________
users mailing list
users lists openshift redhat com
http://lists.openshift.redhat.com/openshiftmm/listinfo/users




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]