Re: multi master auto syncing when servers back on line
Joey, sounds like you've got a lot of testing to do before you can deploy
and support this in production yourself with out fear of shooting yourself
in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
from percona.
A
On Wed, Jun 6, 2012 at 5:09 AM, Joey L mjh2...@gmail.com wrote:
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records) and
then i tried to update the master server - and only seen the records
that I updated and not the records that were additional to the other
server when I first restored.
I am just trying different scenerios before i put this in production.
I was looking to do load balancing and i am concerned about
high-availablitity.
Is there a product that is opensource out there that I can use to
maintian a master master setup with ease ?
thanks
mjh
On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have
you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync
before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is
still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
But andrew do you have an answer for me why i am getting this error ?
thanks
On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore eroomy...@gmail.com wrote:
Joey, sounds like you've got a lot of testing to do before you can deploy
and support this in production yourself with out fear of shooting yourself
in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
from percona.
A
On Wed, Jun 6, 2012 at 5:09 AM, Joey L mjh2...@gmail.com wrote:
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records) and
then i tried to update the master server - and only seen the records
that I updated and not the records that were additional to the other
server when I first restored.
I am just trying different scenerios before i put this in production.
I was looking to do load balancing and i am concerned about
high-availablitity.
Is there a product that is opensource out there that I can use to
maintian a master master setup with ease ?
thanks
mjh
On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have
you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools
for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync
before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is
still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync
the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
Can you tell me what permissions are needed for the user to run these
utilities so i can sync the tables ?
I have only assigned them replication slave right.
thanks
On Wed, Jun 6, 2012 at 9:09 AM, Andrew Moore eroomy...@gmail.com wrote:
Joey, sounds like you've got a lot of testing to do before you can deploy
and support this in production yourself with out fear of shooting yourself
in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
from percona.
A
On Wed, Jun 6, 2012 at 5:09 AM, Joey L mjh2...@gmail.com wrote:
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records) and
then i tried to update the master server - and only seen the records
that I updated and not the records that were additional to the other
server when I first restored.
I am just trying different scenerios before i put this in production.
I was looking to do load balancing and i am concerned about
high-availablitity.
Is there a product that is opensource out there that I can use to
maintian a master master setup with ease ?
thanks
mjh
On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have
you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools
for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync
before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is
still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync
the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Claudio
Re: multi master auto syncing when servers back on line
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
Joey,
read
thishttp://www.percona.com/doc/percona-xtrabackup/howtos/setting_up_replication.html
to
setup the second instance with no o little service disruption.
then be aware that you have basically two options for Multimaster
replication with two nodes, Active-Passive and Active-Active
Active-Passive can be used for:
-Having a stand by Master using a failover loadbalancer (using only one
active at a time)
Avoid by all means Active-Active unless you have a great team of developers
Claudio
2012/6/6 Andrew Moore eroomy...@gmail.com
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Claudio
Re: multi master auto syncing when servers back on line
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records) and
then i tried to update the master server - and only seen the records
that I updated and not the records that were additional to the other
server when I first restored.
I am just trying different scenerios before i put this in production.
I was looking to do load balancing and i am concerned about high-availablitity.
Is there a product that is opensource out there that I can use to
maintian a master master setup with ease ?
thanks
mjh
On Tue, Jun 5, 2012 at 6:18 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: multi master auto syncing when servers back on line
Claudio thank you for your input. I can see that you have set this up before.
My issue is that my db is getting very big approaching 50G and
performance is being impacted.
I am also very concerned about recovery time - this is production - so
i can have very little recovery time - so what else is new :)
I will look at the site for active-active config - but have you had
any experience with active-active yourself?
what was your solution - i am on a seriously low budget - so any thing
free is great.
thanks
mjh
On Tue, Jun 5, 2012 at 6:42 PM, Claudio Nanni claudio.na...@gmail.com wrote:
Joey,
read this to setup the second instance with no o little service disruption.
then be aware that you have basically two options for Multimaster
replication with two nodes, Active-Passive and Active-Active
Active-Passive can be used for:
-Having a stand by Master using a failover loadbalancer (using only one
active at a time)
Avoid by all means Active-Active unless you have a great team of developers
Claudio
2012/6/6 Andrew Moore eroomy...@gmail.com
Joey,
The master master replication topology comes with it's own potential
pitfalls and trials. Be sure your use case needs master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you know something easier or does the trick as
this utility does.
thanks
On Tue, Jun 5, 2012 at 5:06 PM, Claudio Nanni claudio.na...@gmail.com
wrote:
Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync
before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that is
still
running ??
I have found a tool dpkg package called Maakit , but having trouble
running it - get this error on the master:
mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
mailserver 192.168.1.11
DBI
connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
password: YES) at /usr/bin/mk-table-sync line 1284
can anyone assist with the error ?
Or can someone tell me of a better opensource tool to use to sync the
servers without a mysql dump ? my db is rather large.
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
