admin, Author at ClusterEngine.me

Database Weekly News

The rise of the vertical database.

Things are really heating up in the database industry; the last ten years have seen an explosion in the number of products and vendors (analyst firm 451 Research now tracks 386 different products on its popular ‘tube-map’ of the database landscape). The rapid evolution of the internet and the move towards data driven decisions across all industries has created a rich environment for database innovation. Read more.

[information-age.com]

Tools for Database Management. TeamSQL.

We continue to talk about tools for working with MySQL databases. In our reviews we test management and monitoring systems as well as other programs that will be useful for you to work with databases. Today we will consider a project called TeamSQL that has recently appeared on the market.

Performing Backup of a Live MySQL Database using mysqldump

Live MySQL Backup without Locking Tables

Mysqldump client utility is the easiest and favorite tool for DBAs to backup a MySQL database. It supports numerous options to configure the backup such as type of backup format, what to backup, how to deal with key constraints, how to deal with transactions etc. The output of a mysqldump backup operation is named as a dump file and it can be restored to recreate the backed up database. The dump files can be in formats like CSV, tab-delimited, SQL, XML etc. The dump file can be further compressed using a suitable compression utility like Tar, Gzip, XZ, Bzip2 etc to reduce the dump file size to make it easier for storage and transfer.

Is Docker Perfect for Databases?

Docker – a Revolutionary Container Platform

Before going into the analysis, let’s have a brief idea about Containers and Docker. A Container is an executable package of software designed to provide an isolated environment for applications to run in a host server. They have all the necessary code, runtime, libraries etc. to provide a safe environment for the application software. Prominent enterprises like Uber, Facebook, Google etc are using Containers in a very high scale. Docker is a software container platform and is used to create container units on host machines. Many such units share the host’s OS, RAM, Processor and other resources. Disk usage is minimized by sharing filesystem layers and common files. Docker containers help in many aspects for Software Lifecycle, starting from development to deployment and implementation. It provides an agile continuous integration platform with isolated units for development teams, with development, test and production environments. It makes a server compatible for a wide variety of software applications that have different dependencies. Docker makes the host platform portable and distributed by virtue of its self sufficient and isolated container feature. All these come along with reduced need of computing power and space, since Docker Containers use the same Kernel in a host, rather than VMs using separate guest OS.

MySQL Backup and Restore Methods

It is important from an administrative and operational point of view to safeguard your data and database from all kind of risks. Applying this to a MySQL database, it has lot of challenges to overcome and survive – so that the data associated with it is safe, with precise data integrity and genuineness over time. As like any software applications, a MySQL database is also facing threats and challenges in the below forms:

Hardware and software failures
Operating system/File system crashes
Data corruption and deletion
Database upgrades and data corruption
Etc.