- Home
- Tag: MySQL
Posts tagged MySQL
Tag: MySQL
MySQL & macOS Silicon
Feed: Planet MySQL; Author: Michael McLaughlin; It’s a problem for my students who purchased the new Apple hardware that uses Apple Silicon because they can’t install a Docker MySQL instance. However, there is Homebrew formula that works on macOS Big Sur and the new Apple silicon. It supports: Intel Silicon: macOS Big Sur, Catalina, and Mojave Apple Silicon: macOS Big Sur The Homebrew Formula does have conflicts that you may need to avoid. It is a solution for those with the new Apple silicon. As always, I hope this helps those looking for a solution ... Read More
MySQL 101: Basic MySQL Server Triage

Feed: Planet MySQL; Author: MySQL Performance Blog; So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause analysis (RCA). Get the server back up and running. Too many people rush to Step #2 and lose pertinent diagnostics from Step #1. Likewise, too many people will spend too much time on Step #1 and delay getting to Step #2 and restoring service. The goal is to collect ... Read More
MySQL Count Weekday occurrences
Feed: Planet MySQL; Author: Joshua Otwell; Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE functions and the WITH clause… OS and DB used: Linux Mint 20 “Ulyana” MySQL 8.0.23 Self-Promotion: If you enjoy the content written here, by all ... Read More
MySQL NDB Cluster Installation Through Docker

Feed: Planet MySQL; Author: Saroj Tripathy; In this post, we will see how to setup MySQL NDB Cluster from a docker image. I assume that the reader has some basic understanding of docker and its terminology.Steps to install MySQL NDB Cluster:Let's create a MySQL NDB Cluster with the following environment:MySQL NDB Cluster version (Latest GA version)1 Management Node4 Data Nodes1 Mysqld ServerConfiguration slots for upto 4 additional API nodes Note: Docker software must be installed and running on the same host where we are planning to install MySQL NDB Cluster. Also make sure we have enough resources allocated to docker so ... Read More
AWS to Offer Third-Generation Intel Xeon Scalable Processor-Based Amazon EC2 Instances
Feed: AWS Partner Network (APN) Blog. Author: Martin Yip. By Martin Yip, Sr. Product Marketing Manager at AWS At Amazon Web Services (AWS), we are constantly innovating on behalf of customers so they can run virtually any workload, with the highest performance and the best price-performance. AWS pioneered cloud computing and has built the most reliable and secure global cloud infrastructure with the broadest and deepest portfolio of services. Millions of customers, from startups to enterprises, are building their businesses on AWS. Amazon Elastic Compute Cloud (Amazon EC2) provides customers with the most options for compute so they can tailor ... Read More
MySQL and UUIDs
Feed: Planet MySQL; Author: Kristian Köhntopp; In ALTER TABLE for UUID we discuss currently proper way to store and handle UUID in MySQL. Currently it works, even in a performant way, but it still hurts. It should not. Definition of UUID The RFC 4122 defines various types of UUID, and how they are being formatted for presentation and as a bit field on the wire. As this document was written bei Leach and Salz, among others, RFC 4122 UUIDs are also called “Leach-Salz UUIDs” (for example in the Java Documentation). There are other UUID variants, used in other systems (NCS, ... Read More
Which Version of MySQL Should I Use for MyRocks?

Feed: Planet MySQL; Author: MySQL Performance Blog; As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in many cases, this is in no way a trivial undertaking. Another approach that has been gaining interest is the use of MyRocks as an alternative storage engine to the traditional InnoDB. While not for everyone, in certain use cases it could be a potential solution. As with so many things open source, the next ... Read More
Launching a WordPress Website using Amazon Lightsail Containers

Feed: AWS Compute Blog. Author: Emma White. This post is written by Benjamin Gardiner, Partner Solutions Architect. Amazon Lightsail is a great way to get familiar with AWS. Lightsail simplifies the deployment of instances, databases, load balancers, CDNs, and now also containers. In this post I demonstrate how easy it is to launch a WordPress website using Lightsail containers and a Lightsail database. I’ll only use the Lightsail console, so no coding is required to follow along. Product overview Containers offer several advantages over virtual machines. For example, containers require less system resources than virtual machines and are lightweight, which ... Read More
Prepare data from Amazon Redshift and other JDBC-supported databases/data warehouses in AWS Glue DataBrew through native connectors
Feed: Recent Announcements. You can now clean and transform data with an interactive, point-and-click visual interface from Amazon Redshift, Snowflake, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL through native JDBC connectors in AWS Glue DataBrew. In just a few clicks, you can configure these JDBC connections from the AWS Management Console to directly explore and experiment with datasets from AWS data lakes, data warehouses, and databases without writing code. AWS Glue DataBrew is a visual data preparation tool that makes it easy to clean and normalize data using 250+ pre-built transformations for data preparation, without the need to write ... Read More
Amazon RDS for MySQL Supports New Minor Versions 5.6.51, 5.7.33, and 8.0.23.
Feed: Recent Announcements. Following the announcement of updates in MySQL database versions 5.6 , 5.7, and 8.0, we have updated Amazon Relational Database Service (Amazon RDS) for MySQL to support MySQL minor versions 5.6.51, 5.7.33, and 8.0.23. We recommend that customers upgrade to any of the latest minor versions to fix known security vulnerabilities in prior versions of MySQL, and to benefit from the numerous bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more about upgrading your database instances in the Amazon RDS User Guide, including automatic minor version upgrades ... Read More
Recent Comments