MongoDB is changing its open source license

MongoDB is changing its open source license
 3r350.
MongoDB is somewhat offended by the fact that some cloud providers, especially in Asia, use their open code and offer the commercial version of their database in the cloud to their users, not playing according to the rules of open source software. To combat this, MongoDB today announced the release of a new software license - 3r310. Server Side Public License
(SSPL), which will be used in all new releases of their MongoDB Community Server, as well as in all patches to previous versions.
 3r350.
Earlier, MongoDB used 3r3188. GNU AGPL v3
licensed, they have now sent the SSPL for approval at the Open ...
+ 0 -

Install and configure Oracle Internet Directory to resolve database names

Install and configure Oracle Internet Directory to resolve database names 3r3746. 3r3-31. Everyone who has worked with this type of DBMS is aware of setting up access to the Oracle DBMS, which is stored in the tnsnames.ora file. 3r3734.  3r3746. 3r3734.  3r3746. The data is stored in the file 3r3629. tnsnames.ora [/i] in plain text form and can easily be modified using any text editor. It is good if there are not many records in it, but what to do if there are hundreds of databases in the organization, access to which needs to be provided from the hosts of users at various levels or from terminal servers. And if at one point, the database moves to another host, or other ...
+ 0 -

Poststressing stat without nerves and strains

Poststressing stat without nerves and strainsA couple of years ago, trying to figure out another problem in the performance of postgrass, I had to dig into the postsurgical statistics. Digging into the views and functions, I found myself thinking that working with what is defaulted is quite inconvenient.
 
 
And in fact, in postgres is a pretty large pile of metrics, all of them are presented in the form of representations and functions. On the one hand it's very convenient, wrote SELECT and got the data. On the other hand, such a periodical writer is slightly tiring.
 
 
At the same time, I needed to not just look at some status one-time...
+ 0 -

Distributed applications in C ++ with a minimum of effort

The purpose of my post is to tell you about the C ++ API of the distributed database Apache Ignite, which is called Ignite C ++, as well as its features.
 
About the very Apache Ignite on the habr have written more than once, so for sure some of you already roughly represent what it is and why you need it.
 

Briefly about Apache Ignite for those who are not familiar with it yet


 
I will not go into details about how Apache Ignite appeared and how it differs from classical databases. All these questions have already been raised here ...[/h]
+ 0 -

Open webinar «Indexes»

Hello!
 
 
In the framework of our new course «Relational DBMS» creator and teacher of the course Alexey Tsykunov held an open class on the types of indices, their advantages and disadvantages. I was sorted out in which cases which are applied, how they work in SELECT /INSRT /UPDATE /DELETE operations.
 
 

 
 
As always, we are waiting for questions and comments.Hello!  In the framework of our new course «Relational DBMS» creator and teacher of the course Alexey Tsykunov held an open class on the types of indices, their advantages and disadvantages. I was sorted out in which cases which are applied, how they work in SELECT /INSRT /UPDATE /DELETE operations.     As always, we are waiting for questions and comments...
+ 0 -

The developers remained unknown. Lecture of Yandex

The developers remained unknown. Lecture of YandexThis report by the head of the ClickHouse development team Alexey Milovidov is an overview of little-known databases. Some of them are obsolete, some have stopped their development and are abandoned. Alexey draws attention to interesting architectural solutions in the examples listed, understands their fate and explains what requirements should meet your open-source project.
 
 

 
- My report will be about the database. Let me ask you at once, what city map is depicted on this slide? All lines go in one direction. ...
+ 0 -

We collect InnoDB cluster from mysql 5.7 on centos 7

Hello!
 
 
Once there was a task on the job - there is a kind of configured test innoDB cluster on several virtualos with centos 7.? it is necessary to learn it and add a couple more nodes. You can break and scoff anything. It sounds tempting.
 
article on Habré . It seems like it was configured for a cluster of two nodes.
 
 
Well, I read the article, I was somewhat surprised at the difficulty of adding nodes and the lack of many details, but oh well. I added a new node with a sin in half (part of the commands did not come in handy, some of them broke everything), then I started experimenting ...
+ 0 -

DBMS transactions

To all the beaver! We are actively expanding our, so to speak, assortment of courses, and now we are glad to present a new one: "Relational DBMS" . The course was created by one of the leading teachers of the course Linux Administrator - Alexey Tsykunov . In the rest everything will be as usual: utility and open lessons , on which Alex will share different things that are not included in the course itself.
 
 
Go!
 
open lesson Alexey .To all the beaver! We are actively expanding our, so to speak, assortment of courses, and now we are glad to present a new one: "Relational DBMS" . The course was created by one of the leading teachers of the course Linux Administrator - Alexey Tsykunov . In the rest everything will be as usual: utility and open lessons , on which Alex will share different things that are not included in the course itself.  Go!  open lesson Alexey ...
+ 0 -

Tasks and solutions for the soldier PostgreSQL

Tasks and solutions for the soldier PostgreSQL
 
Greetings to all SQL lovers!
 
 
On the Internet, I rarely met articles that cover different working moments and subtleties associated with processing data in SQL .
 
I like it when you can draw a lot from just one article, even in general terms.
 
Therefore, I decided to write my article, containing various tasks and answers with explanations to them.
 
Suitable for those who have mastered all basic skills well and want to develop further.
 
 
The presented answers are suitable for PostgreSQL ( Most tasks are suitable for other DBMS , But the results and solutions may ...
+ 0 -

USE, RED, PgBouncer, its settings and monitoring

<{full}>
USE, RED, PgBouncer, its settings and monitoring
 
We began to update the monitoring service for PgBouncer in our service and decided to do a little bit of combing. To make everything work, we draw the most well-known monitoring performance methodologies: Brendan Gregg's USE (Utilization, Saturation, Errors) and Tom Wilkie's RED (Requests, Errors, Durations).
 
Next, you will learn how we are all up there and about the features of the PgBouncer configuration parameters.
 
First about the methods themselves
 
Although these methods are quite well-known (about <{full}>

 
We ...
+ 0 -