Thank you.
I though it could have a way to avoid updates/inserts without touching my
'mysql' database, so it would be a permanent, exact copy of my master
server.
[]s,
Conrado
- Original Message -
From: <[EMAIL PROTECTED]>
To: "cvarda" <[EMAIL PROTECTED]&g
- Original Message -
From: "Alan Williamson" <[EMAIL PROTECTED]>
To: "cvarda" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 5:30 PM
Subject: Re: Blocking INSERT/UPDATE on SLAVE (replication)
>
>
> cvarda wrote:
>
> > But this wouldn&#x
Hi there.
How could I deny users or applications issuing INSERT or UPDATEs queries on
my SLAVE server? This is intended to ensure that slave will not have data
which MASTER don't know.
Thanks...
[]s,
Conrado
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
It seems to work on my MySQL (4.0.18).
Tell us which version are you using and the error code/message returned.
-- excerpt --
mysql> create table category
-> (
-> id tinyint(4) NOT NULL auto_increment,
-> name varchar(20) NOT NULL
and
up-to-date.
[]s,
Conrado
- Original Message -
From: Steve Williams
To: cvarda
Cc: Batara Kesuma ; [EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 3:28 AM
Subject: Re: Switch replication master
Hi,
Could you take the database down long enough (scheduled downtime) to make
the master
Depending on the size of your databases, it might be a good idea to copy
back your 'data' directory from slave to master.
I think this should work better, even because the master wouldn't get the
INSERT/UPDATEs made on the slave.
[]s,
Conrado
- Original Message -
From: "Batara Kesuma" <
Jail is a technique available on FreeBSD to have isolated environments
running on a common operating system (something similar to virtual machines,
but shares memory as main difference).
More detailed about this is available at:
http://www.freebsd.org/doc/en_US.ISO8859-1/books/arch-handbook/jail.h
Hi there.
I've a table with an auto_increment primary key. I want
to reuse keys (index numbers) that becomes vacant when
I delete entries.
How do I list the vacant keys from a table?
Example table:
1
2
5
6
9
10 <= max value, next is 11.
List of vacant keys:
3
4
7
8
Thanks...
___
