#mysql
01 November 2007
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:36 <****> Dallu1: But yes, you can have more than one management server, but only one is active a the arbitrator
03:38 <****> _k: ok, I went through the doc and I noticed that it's recommended to run the management server on a separate machine but I figured that the odds of the management server machine going down are just as high as one of the data/sql machines and if there is a hot-standby would it impact the cluster ?
03:39 <****> Dallu1: Imagine two machines, A and B. Each running a data node and a management node each, and assume the management node on A is the active one.
03:39 <****> Dallu1: What do you think will happen if A goes down?
03:40 <****> _k: I don't know exactly what the role of the management server is so I can't say for sure I'm kinda trying to figure out if that means that the cluster is non-responsive or if that means that the management node on B takes over
03:41 <****> Dallu1: The management node takes the role of an arbitrator, i.e. it will decide which part of the cluster will survive if there's node failures
03:41 <****> _k: ok so it needs to be up when the failure occurs, thx
03:41 <****> Dallu1: exactly.
03:42 <****> jstubbs it run for just a sec or less... said 0 queries processed
03:43 <****> jstubbs and i wanted to get rid of binlogs and nothing else thus i tried purge BIN logs, not master logs.. not sure if that's same stuff?
03:47 <****> jbalint: pm?
03:48 * chadmaynard wonders if jbalint has become deadroot's personaly support service
03:49 <****> willing testers of odbc are rare :p
03:50 <****> hehe
03:53 <****> robboplus_: the manual lists the command as "purge (binary|master) logs" so they should be one and the same. don't know what the issue is though. it has always worked here.
03:56 <****> robboplus_: check the comment at the very bottom of http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
03:56 <****> it seems you dug your own grave ;)
03:57 <****> jstubbs thank you but not in this case
03:57 <****> i used to wipe before
03:57 <****> but that is a fresh box i never messed up with binlogs there
03:57 <****> all the files were in place and there was an index too
03:58 <****> it just didn't work
03:58 <****> hm perhaps it didn't like it when i run mysql with binlog disabled?
03:58 <****> that's all i can think of
03:59 <****> but then it's a bit like a bug, isn't it?
03:59 <****> sounds like a bug
03:59 <****> it should be easy to reproduce
03:59 <****> even after deleting files manually, mysql should really be able to recover gracefully
03:59 <****> so perhaps a dev here will catch up on this one
04:00 <****> it's very simple what i did: 1. let mysql write some binlogs 2. edit my.cnf and comment out binlog stuff to disable logging 3. restart mysqld 4. try to use PURGE BINARY LOG - it won't work.
04:01 <****> it just seems to be completely ignoring me
04:01 <****> i tried both with filename and TO date
04:02 <****> anyway i just did rm /var/log/mysql/* :)
04:02 <****> and it's happily running now
04:03 <****> it likely still has that last one open
04:03 <****> hm.
04:03 <****> why would it be so if i disabled logging and restarted mysqld?
04:03 <****> well, not if you've disabled logging
04:04 <****> ok
04:04 <****> i'm just worried about that rm stuff... i know it's not any cool
04:04 <****> but probably shouldn't break anything, aye?
04:04 <****> once logging is completely disabled
04:07 <****> ERROR 1045 (28000): Access denied for user 'thomas'@'localhost' (using password: YES)
04:07 <****> I get that error
04:07 <****> what's wrong?
04:08 <****> bye bye
04:09 <****> means your a noob
04:09 <****> aixl: "you're"
04:09 <****> means you might not be using root
04:09 <****> thanks for the gramMA update
04:10 <****> I did use root
04:10 <****> not if it's saying "thomas" doesn't have access.
04:11 <****> u did use root?
04:11 <****> lol
04:11 <****> that means you have absolutely no idea of whats going on... did you give the thomas user access to your database?
04:11 <****> and table?
04:12 <****> well db only in mysql
04:12 <****> no
04:12 <****> you have to do that
04:12 <****> otherwise it wont let u connect
04:13 <****> how do I remove a database, now that I'm gotten in?
04:13 <****> are you using cpanel or something
04:14 <****> no
04:14 <****> straight out shell
04:14 <****> what are u using
04:14 <****> just DROP dbname;
04:14 <****> ic
04:14 <****> mysql -u thomas -p password DROP dbname i think, forgot
04:15 <****> i don't think he is granted that though ;)
04:15 <****> unless admin is a complete idiot
04:16 <****> yeah
04:16 <****> me either
04:16 <****> what is he even doing with shell
04:17 <****> at all
04:17 <****> i'm wondering that myself
04:17 <****> if one can't tell if he is root or not...
04:17 <****> but... the kernel has access to everything!
04:17 <****> he is root, and he's just fooling around
04:18 <****> I keep getting a syntax error with that command "DROP dbname;"
04:18 <****> and yes I changed dbname to the right name
04:18 <****> so you are not fooling around :)
04:18 <****> don't I have to use \g or something?
04:18 <****> get to the mysql shell first then
04:18 <****> hi, I am having problems with phpmyadmin in ubuntu 7.10 ... I can't seem to access via http://localhost/phpmyadmin
04:18 <****> new build
04:21 <****> robboplus_ ok I'm in mysql shell
04:28 <****> my database still doesn't work, how do I restart mysql?
04:29 <****> The-Kernel: depends on the OS and how it was installed
04:29 <****> Ubuntu, and source
04:29 <****> how did you start it? mysqld_safe or /etc/init.d/something
04:32 <****> /usr/sbin/mysqld
04:33 <****> The-Kernel: then you should see the error messages on the screen
04:34 <****> The-Kernel: ignroe that, maybe I mistaken your problem
04:35 <****> The-Kernel: there is no command "DROP dbname"
04:36 <****> DROP DATABASE dbname
04:36 <****> whoever told me that is quite inexperienced
04:37 <****> kimseong I got it all
04:37 <****> thanks for your help anyways
04:41 * chadmaynard sighs
04:41 <****> hi all,have a question on UPDATE....let say I hav a UPDATE statement to update 2 fields of a table, is it possible that the UPDATE statement successfully write into 1 of the field and failed in another?
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last