33
results
Andrew Fletcher
•
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state.
Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
•
When Solr is displaying results on the site, first step is to log in the server...
Andrew Fletcher
•
Having updated Solr, re-indexing wasn't working. The error in the logs...
Andrew Fletcher
•
On an Ubuntu 20.02 system with Nginx, you can utilize the following commands to...
Andrew Fletcher
•
Cleaning out or clearing data in Solr can be done in a few different ways,...
Andrew Fletcher
•
In an environment that is running
Ubuntu 20.02
Nginx
Solr
The default Nginx conf is located /etc/nginx/sites-available/ and contains something similar to:
server {
listen 80;
listen [::]:80;
server_name uat.oursite.com;
return 301 http://uat.oursite.com$request_uri;
}
server {
listen 80;
listen [::]:80;
listen 443 ssl;
ssl_certificate /etc/ssl/certs/Bundle.crt;
ssl_certificate_key /etc/ssl/private/MultidomainWildcard.key;
# Security...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
Whilst attempting to download the latest config.zip file for Solr, I was greeted...
Andrew Fletcher
•
Setting up the admin password.
Process:
1. Edit jetty.xml
To begin you...
Andrew Fletcher
•
Recently I have been investigating one of my Linux server's speed using the copy [cp] command. This came about due to 'upgrading' the server from Centos 6 to 7. Once I had migrated a domain, I ran the following command
yes | cp -rf 'stg/core' 'tmpdir'To my surprise, the first run of this command took over 38 minutes to complete. Crap! Yes a simple cp -a command is a very painful and slow process. Read more about the pain and times under Centos 7 in this...
Andrew Fletcher
•
In this article I'll walk through the steps I went through to install Solr on...
Andrew Fletcher
•
Looking to install Solr on your server? Not sure if it worth the...
Andrew Fletcher
•
The following the CKAN source install docs from start to finish including solr....
Andrew Fletcher
•
This code is from Drupal 9 back-end for a React front-end via REST API.
Working...