Percona

FEBRUARY 1, 2024

This blog was originally published in September 2018 and was updated in Feburary of 2024Configuring replication between two databases is considered to be the best strategy for achieving high availability during disasters and provides fault tolerance against unexpected failures.

Strategy 52

Strategy Database Availability Servers 52

Brendan Gregg

APRIL 30, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 43

DevOps Network Best Practices Programming 43

Brendan Gregg

APRIL 29, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 40

DevOps Network Best Practices Programming 40

High Scalability

JUNE 22, 2018

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Xtracerx : for me the biggest value to serverless functions is how nicely they tie in to the ecosystem of a cloud provider. Daniel Lemire : So Roaring bitmaps can be thousands of times faster than a native JavaScript Set.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

High Scalability

OCTOBER 5, 2018

They'll love it and you'll be their hero forever.

Internet 156

Internet Internet Scalability Software Engineering 156

KeyCDN

OCTOBER 2, 2018

Subjects like version control, crowdfunding, database selection and code editor choices are essential to efficient modern workflows, and this is a good place to start learning about them. Visit website 14. CSSWizardy CSSWizardy is a good place to learn about scalable CSS practices and robust coding in general.

Development 75

Development Website Design Code 75

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Here's the output of the above query: custid orderdate orderid val firstval lastval - - -- - - - 1 2018-08-25 10643 814.50 1 2018-10-03 10692 878.00

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

APRIL 26, 2019

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Database – Log Bytes Flushed/sec. When I looked through the SentryOne database, I found that 3 of the 4 counters were already being captured by default.

Azure 40

Azure Database Metrics Servers 40

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5. 2018 408 617085.30 2018 370 563759.24 DATE_BUCKET. OrderValues. 2019 270 440623.93.

Azure 139

Azure Code Database Servers 139

Scalegrid

JANUARY 24, 2019

January 24, 2019 – ScaleGrid , a rising leader in the Database-as-a-Service (DBaaS) space, has just announced support for Redis Clusters on their fully managed Redis hosting plans. With the introduction of Redis Clusters at ScaleGrid, Redis users can now easily create sharded clusters with a few simple clicks when setting up their databases.

Availability 113

Availability Open Source AWS DevOps 113

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Suppose for example that you want to query the Sales.Orders table in the TSQLV5 sample database. Implicit grouping with PIVOT. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

DZone

SEPTEMBER 9, 2019

In August of 2018 Bob Diachenko, Director of Cyber Risk Research at Hacken.io found that over 2 million Mexican citizens had their healthcare data leaked due to a security vulnerability in a system's database. At that same time, he found that the data of 93 thousand users of a popular babysitting app, Sitter, was also exposed.

Healthcare 113

Healthcare Performance Infrastructure Database 113

Scalegrid

FEBRUARY 11, 2019

With such strong interest in this installation, we decided to write up the steps to configure your MySQL database on the ScaleGrid side to get you up and running ever faster with WordPress on Now. Guillermo Rauch (@rauchg) December 18, 2018. Setting Up Your MySQL Database for WordPress on ZEIT Now. Leave your comments: [link].

Serverless 138

Serverless Azure Database Cache 138

Dynatrace

MAY 9, 2019

supports the tracing of database requests.NET. LTS)—Oracle discontinued Premium Support in September 2018. LTS)—Oracle discontinued Premium Support in September 2018. Dynatrace news. Support for shaded AHC 2.x x in Play 2.6+. Starting with OneAgent 1.167, OneAgent SDK for Java (version 1.7.0) Added support for ioredis (Beta).

Java 100

Java AWS Cloud Monitoring 100

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js WebSphere Application Server version 8.0 ( EOS by IBM in April 2018 ) OneAgent 1.183 will be the last version that supports WebSphere version 8.0. Dynatrace news. Support added for reactor-netty version 0.8. Support for gRPC end-to-end tracing. client is now generally available.

Java 102

Java Traffic AWS Monitoring 102

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. Is MongoDB an open source NoSQL database?

Open Source 80

Open Source Programming Database Servers 80

Percona Community

JUNE 28, 2018

was released GA on 2018-05-25). Even if I am excited about MyRocks and curious on Spider, I am also very interested in less flashy but still very important changes that make running the database in production easier. MariaDB 10.3 is now generally available (10.3.7 The article What’s New in MariaDB Server 10.3

Storage 52

Storage Database Servers Engineering 52

n0derunner

DECEMBER 17, 2018

How to reduce database restore time by 50%. During.Next 2018 in London, Nutanix announced performance improvements in the core-datapath said to give up to 2X performance improvements. I am using X-Ray to simulate a 1TB data restore into an existing database. Here’s a real-world example of that improvement in practice.

Performance 64

Performance Benchmarking Storage Network 64

The Netflix TechBlog

SEPTEMBER 29, 2022

Inside the database, we represent each queue with a sorted set where we rank message IDs (see “Message” section) according to priority. We explain the concept in detail in the sections that follow. We persist messages and queue configurations (see “Queues” section) in Redis as hashes.

Latency 212

Latency Systems Media Serverless 212

Dynatrace

OCTOBER 15, 2021

Cloud databases excel at storing large volumes of information for later reference, and this data often has business value or privacy restrictions. Then, Google made the OpenCensus project open source in 2018. This occurs once data is safely stored within a local cache. Span ingestion. We can also ingest trace data in span format.

Open Source 226

Open Source Metrics Cloud Transportation 226

Percona

SEPTEMBER 13, 2018

2018-09-03.09 > mysql-slowquery.log.2018-09-03.09 2018-09-03.09 2018-09-03.09 system time, 43.80M rss, 141.48M vsz # Current date: Tue Sep 4 15:54:21 2018 # Hostname: aahmed-GL503VD # Files: mysql-slowquery.log.2018-09-03.09 2018-09-03.09 Run pt-query-digest on the log file. . $ user time, 2.5s user time, 2.5s

C++ 42

C++ AWS Open Source Testing 42

CSS Wizardry

JULY 21, 2018

For a slightly more robust, but still imperfect method of identifying dead code, try this technique that I wrote up earlier in 2018. Basically, ctags will create a kind of of database of all of the function, variable, mixin, ID, and class definitions for your project. Learn the Codebase Organically. Don’t go looking for trouble.

Programming 142

Programming C++ Database Code 142

Speed Curve

FEBRUARY 5, 2024

Charlie Vazac introduced server timing in a Performance Calendar post circa 2018. db = Duration of the request processing spent querying the database. In practice, it looks something like this: server-timing: processing_time; dur=123.4; desc="Time to process request at origin" NOTE: This is not a new API.

Servers 58

Servers Cache Retail Benchmarking 58

Percona

DECEMBER 5, 2022

Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Explanation.

Servers 60

Servers Cache C++ Metrics 60

High Scalability

NOVEMBER 30, 2018

The scalability of a native graph database. It was replaced by 48 Cassandra servers. Now it runs on 3 (THREE!) servers of Neo4j. With more data (yet smaller disk footprint), higher load and more functionality. damn, daydreaming again.

Internet 28

Internet Internet Scalability Blockchain 28

The Morning Paper

JUNE 20, 2019

In total, there were 112 such incidents over the period March – September 2018 (not all of them affecting external customers). In 40% of cases different parties assume different formats for shared files or database tables. It looks like data validation isn’t only useful in a machine learning context !

Cloud 81

Cloud Azure Cache C++ 81

All Things Distributed

JUNE 20, 2017

The new AWS Asia Pacific (Hong Kong) Region will have three Availability Zones and be ready for customers for use in 2018. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing).

AWS 149

AWS Logistics Cloud Social Media 149

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Azure SQL Database has a similar issue with max database size, and Microsoft came up with a Hyperscale option. IOPS and throughput for the General Purpose tier are directly tied to vCores and the size of the database files.

Azure 63

Azure Performance Storage Latency 63

Percona

AUGUST 27, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Forking or Branching – Lessons from the MySQL Community on Tuesday, August 28th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog.

Open Source 42

Open Source Internet Internet Strategy 42

Smashing Magazine

OCTOBER 29, 2018

2018-10-30T03:40:14+02:00. For a typical site, that might involve routing the request to the correct part of the application, authenticating the request, making multiple calls to backend systems such as databases and so on. Measuring Performance With Server Timing. Measuring Performance With Server Timing. Drew McLellan.

Servers 87

Servers Performance Metrics Database 87

MachMetrics

DECEMBER 14, 2019

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. Source: ThinkWithGoogle. seconds on desktop and 2.59

Best Practices 105

Best Practices Speed Mobile Google 105

Testsigma

NOVEMBER 11, 2020

Network disconnection is a common automation challenge that a QA team faces wherein they find it hard to access databases, VPN, third party services, APIs, specific testing environments, etc. Network Disconnections. due to unstable network connections. These network disconnections cause unnecessary delays and hinder the testing process.

Testing 85

Testing Mobile Network Analytics 85

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. Is this a problem ?

Tuning 44

Tuning Cache Database Storage 44

KeyCDN

NOVEMBER 8, 2018

We also recommend using a free program like KeePass or KeePassX which allow you to generate secure passwords and store them in a database locally on your computer. That’s why back in September of 2018, we were happy to announce that we launched TLS 1.3 back in March of 2018. with 0-RTT support.

Transportation 47

Transportation Website Google Infrastructure 47

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. Once the schema was built I shutdown and restarted the database and configured a test script as follows: HammerDB-3.1$

Testing 48

Testing Tuning Latency Storage 48

SQL Server According to Bob

FEBRUARY 15, 2018

Well, for SQLBits 2018, it is not just me. Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Which database, when ?

Engineering 40

Engineering Azure Best Practices Servers 40

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. ML + AI are up, but passions have cooled. Security is surging.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134