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

1
vote
1answer
211 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
488 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
568 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
299 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
568 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
2answers
51 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
42 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
1k 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
368 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
257 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
226 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
325 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
229 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
172 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
451 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
826 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
83 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
800 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
51 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
66 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
4k 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
3k 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 ...
3
votes
1answer
6k 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
201 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
1k 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
1k 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
804 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
82 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 ...
3
votes
2answers
644 views

Why does MySQL replication break on missing row, then continue after “START SLAVE”?

The title is a bit confusing, but I can't think of a better one. What I have is a simple vanilla MySQL replication, with the slave occasionally failing, with this error: Error 'Can't find record in ...
3
votes
2answers
1k views

mk-table-sync in a master-slave scenario: Changes not replicated to the slave

I have being employing mk-table-sync to synchronise tables from a master to slave on mysql 5.1. Unfortunately, while differences are correctly detected, modifications done on the master ...
0
votes
1answer
122 views

Mysql slow query log issue…?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # ...
0
votes
4answers
3k views

Easiest way to sync a dev MySQL db to a production MySQL db?

We have a staging server with MySQL installed locally. We plan on running Expression Engine, which requires a database. On the production side, we have two apache servers that are load balanced, so ...
12
votes
4answers
8k views

MySQL Master-Master Replication of ALL databases. How?

Background: I have two MySQL 5.1 servers setup in Master-Master row-based-replication (RBR) following this excellent guide. I want all databases replicated, and will be adding new databases ...
0
votes
2answers
940 views

MySQL Replication - IP Failover

So, I setup master-slave replication in MySQL on two virtual machines in two different physical servers. The problem that I am scratching my head at now, is, when the master goes down, how do the ...
1
vote
3answers
3k views

MySQL in star topology

I have one central database with all the data in MySQL 5.1-lastest-stable. I want to hook up multiple clients in a master-master relationship. Question How do I setup a star topology with 1 central ...
2
votes
3answers
2k views

Secure MySQL replication; SSL or SSH tunneling?

I have a Master-Master MySQL replication setup between two servers. I'm about to move one to another location, so replication will be over the Internet and will - of course - need to be secured. ...
1
vote
2answers
116 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 ...
1
vote
0answers
278 views

MySQL Master silently drops slave thread, replication will not restart

We have a very active (high rate of change) MySQL master / slave. After the slave was offline for a few hours (over a million binlog entries missed) the slave will not start replication again. When ...
6
votes
1answer
691 views

Recovery strategy for Master-Master replication

I have implemented a HA solution for mysql based on master-master replication. There is a mechanism on the front end part which guarantees that only one db will be read/written to at a given time ...
1
vote
1answer
72 views

MySQL database solution

I have 2 offices that are located around 500km apart and both offices need to access the MySQL database frequently. So to make it faster I am planning to set up two MySQL servers where each office has ...
0
votes
2answers
135 views

Mysql Replication restart

I have a slave db (db1) that I moved into the master position after my master db (db2) died. I brought up a new slave db (db3) from a day old snapshot of db1, my problem is trying to figure out which ...
1
vote
2answers
6k views

Why is our MySQL table-opens so large and cache-hit so low?

We're seeing a weird statistic on the number of table-opens. I've appended the mysqltuner dump below. It says we've open 94,000 tables in the past 24 hours. But there's only 15,000 tables total and ...
0
votes
1answer
327 views

Mysql Replication— restricting drop database statements

we have a master-slave mysql replication setup. The master has multiple databases and they get created and dropped, fairly often. I would like to restrict the slave to not drop the databases. I ...
0
votes
2answers
303 views

Any problems with my mysql replication setup command?

I wrote myself a small script that produces the following shell command. echo "CHANGE MASTER TO MASTER_USER='slave_user';" | mysql -uroot -pXXX --host=SLAVE && echo "CHANGE MASTER TO ...
4
votes
1answer
3k views

How to get rid of mysql binlogs?

I've been using mysql for development. I don't use replication but I guess I had binary-logging enabled for some time on one of my previous computers and I have unknowingly accumulated hundreds of ...
0
votes
1answer
597 views

MySQL Master-Master replication using MMM on Linode

Linode allows you have multiple IP's assigned to your node but I'm trying to setup MySQL Master-Master Replication with MMM following the guide on http://mysql-mmm.org/mmm2:guide. One part I don't ...
2
votes
1answer
2k views

How do you load a database with foreign keys on the master without out breaking replication?

I have a MySQL master-slave setup. One master; One slave; Lots of databases. I'm moving an app into this setup from third party. They provided a mysqldump file of the data and database structure. It ...
1
vote
1answer
111 views

MySQL Database Replication and Server Load

I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL ...
1
vote
1answer
343 views

Changing MySQL master host on slave and preserving MASTER_LOG_POS, MASTER_LOG_FILE

Folks, my master MySQL server got an additional NIC used for local networking and now I want all slave servers to use the new local IP of the master server. I know I can achieve this using "CHANGE ...