(Lalit) After MySQL installation, If you don’t have any enterprise level / any GUI interface for monitoring, backup then one of the option is, write your own scripts to automate these tasks.
Tag: Open Source
Partitions number in MySQL Cluster
(Abdel-Mawla Gharieb) As stated in the MySQL Cluster documentation:
MySQL service : Unable to setup unix socket lock file.
(Lalit) How to solve mysqld service restart problem for above error?
Row Store and Column Store Databases
(Rick Golba) In this blog post, we’ll discuss the differences between row store and column store databases.
Applying MySQL’s GROUP_CONCAT Function to Multiple Columns
(Rob Gravelle) In last month’s Why You Should be Using the MySQL GROUP_CONCAT Function article, I highlighted some of the benefits to using MySQL’s GROUP_CONCAT function. What was missing from that introduction was the full breadth of what the GROUP_CONCAT function can do.
Non-standard database set up with SELinux
(Cédric Bruderer) The Security-Enhanced Linux is an extension to the Linux Kernel, made by the NSA (National Security Agency). It implements Mandatory Access Controls (MAC), which allow an administrator to define, how applications and users can access resources on a system.
A Simple Node.JS Example Program for the MySQL Document Store
(Dave Stokes) I have chatting with others who want to use the new X Devapi Document Store features but have not been able to find simple example programs. Finding the bridge between ‘Hello World’ and something useful can often be discouraging.
Group Replication is GA with MySQL 5.7.17 – comparison with Galera
(Frederic Descamps) It’s a wonderful news, we have released MySQL 5.7.17 with Group Replication Plugin (GA quality).
MySQL InnoDB Cluster – Navigating the Cluster
(Alfredo Kojima) An important thing to know when managing an InnoDB cluster are the states that the cluster can be in, especially to know how to interpret the reported status of the cluster and specifically what to do to recover from failure various scenarios.
Getting started with ASP.NET Core and MySQL Connector/NET
(Roberto Garcia) This tutorial shows how to read information from MySQL Sakila database in an ASP.NET Core application using Connector/NET Core to explore the possibility to run this application on any .NET Core supported environment as Windows, Linux, and Mac.
