Showing entries 6086 to 6095 of 44015
« 10 Newer Entries | 10 Older Entries »
Step by Step Notes on SQL Server to MySQL Migration-Part2

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.

Stored Procedure Migration from SQL Server to MySQL

migration of stored procedure from SQL Server to MySQL Sample Example:-
Page under Review...

This Week in Data with Colin Charles #4: Percona Server for MySQL with MyRocks

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

Percona Live Europe Dublin

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]
Automatic Partition Maintenance in MySQL and MariaDB: Part 3

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

Percona Live Europe Featured Talks: Orchestrating ProxySQL with Orchestrator and Consul with Avraham Apelbaum

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 Server for MySQL 5.7.19-17 Is Now Available

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]
MySQL Cluster Manager 1.4.3 released!


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.

Step by Step Notes on SQL Server to MySQL Migration-Part1

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 …

[Read more]
MySQL Marinate Quick Links

Here is a quick reference for MySQL Marinate:

[Read more]
How to Submit MySQL Marinate Homework

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 …

[Read more]
Showing entries 6086 to 6095 of 44015
« 10 Newer Entries | 10 Older Entries »