(Vadim Tkachenko) I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some terms and take a look into theory.
Tag: Open Source
As restoring a dump table into the MySQL master – you better get some sleep
(Ilan Hazan) Restoring a dump table into the MySQL master server can lead to serious replication delay. The massive inserts commands cause the Master and slaves to use most of their resources for replication. As a result, replication lag may increase dramatically (linear to the table size).
How to store IP address value in integer datatype column.
(Krishna Chandra Prajapati) Most of the time, we use string datatype column like char or varchar to store ip address values. There is a way to store ip address value in numeric datatype column like unsigned interger.
MySQL replication for demanding users
(Giuseppe Maxia) I have been working with MySQL replication for quite a while. I have dealt with simple replication setups and I have experimented with complex ones. Five years ago I wrote an article about advanced MySQL replication, which was mostly a dream on what you could do with imagination and
MySQL: GROUP BY in UNION
(Quassnoi) I have a query where I have a custom developed UDF that is used to calculate whether or not certain points are within a polygon (first query in UNION) or circular (second query in UNION) shape.
Checked that MySQL backup log lately?
(Ronald Bradford) Running a MySQL backup and ensuring it completed successfully and backup files exist is not enough. In my B&R Quiz from Checked your MySQL recovery process recently? one important step is “Do you review your backup logs EVERY SINGLE day or have tested backup monitoring in place?”
MySQL: splitting aggregate queries
(Quassnoi) Victor asks: I have a table which I will call sale to protect the innocent:
MySQL Cluster online scaling
(Frazer Clement) Most people looking at a diagram showing the Cluster architecture soon want to know if the system can scale online. Api nodes such as MySQLD processes can be added online, and the storage capacity of existing data nodes can be increased online, but it was not always possible to add
MySQL HA (high availability) cookbook
(Shinguz) In the following article I have summarized some steps and hints to set-up a MySQL active/passive fail-over Cluster also sometimes called MySQL HA.
Adding NOT NULL constraint
(Michael McLaughlin) Somebody wanted to know if you could add a NOT NULL column constraint in MySQL. That’s a great question and the answer is yes. The following example shows you how to do it.