February 25, 2021 | Technical
Configure OVH IP Alias (IP Failover), for dedicated server with CentOS 8 and Squid Proxy

Because we provide an SEO product, we need to have multiple proxies and IPs. Because we have the expertise, we prefer to use our own and not shared proxies. But, with each Server Host, adding multiple IPs is different, and the instructions can be lacking. We bricked the machine more than once, trying to configure…
Read more
January 10, 2021 | Technical
Weird case of MySQL index that doesn’t function correctly

I created an index on one field, which the database was dumped for backup. The operation took 5 hours, which is odd for the amount of data (156 million rows) Queries not working as it should I ran the new code using the new index, and it seems very slow—doing a select on the index…
Read more
December 28, 2020 | Technical
Text summarization web service with NLP machine learning

I wanted to create a web service that takes the text and summarizes it using machine learning. There are several API services on the market, but I wanted to see how easy (or hard) it is to create my own. Step 1 – Use an existing NLP package There’s no need to reinvent the wheel,…
Read more
November 16, 2020 | Technical
Ten ways to increase MySQL query speed and decrease running speed

This is the second article in the MySQL optimization series. In this article, I’m going to cover how to speed up select speed , improve query performance and improve MySQL performance. Some of the concepts here will be similar to the ones in the previous article, so we will summarize them and not go over…
Read more
October 11, 2020 | Technical
Fast Insert Performance Custom Database

The heart of our SEO Analytics product is a fast insert performance custom database. In this blog post, we cover the reasons why we developed a custom database. In summary, MySQL/PostgreSQL insert performance degrades after 50-100GB of data from 14,000 inserts per second to 3,000 inserts per second. This limitation forces the utilization of clusters,…
Read more
September 18, 2020 | Content marketing, Marketing
5 Key SEO Services That Are Profitable For Websites

SEO allows small business owners to build fast, functional, and user-friendly websites that rank higher in search engines, allowing them to attract more interested potential buyers to their pages and ultimately improve conversion rates. SEO also helps create brand recognition for your company when search engine people are more inclined to support a product that…
Read more
September 5, 2020 | Content marketing
Search Intent: The Overlooked factor in Keyword Research

Do you want to skyrocket your rankings on Google? Outshine your competitors in your industry? Then doing content marketing that satisfies user intent is paramount. We cannot overemphasize how important it is to write content that answers the questions or satisfies the query intent that readers have. Over the years, Google has transformed its ranking…
Read more
September 4, 2020 | SEO
Adult keyword research for adult SEO

People were fascinated with sex and sexuality from the birth of human civilization. The figurine of Ain Sakhri Lovers is a figurine of a couple engaged in sexual activity dating to 9000 BCE, and you may be wondering what it got to do with adult keyword research, don’t worry, it will be clear soon. In…
Read more
August 27, 2020 | Technical
PHP SEO API – Using PHP to get SEO data

PHP was invented in 1994 for web applications, it’s very similar to C and C++, and it’s ranked #7 as in popularity of development language. It is used by sites such as Facebook, Slack and us, of course. Since it’s similar to C/C++, it was easy to learn and use. We have an SEO API…
Read more
August 21, 2020 | SEO
Big List of SEO tools and other tools that help with SEO

For me, SEO is fascinating, and it’s trying to figure out Google (or other search engines) algorithm. You see a black box, and via the inputs and outputs, you try to figure out what’s going on inside that black box. For that you need tools, of course, we have our tool, but any tool has…
Read more