[Rocks-Discuss] mysql and rocksdb
Nehemiah Dacres
for each distribution? Also, how do you safely use mysql on rockscluster
after 5.2 where I specifically remember this being a feature they were
excited about.
--
Nehemiah I. Dacres
System Administrator
Advanced Technology Group Saint Louis University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.sdsc.edu/pipermail/npaci-rocks-discussion/attachments/20101215/66f8001d/attachment.html
Jon Forrest
> where is the documentation on rocksdb and the shima for the rocks database
> for each distribution? Also, how do you safely use mysql on rockscluster
> after 5.2 where I specifically remember this being a feature they were
> excited about.
If you look at
http://marc.info/?l=npaci-rocks-discussion&m=126835460720889&w=2
you'll see a posting I wrote that describes how to add
phpMyAdmin to a Rocks cluster. This is arguably the easiest
way to see the schema of the Rocks database. You can
also use phpMyAdmin to make changes to the Rocks database
although you need to be very careful if you do this.
Cordially,
--
Jon Forrest
Research Computing Support
College of Chemistry
173 Tan Hall
University of California Berkeley
Berkeley, CA
94720-1460
510-643-1032
jlfo...@berkeley.edu
Mason J. Katz
The supported interface into the database is through the Rocks command
line. There are still some parts of the database that the command
line does not expose, but in 5.4 we have almost complete coverage.
Think of the command line as the Rocks API. Treat the schema as the
undocumented and unsupported API, and assume it changes in every
release (it does).
mason j. katz
+1.619.800.0655
Nehemiah Dacres
that won't interfere with the rocks database without just up and installing
postgres I want' to put up websites other than the wordpress site.
Philip Papadopoulos
alternate port.
-P
--
Philip Papadopoulos, PhD
University of California, San Diego
858-822-3628 (Ofc)
619-331-2990 (Fax)
-------------- next part --------------
An HTML attachment was scrubbed...
Nehemiah Dacres
documentation but at which step so I start? I ran mysql_install_db but that
did nothing. where do I start the process?
Greg Bruno
> regular ... I don't think that's possible. I could look at the mysql
> documentation but at which step so I start? I ran mysql_install_db but that
> did nothing. where do I start the process?
to start a vanilla mysql database that won't interfere with the rocks
mysql database, just execute:
# service mysqld start
this will start the database and output helpful info to get you started.
- gb
Gijs Koppers
I tried to start an extra mysql database according to the post below but get
the following result
# /sbin/service mysqld status
mysqld (pid 5615) is running...
checking the rocks database pid
# more /var/opt/rocks/mysql/cluster.pid
5615
Shows that the mysqld service belongs to the rocks database.
How do I start an extra database?
Regards Gijs Koppers
"Hung-Sheng Tsao (Lao Tsao 老曹) Ph. D."
hi
in r5.4
there are two services
mysqld
foundation-mysql
if you do chkconfig --list |grep mysql
you will see that mysqld is off
if you just run
service mysqld start
it will create another instance mysql:-)
regards
-------------- next part --------------
A non-text attachment was scrubbed...
Name: laotsao.vcf
Type: text/x-vcard
Size: 343 bytes
Desc: not available
Url : https://lists.sdsc.edu/pipermail/npaci-rocks-discussion/attachments/20110302/6652f648/laotsao.vcf
Nehemiah Dacres
--
Nehemiah I. Dacres
System Administrator
Advanced Technology Group Saint Louis University
-------------- next part --------------
An HTML attachment was scrubbed...