On 2/26/2019 1:57 PM, Jim wrote:
On 2/26/2019 9:44 AM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand
most
of it, but h
On 2/26/2019 9:44 AM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privilege
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replicat
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privile
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next t
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slav
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql> show global variables like 'log_bin%';
+-+---+
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It seems that th
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
| File
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, "william dre
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
+--+--+--+---
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master,
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com
wrote:
> Hello guys, some points to check here:
>
> 1-) Is the master server con
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master, is the Exec_Master_Log_Pos incrementing or not?
3-) Why are you reconfiguring all the replication just bec
Whilst there are a few possibilities, check on the master that your binary
logs are being written to. Another possible reason could be filtering.
On 29 Aug 2014 21:36, "william drescher" wrote:
>
> Replication novice
>
> I have a master server at the office and a replication server at home.
> Thi
Manuel,
Thank you very much for this information. This sounds like a very good
strategy. I think I will try switching some slaves from one relay to another to
familiarize myself and get practice and them do it to deploy a new master.
Again, thank you very much.
Richard
> El Jan 18, 2014, a
2014/1/17 Richard Reina
> I have 3 relay MySQL database servers on my small office LAN backing up a
> master and 3 more machines backing up each relay (1 each). They are all
> replicating all databases and all tables. The master although running fine
> is almost eight years old. I'm thinking it's
Am 17.01.2014 22:42, schrieb Richard Reina:
> I have 3 relay MySQL database servers on my small office LAN backing up a
> master and 3 more machines backing up each relay (1 each). They are all
> replicating all databases and all tables. The master although running fine
> is almost eight years ol
Hi!
> "Ed" == Ed L writes:
Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
Ed> replication. Here's my scenario...
Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
Ed> master-slave configuration to a new, beefier server running same mysql
if i u have LVM's then lock is held only for the duration of taking
snapshot, which would be few min, if there is very less activity on the db.
On Wed, Aug 28, 2013 at 3:08 PM, Ed L. wrote:
> On 8/28/13 2:00 PM, Ananda Kumar wrote:
>
>
> Why don't u try snapshot backups, where the lock held fo
On 8/28/13 2:00 PM, Ananda Kumar wrote:
Why don't u try snapshot backups, where the lock held for less
duration. Or can't u take mysql dumps during Night time when there is
less bd activity
I neglected to mention these systems are both CentOS linux systems.
Unfortunately, the 5.5 hour dumps
Why don't u try snapshot backups, where the lock held for less duration. Or
can't u take mysql dumps during Night time when there is less bd activity
On Thursday, August 29, 2013, Ed L. wrote:
>
> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my sce
On 24/07/2013 19:52, Rick James wrote:
4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here ar
> 4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here are the gotchas for Galera usage:
http:
Thanks & Kind Regards,
> TRIMURTHY
>
>
>
>
>
> From: "Mike Franon"
> Sent: Thursday, February 21, 2013 11:43 PM
> To: "Reindl Harald"
> Subject: Re: replication fails after upgrade to 5.6
>
> Unfortunately that is not
13 10:30 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: replication fails after upgrade to 5.6
>>
>> Am 21.02.2013 19:11, schrieb Mike Franon:
>>> Is the only way to really fix this is to upgrade master? I thought
>>> you can replicate from master -> s
It is safer to have the Slave be a newer version.
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Thursday, February 21, 2013 10:30 AM
> To: mysql@lists.mysql.com
> Subject: Re: replication fails after upgrade to 5.6
>
>
>
Am 21.02.2013 19:11, schrieb Mike Franon:
> Is the only way to really fix this is to upgrade master? I thought
> you can replicate from master -> slave if version is higher on slave,
> just not the other way around?
normally no
but take a look at the changelogs of myslq in the last years
80 ou
Unfortunately that is not possible at the moment, I have 6 slaves off
the one master, also I want to test it as much as possible before
upgrading the master.
Is the only way to really fix this is to upgrade master? I thought
you can replicate from master -> slave if version is higher on slave,
ju
update the master ASAP in a short timeframe too
and re-init replication if needed
normally both should have exactly the same version
the slaves must be updated first because otherwise
a master may write instructions in the binlog the older
slave does not undersatdn at all, but as said normally
bo
So I created a new test box on AWS, and just did one upgrade from
5.0.96 to 5.1, like I did before and replication will not work from a
master with 5.0.96 to a slave with 5.1.68
I keep getting Error 1062, Duplicate Entry for key
I get no errors when I do a mysql_upgrade, all comes back ok.
I was
This is on a slave, i only upgraded on one box which is the slave i
have not touched master
On Wed, Feb 20, 2013 at 5:41 PM, Reindl Harald wrote:
>
>
> Am 20.02.2013 23:27, schrieb Mike Franon:
>> So I successfully upgraded a test db server from 5.0.96 all the way up to 5.6
>>
>> Replication as t
Am 20.02.2013 23:27, schrieb Mike Franon:
> So I successfully upgraded a test db server from 5.0.96 all the way up to 5.6
>
> Replication as the slave, where the master is 5.0.96, started working
> for about 10 minutes and then got the following error:
>
> [ERROR] Slave SQL: Error 'Duplicate en
On 12/3/2012 7:24 AM, Trimurthy wrote:
hi list, i am trying to set up replication but i couldn't
complete because of the following error
Could not find first log file name in binary log index file can any one
please help me.
... snipped ...
This one should have been easy for the list
y are the binlogs in?
>
>
> > -Original Message-
> > From: Michael Dykman [mailto:mdyk...@gmail.com]
> > Sent: Monday, December 03, 2012 8:53 AM
> > To: trimur...@tulassi.com
> > Cc: mysql@lists.mysql.com
> > Subject: Re: replication problem
>
SHOW SLAVE STATUS\G
SHOW MASTER STATUS;
What directory are the binlogs in?
> -Original Message-
> From: Michael Dykman [mailto:mdyk...@gmail.com]
> Sent: Monday, December 03, 2012 8:53 AM
> To: trimur...@tulassi.com
> Cc: mysql@lists.mysql.com
> Subject: Re: r
Trimurthy,
you will have to describe the method you are using to setup
replication. The error message seems plain but an observer could not
reasonably guess what caused it without more information.
- michael dykman
On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy wrote:
> hi list, i am tr
Am 15.11.2012 12:46, schrieb Manuel Arostegui:
> 2012/11/15 Lorenzo Milesi
>
>> Hi.
>>
>> Is it possible to have a master/master replication between servers of
>> different versions?
>> Now I've two 5.0.51 syncing themselves. I'm installing a new server with
>> 5.5.28 and I'd like if I can upgr
2012/11/15 Lorenzo Milesi
> Hi.
>
> Is it possible to have a master/master replication between servers of
> different versions?
> Now I've two 5.0.51 syncing themselves. I'm installing a new server with
> 5.5.28 and I'd like if I can upgrade but still mantaining compatibility.
> Otherwise I'll ke
2012/10/25 Sabika M
> I have replication setup in the following way:
>
> A -> B ->C
>
> I am making updates to server A. I want to stop all my updates and point
> them to server C. After I start writing to server C, can I use the change
> master statement to make the C the master of A (take B out
Sound right.
Be sure there are no writes during certain critical times. And that
replication is caught up.
If you want to verify the "sameness" see Percona's pt-table-checksum.
> -Original Message-
> From: Sabika M [mailto:sabika.makhd...@gmail.com]
> Sent: Thursday, October 25, 2012 1
Are you trying to promote a slave as a new master and replace current master or
create intermediate slave? If it is the latter all you need to do is to:
1. Stop the slave
2. Add "log_slave_updates = 1" in the slave's config file
3. Copy the slave files to the new slave(s)
4. Start your intermedia
nge.net]
>> Sent: Friday, August 24, 2012 2:43 PM
>> To: mysql@lists.mysql.com
>> Subject: Re: Replication question: How to make a slave a master?
>>
>> what would be tricky?
>>
>> remove all relay-logs, remove master.info adn that was it done this
>>
Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Friday, August 24, 2012 2:43 PM
> To: mysql@lists.mysql.com
> Subject: Re: Replication question: How to make a slave a master?
>
> what would be tricky?
>
> remove all relay-logs, remove master.info adn th
cky.
>
>> -Original Message-
>> From: Reindl Harald [mailto:h.rei...@thelounge.net]
>> Sent: Friday, August 24, 2012 8:29 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: Replication question: How to make a slave a master?
>>
>>
>>
>&
Pointing the other slave to the new master is a bit tricky.
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Friday, August 24, 2012 8:29 AM
> To: mysql@lists.mysql.com
> Subject: Re: Replication question: How to make a slave a master
Am 24.08.2012 17:25, schrieb Richard Reina:
> I have a couple of mysql database slaves and would like to make one of them
> be a master as well so that I can set another machine to replicate from it.
> Can anyone tell me how I should go about it or know of any howtos for this
> specific task?
ad
il.com]
> Sent: Wednesday, August 01, 2012 11:20 PM
> To: Pothanaboyina Trimurthy
> Cc: mysql
> Subject: Re: Replication setup hep
>
> if the server is offline , what kind of operation happens on it.
>
> On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy <
> skd.t
if the server is offline , what kind of operation happens on it.
On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy <
skd.trimur...@gmail.com> wrote:
> Hi everyone
> i have 4 mysql servers out of those one server will
> be online always and the remaining will be offline and
I suggest buying a copy of High Performance MySQL 3rd edition that
just came out. It has a whole chapter on HA that answers a lot of
these questions.
On Mon, Apr 2, 2012 at 6:14 PM, Wes Modes wrote:
>
>> Replication rings are possible but you must design your application to
>> take special care t
> Replication rings are possible but you must design your application to
> take special care to NOT update the same row in multiple nodes of the
> ring at the same time. This is even harder to design and code for than
> splitting writes/reads to master/slaves.
>
> Also the loss of one node of a re
Try out functionality you desire with trigger to replicate data
From: Derek Downey
To: [MySQL]
Sent: Thursday, 29 September 2011 10:46 PM
Subject: Re: replication between two tables in same database
You could look into the sphinx engine http
You can do this by initially copying the table and setting up triggers
to refresh new data. Looks like you are not looking for replication, but
you are calling it replication. Having 2 tables in a database with the
same content and different indexes/storage engines/partitioning is
totally possible.
I've now just upgraded to MySQL 5.6 on our test server. Just trying to find
a date as to when it will go into production
On Thu, Sep 29, 2011 at 8:10 PM, mos wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full
> text search engine. It will work on InnoDb tables s
Am thinking now that it might be best to use MySQL 5.6 as this is a new project
still in development and we will have the new FullText Search with Innodb
On 29 Sep 2011, at 18:43, Andrew Moore wrote:
> Hey Neil, I read your question too quickly and jumped to the conclusion you
> weren't sure M
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full
> text search engine. It will work on InnoDb tables so you don't have to export
> the data to MyISAM.
>
> Mike
>
>
Derek is right. The Sphynx search engine is much
faster than MyISAM's full text search engine. It
will work on InnoDb tables so you don't have to export the data to MyISAM.
Mike
At 01:43 PM 9/29/2011, you wrote:
But I could create an additional myisam table to
overcome my problem providing I
But I could create an additional myisam table to overcome my problem providing
I can get the data to synchronise between the two tables
On 29 Sep 2011, at 18:16, Reindl Harald wrote:
> so mysql is currently the wrong database for your project
> sad but true, you can not have fulltext-search and
You could look into the sphinx engine http://sphinxsearch.com/about/sphinx/
No experience with this personally though
- Derek
On Sep 29, 2011, at 1:07 PM, Tompkins Neil wrote:
> Yes, unless I can set-up some sort of replication between the two tables.
>
> On Thu, Sep 29, 2011 at 6:05 PM, Reindl
so mysql is currently the wrong database for your project
sad but true, you can not have fulltext-search and innodb this time
Am 29.09.2011 19:15, schrieb Tompkins Neil:
> We've succesfully used FULLTEXT searching on another application that does
> not need Innodb tables. In addition for
> the F
We've succesfully used FULLTEXT searching on another application that does
not need Innodb tables. In addition for the FULLTEXT searching we use
things like "IN BOOLEAN MODE" as well - so for our project Like %% is not
enough.
On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald wrote:
> you do not ne
you do not need any replication or myisam for
select * from table where field like '%input%';
for most workloads this is enough and you have not the problem
with stop-words, minimum input length and so on
Am 29.09.2011 19:07, schrieb Tompkins Neil:
> Yes, unless I can set-up some sort of replicat
Yes, unless I can set-up some sort of replication between the two tables.
On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald wrote:
> please do NOT post off-list!
>
> so your only workaround is like '%whatever%' currently
>
> Am 29.09.2011 19:04, schrieb Tompkins Neil:
> The reason I'm using Innodb
Sounds like a job for CREATE TRIGGER to me. :)
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
>>> Tompkins Neil 9/29/2011 12:56 PM >>>
Hi
I've a Innodb and MyISAM table in the SAME database that I wish to replicate
the data between the two because I need to use FULLTEXT searchi
Am 29.09.2011 18:56, schrieb Tompkins Neil:
> Hi
>
> I've a Innodb and MyISAM table in the SAME database that I wish to replicate
> the data between the two because I need to use FULLTEXT searching on
> the MyISAM table. Is this possible ? If so how do I do it.
in short: no
in longer:
why in
Thank you for the information and script. I will try it out tonight when
traffic stops.
Thanks,
Carl
- Original Message -
From: "Reindl Harald"
To: "Carl"
Cc:
Sent: Wednesday, February 16, 2011 7:47 AM
Subject: Re: Replication issue
--
MySQL General M
t"
date
echo ""
echo ""
I have never used the rsync process... I will try it out in the in the middle
of the night when I have
> time to recover from a screwup. Who says systems people need sleep!
>
> Thanks,
>
> Carl
> - Original Message -
ee if I am setting
myself up for future problems.
Thanks,
Carl
- Original Message -
From: Johan De Meersman
To: Carl
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 16, 2011 6:55 AM
Subject: Re: Replication, log info
On Wed, Feb 16, 2011 at 12:23 PM, Carl
!
Thanks,
Carl
- Original Message -
From: "Reindl Harald"
To: "Carl"
Cc:
Sent: Wednesday, February 16, 2011 7:02 AM
Subject: Re: Replication issue
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
I can not believe that this would take 24 hours
since rsync with compression is very efficient
and on the other hand - who cares, the master
is not down if you do this in the order i described
Am 16.02.2011 12:57, schrieb Carl:
>> are you saying to restart the slave in question from a good copy of
t: Wednesday, February 16, 2011 6:40 AM
Subject: Re: Replication issue
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Wed, Feb 16, 2011 at 12:23 PM, Carl wrote:
> 110216 5:15:20 [ERROR] Error reading packet from server: log event entry
> exceeded max_allowed_packet; Increase
> max_allowed_packet on master ( server_errno=1236)
>
This seems to be the major player, here. I would make sure to increase the
setti
Am 16.02.2011 12:36, schrieb Carl:
> are you saying to restart the slave in question from a good copy of the
> master that I know to be good?
yes!
there is a reason why the salve stops to work and in my opinion
the only save way to get a 100% clean slave is clone it again
from the stopped master
Am 16.02.2011 12:33, schrieb Carl:
> The max_allowed_packet setting is the same on both.
the question is how large the setting is
we have 200M on all machines
> I have tried restarting the slave... didn't work
after replication errors you should every time
* stop the slave
* "hot" rsync the dad
I know to be good?
Just trying to be really careful.
Thanks,
Carl
- Original Message -
From: "Reindl Harald"
To: "Carl"
Cc:
Sent: Wednesday, February 16, 2011 6:24 AM
Subject: Re: Replication issue
--
MySQL General Mailing List
For list archives: http://list
The max_allowed_packet setting is the same on both.
I have tried restarting the slave... didn't work. I can bounce the master.
Thanks,
Carl
- Original Message -
From: "Elizabeth Mattijsen"
To: "Carl"
Cc:
Sent: Wednesday, February 16, 2011 6:23 AM
Subje
First make sure that the "max_allowed_packet" setting is the same on both
masters.
Make sure that setting is active on the slave in question. Then start
replication or bounce the master (not sure which I did to fix this the last
time I ran into this).
Elizabeth Mattijsen
Got fatal error 1236 from master when reading data from binary log:
'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on
master
So do this in your my.cnf :-)
Forget workarounds to solve replication errors
and re-init you replication if you will be sure
it is really consis
Run the change master again to get the relay logs from master server again.
On Wed, Feb 16, 2011 at 4:50 PM, Carl wrote:
> I am running master - master replication between two locations using MySQL
> version 5.1.41 on Slackware Linux 13 (64bit).
>
> The problem from show slave status is:
>
>
All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database an
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote:
> **On Slave Server I replicate database *A alone* and my replication not
> working due to data fetching happen on B database.
>
Well, yes. Statement-based replication does what it says on the box: it
executes the exact same statement on the sla
Classic scenario where MMM will be your best bet. Check out
http://mysql-mmm.org for more information. Setup two masters and 2 or
more slaves for full High Availability. It scales extremely well if
your application is read-heavy (which most applications are).
If you need help implementing this, I
: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Replication on MySQL databases
Date: Thu, 4 Nov 2010 10:21:11 +0100
If your sites are busy with *writes*, you're kind of stuck. Replication
means that every write that happens on one side, also MUST happen on the
other
If your sites are busy with *writes*, you're kind of stuck. Replication
means that every write that happens on one side, also MUST happen on the
other side, so you win nothing. Well, you win a little delay on half of your
writes, which is, to most people, really a downside, not an upside.
Your bes
Hi everbody!
Machiel Richards wrote:
> Hi Guys
>
> Can someone please confirm whether replication / standby
> functionality is available on the GA release of MySQL or this an
> Enterprise specific functionality?
1) Replication is available in all MySQL configurations, be they for the
com
This is in the GA (free) release and has been for many years I believe...
Quoting Machiel Richards :
Hi Guys
Can someone please confirm whether replication / standby
functionality is available on the GA release of MySQL or this an
Enterprise specific functionality?
Regards
Machiel
On Thu, Sep 2, 2010 at 5:51 PM, wrote:
> Quoting Jangita :
>
>
>> Simply put: I want a solution that ensures that server 2 has all the data
>> at server 1 at any point in time; say server 1 suddenly fell into a pond :)
>> . I wouldnt want to open server 2 and find the last insert/update/delete
>>
On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal wrote:
> If server 1 and 2 are on the same local network, I would use
> a cluster.
>
As in NDB ? I've no personal experience with it - save for a sales talk by
MySQL guys some years back where we decided it was useless to us - but I
understand it has
Quoting Jangita :
Simply put: I want a solution that ensures that server 2 has all the
data at server 1 at any point in time; say server 1 suddenly fell
into a pond :) . I wouldnt want to open server 2 and find the last
insert/update/delete missing...
Ok so that rules out any asynchro
> Simply put: I want a solution that ensures that server 2 has all the
> data at server 1 at any point in time
If server 1 and 2 are on the same local network, I would use
a cluster. If they are located on physically separate networks,
I would use master-master replication.
Neil
--
Nei
On 02/09/2010 4:35 p, a.sm...@ukgrid.net wrote:
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high availability
clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual
On 02/09/2010 4:32 p, Johan De Meersman wrote:
On Thu, Sep 2, 2010 at 1:10 PM, Jangita mailto:jang...@jangita.com>> wrote:
...
Growth should be linear to the growth of customers, no ? :-)
I thought so too; but one customer = 1 customer record, plus all his
transactions, and also weirdly
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high
availability clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual data.
If you want a copy of your data on a
On Thu, Sep 2, 2010 at 1:10 PM, Jangita wrote:
> Hi Guys,
> We have a system that has been running along nicely for the past three
> months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
> system; slightly 2 hits per minute but growing exponentally as customers
> increase.
>
Grow
Force all traffic to Node A
Break/Stop replication
backup Node using mysqldump
Restore backup file on Node B
Resume replication
Install Maatkit
Should do the trick...
From: ext Norman Khine [nor...@khine.net]
Sent: 30 August 2010 15:50
To: mysql@lists.mysql
1 - 100 of 1084 matches
Mail list logo
