Linux, programming and more
MySQL-Replication could be a kind of load balancing for querieng applications or active failover/backup node which has the same data.
Also for common heavy loaded scenarios, where the primary write-queries are going to the master node and all read-queries are running against the slave node.
[Read more…]
Collection of some MySQL commands, very useful to create and restore MySQL-Backups.
[Read more…]
I run a nightly mysqldump of all my databases and one of them has over 500 tables, mysqldumper bring me a error while processing this huge database: [Read more…]
While trying to start or stop MySQL I get:
1 | Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) |
Dabian has a own way to login to the MySQL database the credantials are listed in a file:
1 2 3 4 | cat /etc/mysql/debian.cnf [...] user = debian-sys-maint password = bodCNLUx0GGYm6F |
Logon:
1 | mysql -u root -p |
Execute:
1 | GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'bodCNLUx0GGYm6F' WITH GRANT OPTION; |
By the way set a new root passwort:
1 | mysqladmin -u root password 'new-password' |
Sometimes you need a good reference, and this is one of those times. MySQL’s perror command returns many error codes, and I’ve provided a listing here. To find errors individually, just run:
1 2 | # perror 28 OS error code 28: No space left on device |