created, and I am too lazy too look for a setting that would lead to
> such an silly/annoying state.
>
> On Thu, Mar 12, 2009 at 10:03 AM, Bryan Irvine wrote:
>> Do I jsut need to monitor better and manually add it should the log
>> and pos change?
>>
>> -Bryan
>&
Do I jsut need to monitor better and manually add it should the log
and pos change?
-Bryan
On Wed, Mar 11, 2009 at 7:05 PM, Baron Schwartz wrote:
> That's deprecated too :-)
>
> On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote:
>> hi,
>> #2. try adding the information of master into my.cnf t
I've got 2 questions about my newly set up master->slave replica.
1> When I run "load data from master;" I get an error that I do not
have RELOAD privileges and then it boots the slave offline.
I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT,
REPLICATION SLAVE, RELOAD ON *.* TO roo
On Mon, Dec 22, 2008 at 6:40 PM, Baron Schwartz wrote:
>>> Right. Unless you have some other settings (binlog-do-db or
>>> binlog-ignore-db on the master?) that are interfering
>
> You saw this ^ right?
>
>> on master:
>> mysql> show master status;
>> +--+--+--
On Sun, Dec 21, 2008 at 8:35 AM, Baron Schwartz wrote:
> Hi Bryan,
>
> On Wed, Dec 17, 2008 at 5:35 PM, Bryan Irvine wrote:
>> I've got a master-master set up and I'm trying to figure out the best
>> way to add new databases to the cluster. I've not set any
I've got a master-master set up and I'm trying to figure out the best
way to add new databases to the cluster. I've not set anything for
the replica-do-db which my understanding means it will sync everything
correct?
So if I create a new DB is the create command supposed to replicated
as well? (i
I've got a nagios server that checks to see if the listening port is
open. I'm getting this error:
Host 'nagios-host' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'
I've googled and there's options to use max_connection_errors=100
My (very rough) estimate
without its pros and cons (just like any other HA solution), but
> you might want to check out DRBD.
>
> http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html
>
> -- Jimmy
>
> Bryan Irvine wrote:
>>
>> What's the recommended method for high-
without its pros and cons (just like any other HA solution), but
> you might want to check out DRBD.
>
> http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html
>
> -- Jimmy
>
> Bryan Irvine wrote:
>>
>> What's the recommended method for high-
What's the recommended method for high-availability setups?
I've currently got a master-master replication setup that I'm testing
but it doesn't quite seem as complete a solution as I had pictured.
When a failed server comes back online you still have to manually add
it based off of the line numb
n the slave and see if it starts.
>
> If it doesn't I'd take a fresh mysqldump with the --master-data
> parameter and refresh the slave, run the 'change master' statement at
> the top of the backup and it should start.
>
> -Original Message-
> From: Bry
ve status\G; off the master?
>
> I have a feeling you have the position wrong. I about 100% sure you have
> the position wrong because it happened to me.
>
> if you don't have it do a show slave status\G; and try to remember which one
> you took.
>
> Mike
>
>
start from position Exec_Master_Log_Pos 1? Can you tell us the
> command you used to get this going?
>
> Mike
>
> On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine <[EMAIL PROTECTED]> wrote:
>>
>> I
I'm having an issue setting up a slave Where it doesn't seem to start:
mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
|
Is there a way to find out what configure arguments were used during
compile time?
-Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
15 matches
Mail list logo
