In part 1 and part 2 of this blog series, I showed how a DBA could configure MySQL or MariaDB to automatically drop old partitions. Some readers mentioned that they would also like for new partitions to be automatically created. In this blog post, I will show a stored procedure that can automatically create new partitions, and I will tie ... Read More

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post is with Avraham Apelbaum, DBA and DevOps at Wix.com His talk is titled Orchestrating ProxySQL with Orchestrator and Consul. The combination of ProxySQL and Orchestrator solves many problems, but still requires some manual labor when the configuration changes when there is a network split (and other scenarios). In our …

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 …

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

• Significant reduction in cpu consumption when idle.
• Added support for running your mysqlds with skip-networking enabled.

…

Why to Migrate into MySQL

• Migrating to MySQL from Other database is the technical review of the database feature set and capabilities.
• MySQL User are not dependent on single operating system or platform,it is available on 20+ OS.
• MySQL is one of the popular & widely used open source database.

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:

• • Starting page – talks about the book, FAQs, who the course is for, what it’s all about.
  • How to submit homework
  • Lesson 1/Chapter 1 – Introduction
  • Lesson 2/Chapter 2 – Installing MySQL
  • Lesson 3/Chapter 3 – Using the MySQL …

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. …

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.