Endpoints can be utilized for many different things, such as managing databases remotely, hosting multiple project copies on a single instance, deploying apps straight from IDEs (for IIS), and more.<\/p>\n
Here, we will learn how to use the endpoints on the platform and explore some interesting use cases that you may experiment with.<\/p>\n
Endpoints Managing<\/h2>\n
The environment Settings menu, accessed by clicking on the corresponding button for a particular environment, contains the list of endpoints.<\/p>\n
After the tab has been launched, select the “Endpoints” menu option. You can now start organizing your list of mappings.<\/p>\n Click the “Add<\/strong>” button in the toolbar at the top to add a new endpoint, then fill out the form that displays the required data.<\/p>\n The Public port and Access URL will be configured automatically by the platform.<\/p>\n Click “Add<\/strong>” when you are done.<\/p>\n The real values for the Public port and Access URL are shown in this section. You can quickly copy a specific string by clicking on it and using these parameters for your actions.<\/p>\n Any existing endpoint can be readily edited or deleted if it is no longer required. Choose the desired connection from the list of endpoints, then click the Edit (or double-click on the line) or Remove (or click the button) in the tools pane above to accomplish this.<\/p>\n Depending on the option you choose, you’ll encounter the following:<\/p>\n When you select “Edit<\/strong>,” the Add Endpoint form and the Edit Endpoint form will appear. This is where you can change any setting that was previously discussed, with the exception of choosing a new Node, which is superfluous because you can just add a new endpoint to the chosen instance.<\/p>\n After making the necessary changes, simply click the “Apply<\/strong>” button located at the bottom of the frame.<\/p>\n For “Remove<\/strong>,” a special pop-up window will appear where you will need to confirm your decision.<\/p>\n Immediately after confirming, the respective endpoint will be deleted from the list.<\/p>\n Once the required mappings are established, you can use them for a variety of purposes. We’ll go over a few typical use cases for endpoints below to get you started.<\/p>\n For example, let’s look at a system that has a MySQL database and an Apache application server (you can make a setup like this by following this guide):<\/p>\n Now, let\u2019s learn how to use endpoints for:<\/p>\n You may easily access your database instance remotely by using endpoints, which eliminates the need for extra parameters like a Public IP. Let’s look at two straightforward methods for carrying out this function: using an external database client and the embedded OS terminal.<\/p>\n The standard approach uses the inbuilt terminal on your local computer, which saves additional installations and configurations and provides sufficient functionality for a simple connection setup. Just run just one command:<\/p>\n Here are the details for the command:<\/p>\n {host}<\/strong> – the Access URL of the endpoint without the port suffix (e.g., node30292-env-1425869.us.accuweb.cloud.com in our case) After executing the command, you’ll be prompted to enter the appropriate password for the database user (this password can also be found in the email mentioned earlier) to access your database.<\/p>\n That’s it! Now you can begin working with your database by running the necessary SQL queries.<\/p>\n Use a desktop database client if you require more sophisticated features or would rather manage your database data more conveniently. These clients come with a variety of capabilities to make your work easier and user-friendly graphical interfaces.<\/p>\n For instance, using the established endpoint, one of the most widely used database management programs, MySQL Workbench, can enable remote access to your database.<\/p>\n 1. Launch MySQL Workbench and click on the “New Connection<\/strong>” button.<\/p>\n 2. In the “Setup New Connection<\/strong>” window, enter the following information at the top:<\/p>\n Next, enter the required database details in the “Parameters<\/strong>” tab below:<\/p>\n Click “OK<\/strong>” to save the configuration.<\/p>\n 3. To establish the connection, double-click on the newly formed link and enter your password in the popup that displays (if it has not yet been stored).<\/p>\n If you want to avoid entering your password by hand every time you access your database, you can choose to store it in the keychain. Press “OK<\/strong>” to proceed.<\/p>\n 4. You will have established a successful connection to your database in a minute.<\/p>\n Excellent! Now you can begin managing your data using all the features offered by the comprehensive management client.<\/p>\n Similarly, you can connect to any other database server within the platform or perform tasks like backing up and restoring your data using dump files.<\/p>\n Apart from performing fundamental database management functions, endpoints offer the ability to incorporate an array of practical and captivating solutions for additional servers. We’ll look at one such useful possibility made possible by this feature below: how to use an application server as your production and development environments on the same machine at the same time (using our environment’s Apache instance as an example).<\/p>\n 1. Open the preferred unused private port on your Apache server and map the endpoint to it.<\/p>\n 2. Now, deploy your application twice to different contexts (for example, production and development).<\/p>\n 3. Next, configure Apache itself by clicking the “Config<\/a>” button next to the server and opening its main configuration file (located at `conf > httpd.conf`).<\/p>\n 4. Scroll down and insert the following line into the list of listened ports:<\/p>\n Here, replace the `{port}<\/strong>` parameter with the private port number you specified when adding the endpoint (in our case, we chose port 81).<\/p>\n 5. Next, navigate to the end of the file and create a duplicate of the VirtualHost section, ensuring to specify the same port number used in the previous step (in our case, port 81) within its heading.<\/p>\n Next, make sure that both virtual hosts’ DocumentRoot locations are updated to point to their respective projects (use “dev<\/strong>” for the custom section below and “prod<\/strong>” for the default).<\/p>\n 6. In order to make the changes take effect, save your work and restart the Apache server.<\/p>\n![\"Endpoint\"](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Endpoint.png\" "\\"Endpoint\\"")
<\/a><\/p>\n\n
Adding Endpoints<\/h2>\n
![\"Fill](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Fill-out-the-form.png\" "\\"Fill")
<\/a><\/p>\n\n
![\"Added](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Added-endpoint.png\" "\\"Added")
<\/a><\/p>\nEdit\/Remove Endpoint<\/h2>\n
![\"Edit\/remove](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Edit-remove-endpoint.png\" "\\"Edit\/remove")
<\/a><\/p>\n![\"Edit](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Edit-endpoint.png\" "\\"Edit")
<\/a><\/p>\n![\"Remove](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Remove-edited-endpoint.png\" "\\"Remove")
<\/a><\/p>\nEndpoints Use-Cases<\/h2>\n
![\"Use](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Use-cases.png\" "\\"Use")
<\/a><\/p>\n\n
Database Management<\/h2>\n
Connection via Terminal<\/h3>\n
\r\nmysql -h {host} -P {port} -u {user} -p<\/code><\/pre>\n![\"Connection](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Connection-via-terminal.png\" "\\"Connection")
<\/a><\/p>\n
\n{port}<\/strong> – the assigned public port number (e.g., 3306 in this example)
\n{user}<\/strong> – the database user name (which was sent to you via email during the environment creation; by default, it’s ‘root’ for all new MySQL servers)<\/p>\nConnection via Local Client<\/h3>\n
![\"MySQL](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/MySQL-Workbench-dashboard.png\" "\\"MySQL")
<\/a><\/p>\n\n
![\"Setup](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Setup-new-connection.png\" "\\"Setup")
<\/a><\/p>\n\n
![\"Store](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Store-password.png\" "\\"Store")
<\/a><\/p>\n![\"Successful](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Successful-Connection.png\" "\\"Successful")
<\/a><\/p>\nMultiple Development Stages at a Single App Server<\/h2>\n
![\"Private](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Private-port.png\" "\\"Private")
<\/a><\/p>\n![\"Deploy](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Deploy-environment.png\" "\\"Deploy")
<\/a><\/p>\n![\"httpd.conf\"](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/httpd.conf_-1.png\" "\\"httpd.conf\\"")
<\/a><\/p>\n\r\nListen 0.0.0.0:{port}<\/code><\/pre>\n![\"Listened](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Listened-ports.png\" "\\"Listened")
<\/a><\/p>\n![\"Create](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Create-duplicate-Virtual-host.png\" "\\"Create")
<\/a><\/p>\n
![\"Save](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Save-and-restart.png\" "\\"Save")
<\/a><\/p>\n![\"Open](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/Open-in-browser-8.png\" "\\"Open")
<\/a><\/p>\n