MySQLFabric Q&A
MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features…
MySQL: fresh startup script
[ root @ dbversity : /tmp ] cat mysql_fresh_start.sh service mysql stop & sleep 10; cd /var/lib/mysql rm -rf /var/lib/mysql/* mysql_install_db & sleep 10; chown mysql:mysql /var/lib/mysql/ -R echo -e “\n” service mysql start & sleep 5; echo -e “\n”…
MySQL Fabric setup document
MySQL Fabric is a framework for managing groups of MySQL Servers and using those servers to provide services. It is designed to be extensible so that over time many different services can be added. In the current version the services…
[MySQL]: Master-slave replication for a new-setup
Master: 1. Install MySQL as per the standard procedure 2. Edit my.cnf of Master server with below parameters server-id = 8 # Should be unique id between 2 and 2^32 – 1 log-bin = /home/mysql5/mysql-binlogs/’hostname’binlog # required for replication log-bin-index…
[ERROR] /usr/sbin/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
[ERROR] /usr/sbin/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13) [ERROR] Fatal error: Can’t open and lock privilege tables: Can’t find file: ‘./mysql/host.frm’ (errno: 13) We usually see above errors while we’re trying to start an additional MySQL instances on the…
[MySQL]: How to start multiple instances on a single server
[ root @ dbversity : /tmp ] [ root @ dbversity : /tmp ] ll -lhtr MySQL-5.6.25-1.el6.x86_64.rpm-bundle.tar -rw-r–r– 1 sm70768 mongod 213M Jun 22 08:25 MySQL-5.6.25-1.el6.x86_64.rpm-bundle.tar [ root @ dbversity : /tmp ] [ root @ dbversity : /tmp…
[AuroraDB]: Simulating failures using SQL
Testing Amazon Aurora Using Fault Injection Queries You can test the fault tolerance of your Amazon Aurora DB cluster by using fault injection queries. Fault injection queries are issued as SQL commands to an Amazon Aurora instance and they enable…
[MySQL]: how to do MySQL Sysbench testing on Linux
SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load. The idea of this benchmark suite is to quickly get an impression about system performance…
[MySQL]: SysBench Installation procedure
SysBench: System evaluation benchmark Why ? The idea is to quickly get an impression about system performance for MySQL usage without setting up complex benchmark and even without installing MySQL. In some cases this is very helpful. This is also the…
[MySQL]: SQL script to list MyISAM & innodb_file_per_tables
— It needs to be run from an account that has read permission for the INFORMATION_SCHEMA database. select msg as `==> Checking current version of MySQL.` from ( select ‘This script should be run on MySQL version 5.6. ‘ +…