Tag Info

Hot answers tagged

2

Original Answer (leaving for people that might hit this because of the simple explanation): The clusterAdmin role only applies when you authenticate against the admin database, so unless you specify the --authenticationDatabase option to be admin when you are running mongodump/mongorestore I suspect you are getting a lesser privilege when authing against ...


2

this could be because of openssl update. take a look at the following https://github.com/iuscommunity-pkg/mysql55/issues/4 a notable bug that occurs with the latest version of OpenSSL. This issue prevents secure connections from being made due to the default hardcoded cipher no longer being supported in the newer version of OpenSSL. Below is an ...


2

Use the built-in bitwise operators to examine the column. For example select schema_option & 0x01 AS GeneratesObjectCreation, schema_option & 0x02 AS GenerateCustomSP, ... etc.


2

There are two ways to run a replica. You can use either, or both together: Streaming replication, where the replica makes a PostgreSQL protocol connection to the standby as configured with primary_conninfo in recovery.conf; or WAL shipping, where the replica runs a restore_command (set in recovery.conf that fetches WAL archives to replay. See ...


2

From your description, it sounds like you need something like Bucardo to try and merge data from multiple sources into one. Though you'll probably have to write some custom conflict handlers to deal with data that conflicts across B, B1, and B2. There are examples out there like this for custom conflict resolution: ...


2

Yes, if you are using Peer2Peer replication between the primary and secondary servers which is an enterprise only feature I would personally use Mirroring/AlwaysOn for redundancy between primary and secondary sites as this includes ways to failover without changing the DNS records. Either by adding ';Failover Partner=PartnerServerName;' to the connection ...


1

what will be the effect of this on fields of type "timestamp with timezone"? They're converted from their internal UTC representation to UTC-5 at the moment. They'll be converted using UTC+4 after. So applications will see a 9-hour time shift if they're ignoring the time zone. If they respect the time zone reported in the timestamp then there will ...


1

I have seen this since about 2002. Ignore it; it will go away. I have failed to find out what causes it, and it so elusive that I could not get anyone to look at as a "bug". I do not know if this will have any impact on innobackupex.


1

Not sure if you have checked this; but there is an option in sp_addarticle called @identityrangemanagementoption. If set to manual, then it "Marks the identity column using NOT FOR REPLICATION". Pls check if this is the case. Ref : https://msdn.microsoft.com/en-us/library/ms173857(v=sql.110).aspx


1

I've confirmed this is a bug with MySQL/Oracle Support. They will update the public tickets when the internal fixes are ready. To summarize: MySQL replication is only supported between one release level (the second digit) and the next; e.g. between MySQL 5.1 and 5.5; 5.5 and 5.6 but not between MySQL 5.1 and 5.6. The documentation is mistaken when it says ...


1

To migrate data between different storage engines in MongoDB 3.0 you will need to perform an initial sync to the new replica set node or use mongorestore to seed a new replica set with your data. If you want to add a node with a new storage engine to a live production replica set, rs.add() is the correct approach. To ensure a smooth upgrade I would also ...


1

The MASTER_DELAY option is currently scheduled to be in MariaDB 10.1. There is an issue for the feature. Until that is added to MariaDB, your best option is pt-slave-delay from Percona. I've used it before and it is pretty easy to get going but since it isn't part of the mysql server, it's not as reliable.



Only top voted, non community-wiki answers of a minimum length are eligible