I am using graphite, but what exactly do you want to graph?
For mysql graphing I actually use nagios plugin called
check_mysql_health along with check_mk/pnp4nagios
That works really well.
On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Adars
HI Trimurthy,
Just curious won't it make that data inconsistent on the slave?
Thanks
On Fri, Feb 22, 2013 at 12:15 AM, Trimurthy wrote:
> Dear Mike Franon,
>
> i have also faced the same problem while setting up the replication. by
> that time i have added the error n
otherwise
> a master may write instructions in the binlog the older
> slave does not undersatdn at all, but as said normally
> both should have the same version
>
> Am 21.02.2013 18:03, schrieb Mike Franon:
>> So I created a new test box on AWS, and just did one upgrade fr
was curious if anyone had any ideas?
Thanks
On Wed, Feb 20, 2013 at 5:51 PM, Mike Franon wrote:
> 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
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 entry 'data' for key 'PRIMARY'' on
query. Default database
ce the downtime to a few seconds
>
> Am 20.02.2013 20:29, schrieb Mike Franon:
>> OK I got it to work.
>>
>> I dumped the tables that it was complaining about first, and then
>> dumped the triggers.
>>
>> I then uninstalled anything to do with mysql, a
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
>&
full mysqldump.
I am now going to go from 5.1 to 5.5
On Wed, Feb 20, 2013 at 12:54 PM, Mike Franon wrote:
> I am pretty sure I did, and when I did I got the following errors:
>
>
> Error: Table Upgrade Required, Please dump/reload to fix it
>
>
> I got that on 10 tab
eb 20, 2013 at 12:43 PM, Reindl Harald wrote:
>
>
> Am 20.02.2013 18:26, schrieb Mike Franon:
>> So I did a full mysqldump over the weekend for a second time and this
>> time it is 220GB, no clue what happened last time, I should have
>> realized looking at the file size some
So I did a full mysqldump over the weekend for a second time and this
time it is 220GB, no clue what happened last time, I should have
realized looking at the file size something was wrong, but since I got
no errors did not think about it, and this time I timed it, took 7
hours to do a complete mys
han a 400:1 ratio. Maybe the dump isn't
> working correctly or your data set is much smaller? If the dump output is
> less than a gig I would just edit it with something like vi and look at the
> offending line.
>
> Keith
>
> On Feb 15, 2013 3:55 PM, "Mike Franon&q
out to a wider audience.
>
> Upgrade to 5.5 (through 5.1) first as it is quite proven. Slave 5.6 off it
> and test. Be patient. Save yourself some heartache. Just my two cents.
>
> Keith
>
> On Feb 15, 2013 9:27 AM, "Mike Franon" wrote:
>>
>> Thanks everyone for s
ang.com]
> Sent: Thursday, February 14, 2013 3:41 PM
> To: Rick James
> Cc: Mihail Manolov; Mike Franon; Akshay Suryavanshi;
>
>
> Subject: Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6
>
>
>
> Its a very pedantic case, but we had a few instances where it was an
rther 5.5 --> 5.6 (again all slaves first and then the master)
>
> Hope this helps.
>
> Cheers!
>
> On Fri, Feb 15, 2013 at 2:38 AM, Mike Franon wrote:
>>
>> I have 1 master with many slaves, using the master only for inserts
>> and the rest are readers.
>
y to protect
> data which can not be only hashed
>
> somewhere you need the information how to encrypt them
>
> Am 05.02.2013 15:18, schrieb Mike Franon:
>> I tried all these methods and you are right this is not going to work for us.
>>
>> I am not a developer, do
to store 3 tables that have
email address, ip address, and personal info.
On Sun, Feb 3, 2013 at 12:57 PM, Reindl Harald wrote:
>
>
> Am 03.02.2013 18:52, schrieb Mike Franon:
>> Hi,
>>
>> I was wondering what type of encryption for linux would you recommend
>>
16 matches
Mail list logo
