Below are 10 common replication problems :
1)Session binlog :
Setting sql_log_bin = 0 will disable binary logging for the session. So any DML/DDL query executed within that session on the master will not be replicated to slave
Turn off binary logging on master :
mysql> set sql_log_bin = 0 ; Query OK, 0 rows affected (0.00 sec)
Create table in reptest database ( on master )
mysql> create table reptest(ID int) ; Query OK, 0 rows affected (0.01 sec) mysql> show tables ; +-------------------+ | Tables_in_reptest | +-------------------+ | reptest | +-------------------+ 1 …[Read more...]
Below are some of the common scenarios where information_schema is useful :
How to check the database size using information_schema ?
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
How to list the tables created before 4 days ?
select * from information_schema.tables where CREATE_TIME < NOW() - INTERVAL 4 DAY ;
Columns table :
List all the tables that have a column called birth_date
select table_name from …[Read more...]
Daniel was tracking down what appeared to be a networking problem….
You got a production support call related to connection usage. Max_connections is set to 400 and connection usage has reached the maximum limit.
Below are some of the customized reports that can be used to trace the problem
Count by host :
mysql> select count(*),host from information_schema.processlist group by HOST; +----------+-----------+ | count(*) | host | +----------+-----------+ | 1 | localhost | +----------+-----------+ 1 row in set (0.03 sec)
Count by database:
mysql> select count(*),host from information_schema.processlist group by DB; …
Dear MySQL Users,
The MySQL Workbench team is announcing availability of the first
release of its upcoming major product update, MySQL Workbench 6.2.
MySQL Workbench 6.2 focuses on support for innovations released
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:
* A new spatial data viewer, allowing graphical views of result
containing GEOMETRY data and taking advantage of the new GIS
capabilities in MySQL 5.7.
* Support for new MySQL 5.7.4 SQL syntax and configuration options.
* Metadata Locks View shows …
recently while working on MySQL cluster 7.3.5, we came across this error
Forced node shutdown completed. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
The management nodes would start up but
the data nodes would complete phase 1 & shutdown, some times at phase 2 and some times at phase 5.
The error one would see in the trace file would be as follows:
Status: Temporary error, restart node Message: Internal program …[Read more...]
There are several ways to upgrade MySQL. In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL data, and then re-import it back into the upgraded version of MySQL.
In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if …[Read more...]
The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities, release-1.4.4. This release includes improvements in terms of usability, stability, security and an overall improvement regarding the comprehensibility of the provided error messages.
The following highlights a few of the more significant improvements.
The MySQL Utilities Team is pleased to announce a new release that contains our newest features – SSL and configuration file support. These were added to release-1.5.0-alpha.
How can I make a secure connection to my server via Utilities?
Use the new SSL command-line options that are available for all utilities:
–ssl-ca : The path to a file that contains a list of trusted SSL
–ssl-cert : The name of the SSL certificate file to use for establishing a secure connection.
–ssl-key : The name of the SSL key file to use for establishing a secure connection.