This page contains links and videos to information about MySQL database.
More on MySQL option files in the documentation here.
Tag: resources
Linux commands cheat sheet – nice, useful list of Linux commands and examples of how to use them.
Difference between Ubuntu apt-get autoclean, clean, autoremove commands – it is important to know the difference.
Cleaning up with apt-get – how to clean up with apt clean command
How To Upgrade Ubuntu Using Command Line?
Linux << heredoc syntax info – great link has lots of good linux information
Here is an excellent link to a shell command cheatsheet. This lists the most commonly used shell programs.
An A-Z Index of the Linux command line: bash + utilities. – about the same as the list of shell commands above.20 Shell Scripting Questions for Practice
Writing text to files from shell or shell scripts
Awesome linux software – a list/article about awesome useful linux programs
Understanding Shell Initialization Files and User Profiles in Linux
20 Shell Scripting Questions for Practiceuses opensshLinux visudo command
Linux /etc/profile file information
Understanding a little more about /etc/profile and /etc/bashrc20 Shell Scripting Questions for Practice
Why and How to Edit Your Sudoers File in Linux
LINUX DIRECTORY STRUCTURE:/ETC EXPLAINED
Tutorialspoint Linux tutorials and really good information.20 Shell Scripting Questions for Practice
How to Use Sudo and the Sudoers File – very good article
Ubuntu Environmental variables – Ubuntu Documentation link
How to prompt for input from user in a linux shell script – article 20 Shell Scripting Questions for Practicecovers two ways to prompt users for input in shell scripts.
How to prompt and read user input in a Bash shell script – A good example of a script that prompts users for input and uses it.
Bash read builtin command – this command is built into bash meaning available without installing etc.
Linux while loop explained with examples of alternate syntaxes
How to create a self signed SSL certificate
20 Shell Scripting Questions for Practice – article showing how to prompt users for input and how to answer prompts.
I always, always forget how to do this and it takes an hour of googling to figure this out again. Basically I often need to see not just what php modules are installed on my system, but also what can be installed.
For example you can see what is already installed and available to you on your current system you simply type
php -m
in your command line. This command will list all of what is installed currently on your system.
But that is not what I want and probably not what you want if you are reading this. What I want is to know what is available for installing, or better what are the exact names of the packages. For this information you need a different command.
sudo apt-cache search php7*This command searches the apt cache for packages that contain php7* the * is a wildcard meaning anything that looks like php7 such as php7.4-mysql. Try the command above and you will get a list of all of the php modules specifically for version 7.4. Not all modules will be listed. You can use another command to see all of the available php modules even if they don’t contain 7.4 in the name you can install them.
To see all php modules available use this command.
sudo apt-cache search php*Minus the 7 and it will return every last module that contains the word php.
Then to install anything you need you use a command like the following
sudo apt install php7.4-mysql php7.4-curl php7.4-json php7.4-cgi php7.4-xslAnd that is how you list and install php modules/extensions.
Pro-tip : add -y to the end of the apt install command so you don’t have to keep answering yes during the module installs
After you install the modules you need to restart the PHP service. To see all the services currently running in order to find your PHP service type
service --status-all
That will list all of your systems services. Find the name of your php installation and restart it with this line of code
service php7.4-fpm restart
Here is an interesting article about how apt-cache works on linux
Here is a link to some more resources about this topic.
AWS autoscaling lets you set up groups of EC2 instances which are controlled by a load balancer. The load balancer in turn makes sure your app has the correct number of EC2 instances running at all times. If your traffic is high it adds the maximum that you set. If traffic goes down it adjust to have the minimum EC2 instances that you set.
This system is great for startups who have no idea if their app will go viral or just flop. Often they just flop. But if you are lucky and it takes off you want to be able to handle the traffic so you don’t lose users.
Documentation link to AWS autoscaling
Running EC2 instances at Scale with autoscaling groups – small Ebook that walks through the whole process including using CodeDeploy.
Here is a list of Articles, videos and other information about Continuous integration, deployment etc. etc. Devops resources.
Understanding the CI/CD Pipeline: What It Is, Why It Matters
Set Up a CI/CD Pipeline on AWS
Continuous integration vs. continuous delivery vs. continuous deployment
This page is all about databases, their design, how they work, how they replicate etc.
Living without atomic clocks – article about the subject and cockroachdb
Exploiting a Natural Network Effect for Scalable,
Fine-grained Clock Synchronization – pdf link
Amazon time sync service – atomic clock ntp time syncing for AWS based systems.
STORING UTC IS NOT A SILVER BULLET – article about storing timestamps
Keeping Time With Amazon Time Sync Service
Setting the time for your Linux instance – amazon cloud
Economics of serverless – a great article if you are interested in going serverless.
PHP the Right way – a website/book full of the most useful information you will find about PHP
It is important to understand what namespaces are in PHP and how to use them. Otherwise you will be lost and have many pains.
Videos
Below is a series of great videos explaining PHP namespaces little by little in easy to find and digest chunks.\
PHP namespaces 1/10: What is a namespace in PHP?