Tag: MySQL

Feed: Puppet.com Blog RSS Feed. Author: ; If you’re new to Puppet Tasks™, here’s a quick primer. Puppet Tasks complements Puppet’s model-driven approach to automation by adding the ability to easily execute ad hoc tasks in an declarative way — doing exactly what you want, when you want it. The goal is to make it simple for you to do things like troubleshoot systems and devices, deploy point-in-time changes, and execute commands in an ordered fashion as part of an application deployment workflow.Puppet Tasks is available two ways: Bolt, an agentless open source task runner that can can run ad ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; Data nodes are the distributed, sharded storage core of MySQL NDB Cluster. Its data is usually accessed by MySQL Servers (also called SQL nodes in NDB parlance). The MySQL servers each have their own transactional Data Dictionary (DD) where all the metadata describing tables, databases, tablespaces, logfile groups, foreign keys, and other objects are stored for use by MySQL server. The MySQL server DD, introduced in version 8.0, has enabled improvements such as atomic and crash-safe DDL and the INFORMATION_SCHEMA implementation among other things. At the storage engine level, NDB has its own ... Read More

Feed: Planet MySQL; Author: Chandan Kumar; Introduction Before I talk about installation of MySQL inside docker, it's more important to knowwhat is Docker?- Docker is a tool designed to create , deploy ,and run an application any where. -It allow us to package up application with all requirements such as libraries and other dependencies and ship it all as a PACKAGE.who uses Docker?Developer : Docker enables developer to develop application without spending much time on IT infrastructure.Sysadmin :-Docker enables sysadmin to streamline the software delivery, such as develop and deploy bug fixes and new features without any roadblock. Enterprise :-Docker works in ... Read More

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: Planet MySQL; Author: MySQL High Availability; In part 1, we took a brief, high-level look at the various protocols and mechanisms used to keep the Data Dictionary (DD) of MySQL servers connected to a MySQL Cluster in synchronization with each other and with the NDB Dictionary. More specifically, we explored the problems with the implementation of user-triggered synchronization in the NDB Cluster 7.x versions. These concerns are addressed in NDB Cluster 8.0 through a new feature: Automatic Schema Synchronization (or auto schema sync for short). A new component called Metadata Change Monitor has been introduced to detect any NDB ... Read More

Feed: Planet MySQL; Author: MyDBOPS; As a part of Mydbops Consulting we have a below problem statement from one of our client. “We have a high powered server for reporting which in turn powers our internal dashboard for viewing the logistics status.Even with a high end hardware, we had a heavy CPU usage and which in turn triggers spikes in replication lag and slowness. Below is the hardware configuration.“ OS : Debian 9 (Stretch) CPU : 40 RAM : 220G (Usable) Disk : 3T SSD with 80K sustained IOPS. MySQL : 5.6.43-84.3-log Percona Server (GPL) Datasize : 2.2TB Below is ... 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: Planet MySQL; Author: Severalnines; April 2018 is not just a date for the MySQL world. MySQL 8.0 was released there, and more than 1 year after, it’s probably time to consider migrating to this new version. MySQL 8.0 has important performance and security improvements, and, as in all migration to a new database version, there are several things to take into account before going into production to avoid hard issues like data loss, excessive downtime, or even a rollback during the migration task. In this blog, we’ll mention some of the new MySQL 8.0 features, some deprecated stuff, and ... Read More

Feed: Planet MySQL; Author: Bernd Ocklin; The MySQL NDB Cluster team works on fundamental redesigns of core parts of NDB architecture. One of these changes is the partial checkpoint algorithm. You can now take full advantage of it when building much larger clusters: NDB 8.0 can use 16 TB data memory per data node for in-memory tables. 3-replica 5 PB clusters can be build with disk data. The new partial checkpoint algorithm executes restarts up to 4x faster, reduces checkpoint times by a factor of 6x in typical set-ups and minimizes cluster’s disk space consumption. In addition the new checkpoints ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; There are certain things in life that you can count on … FOSDEM is back in town, and together with that a new pre-FOSDEM MySQL day, actually 2 days this year! And of course, we definitely have not forgotten … the MySQL Community dinner! We continue the by now well known tradition of dining together in style with members from all over the community, and invite you to the ICAB venue (the same location as where the pre-FOSDEM MySQL days are being held. Book your tickets now!!! The listed ticket price includes a selection of ... Read More