Oracle - SQL - MySQL DBA - Life Long Learning Experience

1. Configure the server disk arrays.  Make Standard as:     R1    P1 /                P2 /swap     R10  P1 /mysqldata1     R1   P1 /mysqllogs1     R1   P1 /mysqltemp     This will depend on physical / virtual and number of available disks / size of system.     On a vm environment we typically would split the partitions as above but the disk level Raid configuration would not apply. 2.  Download the 64bit mysql rpm files for server and client and copy onto the new centos server:       MySQL-server-<version>.el6.x86_64.rpm       MySQL-client-<version>.el6.x86_64.rpm 3.  Type   rpm -ivh --replacefiles MySQL-client<version>.el6.x86_64.rpm MySQL-server<version>.el6.x86_64.rpm      Note the --replacefiles flags replaces the 5.1 version that is already installed by default on Centos      This will install the binaries and by default, you'll end up with datafiles in /var/lib/mysql. 4. Create your /mysqldata1/d<

What My.cnf File Was Used To Start The Instance Often it is not clear that configuration file is used to boot a MySQL instance. In this case we will see a trick for Windows. First of all if we execute the following command; C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql –help In one part of the output that gives us, we see the following; Default options are read from the following files in the given order: C:\Windows\ my.ini C:\Windows\ my.cnf C:\ my.ini C:\ my.cnf C:\Program Files\MySQL\MySQL Server 5.7\ my.ini C:\Program Files\MySQL\MySQL Server 5.7\ my.cnf Here indicates the file name and order to search for the file of parameters. The easiest trick in Windows, as long as we have installed MySQL as a service, remember that Windows can be installed as application  although I do not recommend this option. It is to see service properties as shown in the following screen shot;