Replication Question

2012-10-25 Thread 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 of the topology) and proceed to

MySQL Monitor and Percona

2012-10-25 Thread Sabika M
We are in the process of switching to percona binaries of MySQL . I am using Percona 5.5.27 and monitoring the MySQL server with the MySQL Enterprise monitor. It starts up fine, but after a while I end up with MySQL monitor connections stacking up until the server becomes pretty much useless. This

Re: MySQL Monitor and Percona

2012-10-25 Thread Sabika M
James rja...@yahoo-inc.com wrote: What does SHOW FULL PROCESSLIST say? What values do you have for max_connections wait_timeout (GLOBAL version) -Original Message- From: Sabika M [mailto:sabika.makhd...@gmail.com] Sent: Thursday, October 25, 2012 11:44 AM To: mysql

Percona Backup

2012-10-22 Thread Sabika M
hi! I am trying to work with percona's extra backup. Has anyone found any simple instructions how to install it? We are using innodb file per table Thanks! Sabika

Innodb Assertion Error

2012-10-22 Thread Sabika M
hi! I am hoping someone has experienced this before or knows how we can resolve this. I am running into an innodb assertion error (see below) and cannot reproduce it. It has happened 3-4 times, MySQL crashes and sometimes recovers and other times it is unable to recover (MySQL repeatedly

Re: credit where due

2011-10-19 Thread Sabika M
I also want to say Thank you Shawn for your valuable contribution. On the note on Resumes -I thought I would put it out here. My company is looking for an excellent MySQL DBA (Oracle and MSSQL experience a plus) Please send me your resume. Thanks! Sabika On Wed, Oct 19, 2011 at 12:30 PM, Shawn