MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log In this article we will see MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log First setup Master -slave replication between two mysql servers. Use below link to setup Master-slave Replication MySQL… 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 |
Improving MySQL installation Security(UNIX Platform). 1.The mysql_secure_installation programs enables security improvement . Set password for root accounts. Remove remote root accounts. Remove anonymous accounts. Remove the test database. 2.Invoking the program It will prompt for actions to perform . Only applicable to Unix/Linux operating systems.… Read More
MySQL installation using generic binaries-UNIX Platform. In this article we will come to know install MySQL using generic binaries. Learning Objectives : Choose the proper type of MySQL server software distribution. Get an overview of MySQL installation tasks. Load time zone tables. Start and Stop… Read More
MySQL Architecture -2(Disk space & Error logs). How MySQL will use disk space Disk space used primarily for files in the server’s data directory –> A sub directory for each database in the data directory. Data directory depends on distribution platform ,operating system. For Windows… Read More
MySQL Architecture When a query comes to MySQL from Client program it will go to Query parsing (hear it will check for SQL syntax by checking every character in SQL query and generate SQL_ID for each SQL query.) then it will sent to Optimization (Creates… Read More
