Today, I bought a Host1Plus VPS and tried to install MySQL. Initially, I used the yum -y install mysqld command, but after the installation, I was speechless:
Checked if there was a service starting with “my” in /etc/rc.d/init.d/ ls /etc/rc.d/init.d/my*
Using service …
NoSQL surged in popularity in 2010, with web sites large and small turning to NoSQL technologies as a top priority in the pursuit of high performance and high reliability. At the start of this year, InfoQ Chinese had the pleasure of inviting Mr. Sun Li from Phoenix New Media to share his experience with NoSQL …
The UMP (Unified MySQL Platform) system is a low-cost, high-performance MySQL cloud data solution developed by Taobao’s core system database team, with key modules implemented in the Erlang language. The system includes controller servers, proxy servers, agent servers, API/Web services …
When designing database table structures and operating databases (especially SQL queries when looking up tables), we need to pay attention to data operation performance. Here, we won’t discuss too much SQL statement optimization, but will focus specifically on MySQL, the most widely used database in web applications. Hopefully the optimization techniques below …
SSL replication requires that both the primary and replica servers have their own certificates and private keys. By default, SSL functionality is not enabled on the primary and replica servers; you need to enable it first. 1 2 3 4 5 6 7 8 9 10 11 12 mysql> show variables like '%ssl%'; +——— …
Overview Replication is commonly used to create copies of the master node, ensuring high availability by adding redundant nodes. Of course, replication can also serve other purposes, such as performing data reads and analysis on slave nodes. In horizontally scaling businesses, replication is easy to implement, primarily by utilizing the master node for write operations …
Based on a suggestion by morgo, I ran some small tests on the queries and datasets mentioned in Impact of Column Types on MySQL JOIN Performance, but uncovered an issue on another level: response time (aka MySQL versions). The answer, in short …
This is the second of a two-part series on MySQL encryption performance testing. In the first article, I exclusively used MySQL’s built-in SSL support to run stress tests, which produced some surprising results. Of course, it was expected that query throughput with SSL would be lower than without SSL, but …
Issue: After installing MySQL, phpMyAdmin cannot log into MySQL and returns error 1130, but logging in via the MySQL command line with `mysql -u root -p` works. Analysis and Solution: A Baidu search reveals that MySQL error 1130 is caused by remote connection users lacking remote access privileges. Solution: Log in locally …
When installing MySQL, most people enable the binlog feature. The benefit of enabling this feature is that it makes data recovery easier in the future, while the downside is that the log files grow rapidly and can quickly fill up disk space. Therefore, we need to periodically or manually delete oversized log files. The methods for deleting log files generally include the following …
