(Lee Stigile) Oracle Cloud Infrastructure (OCI) is Oracle’s second-generation cloud infrastructure. These new datacenters were built with the latest high-performance servers (Oracle’s X7 Servers) and were designed to eliminate network and CPU oversubscription.
Tag: Open Source
The first impression of MySQL 8 system variable innodb_dedicated_server
We manage several hundreds of MySQL servers, We carefully benchmark and build custom database infrastructure operations for performance, scalability, availability and reliability …
Projected Spatial Reference Systems in MySQL 8.0
(Norvald H. Ryeng) MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions. In a previous post, we covered the definitions of geographic SRSs. In this post we’ll go into the details of projected SRSs. (If you haven’t done so already, I suggest you read the previous post
ProxySQL Series: Handling resource expensive(bad) Queries in MySQL
(Ashwini V. Ahire) This is our fourth blog in the ProxySQL Series
Geographic Spatial Reference Systems in MySQL 8.0
(Norvald H. Ryeng) MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions, and 479 of these are geographic. We usually just refer to them by SRID, but in this blog post we’ll dive into the details and try to understand the definition itself.
Using dbdeployer to manage MySQL, Percona Server and MariaDB sandboxes
(Agustín) Some years ago, Peter Z wrote a blogpost about using MySQL Sandbox to deploy multiple server versions. Last February, Giuseppe introduced us to its successor: dbdeployer. In this blogpost we will demonstrate how to use it. There is a lot of information in Giuseppe’s post, so head there if
Proxy MySQL :: HAproxy || ProxySQL & KeepAlived
(Keith Larson) So when it comes to routing your MySQL traffic several options exist.
MySQL 8.0: MVCC of Large Objects in InnoDB
(Annamalai Gurusami) In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine. MySQL 8.0 has a new feature that allows users to partially update large objects, including the JSON documents.
MySQL master discovery methods, part 6: other methods
(Shlomi Noach) This is the sixth in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
Replication Test Coverage in MySQL 8.0
(Saikumar) In the Replication QA team, we have been continuing to improve test coverage for Replication and Group Replication primarily to ensure that we support the newest and latest offerings of MySQL Server 8.0 such as Generated Columns, Set Persist, User Roles, and User Management DDLs that are