mysql – login: root

changing mysql to innodb_file_per_table=1 with lvm and replication almost without downtime

This conversion was made with mysql 5.5, but it should work with older versions, as replications on mysql were introduced since mysql 3.23.15. Don’t forget the Disclaimer !!! It requires more than the basic knowledge in linux, lvm and mysql. I do NOT take ANY responsibility for Your data loss!!! Long story short:

enable mysql bin logs
create lvm snapshot
mark master status
-
start 2'nd mysql instance from snapshot
dump all data
-
start new mysql instance with innodb_file_per_table=1 in new data_dir
start import of dumped data
start replication from master
-
when slave=master stop both servers
move slave data_dir to /var/lib/mysql and start main mysql instance.

enable mysql bin logs

create lvm snapshot

mark master status

start 2'nd mysql instance from snapshot

dump all data

start new mysql instance with innodb_file_per_table=1 in new data_dir

start import of dumped data

start replication from master

when slave=master stop both servers

move slave data_dir to /var/lib/mysql and start main mysql instance.

LET’S BEGIN:

nsc October 19, 2014 linuxinnodb file per table, mysql, mysql slave, no downtime innodb_file_per_table, slave 0 Read more >

Recover mysql root password

It happens quite often, that You need to do something on database, which was installed long long time ago. And nobody remembers the root password. Kinda good practice is to save mysql password in root user directory with a “.” in front of it (hidden), for example .my.cnf Nobody can read root users directory, except root, and anyway, root user can change mysql password at any time, so it’s not an security issue. If all users are able to see root users directory, that is a problem :) Easy steps how to recover mysql root password.

nsc January 15, 2012 linuxgain, linux, mysql, password, recovery, root 0 Read more >

Tag Archive: mysql

changing mysql to innodb_file_per_table=1 with lvm and replication almost without downtime

Like this:

Recover mysql root password

Like this:

Tag Archive: mysql

changing mysql to innodb_file_per_table=1 with lvm and replication almost without downtime

Share this:

Like this:

Recover mysql root password

Share this:

Like this: