MySQL Master-Slave Replication on different AWS instances. In this article i want show how to configure master-slave replication in two different machines. What is Replication ? Replication is the continuous copying of data changes from one database (MASTER) to another database (SLAVE ). The two… Read More
BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY. Please Refer the previous article. BACKUP AND RECOVERY IN MySQL (Article -17). Using mysqldump utility we can take the backup of only data(ignoring structure ) Check the databases list.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | ctg | | mysql | | performance_schema | | sys | | trg | | trg2 | +--------------------+ 7 rows in set (0.00 sec) |
To take the backup of only data… Read More
BACKUP AND RECOVERY IN MySQL. What is backup ? Backup is nothing copying the data into another location . Why we need backup ? If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups… Read More
Table Maintenance in MySQL. This page contains several commands you will use to optimize, analyse and repair tables. It also presents the mysqlcheck command line tool. Table maintenance will separated in five ways .They are : Check Table Repair Table Analyse Table Optimise Table mysqlcheck … Read More
SECURITY AND USER MANAGEMENT IN MySQL. SECURITY RISKS IN MySQL. When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: Comes with multiple users or… Read More
STORAGE ENGINES IN MySQL We covered MyISAM & InnoDB in previous article. STORAGE ENGINES IN MySQL (Article -12) In this article we will cover one more important storage engine called MEMORY STORAGE.ENGINE. MEMORY STORAGE ENGINE : Memory storage engine creates tables in memory. It is… Read More
STORAGE ENGINES IN MySQL. What is Storage Engine ? A storage engine is a software module that a database management system uses to create, read, update data from a database. There are two types of storage engines in MySQL: transactional and non-transactional. For MySQL 5.5… Read More
Matadata (INFORMATION_SCHEMA) WHAT IS METADATA ? As per definition it is DATA ABOUT DATA. In MySQL METADATA stored in INFORMATION_SCHEMA. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a… Read More
MySQL Clients Learning Objectives : List the available clients for administrative tasks and their basic purposes. Invoke mysql clients and common command line options. Invoke and us the MySQL command line client MySQL. Use the mysqladmin for administrative clients APIs (Drivers and Connectors). Overview… Read More
LOG FILES IN MySQL. Before going to look on logfiles we need to know what is the use of my.cnf file. By default my.cnf file will be in /etc/my.cnf location, when ever you try to restart MySQL server look for my.cnf in /etc/ location.
|
1 2 |
[root@ip-172-31-39-223 ec2-user]# ll /etc/my.cnf -rw-r--r--. 1 root root 1066 Sep 10 10:32 /etc/my.cnf |
