New Local Install And Mysql

Heads up! This is a static archive of our support site. Please go to help.galaxyproject.org if you want to reach the Galaxy community. If you want to search this archive visit the Galaxy Hub search

Latest

Open

RNA-Seq

ChIP-Seq

SNP

Assembly

Forum

Planet

All »

Home

Welcome to Galaxy Biostar! User support for Galaxy! about • faq • rss

Community

Log In

Sign Up

Add New Post

Question: New Local Install And Mysql

10.1 years ago by

Chris Cole • 150

Chris Cole • 150 wrote:

Hi, Galaxy looks like a really cool tool and I'm very keen to try it out on our local set-up (Linux, BTW). This is probably the first of many questions... ;) I've got the basic setup up and running, but I saw somewhere (can't find it now) that you recommend using mysql or postgres for a live set-up. Can you point me to instructions or tell me how I can get galaxy talking to our mysql server? Cheers, Chris

galaxy • 1.3k views

ADD COMMENT • link •

modified 10.1 years ago by Greg Von Kuster • 840 • written 10.1 years ago by Chris Cole • 150

10.1 years ago by

Greg Von Kuster • 840

Greg Von Kuster • 840 wrote:

Hello Chris, The Galaxy distribution includes a sqlite database, but although it is a great product, it is not recommended for a multi-user, live Galaxy instance ( not thread-safe, etc ). To use a mysql or postgres db, simply create the desired database and change your database connection setting in your universe_wsgi.ini file. Comment out the default: database_file = database/universe.sqlite and add a mysql setting: database_connection = mysql:///<database name=""> or possibly something like: database_connection = mysql:///<database name="">?unix_socket=/var/run/mysqld/mysqld.sock Greg Von Kuster Galaxy Development Team

ADD COMMENT • link written 10.1 years ago by Greg Von Kuster • 840

Please log in to add an answer.

Similar posts • Search »