Some Curiosities of Oracle Error Codes

DZone

A blog post about Oracle error codes? If you doubt that this might be possible or of interest, then answer these two questions: database performance oracle code database performance error pl/sql code errorCuriosities about them, even?

Code 130

Millions of tiny databases

The Morning Paper

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Towards multiverse databases

The Morning Paper

Towards multiverse databases Marzoev et al., Therefore, frontend code is responsible for permission checks and privacy-preserving transformations that protect user’s data. The central idea behind multiverse databases is to push the data access and privacy rules into the database itself.

SQL Clone for Unit Testing Databases

DZone

Sometimes, when you are performing unit or integration tests whilst developing code, you need to be able to do something extreme, such as mangling a test database or two, repeatedly, each time subsequently restoring it to its original state before running the next test. database performance sql testing unit testing clone

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

Scalegrid

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? Polyglot Persistence Trends : Number of Databases Used & Top Combinations. 2019 Top Databases Used.

Updating graph databases with Cypher

The Morning Paper

Updating graph databases with Cypher Green et al., Our understanding of updates in the popular graph database model… is still very rudimentary. Violations of atomicity and non-deterministic update behaviour certainly don’t sound like the kind of things you want in a database!!

Squashed Bugs, Served Hot and Fresh With Failure Rate Heatmaps

DZone

Debugging is not just about the fix — sometimes it's the drudgery of trying to locate the root cause that kills passion, especially when you have thousands or even millions of lines of code. A former Oracle database developer, who helped maintain Oracle v12.2 Learn how to squash bugs!

AVIF for Next-Generation Image Coding

The Netflix TechBlog

Brief overview of image coding formats The JPEG format was introduced in 1992 and is widely popular. This is followed by quantization and entropy coding. With the motion extension, it was accepted as the video coding standard for digital cinema in 2004.

Code 177

HammerDB Source Code moved to the TPC Council

HammerDB

HammerDB has increased dramatically in popularity and use and has been identified as the industry default for database benchmarking illustrating both the popularity of open source and TPC based benchmarks. Consequently with the wish to engage with the open source database benchmarking community the TPC Council approached HammerDB to collaborate on development and bring together both the communities around the TPC benchmarks and HammerDB.

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

Scalegrid

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. We have all been there – a supposedly well-tested piece of code is deployed in production, and then all hell breaks loose.

Exploring MySQL Binlog Server – Ripple

Scalegrid

This way, the load on the master is tremendously reduced, and at the same time, the binlog server serves the binlogs more efficiently to slaves since it does not have to do any other database server processing. mysql> create database d12; Query OK, 1 row affected (3 min 0.01

Key Considerations for a Modern Database to Operate at Scale

VoltDB

When your business latency or API latency expectation is larger than the baked in latency, you have room for coding cleverness to try to do something really quick. The post Key Considerations for a Modern Database to Operate at Scale appeared first on VoltDB.

Key Considerations for a Modern Database to Operate at Scale

VoltDB

When your business latency or API latency expectation is larger than the baked in latency, you have room for coding cleverness to try to do something really quick. The post Key Considerations for a Modern Database to Operate at Scale appeared first on VoltDB.

Which Is the Best PostgreSQL GUI? 2019 Comparison

Scalegrid

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large.

View-centric performance optimization for database-backed web applications

The Morning Paper

View-centric performance optimization for database-backed web applications Yang et al., A web page instrumented by Panorama looks like this: Parts of the page are colour-coded heat-map style to indicate how costly they were to generate. you are doing the count in the database, right?).

How to add your database to HammerDB – Pt4 Commit changes and pull request

HammerDB

In parts 1 to 3 of this series we have gone through the steps of taking the HammerDB code and adding support for a new database. If you think you are ready for the changes for your additional database to be included in HammerDB then you should open a pull request.

A one size fits all database doesn't fit anyone

All Things Distributed

A common question that I get is why do we offer so many database products? To do this, they need to be able to use multiple databases and data models within the same application. Seldom can one database fit the needs of multiple distinct use cases. The days of the one-size-fits-all monolithic database are behind us, and developers are now building highly distributed applications using a multitude of purpose-built databases. Purpose-built databases.

How to add your database to HammerDB – Pt3 Adding to and modifying the source

HammerDB

The next step is to see if there is an Issue already created for the database we want to add or whether we should create one. In this example using MariaDB there is already an Issue created Add MariaDB as a separate database #54 although note that this can be for any database you choose.

C++ 52

How to add you database to HammerDB – Pt2 Fork, clone and binary downloads

HammerDB

As noted in the previous post to add a database to HammerDB you will need to change the source code. Under the working directory we know have the HammerDB source code in which to add the new database.

Smart Bundling: How To Serve Legacy Code Only To Legacy Browsers

Smashing Magazine

Smart Bundling: How To Serve Legacy Code Only To Legacy Browsers. Smart Bundling: How To Serve Legacy Code Only To Legacy Browsers. A Practical Guide To Shipping Efficient Code. Shubham Kanodia. 2018-10-15T14:30:13+02:00. 2019-04-29T18:34:58+00:00.

Code 71

How to add your database to HammerDB – Pt1 Opening an issue

HammerDB

A very common request is for HammerDB to add support for a new database. Before reaching out with a request your first reference should be the DB-Engines Ranking to gauge the relative popularity of a database. it is no coincidence that HammerDB supports the most popular databases with all of the databases currently supported being in the top 10 of this ranking. The source code for this interface is here and all intefaces used are open source and GPL compliant.

Embrace event-driven computing: Amazon expands DynamoDB with streams, cross-region replication, and database triggers

All Things Distributed

I am excited to share with you that today we are expanding DynamoDB with streams, cross-region replication, and database triggers. In traditional database architectures, database engines often run a small search engine or data warehouse engines on the same hardware as the database.

Lambda 126

Important Health Checks for your MySQL Master-Slave Servers

Scalegrid

If the exit code indicates a failure, the return code from MySQL will tell us the failure reason. In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

Scalegrid

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. We recently attended the PostgresConf event in San Jose to hear from the most active PostgreSQL user base on their database management strategies.

Cloud 126

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Scalegrid

Default database: 'test'. Query: 'insert into test values(5018,2019,'item100')', Error_code: 1062. Start a free 30-day trial to explore all the MySQL database management capabilities at ScaleGrid. In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point , a crash of the master and failover to the slave is considered to be lossless.

Titan Graph Database Integration with DynamoDB: World-class Performance, Availability, and Scale for New Workloads

All Things Distributed

It opens up the possibility to enjoy the value that graph databases bring to relationship-centric use cases, without worrying about managing the underlying storage. Traditionally, these connections have been stored in relational databases, with each object type requiring its own table.

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Scalegrid

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. Increase the number of connections to the database to > max_db_connections.

Cache 159

Reduce MySQL CPU Usage Through Dynamic Binary Optimization

DZone

This post explores how Dynimize can be used to instantly reduce MySQL CPU usage without altering a single line of your application code or my.cnf. database tutorial performance linux mysql mariadb intel cpu

Intro to Redis Cluster Sharding – Advantages, Limitations, Deploying & Client Connections

Scalegrid

Only Supports One Database. Unlike standalone databases, Redis Clusters support only one database (database 0), and the SELECT command isn’t allowed. Since most people don’t use multiple databases, this too is not a major limitation.

DBLog: A Generic Change-Data-Capture Framework

The Netflix TechBlog

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events.

Connecting MongoDB to Ruby with Self-Signed Certificates for SSL

Scalegrid

To keep the example simple, we have specified the connection string and the cert file path directly in the code snippet – you would generally either put them in a yaml file or specify them as environment variables. Our yml file: development: # Configure available database clients. Alternatively, you can define the following: # # Define the name of the default database that Mongoid can connect to. # (required). The user's database roles.

C++ 100

How to Optimize Digital Experience and Operations with Dynatrace

Dynatrace

Infrastructure Optimization: 100% improvement in Database Connectivity. Think of a user login which requires your back-end systems to validate user credentials and query required user profile information from the backend databases. Dynatrace news.

Cache 229

DBLog: A Generic Change-Data-Capture Framework

The Netflix TechBlog

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events.

Client-side Performance Monitoring with InfluxDB

Wayfair Tech

Each day we deploy hundreds of code changes to the web application for our customer-facing websites, and each change has the potential to impact performance for better or worse. Database Open Source Tools Web Performance databases InfluxDB kafka monitoring real user monitoring time seriesAccurate performance monitoring is crucial for Wayfair’s Storefront Engineering team.

The Marvel of Observability

DZone

That means the system exposes telemetry, which is the data emitted from instrumentation that expresses those external behaviors — a feature ideally baked into your code upfront. database devops performance monitoring performance monitoring observabilityMarvel at this article!

PyMongo Tutorial: Testing MongoDB Failover in Your Python App

Scalegrid

It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements. It is a fairly mature driver that supports most of the common operations with the database, and you can check out this tutorial for an introduction to the PyMongo driver. It is also recommended that SSL connections be enabled to encrypt the client-database traffic.

C++ 39

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Let’s now try to add some data into the database.

Which is the Best MongoDB GUI? — 2019 Update

Scalegrid

In this article, we are going to compare 6 of the top MongoDB Graphical User Interfaces that help developers increase their productivity and manage their database. It’s further enhanced by an in-place code editor which is also available in all three views.

Monitor and Optimize Slow Queries with PMM and EverSQL – Part 2

Percona

EverSQL (use code PERCONA-EVERSQL-10OFF for a 10% discount on the first billing cycle) is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes.

Time to First Byte: What It Is and Why It Matters

CSS Wizardry

Application runtime: It’s kind of obvious really, but the time it takes to run your actual application code is going to be a large contributor to your TTFB. Database queries: Pages that require data from a database will incur a cost when searching over it.

Java Or Scala Performance – Which One Is Better?

Alex Podelko

The Size and Quality of the Code. If you decide to use Java to write your programs with, be prepared to write longer lines of code to accomplish even the smallest tasks. Being able to fit more on a page allows you to easily organize your code with Scala.

Java 130

5 Steps to Accelerate your Cloud Migration with Dynatrace

Dynatrace

There is no code or configuration change necessary to capture data and detect existing services. Database & functional migration. Step 4: Smart Database Migration. Which applications and services are depending on a database that might be impacted by a migration?

Cloud 38

"0 to 60" : Switching to indirect checkpoints

SQL Performance

Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. Change the Target Recovery Time of a Database. database_id = 19 -- db4. database_id = 78 -- db2. ) database_id = 19 -- db4. databases AS d.