(Lalit) Recently I was testing data migration from MSSQL to MySQL using MySQL Workbench. My aim was to include data with all datatype available in MSSQL for migration. In this following blog post will see data migration prerequisites, migration steps and few common errors.

(Przemys³aw Malkowski) This blog discusses how to prepare your database for the new leap second coming in the new year.

(Ashraf Sharif) All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal.

(Frederic Descamps) Today in our series of articles related to MySQL Group Replication’s limitations, let’s have a quick look at Savepoints.

(Øystein Grøvlen) MySQL 5.6 introduced semi-join transformation for IN-subqueries. This opened up for several new ways to execute such subqueries; one was no longer tied to executing the subquery once for every row of the outer query.

(Krzysztof Ksiazek) Database schema change is one of the most common activities that a MySQL DBA has to tackle. No matter if you use MySQL Replication or Galera Cluster, direct DDL’s are troublesome and, sometimes, not feasible to execute.

(Frederic Descamps) Today’s article is about the first two restrictions in the requirements page of the manual:

(Ashraf Sharif) MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM being the most popular ones. Each storage engine implements a more specific set of features required for a type of workload, and as a result, works differently from other engines.

(Frederic Descamps) In this article, I will show you how it’s possible to perform an online migration from a 3 members Galera cluster setup (in this case I’m using PXC 5.7.14) to a 3 members MySQL Group Replication cluster setup (MySQL Community 5.7.17).

(Shahriyar Rzayev) I would like to share our experimental tests about, writing UDF with Python.