Percona Community

JUNE 18, 2023

Percona University is a series of free technical events organized by Percona in various cities around the world since 2013. Percona uses these events to share its unbiased expertise on open source databases with the community, users, and organizations.

Open Source 52

Open Source Database 52

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

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. minutes of downtime in one year. MongoDB Replica Sets.

Azure 187

Azure AWS Latency Database 187

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 110

Servers Storage Database Open Source 110

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). 5000 named Percona to their list in 2013, 2014, 2015 and 2016. Register Now.

Architecture 41

Architecture Database Open Source Internet 41

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Benchmark before you decide.

Performance 123

Performance Hardware Tuning Storage 123

Adrian Cockcroft

FEBRUARY 9, 2023

We used this model effectively at Netflix when I was their cloud architect from 2010 through 2013. That calls into your custom business logic, which is written using a language and libraries platform, makes calls into web services and databases, and is built and deployed by a Continuous Integration/Continuous Deployment (CICD) pipeline.

Engineering 137

Engineering Serverless Lambda AWS 137

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Processed 4.15

Database 40

Database Analytics Blockchain Healthcare 40

Percona

DECEMBER 28, 2022

Connection id: 22 Current database: db + --+ | connection_id() | + --+ | 22 | + --+ 1 row in set (3.19 If you are performing frequent DDL operations in your database, it is not recommended to take logical backups from Aurora Reader. Trying to reconnect. What are the issues? What is the solution?

Storage 94

Storage Servers AWS Database 94

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

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

All Things Distributed

APRIL 12, 2013

Back-to-Basics Weekend Reading - Join Processing in Relational Databases. By Werner Vogels on 12 April 2013 04:00 AM. Joins are one of the fundamental relational database query operations. Join Processing in Relational Databases , Priti Mishra and Margaret H. Comments (). blog comments powered by Disqus. Contact Info.

Processing 97

Processing Database Efficiency Scalability 97

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Votes AS V.

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

JULY 7, 2013

By Werner Vogels on 07 July 2013 06:30 PM. As customers move increasing amounts of compute and database workloads over to AWS, they have expressed an increased desire for finer grain control over their underlying resources. For example, you can mandate that only Senior Database Administrators in your company can modify â??productionâ??

Cloud 116

Cloud AWS Database Scalability 116

All Things Distributed

MARCH 29, 2013

Back-to-Basics Weekend Reading - Principles of Transaction-Oriented Database Recovery. By Werner Vogels on 29 March 2013 03:30 PM. A good early paper to start again is the Survey that Härder en Reuter did on Database Recovery in 1983. All Things Distributed. Comments (). blog comments powered by Disqus.

Database 72

Database Scalability Engineering Systems 72

All Things Distributed

APRIL 5, 2013

By Werner Vogels on 05 April 2013 08:30 AM. At the end of the 80s Ceri and Widom were researching the fundamentals of integrity constraints in databases. Back-to-Basics Weekend Reading - Practical Applications of Triggers and Constraints: Successes and Lingering Issues. Comments ().

Scalability 73

Scalability Database Systems 73

All Things Distributed

JUNE 20, 2017

In 2013, AWS opened an office in Hong Kong. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing). Since then, AWS has added two more PoPs in Hong Kong, the latest in 2016.

AWS 149

AWS Logistics Cloud Social Media 149

Percona

AUGUST 27, 2018

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. Peter was an early employee at MySQL AB, eventually leading the company’s High-Performance Group.

Open Source 42

Open Source Internet Internet Strategy 42

All Things Distributed

JANUARY 25, 2013

By Werner Vogels on 25 January 2013 06:00 PM. My paper to read this weekend was the Alan Demers seminal paper on epidemic techniques for database replication. Epidemic algorithms for replicated database maintenance. Epidemic algorithms in replicated databases. of Database. Comments (). on the Principles of Distr.

Database 89

Database Scalability C++ Systems 89

All Things Distributed

MARCH 11, 2013

By Werner Vogels on 11 March 2013 04:00 PM. These developers typically use EC2 instances combined with one of our database services to create web services used for data retrievals or to create dynamic mobile interfaces. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. Comments ().

AWS 105

AWS Mobile Games Java 105

Brendan Gregg

NOVEMBER 29, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2013 Starting in 2013, some EC2 instance types began supporting hardware virtualization for network interfaces: Single Root I/O Virtualization (SR-IOV). The first was c3. AWS called this [enhanced networking].

Virtualization 111

Virtualization AWS Hardware Storage 111

Official Blog - World Web Technology

NOVEMBER 27, 2023

Shopify introduced its feature – Shopify Payments in 2013. It is written in PHP and uses a MySQL database for operations. Other features include templates, drag-and-drop service, e-commerce and blogging, mobile responsiveness, and integrated hosting. Shopify Shopify’s key features have evolved as the company has added new ones.

Website 59

Website Development Mobile Storage 59

All Things Distributed

APRIL 17, 2013

By Werner Vogels on 17 April 2013 10:30 AM. database performance and scalability are critical for delivering new services to our 34+ million readers on any device. Since we launched DynamoDB, we have seen many database customers migrate their apps from traditional sharded relational database deployments to DynamoDB.

Cloud 116

Cloud Latency Games Scalability 116

SQL Performance

MARCH 30, 2021

I used the public Stack Overflow 2013 database ( download details ). It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. To provide a concrete basis for the analysis, we will follow how a particular parallel query starts execution.

Cache 98

Cache Servers Operating System Processing 98

Percona

AUGUST 15, 2023

These companies include Couchbase, Cockroach Labs, Sentry, and MariaDB, which developed this license in 2013. There is another interesting quote in the HashiCorp Announcement: “With this change we are following a path similar to other companies in recent years.

Open Source 75

Open Source Government Software Software 75

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. This is the first time any server vendor has even bothered to submit a TPC-E result for an AMD-based system since 2013. This processor family has enough compute horsepower, memory bandwidth and capacity, and I/O bandwidth to support large server workloads on a single-socket server.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2013 Starting in 2013, some EC2 instance types began supporting hardware virtualization for network interfaces: Single Root I/O Virtualization (SR-IOV). The first was c3. AWS called this [enhanced networking].

Virtualization 40

Virtualization AWS Hardware Storage 40

Alex Russell

APRIL 29, 2021

Browser release notes and caniuse tables since Blink forked from WebKit in 2013 [7]. have been available in iOS since 2013 with iOS 7.0. The data captured by MDN Browser Compatibility Data Respository and the caniuse database is often partial and sometimes incorrect. CSS Grid and ES6 ).

Media 145

Media Games Education Engineering 145

SQL Performance

MARCH 8, 2021

The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This next example query uses the same database and index as before. There is no blocking operator below that exchange, so no initialization delay arises. A final example.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

JANUARY 15, 2019

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. In 2013, A List Apart published Sustainable Web Design by James Christie. Many efforts are afoot to improve the situation on the web.

Website Performance 73

Website Performance Website Energy Performance 73

Highly Scalable

MARCH 10, 2015

Brunamonti, 2013. Preslar, 2013. Levin, 2013. Fawcett, 2013. VL02] The True Lift Model – A Novel Data Mining Approach to Response Modeling in Database Marketing, V. [CU13] Retail Channel Price Discrimination, S. Cuellar, M. DG12] How Companies Learn Your Secrets, C. Duhigg, 2012. Deerwester, S. Lippert, 2011.

Retail 152

Retail C++ Analytics Metrics 152

O'Reilly Software

MARCH 7, 2018

In addition to that, software is increasingly dependent on other software to provide its functionality, be it WebServices, HTTP APIs, databases, or even external devices such as sensors. HTTP, TCP, FTP, MQTT, JMS), databases (i.e., But each implementation is doing it differently, which makes interoperability hard.

Transportation 72

Transportation Java Programming Architecture 72

Alex Russell

MARCH 6, 2021

The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. Indeed, some large sites I've worked with have built device model databases to bucket traffic based on system RAM to decide which versions/features to serve. twitter.com/slightlylate/status/1139684093602349056 455 06:18 AM · Feb 28, 2020.

Performance 124

Performance Network Cache Metrics 124

All Things Distributed

MARCH 7, 2013

By Werner Vogels on 07 March 2013 08:00 PM. Many of our customers have, with the click of a button, created DynamoDB deployments in a matter of minutes that are able to serve trillions of database requests per year. I am often asked: When is it appropriate to use DynamoDB instead of a relational database? All Things Distributed.

Ecommerce 139

Ecommerce Storage Scalability Hardware 139

All Things Distributed

DECEMBER 12, 2013

We launched DynamoDB last year to address the need for a cloud database that provides seamless scalability, irrespective of whether you are doing ten transactions or ten million transactions, while providing rock solid durability and availability. You saw the first iteration in April 2013 with the launch of Local Secondary Indexes (LSI).

Games 130

Games Scalability Database Retail 130

All Things Distributed

FEBRUARY 18, 2013

By Werner Vogels on 18 February 2013 11:30 PM. When a new app server instance starts, OpsWorks will use built-in recipes to configure the app server software and deploy your apps, and can also apply your specified recipes to make changes to your database and monitoring infrastructure. Comments (). Operational Control â??

AWS 157

AWS Cloud Architecture Infrastructure 157

High Scalability

SEPTEMBER 28, 2018

MrTonyD : I was writing production code over 30 years ago (C, OS, database). They sent me long email listing reasons why I shouldn't get a second monitor, including (numbers are approximate, employee count from 2013 or so) "If every googler gets an extra monitor, in a year it would be equivalent to driving Toyota Camry for 18000 miles.".

Internet 35

Internet Internet Scalability Blockchain 35