Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am designing a web application that uses Quartz Scheduler to scheduler jobs.

I have Quartz configured to use a JDBCJobStore, so it automatically stores each created job in its tables.

I am wondering if I should create a separate database to store these Quartz tables in, or if I should just store these tables in my web application's main database.

My application's database is not that complex, with only a couple of tables.

I should also note that Quartz allows you to specify a table name prefix for all of its tables, for instance "quartz_". So if I did store these tables in my application's main database, they would be easily distinguishable from the other tables.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

My input is that it should be within the application database since it is part of the application. I would put them in a different schema however to keep them separate from the business tables but with only a couple tables, the table prefix should be sufficient too.

share|improve this answer
    
Is it possible to create a schema in anything other than Oracle? It doesn't look like this is supported in MySQL. –  Bri Feb 8 at 8:49
    
@Bri - I did it in PostgreSQL... don't know about MySQL. –  ETL Feb 8 at 17:13
    
Apparently, in MySQL, CREATE SCHEMA is now just a synonym for CREATE DATABASE. But there used to be a SQL standard many years ago that had a separate CREATE SCHEMA command, which allowed you to logically group tables together, into different schemas, and to assign different users different privileges for each schema. I think I could implement this in MySQL by simply creating a separate user and password for Quartz to access the database, and specify that it can only access the quartz tables, and then create a separate user for my main application that can only access the application tables –  Bri Feb 9 at 0:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.