(Frederic Descamps) In this blog post, we’ll discuss read-write split routing in MaxScale.
Tag: Open Source
Simplifying MySQL Partition Management Using Common_schema
(Ike Walker) Maintaining partitioned tables in MySQL can be tedious. In a reporting database that uses monthly date partitions, I’ve found that I can simplify many frequent partition operations using the common_schema QueryScript language.
MySQL 5.7 primary key lookup results: is it really faster?
(Vadim Tkachenko) This blog examines MySQL 5.7’s primary key lookup results, and determines if MySQL 5.7 is really faster than its early versions.
How to Install and Configure MySQL Cluster on CentOS 7
MySQL Cluster is designed to provide a MySQL compatible database with high availability and low latency. The MySQL Cluster technology is implemented through the NDB (Network DataBase) and NDBCLUSTER storage engines and provides shared-nothing clustering and auto-sharding for MySQL database systems.
General Tablespaces in MySQL 5.7 – Details and Tips
(Kevin Lewis) InnoDB in MySQL 5.7 introduced for the first time the ability to create a general tablespace and assign multiple tables to it. These tablespaces can be assigned anywhere on the system.
TokuDB impacts InnoDB Performance?
(Peter Zaitsev) This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment.
mysqlpump — A Database Backup Program
(João Osorio) The MySQL 5.7 Release Notes for version 5.7.8 are out. Besides the new JSON data type, there is also a new tool, called mysqlpump, which offers the following features:
Invalid datetime when converting to timestamp
(Marcelo Altmann) Today I faced an issue that from first looking at it I was almost sure I`ve found a bug, but putting a bit more research on it, it makes totally sense.
Moving with SQL Server to Linux? Move from SQL Server to MySQL as well!
(Peter Zaitsev) In this blog, we’ll discuss MicroSoft’s recent announcement that SQL Server will be available on Linux. If you’re going to Linux, why not move from SQL Server to MySQL?
Print tab separated values as table using MySQL
(João Osorio) Using mysql command line utility to get recordsets, the data rows alignment and line breaks are often a mess.
