2010/10/18 Brent Clark :
> Hiya
>
> I run MySQL Master - Master Replication. Ive had an interesting situation
> whereby I failed over using heartbeat but whats is interesting is that via
> the application (vbulletin), I see that the forums was showing that a weeks
> ago data.
>
Why using M-M repl
On Tue, Oct 19, 2010 at 9:48 AM, short cutter wrote:
> 2010/10/18 Brent Clark :
> > Hiya
> >
> > I run MySQL Master - Master Replication. Ive had an interesting situation
> > whereby I failed over using heartbeat but whats is interesting is that
> via
> > the application (vbulletin), I see that
Good day all
I am hoping someone has had some experience in this to assist
me.
I have been going through lots of forums and documentation and
can find a lot of information on how to setup a master/slave replication
on MySQL.
The question I have however is how do you fail
Quoting Machiel Richards :
The question I have however is how do you fail over to the slave
server in the event that the master server is unavailable and then how
to revert back to the master server once the server is available again.
Hi,
to fail over to the slave, you dont need t
That's pretty much it, indeed. You need to make absolutely sure that no more
connections can be made to the old, broken master, though - even if you have
to physically pull the network or power cable. Failover services refer to
this as STONITH: Shoot The Other Node In The Head.
Don't think "but it
Johan,
You state that master - master is not reliable in dual active environments.
I am in the process of setting up just such an environment (moderate active
on the primary server, lighter activity on the other server.) Do you know
where I can get some information on the risks?
Thanks,
Ca
You may also want to take a look at MySQL MMM which makes use of
Active/passive masters to makes MySQL failover very simple.
On 19 October 2010 11:45, Johan De Meersman wrote:
> That's pretty much it, indeed. You need to make absolutely sure that no
> more
> connections can be made to the old,
On Tue, Oct 19, 2010 at 1:03 PM, Carl wrote:
> Johan,
>
> You state that master - master is not reliable in dual active environments.
> I am in the process of setting up just such an environment (moderate active
> on the primary server, lighter activity on the other server.) Do you know
> where
Hi,
There is a detailed readme (text file) within the file you have downloaded.
It will gives you the complete picture.
Krishna
cgi.com
On Mon, Oct 18, 2010 at 9:24 PM, ml ml wrote:
> Hello List,
>
> i am trying to install mysql on debian lenny from source. Here is what
> i did (yes, i did rea
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Krishna
CGI.COM
On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan wrote:
> Hi,
>
> I am using the following version of MySQL on my Mac
Hi,
I've the following query :
SELECT IFNULL(SUM(gate_receipts),0) AS gate_receipts, competitions.caption
FROM fixtures_results
INNER JOIN competitions ON fixtures_results.competitions_id =
competitions.competitions_id
WHERE home_teams_id = 27
AND worlds_id = 1 AND status = 'approved'
However, I
The short answer is this: You need special software outside of MySQL to do
this. This software has to
- Keep a heartbeat going between the two servers. Whether or not you do this
by checking only MySQL, or the machines themselves, depends upon what other
applications might be running (web serve
Ok, been googling all morning, and keep getting the same post (on
multiple different sites).
Is there a way, where i corrupt a table purposely? I've tried playing
with the .MYD file, and yeah, it "marks" it deleted under the check
routine, but the table is still readable/writable, just doesn't
Hi,
Keep key_buffer_size very low and insert lots of data into table (myisam).
After some time the index file will crash.
Krishna
CGI.COM
On Tue, Oct 19, 2010 at 7:53 PM, Steve Staples wrote:
> Ok, been googling all morning, and keep getting the same post (on
> multiple different sites).
>
>
Hi,
I think I've managed to do it :
SELECT
IF(competitions.competition_type = 'cup',
IFNULL(ROUND(SUM(gate_receipts)/2),0), IFNULL(SUM(gate_receipts),0))AS
gate_receipts
FROM fixtures_results
INNER JOIN competitions ON fixtures_results.competitions_id =
competitions.competitions_id
WHERE home_tea
Of course you know you did not delete r...@localhost, just root @ '%'
which generally should not matter to mysqldump.
What I suspect is the issue here is that the database you are trying
to dump contains procedures/methods that were defined by a user while
logged in as root@'%'. If you recreate t
I had an old version of mySQL on my computer but never used it. I thought I
knew the root password but it wouldn't let me in. I went ahead and uninstalled
it thinking I would get a newer version anyway. I used the Windows interface to
uninstall the previous version. It appeared to be gone but wh
It's easy to corrupt the MYISAM index (MYI) file... I do something
like this in linux -- assuming your table is not tiny, and mysql isn't
running or you have a lock on the table:
dd if=table.MYI of=table2.MYI bs=2048 count=100
then copy table2.MYI over table.MYI and then "flush tables" and then u
Tammie,
You might just try resetting the root password
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-windows.
Hope this helps,
Tyler
On 10/19/10 12:38 PM, Montgomery, Tammie wrote:
I had an old version of mySQL on my computer but never used it. I
Hi all,
How to install multiple instances in windows???
Thank you.
I'll tell a much easier way to corrupt table. Open the data or index file,
remove some text data in the file and save.
It will show it a corrupt. ( Only for test setups ).
On Tue, Oct 19, 2010 at 10:11 PM, Hank wrote:
> It's easy to corrupt the MYISAM index (MYI) file... I do something
> like th
by running it on different ports.
On Tue, Oct 19, 2010 at 10:42 PM, kranthi wrote:
> Hi all,
>
>How to install multiple instances in windows???
>
>
>
> Thank you.
>
>
--
Thanks
Suresh Kuna
MySQL DBA
http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html#c11545
Note that if you are trying to keep your own database of cities and their
timezones, you can NOT use the mysql.time_zone_name.Time_zone_id as your FK
because the key will change the next time you get a new "tzdata" update
(like f
To Clarify this a bit: You can only reliably do writes to one server.
Your reads can go to both servers with no problems.
For reads that need to read data that was just written though, you
need to read from the 'active' master, as you can not rely on
replication to be instantaneous.
On Tue, Oct 19
On Tue, Oct 19, 2010 at 19:06, John Daisley wrote:
> You may also want to take a look at MySQL MMM which makes use of
> Active/passive masters to makes MySQL failover very simple.
+1 We could not do much of our daily work without MMM. It makes
the whole HA/Failover thing a breeze. We have it i
Hellpo Krishna,
On 10/19/2010 8:40 AM, Krishna Chandra Prajapati wrote:
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Not true. The utility mysqldump is just a client like any oth
Yes, r...@localhost entry is still present in user table. Only
root@'%' is deleted. So it's not obvious to fail.
Hi yu.zou,
The r...@localhost entry already had all privileges, except this entry
had empty password column.
u...@localhost entry before GRANT
+---
You mention the Windows installer has Hung. I have seen this before...try
killing the process with task manager and then log into your server via the
client.
-- Sent from my HTC Desire on 3 --
- Reply message -
From: "ext Tyler Poland"
Date: Tue, Oct 19, 2010 17:50
Subject: uninstall/r
28 matches
Mail list logo
