Michael,
I have been following this thread from the beginning and I just don't see
the practical difference between what you propose and the replication
methods (SBR and RBR) already in place. How does what you propose differ
from the SBR (statement -based replication) that MySQL already
Shawn,
Thanks for the reply, but I think the thread has become much more dramatic than
nececessary. Basically, I'm not looking for what has been ALTERed. I simply
need the table
creation data output in ALTER IGNORE (or whatever is appropriate) format so as
to ensure
table structure is the
One problem with dual-master or multi-master replication is that you have
to be able to set and check a lock across all masters before performing a
schema change. How would you deal with this scenario using your ALTER
TABLE database dumps without such a lock?
Server A and B share a table X
Ah, well, in this particular DB, *every single transaction* it's it's own
entry. . .basically the DB itself is a binary log. . .kinda. . .sorta. So the
current value of a particular item isn't necessarily an issue since, once
entered, it will always be the same. A change to that value will in
Ok, I get that. I have several tables just like that (I use mine as shadow
tables for change audits. Every change to the normal table ends up
creating new record in the shadow table thus documenting each state of
the normal table through time). However, shouldn't schema changes be very
rare
Yes, schema changes would/should be rare. You may be right, but I would think
that since schema information is *alway* checked before any INSERTS then we
should be good. There should never be an occasion to break per se.
Obviously anything can happen, and appropriate recovery methods (e.g.
mysqldump takes a table or database and dumps it -- current schema,
current data. You won't get alter tables.
What you want is something that will show all the alter statements.
You can run something like this on unix:
tail -f binlog* | grep ALTER alter.sql
and then the alter.sql text file
Sheeri,
Thanks very much for the reply. However, that is not what I'm looking for. I
don't want the
tables that *have been* altered. I want CREATE TABLE statements output in the
ALTER TABLE
format for re-creation on another system (clean or otherwise).
Regards,
Michael
-- Original
PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: (mysqldump) Serial output. . .?
Shawn,
I'd actually considered such, but I was hoping for it to
already be present. I'm currently on a
tight deadline to finish a project I'm working on so devoting
time to getting 'mysqldump'
stable
All,
I'm looking to output every piece of data from the database line by line. Is
there any
methody by which 'mysqldump' can output the following?:
use MY_DATABASE;
CREATE TABLE IF NOT EXISTS MY_TABLE;
ALTER IGNORE TABLE MY_TABLE ADD MY_COLUMN [properties]
ALTER IGNORE TABLE MY_TABLE ADD
mysqldump --help
:~ -Original Message-
:~ From: mwilliams [mailto:[EMAIL PROTECTED]
:~ Sent: Thursday, February 16, 2006 11:50 AM
:~ To: mysql@lists.mysql.com
:~ Subject: (mysqldump) Serial output. . .?
:~
:~ All,
:~
:~ I'm looking to output every piece of data from the database line
-
:~ From: mwilliams [mailto:[EMAIL PROTECTED]
:~ Sent: Thursday, February 16, 2006 11:50 AM
:~ To: mysql@lists.mysql.com
:~ Subject: (mysqldump) Serial output. . .?
:~
:~ All,
:~
:~ I'm looking to output every piece of data from the database line by
:~ line. Is there any
:~ methody by which
options for the stuff you want to do by typing
mysqldump --help
:~ -Original Message-
:~ From: mwilliams [mailto:[EMAIL PROTECTED]
:~ Sent: Thursday, February 16, 2006 11:50 AM
:~ To: mysql@lists.mysql.com
:~ Subject: (mysqldump) Serial output. . .?
:~
:~ All,
:~
:~ I'm looking
Shawn,
I'd actually considered such, but I was hoping for it to already be present.
I'm currently on a
tight deadline to finish a project I'm working on so devoting time to getting
'mysqldump'
stable enough to then propagate across corporate servers in such a short period
is not very
@lists.mysql.com
Subject: RE: (mysqldump) Serial output. . .?
Shawn,
I'd actually considered such, but I was hoping for it to already be
present. I'm currently on a
tight deadline to finish a project I'm working on so devoting time to
getting 'mysqldump'
stable enough to then propagate across corporate
-
From: mwilliams [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 14:44
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: (mysqldump) Serial output. . .?
Shawn,
I'd actually considered such, but I was hoping for it to
already be present. I'm currently
16 matches
Mail list logo