|
erics, March 22nd, 2021 Ah, the power of grep!
|
1 |
mysql --help | grep 'Default options' -A 1 |
Categories: How-To's, Technology howto, my.cnf, mysql, tips
| 
No comments
erics, November 18th, 2020 |
1 2 3 4 5 6 7 8 |
yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm yum install mysql-community-server mysql-community-client mysql-community-common mysql-community-devel mysql-community-libs nagios-plugins-all nagios-plugins-mysql sysbench grep 'temporary password' /var/log/mysqld.log 2020-11-18T15:17:13.884662Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ujtBqhNzE0>8 mysql_secure_installation -p'ujtBqhNzE0>8' systemctl enable --now mysqld mysql -uroot -p mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'secretStr0ngPassw0rd!'; |
Categories: How-To's, Technology AWS, AWS Linux, AWS Linux 2, howto, Install, Linux, mysql, MySQL 8, tips
| No comments
erics, April 5th, 2020 As a non-root user:
|
1 2 3 4 5 6 7 |
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)" brew install cmake brew install openssl brew install mysql@5.6 brew services start mysql@5.6 brew link mysql@5.6 --force mysql |
Make sure your PATH contains /usr/local/bin
Categories: How-To's, Technology /usr/local, /usr/local/bin, 5.6, apple, Brew, cmake, Homebrew, howto, Install, Launchd, Link, MacOS, macosx, mysql, MySQL 5.6, mysql@5.6, openssl, Services, tips
| No comments
erics, January 21st, 2020 |
1 |
echo `mysql -uyourUser -pyourPassword -B --disable-column-names -e "SELECT CONCAT('DROP DATABASE ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'yourPrefix%';"` | mysql -uyourUser -pyourPassword -B |
Categories: How-To's, Technology Concat, Database, DB, drop, DROP DATABASE, drop database like, howto, INFORMATION_SCHEMA, INFORMATION_SCHEMA.SCHEMATA, LIKE, Match, mysql, SCHEMA_NAME, SCHEMATA, tips
| No comments
erics, September 26th, 2019 Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
Categories: Architecture, cctrl, Composite, Mastering Tungsten Clustering, Question HA, mysql, Performance, Performance Tuning, QA, Shell, Tungsten
| Comments Off on Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
erics, August 29th, 2019 Why does the DIY approach fail to deliver vs. the Tungsten Clustering solution for geo-distributed MySQL multimaster deployments? Before we dive into the 10 reasons, note why commercially-supported enterprise software is less risky and in fact less costly.
Categories: Connector, Geo-Distributed, Maintenance, Multimaster, Multimaster MySQL, Multisite AWS, Clustering, Disaster REcovery, High Availability, mysql, proxy, Replicator
| Comments Off on 10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments
erics, August 26th, 2019 Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Categories: Architecture, cctrl, Composite, Datasource, Downtime, Maintenance, Mastering Tungsten Clustering, Question, Shun, Zero-Downtime Command, HA, Master, mysql, QA, recover, Shell, Slave, Switch, Tungsten, welcome, Zero
| Comments Off on Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
erics, August 8th, 2019 The power of Tungsten Clustering for MySQL / MariaDB is its built-in intelligent MySQL proxy, known as the Tungsten Connector. The Connector has built-in read-write splitting capabilities, and it is also possible to configure different algorithms which select the appropriate slave (i.e. Round-Robin or Lowest-Latency).
Categories: Balance, Bottleneck, Connector, Heavy I/O Load, Load Balancing, Mastering Tungsten Clustering, Overloaded, Read-only, Read-write, Splitting Clustering, mysql, proxy, Slave, Tungsten
| Comments Off on How to use Round-Robin Load Balancing with the Tungsten Connector
erics, August 7th, 2019 The replicator is a critical piece of the Tungsten Clustering solution for MySQL / MariaDB, as well as its own stand-alone data replication product. Automatic recovery enables the replicator to go back online in the event of a transient failure. In this blog, we discuss how to enable Autorecovery.
Categories: Auto Recover, Auto recovery, Mastering Tungsten Clustering, Mastering Tungsten Replicator, Offline, Tune Configuration, mysql, Network, Online, Recovery, Replicator, Tungsten, tuning
| Comments Off on Enabling Autorecovery for the Tungsten Replicator
erics, August 1st, 2019 Every time I use awk, my respect for it grows! Like grep, find and rsync, it is one of the powerhouse command-line tools in my arsenal. Recently, I needed to list all MySQL binary log files from a starting file forwards in sequence. AWK to the rescue! For example, I knew the starting file was […]
Categories: How-To's, Technology AWK, binary log file, howto, Index, Log, log file, Match, mysql, tips
| No comments
