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

High Scalability

JUNE 22, 2018

Charlie Demerjian : what does Intel have planned for their server roadmap? For the same reason the 14/10nm messaging is causing consternation among investors, but the server side is in much worse shape. using them to respond to storage events on s3 or database events or auth events is super easy and powerful. How bad is it?

Internet 113

Internet Internet Scalability Artificial Intelligence 113

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. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data.

Best Practices 108

Best Practices Servers Database Azure 108

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

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

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js OneAgent for IBM Z platform is now also compatible with the SUSE Linux Enterprise Server (SLES) 12 distribution. 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.

Java 101

Java Traffic AWS Monitoring 101

KeyCDN

OCTOBER 2, 2018

Its blog articles will definitely come in handy as your projects scale, but they’re also great reading for those who simply want to understand the philosophies behind specific dev practices in the front end or server side. Visit website 6. features collected articles that concentrate on what makes JavaScript work and what doesn’t.

Development 75

Development Website Design Code 75

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.

Open Source 81

Open Source Programming Database Servers 81

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

The Netflix TechBlog

SEPTEMBER 29, 2022

Arrows link all the components touched during a typical Timestone client-server interaction. Every write request (see Step 1 — note that this includes dequeue requests since they alter the state of the queue) that reaches the cluster (Step 2) is persisted to a transaction log before a response is sent back to the server (Step 3).

Latency 212

Latency Systems Media Serverless 212

Percona Community

JUNE 28, 2018

was released GA on 2018-05-25). The article What’s New in MariaDB Server 10.3 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

Storage 52

Storage Database Servers Engineering 52

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. How fast is the average time to first byte (server delay)? How long is the average server delay? Source: ThinkWithGoogle. Mobile is still the top priority.

Best Practices 105

Best Practices Speed Mobile Google 105

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Organizations are taking advantage of having managed backups, lots of built-in security features, an uptime SLA of 99.99%, and an always up-to-date environment where they are no longer responsible for patching SQL Server or the operating system.

Azure 63

Azure Performance Storage Latency 63

High Scalability

NOVEMBER 30, 2018

” @emileifrem : Adobe used 125 MongoDB servers to run their activity feed. It was replaced by 48 Cassandra servers. servers of Neo4j. The scalability of a native graph database. Now it runs on 3 (THREE!) With more data (yet smaller disk footprint), higher load and more functionality. damn, daydreaming again.

Internet 28

Internet Internet Scalability Blockchain 28

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

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

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

Jos

JUNE 2, 2018

presented in Google IO 2018 ( source ) These tools make it easier to determine where we need to put emphasis to improve our sites. How would you architecture a non-trivial size web project (client, server, databases, caching layer)? How do you scale it through different servers? A screenshot of Lighthouse 3.0,

Performance 237

Performance Speed Google Media 237

Smashing Magazine

JANUARY 15, 2019

The Mozilla Internet Health Report 2018 states that — especially as the Internet expands into new territory — “sustainability should be a bigger priority.” The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT S.

C++ 140

C++ Servers Code Efficiency 140

High Scalability

DECEMBER 21, 2018

Whether it’s database or message queues it’s a really weird combo of licenses and features for hostage. ” And in most main­stream ap­pli­ca­tion­s, you should be able to get there with server­less. kellabyte : “Open source” infrastructure companies are a giant s**t show right now.

Internet 137

Internet Internet Scalability Serverless 137

SQL Performance

OCTOBER 13, 2021

In my examples I’ll use a sample database called TSQLV5. Like views, iTVFs are created as a permanent object in the database, and therefore are reusable by users who have permissions to interact with them. SQL Server caches the last executed plan, so it can show statistics for that execution, but by request, it doesn’t reuse the plan.

Cache 144

Cache Strategy C++ Code 144

Jos

JUNE 2, 2018

presented in Google IO 2018 ( source ). How would you architecture a non-trivial size web project (client, server, databases, caching layer)? How do you scale it through different servers? They can be run as a one-off or integrated in our development and deployment pipelines. A screenshot of Lighthouse 3.0, Aim for that.

Performance 130

Performance Speed Google Media 130

The Netflix TechBlog

DECEMBER 17, 2019

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. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

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. Designed with High Availability in mind.

Database 197

Database Traffic Transportation Open Source 197

SQL Performance

JULY 9, 2019

I posted a suggestion to improve SQL Server by adding support for nested window functions. For example, suppose that you want to query the Sales.OrderValues view in the TSQLV5 sample database, and return for each customer and order date, the daily total of the order values, and the running total until the current day. 1 2018-10-03 878.00

Servers 83

Servers Availability Database Code 83

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. The size of the database and your database environment—if it is on colo or cloud—matters. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster.

Strategy 52

Strategy Database Storage Open Source 52

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT S.

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

JULY 8, 2020

In my examples I’ll use sample databases called TSQLV5 and PerformanceV5. I should stress that in practice, there’s no actual process in which SQL Server converts the original query string with the nested logic to a new query string without the nesting. In Part 3 I started covering optimization considerations of derived tables.

Servers 110

Servers Code Processing Performance 110

Smashing Magazine

NOVEMBER 22, 2021

A website’s performance can make or break its success, yet in August 2020, despite many improvements we had previously made, such as implementing Server-Side Rendering (SSR), the ratio of Wix websites with good Google Core Web Vitals (CWV) scores was only 4%. Dan Shappir. 2021-11-22T10:30:00+00:00. 2021-11-22T11:06:56+00:00.

Website 126

Website Performance Google Media 126

Smashing Magazine

OCTOBER 26, 2018

2018-10-26T13:45:46+02:00. It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress. Denis Žoljom. Large preview ).

Cache 78

Cache Website Speed Database 78

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . Start the PostgreSQL Database. cat /proc/meminfo. Configure PostgreSQL.

Best Practices 40

Best Practices Scalability Performance Hardware 40