Hi Eric,
>> At least with Maatkit, you get transparency. We make a concerted
>> effort to update the RISKS section of each tool with each release, so
> there
>> is full disclosure.
>
> Fair enough, but I still found the warnings a little too scary. A more
> complete explanation of the exact natur
Hi Baron,
> I'm the primary author of Maatkit.
Awkward... :-)
> What can I say -- you could go buy a commercial off-the-shelf tool
> and believe the song and dance they feed you about the tool
> being perfect.
There's not a single commercial software solution in our toolbox. We're
big fan
Eric,
>> There are ways to resync data that don't involve all
>> this as well: Maatkit has some tools
>
> I've looked with great interest at Maatkit, but their tools are replete
> with warnings about dangers, bugs, and crashes. They certainly do not
> inspire confidence.
I'm the primary author o
>> I would never have any confidence that the replication
>> is solid enough to use the slave server for backup purposes.
> I agree completely there. That's the other reason I like filesystem
> snapshots is that it allows you to take a backup from
> the master relatively painlessly.
I've thou
---Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Friday, December 04, 2009 1:24 PM
To: Gavin Towey; Tom Worster; mysql@lists.mysql.com
Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production
Hours without Interrupting Users (Much)
> I
> I would say that it's very important to know why data
> is getting out of sync between your master and slave.
Ultimately, I agree. But since it's a canned application, getting to
that point might be hard, and once it is resolved, new issues might
arise. I would never have any confidence that t
On 12/4/09 3:14 PM, "Gavin Towey" wrote:
> I would say that it's very important to know why data is getting out of sync
> between your master and slave. Fixing those root causes would eliminate the
> need for this.
i very much agree. the only instances of slaves getting out of whack that
i've e
9:00 AM
To: Tom Worster; mysql@lists.mysql.com
Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production
Hours without Interrupting Users (Much)
> (1) innodb?
It's an off-the-shelf application that uses MyISAM tables. It is
possible to convert to innodb, but I h
On 12/4/09 11:59 AM, "Robinson, Eric" wrote:
>> (2) why delete slave logs when you can
>> restart the slave with --skip-slave and
>> then use CHANGE MASTER TO?
>
> Well... I guess mainly because I didn't know about that option! I
> thought I needed to "fake out" mysql on this, but it sounds like
> (1) innodb?
It's an off-the-shelf application that uses MyISAM tables. It is
possible to convert to innodb, but I have not been sold on innodb in
terms of its performance characteristics for this particular
application. Maybe I've been reading the wrong stuff. Do you have
general thoughts on t
i have two questions. (1) innodb? (2) why delete slave logs when you can
restart the slave with --skip-slave and then use CHANGE MASTER TO?
tom
On 12/4/09 6:34 AM, "Robinson, Eric" wrote:
>
> Let's face it, sometimes the master and slave get out of sync, even when
> 'show slave status' and 's
Let's face it, sometimes the master and slave get out of sync, even when
'show slave status' and 'show master status' indicate that all is well.
And sometimes it is not feasible to wait until after production hours to
resync them. We've been working on a method to do an emergency
hot-resync durin
R. Hannes Niedner wrote:
Isn't that funny: if I have a mysql related question and search google I end
up in the mysql online documentation in 90% of cases.
I find if I just use the word 'mysql' in my query on Google, I get
fairly appropriate results too.
Not using the word mysql often give
[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "David T-G"
<[EMAIL PROTECTED]>; "mysql users" <[EMAIL PROTECTED]>
Sent: Wednesday, January 01, 2003 6:36 PM
Subject: Re: FAQ hosting site (was "Re: An Idea")
&
esday, January 01, 2003 6:25 PM
Subject: RE: FAQ hosting site (was "Re: An Idea")
> Hi
>
> Is '111' the IP it is trying to connect on?
>
> If so it is an invalid IP.
>
> If the IP is valid how are you trying to connect?
>
> Peter
>
&
sql,query,queries,smallint
On Thu, 2 Jan 2003, Peter Lovatt wrote:
> I was looking for a reasonably heavyweight php application, there are some
> lightweight ones and some half finished ones and some perl ones, but none
> that were what I was looking for.
>
> Any suggestions would be appreciated,
ham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
> -Original Message-
> From: mnbv [mailto:[EMAIL PROTECTED]]
> Sent: 02 January 2003 00:23
> To: Peter Lovatt; Stefan Hinz, iConnect (Berlin);
[mailto:[EMAIL PROTECTED]]
Sent: 02 January 2003 00:37
To: Peter Lovatt
Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users
Subject: Re: FAQ hosting site (was "Re: An Idea")
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
>
> I am not sure if there is exist
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
>
> I am not sure if there is existing faq software (I've checked
> sourceforge and freshmeat without much luck)
Really?
That's a wheel I've seen re-invented many times. I know there's stuff
out there.
--
Jeremy D. Zawodny | Pe
t: RE: FAQ hosting site (was "Re: An Idea")
I really need your help, I installed MySQL and I can
connect to it through localhost but when trying to
access it from outside I get:
ERROR 2003: Can't connect to MySQL server on 'IP'
(111)
Any suggestions?
Someone sugges
---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
> -Original Message-
> From: Stefan Hinz, iConnect (Berlin
, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 01 January 2003 21:26
To: David T-G; mysql users
Subject: Re: FAQ hosting site (was "Re: An Idea")
David,
> Sure; it's the least I can do. Look for mysql.justpickone.org to be
in
> the DNS tables by tomorrow. By then the
[EMAIL
-Oorspronkelijk bericht-
Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 1 januari 2003 22:26
Aan: David T-G; mysql users
Onderwerp: Re: FAQ hosting site (was "Re: An Idea")
David,
> Sure; it's the least I can do. Look for mysql.justpickone
. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
Sent: Wednesday,
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 01, 2003 5:31 AM
To: JamesD; David T-G; mysql users
Subject: Re: An Idea
James,
> something that can be based upon pages of htm and
> emails that exists, and that can sit under
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% > see it dropped if they don't jump on it at the start.
%
% I agree. Will you set it up at http://justpickone.org/? (BTW, I like
Sure; it's the least I can do. Loo
: +49 30 7970948-3
- Original Message -
From: "JamesD" <[EMAIL PROTECTED]>
To: "David T-G" <[EMAIL PROTECTED]>; "mysql users"
<[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
Sent: Wednesday, Jan
Fax: +49 30 7970948-3
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
Sent: Wednesday, January 01, 2003 1:35 AM
Subject: Re: An Idea
>
On 12/31/02 8:11 PM, "JamesD" <[EMAIL PROTECTED]> wrote:
> lists work, and faq's work, some like to call...etc.
> personally, I'd prefer a search engine style...
> like google, but only for mySQL topics, and with
> a visible list of most popular search terms.
>
> something that can be based upon
ten Rutsch
Jim
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 4:36 PM
To: mysql users
Cc: Stefan Hinz, iConnect (Berlin)
Subject: Re: An Idea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) sa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% regarding the MySQL FAQ:
%
% > Why should it have to be there? Let anyone with a site set it up and
...
%
% MySQL.com would be the natural place for the FAQ. Any other pl
David,
regarding the MySQL FAQ:
> Why should it have to be there? Let anyone with a site set it up and
get
> it going and see if readers will even care about it, and *then*
perhaps
> have it move to mysql.com later...
MySQL.com would be the natural place for the FAQ. Any other place
wouldn't be
-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: 31 December 2002 11:13
To: mysql users
Cc: Stefan Hinz, iConnect (Berlin)
Subject: Re: An Idea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% > So (taking a deep bre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% > So (taking a deep breath !) I would be prepared to lay the foundations
...
%
% Thanks, I appreciate that. I've been waiting a moment before answering,
% waiting for others to
nz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "Cal
Evans" <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>; "Adam
Wi´ckowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 1:18 AM
Subject: RE: An Idea
>
hex.com
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea
Hi
My first thought was that the docs on mysql.com should do the
we are all in sales, 24/7. :-)
Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:24 PM
To: JamesD; Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote:
>wh
e Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 7:35 PM
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea
while Paul probably wouldnt say it, I would:
his book: "MySql and Perl for the Web&q
unmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: 30 December 2002 01:35
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea
while Paul probably wouldnt say i
ecember 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea
Hi
My first thought was that the docs on mysql.com should do the job, but,
although they answer most technical questions, often more down to earth
stuff l
ROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "Adam Wi´ckowski"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea
> Because that's the way that (FoxPro, Access, Paradox, insert name of
uBois" <[EMAIL PROTECTED]>; "Adam Wi´ckowski"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea
> Because that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here)
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote:
>
>
> BTW, does MySQL have a RowNumber function?
You can use variables:
select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever;
But you cannot use that number in the where part.
Good luck.
(sql, etc)
--
sage-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 10:02 AM
To: Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea
Why?
-
Before posting, please check:
http://www.mysql.com/manual.ph
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even a
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one
Why?
even after
deleting,
On Sunday 29 December 2002 12:26, Adam Wiêckowski wrote:
> I had a problem few days ago. I'm doing my questbook, and I were thinking
> what would hapen if I delete some row. Now I know, nothing. I had one
> column ID (auto_increment) in my table. I wanted it to be one by one even
> after deleting,
Hello.
On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote:
> Hello,
> I had a problem few days ago. I'm doing my questbook, and I were thinking
> what would hapen if I delete some row. Now I know, nothing. I had one column
> ID (auto_increment) in my table. I wanted it to be one by one e
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even after
deleting, so I changed it by myself. But then (after deleting the la
49 matches
Mail list logo