replication

I have a Master-slave replication setup, it is working from the command line - I execute an insert statement which in turn updates the log file, and…

I have two databases: 1) accounts-management 2) games-management I want to make reports, which use data from both databases and i want to have third…

I currently have 2 mysql servers running, 1 as master and 1 as slave as in the mysql manual…

I try to setup replication from slave to the master. CHANGE MASTER TO MASTER_HOST = 'master', MASTER_PORT = 3306, MASTER_USER = 'repl',…

Is it possible to set up replication on a single mysql server, replicating a few tables (for readonly access) from one database to another? So say…

If a data block is replicated, in which data node will it be replicated to? Is there any tool to show where the replicated blocks are present?

I am curious how com.mysql.jdbc.ReplicationDriver works. I have configuration with 1master & 1slave. I want to force some queries to JUST on…

Our development team is currently looking into migrating our search system to Apache Solr, and we would greatly appreciate some advice on setup. We…

I've set up a MySQL database as a master server, and a second MySQL database as a slave. When I create or drop a database on the master, I can see…

I have the following problem. I have a MMORPG game based on PHP and MySQL with now around 600 queries per second averagely. I happen to have…

We are currently evaluating failover support in different databases. We were earlier using HSQLDB but it seems that it does not have…

Consider there is one DB -DB1 on one machine-M1, which has many tables. There is a different DB2 on other machine-B . Now there is a requirement…

I need to exclude some files from being logged in the binary log to avoid wasting my network bandwidth and time on replication of caching tables. i…

Current configuration is basic Master->Slave replication. Each night various data import jobs run on master. During this time, slave replication…

I have two Linux boxes. On the master following is the configuration file (my.cnf) log-bin = master-bin log-bin-index = master-bin.index…

I'm trying to set-up bucardo in a master-slave setup with pushdelta, however I keep running into the following error when trying to create the sync.…

cross database syntax like INSERT INTO SOME_TABLE SELECT * FROM DATABASE1 .OTHER_TABLE is breaking replication even though SOME_TABLE is in…

I've got a vanilla MySQL replication, using "MIXED" mode. The mysql slave lag calculation behaves very strangely - one moment it is 0 and the one…

Hello, I am hosting my website on a shared server, with a mysql database which I can access it using phpmyadmin only. Can we setup replication…

I am not a DBA; I'm the primary developer of an enterprise database based application. I'm currently specing out some new machines to upgrade our…