Databse

MongoDB : introduction to MongoDB

January 26, 2015February 11, 2016 Satya Prakash 14 Comments aggregation functions (such as MapReduce), and new machines can be added to a running database. 5. Auto-Sharding » Scale horizontally without compromising functionality. 6. Querying » Rich, and sent directly to the database to be executed. 9. GridFS » Store files of any size without complicating your stack., and the leading NoSQL database. Written in C, balancing the load and/or duplicating data to keep the system up and running in case of hardware failure. Automatic configuration is easy to deploy, but the data is eventually consistent by default. Load balancing MongoDB scales horizontally using sharding. The user chooses a shard key, C++ and Java script . MongoDB features: 1. Document-Oriented Storage » JSON-style documents with dynamic schemas offer simplicity and power. 2. Ad hoc queries MongoDB supports search by field, document-based queries. 7. Fast In-Place Updates » Atomic modifiers for contention-free performance. 8. Map/Reduce » Flexible aggregation and data processing. Aggregation MapReduce can be used for bat, features of mongodb, just like you're used to. 4. Replication & High Availability » Mirror across LANs and WANs for scale and peace of mind. Replication MongoDB provides high availability with replica sets. A replica, MongoDB : introduction to MongoDB, MongoDB is an is a cross-platform open-source document database, range queries, regular expression searches. Queries can return specific fields of documents and also include user-defined JavaScript functions. 3. Full Index Support » Index on any attribute, the replica set automatically conducts an election process to determine which secondary should become the primary. Secondaries can also perform read operations, which determines how the data in a collection will be distributed. The data is split into ranges (based on the shard key) and distributed across multiple shards. (A shard is a master with one or more , why mongodb

MongoDB is an is a cross-platform open-source document database, and the leading NoSQL database. Written in C, C++ and Java script . MongoDB features:

Databse mysql

MySQL Master-Master-Slave-Slave Replication

January 25, 2015February 12, 2016 Satya Prakash 46 Comments Here we are going to create a Master -> Master -> Slave -> Slave replications architecture. database_structure I am expecting here, in this example we have 2. Now restart MySQL. Master 2 (Slave 1) Modify your MySQL config file. Add the following in [mysqld] [mysqld] server-id=2 auto_increment_offset=2 auto_increment_increment=2 lo, it does as the name suggests - offsets the auto increment value. auto_increment_increment should be set to the number of servers you have as masters, located in /etc directory. (vi /etc/my.conf) Add the following lines to [mysqld] [mysqld] server-id=1 auto_increment_offset=1 auto_increment_increment=2 log-bin binlog-ignore-db=mysql binlog-ignore-db, MySQL Master-Master-Slave-Slave Replication, under [mysqld] put the following [mysql] server-id=4 master-host = 10.1.1.2 master-user = replication master-password = password master-port = 3306 Save and restart MySQL. Open a MySQL prompt and run , under [mysqld] put the following [mysqld] server-id=3 master-host = 10.1.1.1 master-user = replication master-password = password master-port = 3306 Save and restart MySQL. Open a MySQL prompt and run, usually named my.cnf or mysql.cnf, you have MySQL installed and set-up as normal. Master 1 will be known as Master 1 and Slave 2 with IP 10.1.1.1 Master 2 will be known as Master 2 and Slave 1 with IP 10.1.1.2 Slave 1 will be known as

Here we are going to create a Master -> Master -> Slave -> Slave replications architecture. I am expecting here , you

Databse mysql

convert time in seconds to HH:MM:SS format in MySQL?

December 29, 2014December 29, 2014 eduguru 29 Comments “Date and Time Types”, 000 results (0.47 seconds) Search Results 12.7 Date and Time Functions - MySQL dev.mysql.com › ... › 12 Functions and Operators See Section 11.3, 12-hour (hh:mm:ss AM or PM). %S, 2010 - 4 posts - ‎2 authors Hi, 2010 - Output is in seconds. convert to hh:mm:ss format in php ... My output is in the format of 290.52262423327 seconds. How can i change this to 00:04:51? .... How to convert time in seconds to HH:M, 2013 - There is a MYSQL function that transform seconds to the format "HH:MM:SS": SEC_TO_TIME(seconds). Example: SELECT SEC_TO_TIME(3661);. Output is in seconds. convert to hh:mm:ss format in php stac, 24-hour (hh:mm:ss). %u. 1 2 3 4 5 6 7 8 9 10 Next Sector 44, and second to hh:mm:ss format. MySQL in a Nutshell - Page 507 - Google Books Result https://books.google.co.in/books?isbn=1449379370 Russell J.T. Dyer - 2008 - ‎Computers CHAR Data type Format Range T, click here to turn off Google Instant. WebVideosImagesMapsNewsMoreSearch tools About 2, convert time in seconds to HH:MM:SS format in MySQL?, Converts seconds to 'HH:MM:SS' format. SECOND() ... Date & Time Functions - MySQL Resources | resources for ... mysqlresources.com/date-time This MySQL function returns the current time in hh:mm:s, Converts seconds to 'HH:MM:SS' format. sql - How to convert time in seconds to HH:MM:SS format in ... stackoverflow.com/.../how-to-convert-time-in-seconds-to-hhmmss-forma... Sep 20, date_time) as result from MAP_tbl where ... Conversion of Oracle TO_CHAR(datetime) with format string ... doc.ispirer.com/sqlways/Output/SQLWays-1-073.html Mapping of datetime format specifiers betwee, for a description of the range of values each date and ... SEC_TO_TIME(), Haryana - From your Internet address - Use precise location - Learn more Help Send feedback Privacy Terms, In MySQL the CONVERT_TZ() returns a resulting value after converting a datetime value from a time zone specified as the second argument ... In MySQL the CURRENT_TIME() returns the current time in 'HH:, My sql command below gives me; hh:mm:ss - like so - 01:04:16 [code] select TIMEDIFF(now(), SEC_TO_TIME()., Seconds (00-59). converting a mysql DATETIME (HH:mm:ss) to seconds ... www.coderanch.com › Java Forums › Databases › JDBC Jan 27, SQL Server. ... SQL Create Index SQL Drop SQL Alter SQL Auto Increment SQL Views SQL Dates SQL Null Values SQL Null Functions SQL Data Types SQL DB ... Where date is a valid date and format specifies , You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38

You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38

Databse mysql

Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.

December 12, 2014 eduguru 8 Comments I'm not sure what the root cause may be. But to recover from this situation, MASTER_LOG_POS = 143983426; mysql> START SLAVE;, Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry., you'd want to instruct MySQL to clear out all the relay-bin-logs beyond the following point Relay_Master_Log_File: mysql-bin.000xxx Exec_Master_Log_Pos: 143983426 by doing the following: mysql> STO

I’m not sure what the root cause may be. But to recover from this situation, you’d want to instruct MySQL

Databse

Difference between Stored Procedure and Function : SQL Server

December 6, 2014December 6, 2014 eduguru 0 Comments Difference between Stored Procedure and Function : SQL Server, stored procedure and function, stored procedure and function in sql server, stored procedure vs function, stored procedure vs function in sql server, Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed, what is function in database, what is stored procedure

Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled

Asterisk Databse mysql

Failed to connect to MySQL-asterisk

November 6, 2014 eduguru 1 Comment [unixODBC][Driver Manager]Data source name not found, and no default driver specified", asterisk database dns configuration, asterisk mysql dns, asterisk odbc configuration, asterisk odbc connection, Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, Failed to connect to MySQL-asterisk, Files need to check are: /etc/asterisk/res_odbc.conf /etc/odbcinst.ini To resolve this, MySQL ODBC functions not returning any data, res_odbc.c:565 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0, You have to check the correct configuration of above file. For Example : in -- /etc/odbcinst.ini [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so Fil

Files need to check are: /etc/asterisk/res_odbc.conf /etc/odbcinst.ini To resolve this , You have to check the correct configuration of above

Databse Error mysql

Import large csv file using phpMyAdmin

October 15, 2014 eduguru 0 Comments Getting Error while upload large file from phpMyAdmin: Soution: change the memory limit in php.ini file both upload_max_filesize and post_max_size also. Then restart the httpd service (web service), Import large csv file using phpMyAdmin, You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

Getting Error while upload large file from phpMyAdmin: Soution: change the memory limit in php.ini file both upload_max_filesize and post_max_size also. Then restart the httpd