Thanks Aye. I would prefer to use the same store for both the registries. Any idea which DB is better in terms of the performance for both these registries ? Any thoughts around this decision making? Thx
On Mon, Feb 20, 2017 at 6:54 AM, Ayé Rayé <[email protected]> wrote: > Hello, > > I use MariaDB for services's storage. You will find in the attachment the > script of creation of database. > For ticket's storage I entend to use Hazelcast. > > > Le dimanche 19 février 2017 18:08:35 UTC+1, RJ a écrit : >> >> Did you try mysql/maria DB for ticket storage as well? MySQL is something >> we are interested in for both service and ticket registry. Can you share >> the table structure details for this? Thanks >> >> On Saturday, February 18, 2017 at 2:17:41 PM UTC-5, Ayé Rayé wrote: >>> >>> Hello hello, >>> >>> I did a CAS 5.0.2 installation with Cas Services Management installed >>> with persistent services on MariaDB database. It seems to me that >>> everything works well except that: >>> Each time the Tomcat is stopped, the tables in the database containing >>> the services registry are deleted. When I start the Tomcat, the tables are >>> recreated and of course my previous additions of services are lost. >>> >>> What did I miss in my setup? Thanks for your help. >>> >>> >>> *In cas.properties* >>> cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM >>> INFORMATION_SCHEMA.SYSTEM_VARIABLES >>> # cas.serviceRegistry.jpa.isolateInternalQueries=false >>> cas.serviceRegistry.jpa.url=jdbc:mysql://127.0.0.1:3307/cas >>> -service-registry >>> # cas.serviceRegistry.jpa.failFast=true >>> cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect >>> # cas.serviceRegistry.jpa.leakThreshold=10 >>> # cas.serviceRegistry.jpa.batchSize=1 >>> # cas.serviceRegistry.jpa.defaultCatalog= >>> # cas.serviceRegistry.jpa.defaultSchema= >>> cas.serviceRegistry.jpa.user=root >>> # cas.serviceRegistry.jpa.ddlAuto=create-drop >>> cas.serviceRegistry.jpa.password=root >>> cas.serviceRegistry.jpa.autocommit=true >>> cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver >>> cas.serviceRegistry.jpa.idleTimeout=5000 >>> >>> # cas.serviceRegistry.jpa.pool.suspension=false >>> # cas.serviceRegistry.jpa.pool.minSize=6 >>> # cas.serviceRegistry.jpa.pool.maxSize=18 >>> # cas.serviceRegistry.jpa.pool.maxIdleTime=1000 >>> # cas.serviceRegistry.jpa.pool.maxWait=2000 >>> >>> >>> in *management.properties* >>> >>> >>> *cas.serviceRegistry.initFromJson=falsecas.serviceRegistry.jpa.healthQuery=SELECT >>> 1 FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES# >>> cas.serviceRegistry.jpa.isolateInternalQueries=false >>> cas.serviceRegistry.jpa.url=jdbc:mysql://127.0.0.1:3307/cas-service-registry >>> <http://127.0.0.1:3307/cas-service-registry># >>> cas.serviceRegistry.jpa.failFast=true >>> cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect# >>> cas.serviceRegistry.jpa.leakThreshold=10# >>> cas.serviceRegistry.jpa.batchSize=1# >>> cas.serviceRegistry.jpa.defaultCatalog=# >>> cas.serviceRegistry.jpa.defaultSchema= cas.serviceRegistry.jpa.user=root >>> cas.serviceRegistry.jpa.ddlAuto= cas.serviceRegistry.jpa.password=root >>> cas.serviceRegistry.jpa.autocommit=true >>> cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver >>> cas.serviceRegistry.jpa.idleTimeout=5000# >>> cas.serviceRegistry.jpa.pool.suspension=false# >>> cas.serviceRegistry.jpa.pool.minSize=6# >>> cas.serviceRegistry.jpa.pool.maxSize=18# >>> cas.serviceRegistry.jpa.pool.maxIdleTime=1000# >>> cas.serviceRegistry.jpa.pool.maxWait=2000* >>> >>> >>> -- > - CAS gitter chatroom: https://gitter.im/apereo/cas > - CAS mailing list guidelines: https://apereo.github.io/cas/ > Mailing-Lists.html > - CAS documentation website: https://apereo.github.io/cas > - CAS project website: https://github.com/apereo/cas > --- > You received this message because you are subscribed to the Google Groups > "CAS Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit https://groups.google.com/a/ > apereo.org/d/msgid/cas-user/997b110a-a0c4-4317-a7e1- > c636177d6772%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/997b110a-a0c4-4317-a7e1-c636177d6772%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CACNfiM%2Bc8fR_%3DH56Vpzvpu2Ouy%3DuGKWcfWFV2adoqqg0ptm6%3DA%40mail.gmail.com.
