The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
3answers
37 views

Can data be replicated from a slave MySQL back to a master without the slave containing all the master data?

We have a PHP/Symfony 2 application using MySql as the database. The database contains a large amount of data. The application is deployed to a separate server(s) and an empty/clean version of the ...
1
vote
1answer
22 views

Recovering credential data from a master DB backup

On a SQL 2008 R2 instance, a misconfigured credential used as a SSIS proxy for an SSA job was dropped before I could look at the system views to figure out when it was originally misconfigured. I ...
0
votes
1answer
18 views

Prevent MySQL to connect Master

We switched a slave to master today and after restarting the new master it tries to connect to the old master. Even with stop slave;, it tries to connect after restarting.
1
vote
0answers
91 views

MySQL replication error: Table doesn't exist

I just run a MySQL database master-slave replication using these instructions. The process seemed to be ok, but when I run some queries on the slave server I get this message on 3 of my tables. ...
1
vote
0answers
1k 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 ...
1
vote
0answers
87 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
0answers
152 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
220 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 ...
1
vote
0answers
91 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).
0
votes
0answers
49 views

PostgreSQL streaming replication with slots works for one slave, but not for another slave

Master (10.0.0.1): Edit postgresql.conf listen_addresses = '*' wal_level = logical max_wal_senders = 3 max_replication_slots = 3 hot_standby = on Edit pg_hba.conf host replication ...
0
votes
0answers
744 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
32 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
141 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 ...