Shotover is now open source


Instaclustr is now making the shotover proxy project completely open source. With the L7 data layer proxy from the managed service provider, users can control, manage and modify the flow of active database queries.

According to Instaclustr, most problems in the operation of databases are due to the use of data models, queries or databases themselves, the behavior of which is not well suited for the respective workload. These fundamental discrepancies often result in slow databases, as well as queries for certain keys and inefficient queries. Unsuitable data models can also lead to excessively large and inefficient tables, but also to “hot” partitions that have to process a massive number of read and write accesses.

Typically, these problems only occur in production environments when the possible remedy would require difficult application or schema changes. IT teams then often ask themselves whether it might not have been better to use a different database. At this point, it is no longer possible to quickly and easily revise the decision already made for this database.

Shotover defuses the problem by decoupling applications from data localization, performance and storage. The solution provides predefined transformations that teams can use to modify, route, and control queries going from any number of sources to a corresponding number of upstream databases. Users can also create sequences of predefined query transformations to achieve their target behavior. Immediate changes to the queries and data storage options are possible without the user having to change or redeploy applications themselves.

The proxy project offers the following features:

  • Data encryption at field level with common key management for all databases.
  • Data routing to several databases in order to use certain query and performance capacities (e.g. indexing of data in Redis with Elasticsearch or simple caching of Cassandra data in Redis).
  • Data routing or replication across regions (useful in scenarios where databases do not have native cross-region support or are sealed off by proprietary limitations of an open core approach).
  • A general audit and AuthZ / AuthN point to achieve SOX / PCI / HIPAA compliance.

Conor Brosnan, Software Engineer at Instaclustr: “Our R&D team developed Shotover with the aim of making life easier for IT teams in scenarios in which the desired database operations and the data load do not quite match. We are happy to meet the communities around To give something back to Cassandra, Kafka, Redis, Postgres and the other open source data infrastructure technologies we support with this new open source project: especially those who run multiple databases and can use Shotover to work together. ”

Shotover also runs in practice at Instaclustr itself and supports the replication capacities there across several regions for Redis clusters. The latest version of the L7 data layer proxy is available now on GitHub ready. Further information can be found at docs.shotover.io.

Source: com! professional by www.com-magazin.de.

*The article has been translated based on the content of com! professional by www.com-magazin.de. If there is any problem regarding the content, copyright, please leave a report below the article. We will try to process as quickly as possible to protect the rights of the author. Thank you very much!

*We just want readers to access information more quickly and easily with other multilingual content, instead of information only available in a certain language.

*We always respect the copyright of the content of the author and always include the original link of the source article.If the author disagrees, just leave the report below the article, the article will be edited or deleted at the request of the author. Thanks very much! Best regards!