Оптимизация запросов MySQL для ускорения скорости загрузки сайта

General information It is necessary to develop a simple minimalist web system, the main purpose of which is to maintain a client database, create appointments for visits, and automate the process of confirming visits via SMS, sending one-time links through the API from the service itself. The project is being developed in stages. In the first stage, it is necessary to implement only the basic functionality (MVP) so that the system can be used in real work. After launch and testing, it will gradually be expanded with new modules.Main functionality of the first stage User authorization; Client database; Creating and editing appointments; List of appointments (or a simple calendar); Switching between points of sale; Integration with the SMS operator via API; Sending SMS with any text or link for visit confirmation; Confirmation or cancellation of the visit by the client via a one-time link; Displaying the confirmation status directly next to the client's appointment. At the initial stage, instead of a full calendar, the use of a simple list of appointments by days is allowed. Each day should contain a chronological list of bookings indicating the time, client's name, service, employee, and confirmation status. Later, this list can be replaced with a full calendar without changing the system structure. The system must have the ability to switch between points of sale. Each point of sale has its own list of appointments (or calendar), but they all use a common client database.

Looking for an experienced Go developer to participate in a project. Confident knowledge of Go, experience in backend/API development, working with databases, and Git is required. Experience with Docker, Kubernetes, and microservices architecture will be a plus.

Copying the database and front for the database (Currently, the front is partially copied and some characteristics are incorrect. The parser filled the database with its own characteristics) Synchronizing the parser with the database and the characteristics of the database Fixing the bug in the parser agent Cropping photos proportionally to the watermark that comes from the parser Working with the buffer with the new database and tools with the objects of this database Fixing minor bugs: for example, text in pop-ups, or small issues on the front, bugs that appear during task execution Connecting a new storage for media storage Logs have stopped writing to the financial operations table, which affects the balance and tariff plan pages (payment of the tariff, account replenishment (successful/not)) Check the payment functionality again and then replace the test billing API from Monobank with the real one Refine access rights for the database administrator user There are currently hanging processes that load the server; this needs to be checked The logic of comments and notes is currently working incorrectly; it needs to be such that for the same object in 2 databases - comments are tied to each database, not to the object, the source of which is the object of this database (I can explain in more detail in private) Fix the sorting in the databases correctly (Currently from the first added to the last. It needs to be the opposite; the sorting functionality is created) Check and correct the accuracy of filters in the databases, possibly add restrictions on filtering with large data volumes

Hello. I am looking for a mentor in Linux. I have experience as a strong junior DevOps specialist, but Linux and Kubernetes are my weak points. While I have some project experience with Kubernetes, my interaction with Linux is very superficial. Creating something, adding, renaming, opening, etc. is clearly not enough. I need a mentor who can help me improve in this area. The main task is to ensure that the knowledge sticks in my head, possibly through some pet project, tasks, or something along those lines, rather than just "repeat after me." I have taken courses on my own, but they don't particularly "stick" in my head. Here is a rough list of what I think I need: - Linux/Unix systems — in-depth administration of operating systems, file systems, user and access rights management, processes and services (systemd), Bash scripting, logging, monitoring, security configuration, automation of administrative tasks; - Networking technologies — OSI model and TCP/IP stack, DNS, HTTP/HTTPS, SSL/TLS, SSH, VPN, load balancing, proxy servers, NAT, routing, network utilities (ping, traceroute, netstat, ss, tcpdump, curl), diagnosing and troubleshooting network issues; If Kubernetes can be added to this list, that would be great. Perhaps you can suggest something from your side. The format of the sessions, as I see it, is twice a week, meetings, discussions, consultations. More details can be your ideas and suggestions. Regarding the cost per hour or per month - please propose.

Für ein Kundenprojekt im Bereich Microsoft 365 Modern Workplace suchen wir erfahrene Freelancer (m/w/d) mit Schwerpunkt Microsoft Places. Im Mittelpunkt steht die Beratung, Konfiguration und Optimierung einer Microsoft-365-Umgebung zur Unterstützung moderner Hybrid-Workplace-Konzepte. Aufgaben Beratung bei der Einführung und dem Betrieb von Microsoft Places Analyse bestehender Microsoft-365-Umgebungen und Erarbeitung geeigneter Lösungskonzepte Konfiguration von Gebäuden, Stockwerken, Meetingräumen und Arbeitsplätzen Einrichtung und Optimierung von Desk-Booking- und Room-Booking-Szenarien Integration von Microsoft Places in Microsoft Teams, Outlook und Exchange Online Unterstützung bei Lizenzierungsfragen sowie Best-Practice-Empfehlungen Durchführung von Workshops und Know-how-Transfer für Anwender und IT-Teams Unterstützung bei Troubleshooting sowie im laufenden Betrieb Anforderungen Mehrjährige Erfahrung im Microsoft-365-Umfeld Praktische Erfahrung mit Microsoft Places Sehr gute Kenntnisse in Microsoft 365, Microsoft Teams, Exchange Online und Outlook Erfahrung mit Microsoft Entra ID (Azure AD) Kenntnisse moderner Hybrid-Workplace- und Modern-Work-Konzepte Wünschenswerte Kenntnisse Microsoft Teams Premium PowerShell für Microsoft-365-Administration Erfahrung mit Arbeitsplatz- und Raumbuchungslösungen Microsoft-Zertifizierungen im Bereich Modern Workplace oder Microsoft 365 Erfahrung in der Konzeption und Einführung moderner Arbeitsplatzkonzepte Start: asap Dauer: ca 3 Monate mit Option auf + Einsatzort: Remote / nach Absprache Auslastung: Nach Absprache Interesse? Da sich das Projekt aktuell in der Vorbereitungsphase befindet, möchten wir frühzeitig passende Experten kennenlernen. Bitte senden Sie uns an contract (AT) advergy de : CV Verfügbarkeit Stundensatz (Remote / Onsite) Dreizeiler, wieso Sie besonders gut auf das Projekt passen Vielen Dank und liebe Grüße Seda