The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
6 views

Mysql Master - Master Replication

i have established a master A and master B replication between two servers.Both are getting replicated.But it is limited with only one database. My questions 1.How to create a new database in ...
0
votes
0answers
17 views

How to solve MySql Slave Error 1452 Foreign key constraint fails?

I am site administrator. We use to have a mysql 5.5.40 master(db01) - slave(db02) setup. One day our master server (db01) got down due to hardware failure. So we switched our site to slave (db02) ...
0
votes
0answers
11 views

Master-Slave replication (Master as my local system and Slave as VPS server in cloud)

Please suggest me how to connect Master-Slave replication process in My local system and Cloud VPS ?. Here i purchased VPS WPS(centOS) from godaddy,this server i'm making it as slave and making my ...
0
votes
1answer
45 views

Why does my MySql Savel replicate changes that are neither in binlog_do_db nor replicate_do_db?

I have a standard simple master slave replication that usually runs fine. But sometimes, all of a sudden, I get replication errors on the "phpmyadmin" table. I have explicitly only specified one ...
0
votes
0answers
241 views

Database Properties Error - sys.spt_values missing but dbo.spt_values works?

We have SQL2012 SP1 installed on several servers and have run into an issue on one instance trying to view the database properties in SSMS. (This happens with both SSMS 11.0.5058.0 and 11.0.3128.0.) I ...
0
votes
1answer
46 views

how to setup [master] - [master-slave] - [slave] mysql replication

i am trying to setup a mysql replication architacture between 3 mysql server. (by following some tuto like ...
0
votes
2answers
583 views

MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?

We have a large mysql database (about 100GB on disk) that we would like to spawn a slave for. Our typical process for creating a slave is: Create a slave server Load in a mysql dump of the master ...
1
vote
2answers
414 views

Galera Cluster with MariaDB 10 and asynchronous slave

So, as it's easier to understand what I'm trying to accomplish with a picture. Here's a picture: I'm really not an expert in database administration, so please be patient. I am working on a setup ...
0
votes
0answers
67 views

mongodb master slave replication

I Have Setup master slave replication in mongo its working fine for few month then after that suddenly replication fails.I have started again with initial sync but during sync after a specific point ...
3
votes
1answer
136 views

When interrupting a query on a Master, does it replicate to the Slave?

In MySQL, when does the master send a query to the slaves? Here's a specific scenario that I'm trying to understand. Admin entered an update on master that took a long time to execute. Admin hits ...
1
vote
1answer
19 views

CREATE TABLE not issued on other masters

Database is created on all multi masters. Why CREATE TABLE doesn't being replicated to other masters. some explanations?
0
votes
0answers
135 views

MYSQL 5.5 SERVER MULTI MASTER REPLICATION

Myself using mysql 5.5 in master side and in slave side(remote connection) It seems the configuration like log_bin,binlog_do_db are correct but it shows Slave_Io_Running : Connecting ...
0
votes
2answers
426 views

MySQL Master/Slave replication on same VM instance?

I'm fairly new to databases so I hope this isn't a silly question! Is it possible to set up master/slave replication on the SAME server? I understand there are not any advantages to this in terms of ...
0
votes
0answers
50 views

How to efficiently synchronize MySQL slave with secondary mater?

I have a database setup with chained replication: +-----------+ +-----------------+ +----------+ | A: master | <-- | B: slave/master | <-- | C: slave | +-----------+ ...
1
vote
0answers
52 views

Mysql Replication Master/Slave and Master/Master

Looking for some insight and opinions from some DBAs, as I've been tasked to look into using Master/Master replication for a single table in a database. We currently run mysql replication using a ...
1
vote
3answers
185 views

How to remove master role from MySQL server

I have 2 MySQL servers, one is the master and other one is slave, that's all good. The problem I have is that the slave is also set up as a master. I would like to disable or remove the master role ...
1
vote
2answers
2k views

Master - Master replication Duplicate entry

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days... My setup is as follow: One server in The ...
0
votes
0answers
89 views

Can maintenance plans be used in SQL Server multiserver (Master-Target servers) administration?

Since I failed to configure SQL Server 2012 Multiserver (Master and Target Servers) administration, I am eager to understand whether it (setting Master and Target servers) would permit to send from ...
1
vote
0answers
158 views

How to upgrade MySQL 5.0 to 5.5 with master-master replication?

I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31. The release notes state: SLE 11 SP3 introduces the upgrade of the MySQL ...
0
votes
0answers
30 views

Accessing Database from Slave server

I have an application running in one server eg: My Server's Ip is 192.168.10.10, and I have the MySQL database server in the same machine. The application connects database server as localhost. ...
0
votes
0answers
107 views

MYSQL replication not working with connector but works VIA phpmyadmin

I have setup a MYSQL replication, and have tested the replication by using phpmyadmin. On all occasions when using phpmyadmin, the data was being replicated successfully. But when records are ...
1
vote
0answers
63 views

Best practice for upgrading mysql on a master-master setup

Anyone have experience upgrading a master-master setup of Mysql 5.1 to a release version of Mysql while trying to keep at least one server online (in my case we are upgrading to MariaDB 5.5).
1
vote
1answer
104 views

Replication Master/Master, both master stop by themself

I did a master/master replication with MySQL on a Gentoo OVH Release 2, all work fine in my test phase, i put it in production, the replication works fine in 1 or 2 days but this morning, i don't know ...
1
vote
1answer
207 views

Do I need to perform any tasks after Postgres goes into recovery mode?

For starters, I do not have any sort of automated failover in place. After two scenarios, I'm unsure of the state of the database and any required actions, if any, to take: My master server ...
2
votes
1answer
99 views

PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave

I have a master database (PostgreSQL 9.0) and I need to setup a streaming replication on a slave. Slave db can read/write and make schema level changes too which shouldn't write back to master. Can ...
0
votes
1answer
418 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
1answer
123 views

Should we always prefer clustering over a master-slave configuration if the goal is high-availability?

Given: I have two virtual machines on a SAN that I can use to host RavenDB. Question: If my goal is high-availability, then should I always prefer clustering over a master-slave configuration? From ...
2
votes
1answer
968 views

Adding slave to existing master-master config in mysql throws Foreign key constraint failed error

We have two mysql servers running in master - master configuration. Now we have to add a slave to the existing configuration. But upon adding the third DB server and starting slave on it, it throws ...
0
votes
2answers
314 views

Need advises for a new MySQL architecture

I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up: Scale of deployment 5 servers with a ...
2
votes
1answer
103 views

Created databases and inserted data on MySQL slaves in Master-Slave replication - how to fix?

I got MySQL Master-Slave replication running on 1 master with 2 slaves. SHOW MASTER STATUS / SHOW SLAVE STATUS says they are in sync, but databases have been created on the slaves and filled with data ...
2
votes
1answer
562 views

Safely promoting master to slave

Previously I've asked the similar question MySql Switching Masters During Failover with log-slave-updates. Let's say this is our current replication In addition, I have few application servers. ...
0
votes
1answer
1k views

MySQL 5.5 not starting after master-master configuration

The following master-master configuration worked on MySQL Server 5.1.x(Ubuntu 10.04). Master1(192.168.2.80) ################################## #MySQL Replication ################################## ...
5
votes
3answers
2k views

What would cause an orphaned ##MS_PolicyEventProcessingLogin##?

This morning I noticed my SQL Log was filling with the following message. The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the ...