SQL Database Performance Tuning for Developers
Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most SQL database tuning will…
PostgreSQL – Recommendation document
dbversity_PostgreSQL_recommendation-doc Product Description: PostgreSQL is an open source object-relational database system. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant,…
Score Cards of MySQLDB vs MariaDB vs PostgreSQL
MySQLDB_MariaDB_PostgreSQL_ScoreCards MySQL #Scr MariaDB #Scr PostgreSQL #Scr MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities Widely used open source RDBMS Based on the object relational DBMS Postgres …
Mongo Ruby shards now available
If you have already imported the certificate then you can also use the below code (much simpler version). import com.mongodb.*; import javax.net.ssl.SSLSocketFactory; public class SSLApp1 { public static void main(String args[]) throws Exception { System.setProperty(“javax.net.ssl.trustStore”, …
[MariaDB]: Configuring & setting-up Galera Cluster.
MariaDB MariaDB is a community-developed fork of the MySQL relational database management system, the impetus being the community maintenance of its free status under the GNU GPL. Being a fork of a leading open source software system, it is notable…
[PostgreSQL]: YSCB Benchmarking
[ postgres @ dbversity : /YCSB-master ] ls -lhtr total 2.4M -rw-r–r– 1 postgres postgres 479 Aug 18 2014 NOTICE.txt -rw-r–r– 1 postgres postgres 7.9K Aug 18 2014 LICENSE.txt -rw-r–r– 1 postgres postgres 2.6K Aug 18 2014 CHANGELOG drwxrwxrwx 2…
[PostgreSQL]: How to check Replication lag
We can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using pg_current_xlog_location on the primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_location on the standby,…
[PostgreSQL]: Replication setup
Postgres installation : [ root @ masterhost : ~ ] yum install postgresql postgresql-server http://guegs3.nam.nsroot.net/SOELinux/repos/prod/soe6gdeproducts-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 – “The requested URL returned error: 404 Not Found” Trying other mirror. Setting up Install Process Resolving Dependencies –>…
PostgreSQL Installation using Yum
[root@ip-10-0-0-14 ec2-user]# sudo yum install postgresql-server postgresql-* Loaded plugins: priorities, update-motd, upgrade-helper amzn-main/latest | 2.1 kB 00:00 amzn-updates/latest | 2.3 kB 00:00 4 packages excluded due to repository priority protections Resolving Dependencies –> Running transaction check —> Package postgresql-jdbc.noarch 0:8.4.701-8.11.amzn1…
[PostgreSQL]: Data directory is not empty! Error
[root@ip-10-0-0-228 ec2-user]# service postgresql initdb Data directory is not empty! [FAILED] [root@ip-10-0-0-228 ec2-user]# Clean-up the data files & restart [root@ip-10-0-0-228 ec2-user]# ll -lhtr /var/lib/pgsql9/data/ total 88K -rw——- 1 postgres postgres 4 May 5 09:32 PG_VERSION drwx—— 2 postgres postgres 4.0K…