I have some CSV files with location information for IPv4 and IPv6 so I have manually made 2 separate tables.
LOAD DATA LOCAL
INFILE 'IP2LOCATION-LITE-DB1.CSV'
INTO TABLE
...
Type: Posts; User: Vegan; Keyword(s):
I have some CSV files with location information for IPv4 and IPv6 so I have manually made 2 separate tables.
LOAD DATA LOCAL
INFILE 'IP2LOCATION-LITE-DB1.CSV'
INTO TABLE
...
Drupal is a content management system like WordPress but with a much smaller user base
might be better to add more memory to cope with the load
I use WordPress which will not render without JavaScript and PHP along with a database
<noscript>This site requires JavaScript to render</noscript>
sudo apt autoremove
add this to any web site header and it will reload the https version immediately
<script type="text/javascript">if (window.location.protocol != "https:") window.location.href = "https:" +...
That much RAM should make for an excellent cache for the web server in addition to the database.
Is the standard LAMP stack able to use available resources as needed or should I consider some...
I have used SAMBA for integration into NT Active Directory, look into that package, might be of some use
I assume this forum lives on a SSD, hate to see how thrashed a hard disk would be.
I was more interested in larger databases, say a NSA file on every person on the planet etc?
Perhaps a...
I run a bunch of web sites from one database, so I was can MySQL scale up with hundreds, thousands or even millions of articles before i should up a new server or 3
How about a swarm of databases?
do not forget to unpack the package
tar -xvf latest.tar.gz
16 GB is not going to get very far with plex. Especially with some other workloads besides it. I recommend doubling the RAM to 32GB or even more to allow each VM enough memory to breath.
i use wordpress and i learned from using my old IBM box that distribution upgrades often mangled the system
now that i am using cloud virtual machines when a new major LTS surfaces, i create a new...
get a small SSD for the system, then use the disks for storage and mount them under /JBOD
use another server for backups
raid is passe use JBOD and use a backup server for addition redundancy
bind is designed for programmatic configuration, use zpanel which can help setup a dot.com
logon with SSH
then run
sudo apt update
sudo apt full-upgrade
sudo lshw -class disk
this will show you all disks the OS can see
so far my Linux VM has worked well, then again why not. For now it's a database appliance.
looking at charts I see that MySQL and Linux can use most of the VM memory for a cache which is helpful...
https://ubuntuforums.org/showthread.php?t=2338968
server post problem and duped
1) make sure all management accounts are using 128-bit or better passwords
2) use a firewall if you are hinked up over hanging a server over the internet
windows 10 seems to work better that way
there is a new release of MySQL out, not much can be done for Apache or IIS. Both have issues mostly due to GET and POST messages back and forth.
i assume the ports are open on the firewall
I found it was easier to use a new virtual machine with a new LTS release, then migration would be easier and less likely to be a problem
I have experimented with release upgrades and they usually...