Category: Oracle Database

Feed: Planet MySQL; Author: Yves Trudeau; As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune it correctly. This post is a bit long and complex as it goes very deep into some InnoDB internals.InnoDB internally handles flush operations in the background to remove dirty pages from the buffer pool. A dirty page is a page ... Read More

Feed: All Oracle Press Releases. For 36 years, Manquehue Hotels has been delighting guests with unique properties and top-notch service. When the group looked to expand its footprint in Chile with three new hotels, they turned to Oracle Hospitality to help support this rapid growth. With Oracle, Manquehue was able to efficiently establish internal operations at the new hotels and enhance the overall guest experience for its customers. “As we continue to grow our hotels and chain, we need a system in place that provides us with standardized, timely and online information to better serve our customers,” said Abner Cayul, ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so difficult that the pain far outweighs any technical advantage you might get. In the vast ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Kubernetes is gathering a lot of steam in the container ecosystem. Since the project was donated to the CNCF there has been massive adoption from the likes of Microsoft, Oracle and VMware. At Puppet, we’re committed to helping our customers adopt whatever’s next. To that end, we announced Project Blueshift last year and we’re continuing to expand on that promise with our latest set of releases. We have developed a new set of tools to make your adoption of Kubernetes as efficient as possible, covering your full workflow cycle from development to production ... Read More

Feed: Recent Announcements. By moving from contract-based to usage-based billing, we are aligning with the AWS consumption model that provides customers with greater flexibility. Customers can now easily use our solution by paying a per server hourly rate instead of committing to a long-term contract or set number of servers. CloudEndure Disaster Recovery allows you to meet stringent recovery objectives for all major disaster recovery use cases: on-premises to cloud, cross-Region, cross-Availability Zone, and cross-cloud. Whatever the use case, you can follow the same simple process to set up, maintain, monitor, and test your disaster recovery plan. Thousands of AWS ... Read More

Feed: Planet MySQL; Author: Severalnines; With MySQL 8.0 Oracle adopted a new approach to development. Instead of pushing features with major versions, almost every minor MySQL 8.0 version comes with new features or improvements. One of these new features is what we would like to focus on in this blog post.  Historically MySQL did not come with good tools for provisioning. Sure, you had mysqldump, but it is just a logical backup tool, not really suitable for larger environments. MySQL enterprise users could benefit from MySQL Enterprise Backup while community users could use xtrabackup. Neither of those came with a ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I'd like to continue reviewing MySQL bug reports from Community users that I considered interesting and subscribed to. Unlike in the previous post in this series, I am not going to check test cases on any competitor product, but will use only recently released MySQL 5.7.29 and 8.0.19 for checks, if any. This time I'll concentrate on bugs reported in November 2019.As usual, I mostly care about optimizer, InnoDB and replication related bugs. Here is the list:Bug #97476 - "Range optimizer skips rows". This bug reported by Ilya Raudsepp looks like a clear regression in ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Whether you’re edging toward a full DevOps initiative or simply looking for ways to better communicate and collaborate across functions, you and your IT organization can take advantage of a wide variety of free and proprietary DevOps tools to help you along.DevOps tools are those that promote sharing and collaboration, and they're so widely used, you may already be familiar with some of the ones described below. The key to expanding DevOps culture and practices is to think about how they might be used beyond your IT department, and shared in new ways ... Read More

Feed: All Oracle Press Releases. As we move into the third decade of cloud computing, it’s important to remember that not all clouds are alike. Back in, say 2006, cloud computing services were a revelation to software developers. These rentable storage and compute services provided a handy virtual holding cell that developers could use for designing and prototyping new applications without breaking the bank, or requiring scarce cooperation from in-house resources. And that was all well and good for that time. Fast forward more than a decade and the status quo is a lot more complicated. As businesses of all ... Read More

Feed: Planet MySQL; Author: Mikael Ronström; Just a fun image from running a benchmark in the Oracle Cloud. The image above shows 6 hours of benchmark run in a data node on a Bare Metal Server. First creating the disk data tablespaces, next loading the data and finally running the benchmark.During loading the network was loaded to 1.8 GByte per second, the disks was writing 4 Gbyte per second. During the benchmark run the disks was writing 5 GByte per second in addition to reading 1.5 Gbyte per second.All this while CPUs were never loaded to more than 20 percent ... Read More