I have very large databases with tens of thousands of tables some of which have up to 5GB of data in 10’s of millions of entries. (I run a popular service)… I’ve always had headaches when backing up these databases. Using default mysqldump it quickly spirals the server load out of control and locks up … Read more
I suggest you to use IF() to do that. Refer: conditional-duplicate-key-updates-with-mysql INSERT INTO daily_events (created_on, last_event_id, last_event_created_at) VALUES (‘2010-01-19’, 23, ‘2010-01-19 10:23:11’) ON DUPLICATE KEY UPDATE last_event_id = IF(last_event_created_at < VALUES(last_event_created_at), VALUES(last_event_id), last_event_id);
Add “?connect=replicaSet” to the end of your connection string if connecting to MongoLab. new MongoClient(“mongodb://username:password@ds011111.mongolab.com:11111/db-name?connect=replicaSet”) This JIRA ticket has some details: https://jira.mongodb.org/browse/CSHARP-1160 Basically the default is to connect to a replica set member. But MongoLab’s Single-Node settings are actually a single node replica set and this causes us to not trust it. Appending ?connect=replicaSet to … Read more
The answer by baldy below is correct, but you may also need to enable 32-bit applications in your AppPool. Source: http://www.alexjamesbrown.com/uncategorized/could-not-load-file-or-assembly-chilkatdotnet2-or-one-of-its-dependencies-an-attempt-was-made-to-load-a-program-with-an-incorrect-format/ Whilst setting up an application to run on my local machine (running Vista 64bit) I encountered this error: Could not load file or assembly ChilkatDotNet2 or one of its dependencies. An attempt was made … Read more
I’ve been doing A LOT of reading on the available options. I also got my hands on High Performance MySQL 2nd edition, which I highly recommend. This is what I’ve managed to piece together: Clustering Clustering in the general sense is distributing load across many servers that appear to an outside application as one server. … Read more