I have two different servers(A1, B1) with mysql-5.1.73 and currently, I'm replicating DBs with another two servers(A2, B2).   I would like to know is it possible to do a centralized DB replication, which means replicating DBs of both Master_A1 and Master_B1 to a single Slave_A2.  P.S: database and their table names will be same in both Master servers.
120514
I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
80398
In general is it problematic to cluster across two datacenters that are up to 15-miles apart?  For this one particular project the approach is the following?   2-Node Failover Cluster across two datacenters, one node per datacenter local SAN disks, no shared disks 'Node and FileShare Majority' at third location on-campus employ AAG, failover will be manual; asynchronous mode   Is anyone implementing something like this with success??!?  Thanks so much for the help!!
79019
My scenario is I have a thick client side app using a SQL DB. The use of the app is divided into 10 "sites" mostly by Geography but some by Usage. I've written an SP to archive selected data out of the DB and put it elsewhere as the DBs are growing to nearly 500GB in size at this point. Further whilst most servers host one application DB there is one server (and instance) that hosts 3 DBs.  My dilemma is I want to write code that is the same everytime. Ideally I would write something like  declare @dbname varchar(20) set @dbname = 'Archive' + DB_NAME(DB_ID())  INSERT INTO @dbname.dbo.ArchiveTable (ID, DATA) SELECT (ID, DATA) from TheData WHERE Archive = 1   That way I can have the same SP installed on each server, any bug/feature fixes doesn't need me to manually type up 10 different SPs to install.  In the real world I'm also limited by SQL2000 however I'd be interested to hear in ideas using SQL2000 and/or SQL2008R2. The servers are a mixture of both.  As I understand it Synonyms wouldn't help as on the instance with 3 DBs I'd still end up with each DB having it's own copy of the SP with it's own hard coded definition of which named synonym to use.  I also don't feel dynamic SQL statements would be a good fit. There's more to it than the example snippet above and I use table variables to marshal all the work to be done- so that would be out of scope for all the other statements I need to work with.
96803
It was convenient that MyISAM used to store each table in a corresponding file. InnoDB has made advancements in many aspects, but I wonder why InnoDB stores all databases in one file (ibdata1 by default).  I understand that InnoDB will map the location of data in the file by individual index files for tables, but I do not understand why it mixes all data in one file. And more importantly, why mix the data of all databases on the server?  An interesting feature of MyISAM is that one can copy/paste a database folder to another machine and then use the database (without a dump).
124032
In my environment, I have Db01 and Db02 setup with SQL 2012 AlwaysOn. Db01 is the preferred master as that is where all of the backup jobs reside. Typically, the only time that Db01 is unavailable is during maintenance period of installing Windows Update.   Is there a way to always have Db01 be the primary when it is a member of the cluster? Currently, when Db01 rejoins the cluster after a reboot, it is marked as the secondary, since Db02 has become the primary. I would like to see Db01 join the cluster and then automatically (or via a command executed on startup) be designated primary.  Db01 and Db02 are both set to SYNCHRONOUS_COMMIT and Automatic Failover Mode
5936
I need to move 20 Gb MySQL database from on Debian server to another. The problem is that there is no way to create its backup since there are almost no free HDD space on the source server. What would you suggest?
124120
I have one database which contains the most recent data, and I want to replicate the database content into some other servers. Due to non-technical reasons, I can not directly use replicate function or sync function to sync to other SQL Server instances.  Now, I have two solutions, and I want to learn the pros and cons for each solution. Thanks!  Solution 1: detach the source database which contains the most recent data, then copy to the destination servers which need the most recent data, and attach database at the destination servers;  Solution 2: make a full backup of source server for the whole database, then copy data to destination servers and take a full recovery at the destination server side.  thanks in advance, George
55040
We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of MySQL we will run ... either Community or Enterprise, but that is a TBD. Looks like we will be running the InnoDB engine, OS is going to be RedHat EL 5.5 The primary servers are going to be active, while the secondary will be passive or hot stand-bys.   I would like to implement replication, high availability and automated failover in MySQL across the two data centers.   After a failover to the secondary servers, when we fail-back to the primary servers, we'd like to have data synched from the secondary DB to the primary DB quickly and completely so that we can continue to serve content from the primary servers.  I am interested in knowing what technologies/tools/best practices can be used to solve/address these issues. Also, any gotchas or ah-ha moments would be much appreciated as well. I've read up on MySQL replication, clustering, and at some 3rd party tools like Tungsten and Dolphinics, but I a unsure what the is best course of action.  Thank you for your time!  KM
43587
This is a  about Redundant DHCP Servers.   Is it possible to have more than one DHCP server on the same LAN? What are the implications of doing this?    What happens if there is more than one DHCP server available? How do my clients know which one to use?  How can I have DHCP servers supplying addresses to more than one subnet\network segment? How can I configure multiple DHCP servers to supply addresses for the same subnet.
28720
I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database.  My questions are:  How can it automatically change host of one if the other one was dropped ?  Is the performance of mirroring is acceptable and is there another way to make one as host and other is backup then if the main server was dropped the other works automatically better than mirroring?
84860
Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without content) into another without using mysqldump?  I am currently using MySQL 4.0.
119956
How can I move MySQL tables from one physical server to another?  Such as this exact scenario:  I have a MySQL server that uses innodb table and is about 20GB size.  I want to move it to a new server, what's the most efficient way to do this?
60317
I currently have a Master with 2 slaves, all running MySql 5.5.  What are the limitations on the amount of slaves I can connect to a single master? what parameters should be taken into affect?
6636
I am using , and want to use it to execute the checks on all of my SQL Servers and have it write the results to a single table.   Do I need to create linked servers on the central instance to connect to the other instances, or is there some other way to input the server names into the sp_Blitz stored procedure?
89672
I have two processes which execute code like this in parallel:  begin; update foos set unread=false where owner_id=123 and unread=true; commit;   This results in deadlocks.  My understanding of what causes deadlocks is like the scenario described in , with "interwoven" UPDATE statements updating two different rows in a different order. I don't understand how a single UPDATE statement could result in a deadlock. I'm not able to replicate the deadlock scenario using two parallel psql sessions in my dev environment. My guesses for why I can't replicate it:   I'm misunderstanding my code which creates the deadlock error, and there are actually multiple UPDATE statements in each transaction The "interwoven" aspect is happening, but "within" the UPDATE statement which covers multiple rows, so it's difficult to replicate.   Is it possible for this single UPDATE to be creating the deadlock?
123419
I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data.  I would like to establish a reporting server (may be 2008 or 2012), that consolidates the rows  from selected tables across the 8 source servers into a single instance of those tables on the reporting server. This is one-way replication (no changes will be made to the reporting server). I will need to replicate changes from the source databases with relatively low latency (say 20-30 seconds).  Furthermore, I'd like to find methods to achieve this with as little impact to the source servers as is practical.  3rd-party agents, triggers, or schema mods to those servers are difficult in my environment.  My questions:   What are promising architectures and technologies for  achieving this goal?  I've looked at SQL Server Merge Replication, but I am concerned about latency. Is this an appropriate technology for this goal? Are there many-to-one architectures for transactional replication?   Should I be looking at 1-to-1 replication into 8 databases on my reporting server, followed by some custom merge function (a 2-step replication)?   Thanks, John
36586
Quick question - I run two linux boxes, one my own desktop and the other my VPS. For security reasons on the VPS end I opted for socket connections to MySQL (/var/run/mysqld/mysql.sock). I know I can tunnel like this: ssh -L 3307:127.0.0.1:3306 user@site.com if I set up the remote sql server to listen on some port, but what I want to know is can I do something like: ssh -L /path/to/myremotesqlserver.sock:/var/run/mysqld/mysql.sock thereby tunnelling two sockets, as opposed to two ports?  A perfectly acceptable solution would also be to forward a local port to the remote socket file, but where possible I'm trying not to have tcp servers running on the remote box.  (and yes, I know tcp would be easier).