If a slave dies, is there any way to determine that state from an
external point of view (ie: via Perl/DBD) so we can write a script of
some kind to either connect to the slave and issue a "START SLAVE" or
send the last xx lines of the .err log file to our tech staff?
I tried writing a Perl scri
Except that changes made on the master are not automatically picked up
by the slaves.
My bad, I wasn't running "START SLAVE" to get them going. Seems odd that
this has to be done manually.
Also, overnight, my slaves reported this error:
041108 19:06:42 [Note] Slave I/O thread: connected to maste
Id Study keyword
1 AK1
2 AK2
3 BK1
4 BK2
5 CK1
6 Ck3
SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT
keyword='K2'
That *should* give you a single entry for 'C' since its keywords do not
match both 'K1' *and* 'K2'
But your posting *was* a little
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
Except that changes made on the master are not automatically picked up
by the slaves.
Am I missing something?
-id
--
MySQL General Mailing List
For list archives: http://li
LIENT" on the
master, which didn't work.
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
-id
ian douglas wrote:
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on Red
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on RedHat 8.0
On the master system I did this:
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1'
identified by 'repl_passwd' ;
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2'
iden
,
CaseNumber CHAR(12) NOT NULL,
Payment_Amount FLOAT(8,2),
INDEX CaseNumber ( CaseNumber ),
INDEX ID ( ID ),
INDEX ( ID )
);
On Fri, 05 Nov 2004 10:22:42 -0800, ian douglas <[EMAIL PROTECTED]> wrote:
Put Purge into backticks.
`Purge` char
Put Purge into backticks.
`Purge` char(1),
It worked great but I would like to know why, thank!
It could be that 'purge' is a reserved word in MySQL. I wanted to have a
table with a shortened name of 'description' by trying to create a table
with a 'desc' field, and MySQL had problems wi
In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/mysql.sock
-
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database.
Just FYI to everyone replying:
Ed replied to me personally admitti
It doesn't say access denied so I assume the socket is not even open.
Never assume :o)
From your windows box, you could try:
telnet host.domain.com 3306
... if it connects, it connected to *something*
How can I find out if MySQL is on the port 3306?
What Linux command shows all active ports
1. If a new database is created on db1, this is not replicated on db2
and db3. ... is there a better way to automate duplicating this
>>database on the slaves?
Yes put in your my.cnf on the master binlog-ignore-db=mysql,test this
means the master will replicate any event to any database other then
RAID system and mounted via NFS to multiple machines to
actually run the MySQL engine? The tables we use have a lot of
auto_increment fields, and I'd be worried about data being corrupted or
lost.
Thanks,
Ian Douglas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives: http://lists.mys
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1 14:10 ib_log
But can I edit a column field? Can I go into a specific column in a
specific record and edit it just like I was in a text editor? That's the
action I want. None on the products specifically state they can do it(?)
phpMyAdmin will allow you to alter a column name within a table, yes.
can't speak for
There are lots of ways to do it. My personal favorite is to write it in
Perl with the DBI library and tell cron to run that Perl script ... your
Perl script could then write the data in any format you see fit, even
send it somewhere else using Net::FTP or whatever.
Just my $0.02...
-id
Scott Ha
17 matches
Mail list logo