GitHub uses MySQL as the main storage for all non git warehouse data, and its availability is critical to the access operation of GitHub. The GitHub site itself, GitHub APIs, authentication, and so on all need database access. We run multiple My

Now that MySQL 8 and PostgreSQL 10 have been released, it is time to review how these two open source relational databases compete with each other. Before these versions, it was generally believed that Postgres performed better in the feature set because of its "academic" style

Many of our users, developers and database administrators constantly consult our team about the index recommendation algorithm of EverSQL. So we decided to write something about it. This tutorial will not introduce all the internal features of the algorithm in detail, but will simply explain

MySQL is the most popular open source database system in the world, and MariaDB (a branch of MySQL) is the fastest growing open source database system in the world. After the MySQL server is installed, it is insecure in the default configuration. To ensure database security, it is usually a general database management system

You must know that a fast visiting website can make users like it, help the website improve its ranking from Google, and help the website increase its conversion rate. If you have read articles on website performance optimization, such as setting the best implementation of the server, killing slow code

In this blog, we are going to see how ProxySQL can improve the SSL connection performance of MySQL. When deploying MySQL using SSL, the main problem is that if the connection pool is not used (for example, mysqlnd mux in PHP, mysq in Python

What is the median? The median of a numeric array is the value in the middle of the array after data sorting. If the array has an even number of elements, the median is the average of the two values in the middle. The median is useful for understanding "Is my value in the middle?". For example

In the era of the need to support mobile/tablet applications and ordinary desktop browser access, the popularity and effectiveness of websites largely depend on their availability and performance. A website with slow access will cause the loss of visitors or potential customers, and lead to business failure. One

I like pizza. I'm kidding. I like pizza. Especially if it is free. I even like things that look like free pizza. One day, a package came to my mailbox, which was wrapped in a pizza box. I will give Etsy shopkeeper five stars

Before performing performance analysis, you need to locate time-consuming queries. MySQL provides a built-in time-consuming query log. Before use, open the my.cnf file and set slow_query_log to "On". At the same time, set long_query_time to be a slow time for a query

If you have not indulged in LINQ, you will think that there is nothing to make a fuss about. SQL is not broken, why fix it? Why do we need another query language? The popular saying is that LINQ is integrated with C # (or VB), so

Install $npm install MySQL. For information about the previous 0.9. x version, please visit the v0.9 branch. Sometimes I also ask you to install the latest version from Github to check whether the bug has been fixed. In this case, enter: $npm install mysqljs/m

This blog tests the primary key query results of MySQL 5.7 and determines whether MySQL 5.7 is really faster than previous versions. MySQL 5.7 was just released some time ago. Now that the dust has settled, it is time to test its performance improvement. I'm not just trying to

Configure the world's smallest MySQL server - how to install a MySQL server on an Intel Edison control board. In my recent blog post, the Internet of Things, news and MySQL, I showed that if the board of Particle Photo

We are proud to announce that MySQL 5.7 stable version is available for download. MySQL 5.7.9 is an exciting new version of the most popular open source database in the world, which is three times faster than MySQL 5.6, and also improves the availability, manageability and security. Some important

In the past few months, I have been thinking about and trying to implement the transaction function of lua script in Redis. Not many people understand my idea, so I will explain it to you through some history. MySQL and Postgres in 1998-2003, if you

Background We use MySQL to store all data of FriendFeed. The database has grown a lot with the growth of the user base. Now it has stored more than 250 million records and a pile of other data covering from comments and "likes" to friend lists. As data grows

In the past few months, I have written two articles, one about the dangerous debts related to InnoDB transaction history, and the other about the truth that MVCC may cause serious performance problems of MySQL. In this article, I will discuss a related topic - InnoDB transaction isolation mode, and

Last week, the fifth anniversary of Oracle's acquisition of MySQL passed. This also means that Oracle's notorious "10 Commitments for Five Year Term" on MySQL users in the European Commission has expired. Since I worked for another database technology, I seldom wrote blogs about MySQL related issues

Introduction I know that there are many articles and guides about master slave replication on the Internet. In master-slave replication, the host affects the slave. However, any changes in the slave database will not affect the master database. This article will help you achieve two-way replication. (That is, whether it is the master or the slave