Language:
-
-
Recent Posts
Categories
- backup (4)
- binlog (5)
- bug (1)
- Charset (1)
- Collation (1)
- index (1)
- InnoDB (3)
- install (10)
- MySQL (25)
- mysqld (2)
- mysqld_multi (1)
- mysqldump (2)
- optimize (3)
- password (4)
- performance (6)
- query cache (1)
- replication (10)
- Security (4)
- Uncategorized (5)
Category Archives: install
MySQL 5.7 auto-generated root password
Hi There. You may have noticed something different when you install a fresh copy of MySQL 5.7 either via yum or using binary source. The root password is auto-generated. Ok and where can I find it ? Centos cat /var/log/mysqld.log … Continue reading
Posted in install, MySQL, password, Security
13 Comments
MySQL & NoSQL – Memcached Plugin
Many of you have already heard about NoSQL databases and one of the the most used tool is Memcached, where you add a cache layer between the application and database. Since MySQL version 5.6, a new plugin is available to … Continue reading
Posted in InnoDB, install, MySQL, optimize, performance
Leave a comment
MySQL Fabric – Part 1 – Installing
MySQL Fabric is a tool included on MySQL Utilities that helps you to manage your MySQL instances. It works by basically adding a new layer between your application and MySQL instances, which can provide an easy way to use sharding … Continue reading
Posted in install, MySQL, performance, replication
3 Comments
MySQL Sandbox
Hi there, today we will learn about an amazing tool that every single MySQL dba must know, I’m talking about MySQL Sandbox. MySQL Sandbox is developed by Giuseppe Maxia (The Data Charmer), it’s a tool that make the installation of MySQL servers … Continue reading
Posted in install, MySQL, replication
3 Comments
Installing latest version of MySQL via yum
Usually when you try to install MySQL via yum, by default, the version that comes with your OS is always an old version (not the latest version available from mysql.com/downloads). In order to have the latest version, you always needed … Continue reading
Auditing MySQL With Mcafee Audit Plugin
Audit MySQL isn’t an easy task by default, you can use some technics like tcpdump, write a parser for general log, use MySQL proxy, or you can use some of audit plugins available out there(Mcafee MySQL Audit Plugin or MySQL … Continue reading
Posted in install, mysqld, Security
7 Comments
MySQL 5.6 Replication with GTID – Global Transaction ID
Hi guys, Early February Oracle released the new version of MySQL named 5.6, one of the enhancements is the GTID (Global Transaction ID) GTID is an unique identifier which will be added at each transaction, and will be very useful … Continue reading
Posted in backup, binlog, install, replication
2 Comments
Installing MySQL 5.5 Part 2 – Multiple instances with mysqld_multi
Continuing our previous post, today we’ll go up several instances of MySQL on the same server, very common practice today, instead of creating a single instance in100% of the resources of the server splits the load of QPS (queries per seconds) between multiple instances. The groups will look for mysqld_multi [mysqldN] within our my.cnf configuration file, where N is an integer that will be used later to refer to what server we’ll see the STOP or START REPORT … Continue reading
Posted in install, MySQL, mysqld_multi
7 Comments
Installing MySQL 5.5 Part 1 – A single instance
Today I will teach you how to install a MySQL server with ease. With only a single instance in the second part of this article, I will teach installing multiple instances of MySQL and control them through the mysqld_multi. For … Continue reading
Posted in install, MySQL, mysqld
2 Comments
Recover MySQL root password
If you have lost the MySQL root password, or just don’t remember it, don’t worry, follow the step by step for you to retrieve it Stop the MySQL service if it is running “/etc/init.d/mysql stop” Up the Server “skiping” the … Continue reading
Posted in install, MySQL, password
9 Comments