[MemSQL]: 4.0 Installation thorough memsql ops
MemSQL_4.0_Installation_thorough_memsql_ops
YCSB Benchmarks on Amazon RDS Oracle
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr total 16M -rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt -rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads -rw-r–r–. 1 501 games 2.3K Feb 23…
[MySQL]: General/Error log as a solution for user audit log
MySQL General Log : The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general…
[MongoDB]: How to simulate read/write transactions manually
[root@dbversity ~]$ /opt/mongodb/bin/mongo MongoDB shell version: 2.6.9 connecting to: test > > // To simulate write (inserts) transactions > for(var i = 1; i <= 10000000 ; i++){db.test_collection.insert({“_id” : i , “action” : “write transaction simulations”, ” iteration no:” :…
[Oracle]: SQL*Plus Client installation (sqlplus)
[root@ip-10-0-0-67 ~]# cd /home/ec2-user/ [root@ip-10-0-0-67 ec2-user]# ll -lhtr total 100M -rw-r–r–. 1 root root 95M Feb 24 2012 ycsb-0.1.4.tar.gz -rw-rw-r–. 1 ec2-user ec2-user 809K Jul 7 03:57 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]#…
3T MongoChef – Your New MongoDB GUI
Official website : http://3t.io/ Compare databases, collections and documents: discover differences in your data. See the differences, side by side: visualize comparison results. Built in synchronization: synchronize databases, collections, and fields. Explore the schema of your MongoDB data: find outliers and…
![[MongoDB]: Working with shards](https://dbversity.com/wp-content/uploads/2015/07/Sharding_Day8-150x150.jpg)
[MongoDB]: Working with shards
ReplicaSet 1 (rs1) : =================== ./mongod –shardsvr –replSet rs1 –dbpath /data/rs1_1 –logpath /data/rs1_1/rs1_1_mongod.log –port 27010 –smallfiles –nojournal –quiet & ./mongod –shardsvr –replSet rs1 –dbpath /data/rs1_2 –logpath /data/rs1_2/rs1_2_mongod.log –port 27011 –smallfiles –nojournal –quiet & ./mongod…
mysqlfabric commands
[ root @ vm-5cc5-bad6 : ~ ] mysqlfabric group lookup_servers mysql-ha-group Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 server_uuid address status mode weight ———————————— ——————- ——- ———- —— 4a914fd4-1eec-11e5-972b-005056bb627d 10.116.175.107:3306 PRIMARY READ_WRITE 1.0 [ root @ vm-5cc5-bad6 : ~ ] [ root…
[MongoDB]: How can I create a user with hash password insert with __system role.
__system¶ MongoDB assigns this role to user objects that represent cluster members, such as replica set members and mongos instances. The role entitles its holder to take any action against any object in the database. Do not assign this role…
MySQLFabric Q&A
MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features…