0
votes
0answers
9 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
2answers
89 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
2
votes
3answers
175 views

MySQL specific database replication (Master - Master)

We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this... We have a second ...
1
vote
3answers
206 views

Replicate between mysql 5.0.xx community and enterprise edition over ssh

I'm trying to setup a mysql replication over an SSH tunnel. The odd thing about this setup is that I have one master with mysql 5.0.60sp1-enterprise-gpl-log and one slave with mysql ...
2
votes
2answers
158 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
0
votes
1answer
68 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
1
vote
2answers
149 views

Measuring MySQL Replication Delay

How to measure MySQL replication delay between 2 MySQL servers ( 1 Master 1 Slave ) ? Given that two Xeon E5620 grade 1U servers are separate machine in same network segment, using MySQL Community ...
1
vote
2answers
627 views

Broken Slave (MySQL replication)

Last night one of the developer ran a wrong mySQL statement (Query inserting a row with duplicate primary key) on master machine. Suddenly the replication to its slave stopped. Slave started writing ...
0
votes
1answer
88 views

mysql performance optimization after enabling replication

Over the weekend I upgrade my Ubuntu server from 9.10 to 10.04 which also updated my MySQL server. I also enabled MySQL replication over to another server as slave. I have not yet moved any ...
4
votes
2answers
782 views

Are Master-Master database collisions a problem even with auto increment?

I've done quite a lot of reading into this and I'm still I'm not sure where I stand. Am I going to get database collisions (and then corruption) with two Masters both receiving writes ? Now that ...
1
vote
2answers
100 views

MySQL Replication Server Error

My replication server showing the following error,Please go through the query and tell me your comments.The insert query is working in live DB server Properly , but showing error in replication DB ...
3
votes
3answers
1k views

mysql best practices with replication of the mysql db (grants storage)

is there a best practice to ensure that privileges do not get replicated to mysql slave servers? the problem is, there a maintenance users in the mysql table that have different passwords on each box. ...