In Continue to Previous Post Migration Part-1, Page under
Review...
Disclaimer:This is my personal blog. The views expressed
on these pages are mine alone and not those of my Current
Employer.
migration of stored procedure from SQL Server to MySQL Sample
Example:-
Page under Review...
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Have you registered for Percona Live Europe Dublin? We’ve more or less finalized the schedule, and the conference grid looks 100% full. We’re four weeks away, so I suggest you register ASAP!
I should also mention that no event can be pulled off without sponsors, so thank you sponsors of Percona Live Europe 2017. I sincerely hope to see more sign up. Feel free to ask me more about it, or just check out our sponsor prospectus.
…[Read more]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 …
[Read more]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
- 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 …