Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

learn more… | top users | synonyms

2
votes
1answer
283 views

Replication stops

I have 2 CentOS 5.5 servers runnig Mysql 5.5, configured as master-master replication. When on one server i have network problems, on another i see messages in log: 111105 2:38:30 [Note] Stop ...
0
votes
0answers
173 views

MySQL Replication delays INSERT queries

I am setting up MySQL master-master replication using Ubuntu and MySQL 5.0.51. I have two servers, which I will call Master 1 and Master 2. Master 1 is the master where clients connect to. About 50 ...
1
vote
0answers
146 views

MySQL master-master replication: “Lock wait timeout exceeded”

I am setting up master-master replication with MySQL. Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of ...
1
vote
1answer
221 views

MAMP MySql Master Slave Replication on local machine [closed]

Has anyone got a good tutorial or info how to make a master slave replication on a local machine with MAMP 2.0? Should I install multiple MySQL instances or can I do it with one installation? Thanks ...
0
votes
2answers
90 views

MySQL Master Slave Replication Not Working

I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master. Here is the relevant configuration on the master: server-id=1 ...
1
vote
2answers
199 views

mysql master master master

I have n servers and I am planning to setup n master servers using master-master configuration. What architecture will be the best one ? Also I need to take care of auto-increment table things... ...
0
votes
1answer
47 views

msyql replication time

I am planning to setup mysql master-master or master-slave configuration. Yet to be decided. But my question is, is there any way to specify in the slave or master saying that it needs to check for ...
1
vote
2answers
630 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 ...
1
vote
3answers
239 views

Is it possible with MySQL to have a database-specific Master Binary Log setup?

Is it possible for me to have a unique binary log per MySQL database on my MySQL server? I've done some googling and can't seem to find any solutions. Surely there's a way!!
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 ...
1
vote
1answer
108 views

Failed to Attach DB on replicated SAN

We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server. Our web servers ...
2
votes
1answer
576 views

Redundancy for WordPress sites

For static websites I'm using HAProxy (one master, several nodes with static HTML files on them). What services in addition would you recommend to allow WordPress sites to be hosted in the same way in ...
3
votes
2answers
4k views

MySQL binlog format dilemma?

MySQL version: 5.5.13 If I set binlog format to STATEMENT, I got the following warnings on the Master: [Warning] Unsafe statement written to the binary log using statement format since ...
0
votes
2answers
109 views

Replicate mysql database to DBserverBackup without stopping the service on DBserver

I have an Ubuntu Server with mysql database on it and I would like to copy its full content (data, users, anything) to another mysql server I have on the network. How can I obtain this result ...
2
votes
3answers
279 views

mysql replication master master

is it recommended to do mysql master-slave cluster or master-master cluster? do I need a 3rd party tool in order to do a master-master mysql cluster for the virtual IP? (I thought to use heartbeat ...
3
votes
3answers
966 views

Database scalability with write-heavy application

I have a write-heavy application. The application is best compared to surveys - the customer creates custom questionares and this is saved to the database. Most of the requests are from their users ...
0
votes
1answer
112 views

MySQL table keeps corrupting, need a simple fail over solution?

One of my clients servers recently crashed at the planet, we got an automatic email from them that they had to do a hard reboot. Since then mysqld stops running occasionally and then shopping cart ...
2
votes
1answer
433 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
0
votes
1answer
60 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
0
votes
2answers
690 views

MySQL Binary Logs more than 15 GB

Binary log in one of my server has grown more than 15 GB even after setting the max size to 1 GB. The MySQL server is as well not starting. Can anyone highlight what might have caused it ? Thanks.
15
votes
2answers
1k views

Is it ok to replicate the `mysql` database?

When I originally set up my master-to-master replication, I used: binlog-ignore-db=mysql and have been syncing the user accounts and grants manually. This is simply how it was done in the how-to I ...
1
vote
1answer
172 views

Setting up MysqlMM replication with EC2 instances with elastic IPs for both

I just spun up two EC2 instances and got an elastic IP for each. I can't seem to get it to connect. Here is the bulk of my config: auto_increment_offset=2 log-bin=master2-bin binlog-ignore-db=mysql ...
1
vote
1answer
454 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
0
votes
1answer
471 views

MySql backup using mysqldump in replication environment

I was checking the mysql backup script that being designed by senior mysql admin (left long time ago), just in order to implement the same setup for different client. all the steps were clear and ...
2
votes
1answer
249 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
1answer
474 views

Best MySQL failover and load-balancing for shared hosting environment [closed]

I am creating a shared hosting environment, load balanced and HA. HTTP/HTTPS is okay as well as the distribution of files (code and file uploads) between the servers. The last thing remaining is to ...
2
votes
1answer
39 views

MySQL slave attaches production database name to new views

I have a slave database that bears a different name than it's production counterpart. (We are using the replicate-rewrite-db option.) When I run a mysqldump from the slave (which I do for making dev ...
0
votes
2answers
40 views

Mysql replication where is ./data?

By following http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html I stuck when it ask me to shell> tar cf /tmp/db.tar ./data, where is ./data ?
2
votes
3answers
932 views

How to scale out mySQL with many Database Server (say 20 database servers)

To scale from 1 MySQL Database server to 4-5 server is very clear from the documentation by MySQL official developer website: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-scaleout.html ...
0
votes
2answers
289 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
2
votes
2answers
224 views

Is it safe to delete MySQL binlogs (mysql-bin.*)?

I have over 500 files in my /var/lib/mysql folder named mysql-bin.000522 (or some variation thereof)...each is anywhere from a couple megabytes to 1.1GB. Overall, these files are taking up >400GB on ...
1
vote
1answer
213 views

What version of MySQL first supported row-based replication?

I'm thinking of switching from STATEMENT-based to ROW-based MySQL replication, but I'm having a hard time figuring out if ROW-based replication is available on my 5.1.41-3ubuntu12.10-log ...
1
vote
1answer
320 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
0
votes
1answer
207 views

MySQL third-party replication agents or alternatives to circular replication

I'm planning the set-up of a secondary datacenter for an existing system that runs in a single facility and uses master-master MySQL replication between two machines. I plan to add two machines to the ...
0
votes
1answer
111 views

Syncing with Master DB after slave record is modified

I've set up a MySQL replication scheme between 2 remote databases. I've realized that if I change data on the slave DB, the changed data does not get updated again. For example, I have a table User ...
1
vote
1answer
361 views

Using MySQL partial replication with --replicate-do-table with queries that depend on a non-replicated table

I'm considering using --replicate-do-table on a MySQL slave to only replicate certain tables. When the master is configured to use MIXED mode binary logging, deterministic queries will be written to ...
1
vote
0answers
656 views

MySQL Replication: Slave I/O thread constantly dying and starting back up

I have MySQL running on Debian 5 (Lenny) between two MySQL databases. The data is being transferring between the two machines, but one of them is logging the fact that it's slave I/O thread is ...
0
votes
3answers
82 views

What is a good tool/method for version controlling a part of a live database?

Sometimes if a database gets corrupted, a replicated database could also replicate that same corruption. What is the best way to replicate/backup a database and prevent something like this from ...
1
vote
3answers
709 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
1
vote
1answer
49 views

maybe stupid question: If a single java app on a separate server is causing 23Gigs of Binlogs to be sent to the db replica

does this mean there is 23gb of traffic (or more ) moving between the Java app (server) and the master Mysql server? this has been bugging me. The reason why I ask is because we have one server that ...
0
votes
1answer
61 views

MySQL Replication, Master vs Slave commits

I have a production webserver with a MySQL database setup as Master. I have a dev server with MySQL setup as Slave, with the data successfully being replicated from the Master. What happens when a ...
4
votes
2answers
3k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
2
votes
1answer
2k views

MySQL Multi-Master Replication vs. MySQL Cluster

I need a MySQL database that is fast and supports many connections. Most of the connections will only be reading, but a few will be reading/writing. All connections will need to read and write at ...
2
votes
1answer
4k views

Failed to connect from slave to master with error “error connecting to master (1045)”

I try to setup replication from slave to the master. CHANGE MASTER TO MASTER_HOST = 'master', MASTER_PORT = 3306, MASTER_USER = 'repl', MASTER_PASSWORD = 'xxx'; And I did grant privileges ...
1
vote
2answers
181 views

Working setup for MySQL HA & LB

I have to setup High Availability and Load balancing for web(apache-tomcat+mod_jk) and MySQL(where all clients info is stored) server which are running on the same machine(ubuntu server). First I am ...
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
5answers
735 views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
5
votes
3answers
750 views

MySQL load balancing

I'm looking into ways to balance the load on our MySQL infrastructure, and can't seem to find an answer that works for me... :) So, I have one big and fat server, that handles everything. Many DBs, ...
1
vote
2answers
78 views

MySQL Slave set-up with lots of databases

I find myself in need of setting up a master-slave replication between a MySQL server with 4000+ DBs and it's first slave. The database is currently handling production workload and starting up ...
6
votes
3answers
1k views

Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables

I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I ...