Percona announces the release of Percona Server for MySQL 5.7.19-17 on August 31, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.19, and including all the bug fixes in it, Percona Server for MySQL …
[Read more]
You might already have seen the announcement earlier this summer
– we made MCM 1.4.3 available for download from My
Oracle Support.
What’s new?
The most notable changes to MCM 1.4.3 include
…
Why to Migrate into MySQL
Below Table help you to migrate databases from SQL Server to
MySQL. Page Under Review...Note:-I am Skipping DataType Migration
here. if anyone want it i will share the same.
I tried to pull off RealTime
scenario which is important to know while doing migration.
Disclaimer:This is my personal blog. The views expressed
on these pages are mine alone and not those of my Current …
Here is a quick reference for MySQL Marinate:
We will be submitting the homework via GitHub. The reason for this is to have a centralized place for homework, as well as teaching how to use a revision control system and how to interact specifically with GitHub.
Reading:
Learn about git at http://git-scm.com/book/en/Getting-Started-Git-Basics
(You only need to read this one webpage, no need to go to the
next page)
To do:
– Create a github account at www.github.com if you do not already have
one.
– Install and configure git on your local machine as per https://help.github.com/articles/set-up-git
– Fork the MySQL Marinate repo as per …
Want to learn or refresh yourself on MySQL? MySQL Marinate is the FREE virtual self-study group is for you!
MySQL Marinate quick links if you know what it is all about.
This is for beginners – If you have no experience with MySQL, or if you are a developer that wants to learn how to administer MySQL, or an administrator that wants to learn how to query MySQL, this course is what you want. If you are not a beginner, you will likely still learn some nuances, and it will be easy and fast to do. If you have absolutely zero experience with MySQL, this is perfect for you. The first few chapters walk you through getting and installing MySQL, so all you need is a computer and the book.
The format of a virtual self-study group is as follows:
Each participant acquires the same textbook ( …
The website or mobile app is the storefront for participating in the modern digital era. It’s your portal for inviting users to come and survey your products and services. Much attention focuses on front-end development; this is where the HMTL5, CSS, and JavaScript are coded to develop the landing page that everyone sees when they visit your site.
But the real magic happens on the backend. This is the ecosystem that really powers your website. One writer has articulated this point very nicely as follows:
The technology and programming that “power” a site—what your end user doesn’t see but what makes the site run—is called the back end. Consisting of the server, the database, and the server-side applications, it’s the behind-the-scenes functionality—the brain of a site. …
[Read more]In this article, we will show you how to configure remote and secure connections for MySQL on Ubuntu 16.04 VPS. ...
Read moreHow to configure remote and secure connections for MySQL on Ubuntu 16.04
The post How to configure remote and secure connections for MySQL on Ubuntu 16.04 appeared first on RoseHosting.
In a previous blog post, I showed how a DBA could configure MySQL or MariaDB to automatically drop old partitions. Some readers provided some feedback on some issues that they’ve run into while doing similar operations. Specifically: It can sometimes help to maintain an empty first partition when partitioning by dates, since partition pruning cannot always eliminate the first partition. ... Read More
In this blog post, we’ll look at nested data structures in ClickHouse and how this can be used with PMM to look at queries.
Nested structures are not common in Relational Database Management Systems. Usually, it’s just flat tables. Sometimes it would be convenient to store unstructured information in structured databases.
We are working to adapt ClickHouse as a long term storage for Percona Monitoring and Management (PMM), and particularly to store detailed information about queries. One of the problems we are trying to solve is to count the different errors that cause a particular query to fail.
For example, for date 2017-08-17 the query:
"SELECT foo FROM bar WHERE …[Read more]
