Hi all,
I need to set up mysql monitoring graphs in Graphite. I am able to monitor
basic system metrics after runnning example-client.py that comes with
graphite installation.
when i m looking for mysql plugin for graphite , i find
MySQLPerfCollector.py but when i am running it after installing
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
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
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,
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 out
They are both right. It is a matter of how many decimal places you want to
display:
mysql SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
* Smells like some huge LONGTEXTs were INSERTed, then DELETEd. Perhaps just a
single one of nearly 500M.
* Yes, there is an impact on full table scans -- it has to step over the empty
spots. Or maybe not -- one big cow chip of 500MB would be easy to leap over.
* OPTIMIZE TABLE is the
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
and where did anybody say the opposite in this thread?
Am 21.02.2013 22:25, schrieb Rick James:
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:
Anyone has any idea about this.
On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Hi all,
I need to set up mysql monitoring graphs in Graphite. I am able to monitor
basic system metrics after runnning example-client.py that comes with
graphite installation.
when
- Original Message -
From: Adarsh Sharma eddy.ada...@gmail.com
Anyone has any idea about this.
Unless someone else here is using Graphite (I've never even heard of it, tbh) I
think this may be something for the Graphite support channels, instead.
--
Unhappiness is discouraged and
11 matches
Mail list logo