Archives
- By thread 3809
-
By date
- June 2021 10
- July 2021 6
- August 2021 20
- September 2021 21
- October 2021 48
- November 2021 40
- December 2021 23
- January 2022 46
- February 2022 80
- March 2022 109
- April 2022 100
- May 2022 97
- June 2022 105
- July 2022 82
- August 2022 95
- September 2022 103
- October 2022 117
- November 2022 115
- December 2022 102
- January 2023 88
- February 2023 90
- March 2023 116
- April 2023 97
- May 2023 159
- June 2023 145
- July 2023 120
- August 2023 90
- September 2023 102
- October 2023 106
- November 2023 100
- December 2023 74
- January 2024 75
- February 2024 75
- March 2024 78
- April 2024 74
- May 2024 108
- June 2024 98
- July 2024 116
- August 2024 134
- September 2024 130
- October 2024 141
- November 2024 171
- December 2024 65
-
Finish signing in to Substack
Click here to sign in͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ Substack App
Here's the sign-in link you requested for the Substack app. It can only be used once and expires after 24 hours.
971© 2024 Substack Inc.
548 Market Street PMB 72296, San Francisco, CA 94104
by "Substack" <no-reply@substack.com> - 06:17 - 23 Oct 2024 -
RE: Cost Estimation/Takeoff Services
I have not heard from you. Please Let me know if we can be of any assistance in regards to providing Takeoff/Estimating services.
ThanksFrom: Eric Steven
Sent: Monday, October 21, 2024 12:12 PM
Subject: RE: Cost Estimation/Takeoff ServicesI'm sure you're busy because I didn't hear anything back from you. I’d appreciate a response to my original email below.
Thanks
From: Eric Steven
Sent: Thursday, October 17, 2024 12:51 PM
Subject: RE: Cost Estimation/Takeoff ServicesJust making sure you saw my original email below regarding our Cost Estimation & Takeoff services.
From: Eric Steven
Sent: Tuesday, October 15, 2024 3:16 PM
Subject: Cost Estimation/Takeoff ServicesHi,
Get accurate and efficient construction project estimates with JU Estimating. Our experienced estimators provide expert solutions for all types of residential and commercial projects. Our pricing strategy is based on a per-project basis and we work with our clients to provide customized solutions that fit their specific needs and budget.
Contact us today to learn more about how we can give you the edge you need to succeed in bidding on projects.
Best Regards,
Eric Steven | (703) 721-8864
JU Estimating LLC
8855 Peregrine Heights Rd Apt 201 Manassas, VA 20111
If you no longer wish to receive emails from us, please respond with unsubscribe. We apologize if this email was not relevant to your needs.
by "Eric Steven" <eric@ju-takeoff.co> - 02:15 - 23 Oct 2024 -
projects & contracts
Complement of the day.
We are inviting your company for vendor registration and partnership 2024/2025 projects & contracts.
We are looking for reliable and innovative Suppliers, Contractors, Agents, Manufacturers, Distributors, Service Providers, Consultants, Travel Agents, General Trading Companies, Engineering Companies, Freight/transportation companies and others to tender for contracts.
Kindly indicate your interest by requesting for a vendor application form and registration terms & conditions document.
We appreciate your interest in this invitation, and look forward to your early reply.
Thanks & Regards,
Mr. Akbhar Essa,
Snr. Procurement Coordinator.
Mandarin Oriental Hotel, Muscat.
by "Mandarin Oriental Hotel, Muscat." <vendors@mandarinorientaltenderom.com> - 12:13 - 23 Oct 2024 -
2024 Observability Forecast Report is here!
New Relic
The Report highlights key growth areas, challenges, and external trends influencing observability investments.
Dive into the Global Data
The 2024 Observability Forecast reveals the state of observability, identifying key areas of growth and opportunity, while uncovering what’s driving adoption and investment strategies.
Key findings from the forecast include:- AI adoption is currently at 29% globally, but is expected to surge, with 41% of companies planning to implement AI monitoring, and 39% adopting AIOps capabilities over the next year.
- 37% of organizations manage siloed telemetry data while continuing to grapple with tool sprawl, compared to 38% that have more unified data.
- 46% said observability improved their operations most by enabling real-time data insights from a single dashboard.
Discover insights from 1,700 technology professionals to help shape your strategic decisions for the coming year.Read Report View in browser
This email was sent to info@learn.odoo.com. Update your email preferences.For information about our privacy practices, see our Privacy Policy.
Need to contact New Relic? You can chat or call us at +44 20 3859 9190
Strand Bridge House, 138-142 Strand, London WC2R 1HH
© 2024 New Relic, Inc. All rights reserved. New Relic logo are trademarks of New Relic, Inc.
by "New Relic" <emeamarketing@newrelic.com> - 06:06 - 23 Oct 2024 -
A full year of wins! 🎉
A full year of wins! 🎉
Your monthly global update from Remote has landed, check it out!Featured news
A full year of wins! 🎉
Remote is #1 Global Employment Platform for the 4th quarter in a row! We’re also #1 in:
- Freelancer Management Systems (Europe)
- Multi-Country Payroll (Europe)
- 31 categories total - check out our G2's Fall report 2024 rankings! 📊
This is a huge testament to the hard work of our team and the love from our customers. Huge thanks to both 💜
Product updates
Track time with Remote ⏰
Employees and contractors can now use Remote to clock in and out, simplifying their experience and ensuring working hours are accurately reflected on their timesheets. This feature is available on the web platform and coming soon to the mobile app!
Automate HR notifications with the Remote Workflow Engine beta ✨
Did you know admins can now configure workflows that will automatically notify team members by email and/or Slack when common HR triggers occur?
Featured webinar
Masterclass: How to Efficiently Manage Global Freelancers
Final call: Join our masterclass for practical strategies to manage freelance contractors across borders. HR, Finance, and Operations leaders will discover how to streamline onboarding, simplify invoicing, and ensure fast, compliant payments—while reducing admin headaches.
Upcoming events
📍🇵🇹 See you at Web Summit Lisbon this November
Meet the Remote team at Web Summit Lisbon, you can find us on booth 0402-07, Pavilion 3. Or join us for one of our exclusive gatherings: Elevating Early-Stage Startups or the Exclusive Growth Dinner. Spaces are limited, sign up early to avoid disappointment.
📍🇫🇮 In Helsinki for Slush? We’d love to meet you!
Remote is back in Helsinki this November for Slush. Stop by booth 7A10, and say hei to the team.
Meet the Remote team at Slush, Helsinki📍🇩🇪 Meet us in Berlin on November 7th
Join us as we bring together four of Germany’s leading tech HR experts to share their experiences, challenges, and successes in closing the gender pay gap and improving diversity within their organizations.
Must read
Contractor Management Software: Build or Buy? 🤔
If you’re managing a large team of contractors, you might consider building an in-house custom solution vs choosing a ready-made solution. Our SVP of Contractor Management, Pedro Barros, shares valuable insights on the pros and cons of building vs. buying a CMS.
Need Help?
We're Here for You!Search over 1,500 articles, visit our Help Center.
Live Chat for direct help inside your Remote dashboard.
Prefer a personal touch? Schedule a call with an expert.
You received this email because you are subscribed to
News & Offers from Remote Europe Holding B.V
Update your email preferences to choose the types of emails you receive.
Unsubscribe from all future emailsRemote Europe Holding B.V
Copyright © 2024 Remote Europe Holding B.V All rights reserved.
Kraijenhoffstraat 137A 1018RG Amsterdam The Netherlands
by "Remote" <hello@remote-comms.com> - 02:04 - 23 Oct 2024 -
very special offer
Hi,,Check my website and guide how shift these websites to odooshttps://www.bigwritehook.co.uk/ https://blogarcyart.co.uk https://dotsnel.com/ https://10for10.uk/ https://www.everrisebrokers.com/ https://quellpress.com/ https://bruitly.com/ https://dottrusty.com/ https://trueqube.com/ https://www.kawatan.net/ https://the10co.com/ https://distinctionbetween.com/ https://juniorh.net/
by "Shahid Maqsood" <smaqsood1988@gmail.com> - 01:31 - 23 Oct 2024 -
15 charts about generative AI’s future
Only McKinsey Perspectives
A visual McKinsey Explainer
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:06 - 23 Oct 2024 -
How to succeed as a data-driven enterprise
Intersection
Get your briefing The proliferation of generative AI and other technologies offers great promise for organizations—if they can manage their data. For many companies, that isn’t easy, say McKinsey senior partners Holger Harreis and Kayvaun Rowshankish and coauthors. To learn how to excel as a truly data-driven organization, check out the latest edition of the Five Fifty.
We are celebrating the 60th birthday of McKinsey Quarterly with a yearlong campaign featuring four issues on major themes related to the future of business and society, as well as related interactives, collections from the magazine’s archives, and more. Our first issue, on the future of technology, launches later this week. Sign up for the McKinsey Quarterly alert list to be notified as soon as new Quarterly content is published.
Share these insights
Did you enjoy this newsletter? Forward it to colleagues and friends so they can subscribe too. Was this issue forwarded to you? Sign up for it and sample our 40+ other free email subscriptions here.
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to our McKinsey Quarterly Five Fifty alert list.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey Quarterly Five Fifty" <publishing@email.mckinsey.com> - 05:34 - 22 Oct 2024 -
Uber Reduces Database Lock Time by 94% with Major MySQL Fleet Upgrade
Uber Reduces Database Lock Time by 94% with Major MySQL Fleet Upgrade
The Future of AI, LLMs, and Observability on Google Cloud (Sponsored)͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ Forwarded this email? Subscribe here for moreThe Future of AI, LLMs, and Observability on Google Cloud (Sponsored)
Discover 7 key insights for technical leaders from Google’s Director of AI, Dr. Ali Arsanjani, and Datadog’s VP of Engineering, Sajid Mehmood. This ebook provides actionable insights around questions such as:
How can organizations better approach AI and LLMs?
How can you build customer confidence in the output of LLMs and LLM-based applications?
How should you evolve your tooling as your maturity with LLMs grows?
Disclaimer: The details in this post have been derived from the Uber Engineering Blog. All credit for the technical details goes to the Uber engineering team. The links to the original articles are present in the references section at the end of the post. We’ve attempted to analyze the details and provide our input about them. If you find any inaccuracies or omissions, please leave a comment, and we will do our best to fix them.
MySQL serves as the backbone for Uber’s vast and complex operations. For many years, Uber relied upon MySQL version 5.7 to support business-critical features.
However, in 2023, they decided to upgrade from MySQL version 5.7 to version 8.
In this post, we’ll look at the need for this and the challenges Uber faced in such a large-scale upgrade. We will also investigate the solutions Uber used to achieve the upgrade without violating the Service-Level Objective (SLO).
The Need for the Upgrade
The decision to upgrade Uber's MySQL infrastructure from version 5.7 to 8.0 was driven by several critical factors.
First, MySQL 5.7 was reaching its end-of-life, meaning it would no longer receive security updates or bug fixes, leaving Uber's infrastructure vulnerable to potential security risks and operational instability. Upgrading to MySQL 8.0 mitigated these risks by ensuring ongoing support and security improvements.
Additionally, MySQL 8.0 offered significant performance and concurrency enhancements such as:
Improved indexing and resource utilization: This led to faster query execution and better concurrency handling, crucial for Uber’s high-traffic operations.
Enhanced performance: These optimizations reduced latency and improved the overall user experience by supporting smoother transaction processing.
Beyond performance, MySQL 8.0 introduced several new functionalities such as:
Window functions and enhanced JSON handling: These improvements allowed more efficient data querying and manipulation.
Improved spatial data capabilities: This enabled more advanced processing of geographic data which is important for location-based services.
"Dual passwords" for smoother password rotations: This feature allowed Uber to rotate passwords during security incidents without causing service disruptions, enhancing security protocols.
Instant ADD Column functionality: This feature allowed schema changes to be made with minimal downtime, streamlining Uber's database management and ensuring high service availability.
Overall, these performance, security, and operational benefits made the transition to MySQL 8.0 a critical move for Uber's data infrastructure.
Workshop: Implementing Clean Architecture in Next.js (Sponsored)
Lazar Nikolov and Sarah Guthals are hosting a free workshop on Implementing Clean Architecture in Next.js. It will dive deep into what clean architecture *actually* is, what problems it solves, and how to implement it in a Next.js application with Sentry.
The Scale of The Upgrade
Uber’s MySQL infrastructure is vast, operating at a scale that supports its global platform operations. Here are some stats about the overall scale that shows the critical role of MySQL in Uber’s services:
The system is composed of over 2,100 MySQL clusters.
The clusters are spread across 19 production zones in different regions.
More than 16,000 nodes manage the massive volumes of data.
These clusters handle petabytes of data and serve around 3 million queries per second.
Also, to ensure high availability and data redundancy, Uber employs a primary-secondary replication architecture. It works as follows:
Primary node: Responsible for handling all write traffic in each cluster.
Secondary nodes: Replicate the data asynchronously from the primary node, ensuring redundancy and fault tolerance. These secondary nodes are distributed across multiple data centers to enhance data availability and support seamless failover in case of primary node failure.
Challenges with the Upgrade
Several challenges had to be addressed during the upgrade of Uber’s MySQL fleet from version 5.7 to 8.0. Some of the major ones are as follows:
Manual upgrades were not possible due to the sheer scale of Uber’s MySQL infrastructure. It was important to have a detailed upgrade strategy that could be executed efficiently across diverse environments.
Uber’s platform operates globally, meaning that downtime could significantly impact services. Maintaining SLOs throughout the upgrade was crucial.
It was important to ensure compatibility with Uber’s existing applications and services. Since upgrading from MySQL 5.7 to 8.0 introduced new features and syntax changes that could potentially break existing queries, extensive testing was needed.
Uber conducted thorough regression checks and validation tests to ensure all existing systems and applications continued to work seamlessly with the upgraded database.
This process included testing in a staging environment before making production upgrades. By validating every aspect of the system, Uber was able to mitigate the risk of any unexpected issues after the upgrade.
Finally, Uber implemented automated rollback mechanisms to safeguard the upgrade process.
In the event of any failures or compatibility issues during the upgrade, these mechanisms could automatically revert the changes, ensuring the maintenance of service continuity and data integrity.
For instance, in the pre-maintenance stage, where the new MySQL 8.0 nodes operated as replicas, if performance issues or system degradation were detected, Uber could instantly roll back to MySQL 5.7 without any risk of data loss. The rollback capability was crucial for addressing any latency, resource consumption, or service degradation issues, allowing Uber to revert to a stable state until the issues were resolved.
However, once a MySQL 8.0 node was promoted to the primary status, rolling back to MySQL 5.7 became more complex because replication between the new and old versions was no longer possible. In other words, Uber had to ensure everything was functioning correctly before promoting the new nodes to avoid irreversible complications.
Upgrade Strategy
When upgrading its massive MySQL infrastructure from version 5.7 to 8.0, Uber had two possible strategies to choose from: side-by-side upgrade and in-place upgrade.
In-Place Upgrade
An in-place upgrade involves directly upgrading the existing MySQL installation to the new version (MySQL 8.0) on the same nodes.
The process typically requires stopping the MySQL service, upgrading the software, and restarting it. While this method can be simpler in terms of setup, it also comes with significant drawbacks:
Extended downtime: Since the MySQL service must be stopped during the upgrade, this approach leads to a noticeable period of downtime. For a global platform like Uber, even a brief service interruption can have a major impact.
Limited rollback: If issues arise after the upgrade, rolling back to the previous version can be difficult. In-place upgrades provide less flexibility in case of failure, making it harder to revert to a stable state.
Risk of data loss or degradation: Any problems encountered during the in-place upgrade might lead to data loss or degradation of system performance, with fewer opportunities to recover without downtime.
Due to these limitations, Uber decided against the in-place upgrade method.
Side-by-Side Upgrade
Uber chose a side-by-side upgrade approach, which allowed for a smoother and less risky transition.
See the diagram below:
In this method, the new MySQL 8.0 nodes were set up and operated alongside the existing MySQL 5.7 nodes.
This approach was more suitable for Uber’s infrastructure due to the following reasons:
Minimal downtime: With the side-by-side method, the old MySQL 5.7 nodes remained operational while the new MySQL 8.0 nodes were being deployed. This allowed Uber to gradually transfer traffic from the old nodes to the new ones, avoiding significant service disruptions.
Easier rollback: If any issues occurred with the new MySQL 8.0 nodes, Uber could easily revert to the old MySQL 5.7 nodes. Since the old nodes were still running, the rollback process was simple and risk-free, reducing the chance of data loss or service degradation.
Thorough testing: Running the two versions side-by-side allowed Uber to fully test the new MySQL 8.0 nodes with real production traffic before completing the migration. This ensured that problems were detected and addressed before fully switching to the new version.
Scaling the Upgrade Process with Automation
To manage the complexity of upgrading such a large infrastructure, Uber implemented an automated workflow.
With more than 2,100 clusters and over 16,000 nodes, upgrading each node manually was an impossible task. Automation ensured that the process was scalable, efficient, and free from human error.
Two main aspects of this automation are:
Monitoring and alerts: The system was designed to automatically monitor each stage of the upgrade, notifying the engineering team if any problems occurred. This allowed Uber to handle the upgrade across thousands of nodes without risking service stability.
Risk mitigation: The automated workflows minimized the risk of human error and allowed for quick intervention if any issues were detected during the upgrade process.
Four-Stage Upgrade Process for MySQL
Uber’s MySQL upgrade from version 5.7 to 8.0 was carefully planned and executed in a four-stage process.
This approach ensured minimal service disruption and allowed Uber to transition its massive data infrastructure safely. Let’s break down the four stages in simple terms:
1. Pre-Maintenance Stage
In the pre-maintenance stage, new MySQL 8.0 nodes were added as replicas to the existing MySQL 5.7 clusters. A "node" here is a server running a MySQL instance.
By adding these MySQL 8.0 nodes as replicas, they could work alongside the old 5.7 nodes without disrupting any operations.
This setup ensured that the old system (MySQL 5.7) continued functioning normally while the new system (MySQL 8.0) was being integrated, allowing Uber to keep everything running smoothly.
2. System Monitoring (Soak Period)
After setting up the MySQL 8.0 nodes, Uber entered the system monitoring stage, also known as the "soak period." This stage lasted for about a week and was crucial for testing the new system under real-world conditions.
During this time, Uber monitored the MySQL 8.0 nodes as they handled real production traffic (read operations), checking for issues such as slow performance, errors, or increased resource usage.
This period was essential to detect potential problems before making the final switch to MySQL 8.0.
3. Maintenance Stage
Once the soak period confirmed that everything was working smoothly, Uber moved to the maintenance stage.
In this phase, the MySQL 8.0 node was promoted to primary status, meaning it now handled all write operations and became the main database for that cluster.
This promotion marked the point where MySQL 8.0 officially became the main database, while the MySQL 5.7 nodes were demoted or turned off for write traffic.
4. Post-Maintenance Stage
Finally, in the post-maintenance stage, Uber removed all the old MySQL 5.7 nodes that were no longer needed.
At this point, the new MySQL 8.0 nodes were fully operational, and all traffic (both read and write) was being handled by the new system.
By completing this step, Uber successfully transitioned to the new version, ensuring that the system was upgraded without any data loss or significant service disruptions.
Issues During Upgrade
During the upgrade of Uber’s MySQL infrastructure to version 8.0, several issues were encountered that required careful handling and technical solutions to ensure the system continued to run smoothly.
Here’s a breakdown of the key problems and how they were addressed:
Query Execution Plan Changes
One of the major issues that Uber faced was related to changes in the query execution plans in MySQL 8.0.
A query execution plan is the path the database system uses to retrieve data. In some clusters, MySQL 8.0 chose different paths compared to version 5.7, leading to increased latencies (delays) and higher resource consumption.
These changes could slow down certain operations, affecting the performance of dashboards and other tools that relied on quick access to data. For instance, clusters powering key dashboards at Uber experienced noticeable slowdowns.
Uber worked with Percona, a database consulting company, to develop a patch that optimized the execution plans for the affected clusters. By applying this patch, Uber was able to restore performance and reduce resource consumption, bringing the system back to optimal operation.
Unsupported Queries and Configurations
MySQL 8.0 introduced new syntax rules and stricter configurations, which caused some queries that worked in MySQL 5.7 to fail after the upgrade.
Specifically, some clusters didn’t have the STRICT_TRANS_TABLES SQL mode enabled, which is a default setting in MySQL 8.0. This mode enforces stricter rules on handling invalid or missing data.
Uber had to carefully adjust configurations and rewrite certain queries to align with MySQL 8.0’s new syntax and rules. For example, they enabled the STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY modes, which made the system more robust but required changes to some of the legacy queries and applications.
Collation and Character Set Changes
MySQL 8.0 also brought changes to the default character set and collation. The character set controls how text is stored, and the collation determines how text is compared.
In MySQL 5.7, Uber had been using the utf8mb4_unicode_520_ci collation, but MySQL 8.0 switched to the new utf8mb4_0900_ai_ci collation.
This change in the default character set and collation caused issues with sorting and comparing text data across different clusters, particularly when dealing with different languages or special characters. The system needed consistency in collation settings to function correctly, but this shift created mismatches.
Uber had to align the collation settings across its systems to ensure all nodes used the same character set and collation. This required detailed configuration changes and testing to ensure compatibility and proper sorting behavior across all clusters.
Client Library Incompatibility
Many client libraries that Uber used to connect to the MySQL database were not initially compatible with MySQL 8.0. Client libraries are essential for applications to communicate with the database, and outdated versions of these libraries did not support some of the new features and functions introduced in MySQL 8.0.
Without updating these libraries, Uber’s applications couldn’t fully utilize the benefits of MySQL 8.0, and some applications experienced failures or errors when trying to connect to the upgraded database.
Uber upgraded these client libraries across its systems. This process involved rigorous testing in a staging environment to ensure that all client libraries worked properly with MySQL 8.0 before the full upgrade. Once the testing was complete, the libraries were deployed in production, ensuring a smooth transition.
Improvements After The Upgrade
The upgrade to MySQL 8.0 brought significant performance improvements to Uber’s infrastructure, both on the server side and client side.
Let’s look at both.
Server-Side Performance:
29% improvement in p99 latency for inserts: At high concurrency levels (i.e., when many operations were happening simultaneously), the latency for insert operations improved by 29%, allowing Uber to handle more data input efficiently.
33% improvement in read latency: Queries that required reading data from the database saw a 33% reduction in latency, meaning data retrieval became much faster.
47% improvement in update latency: Similarly, update operations were executed 47% faster, enhancing the overall responsiveness of the system under heavy loads.
Source: Uber Engineering Blog Client-Side Performance:
94% reduction in database lock time: The upgrade dramatically reduced the time the system spent waiting for locks on database resources, leading to more efficient transaction processing.
78% reduction in query time for certain queries: Some queries saw a significant 78% reduction in execution time, allowing Uber’s applications to run more smoothly and respond quicker to user requests.
Conclusion
Through careful planning, automation, and a phased rollout strategy, Uber successfully transitioned its vast data systems with minimal downtime and disruption.
The new version brought significant benefits in terms of performance, security, and functionality, helping Uber improve its operational efficiency and user experience.
Some key learnings are as follows:
Automation is Critical: Given the scale of Uber’s MySQL infrastructure, automating the upgrade process was essential to reduce human error and ensure efficiency.
Thorough Testing: Extensive testing, including regression checks and system validation, was necessary to identify and resolve issues before the full production rollout, ensuring that existing applications remained compatible.
Rollback Mechanisms: Building automated rollback mechanisms proved vital to maintain service continuity and prevent data loss in case of unexpected issues during the upgrade.
Collaboration: Working with partners like Percona helped Uber quickly resolve specific issues, such as query execution plan changes and performance bottlenecks.
References:
SPONSOR US
Get your product in front of more than 1,000,000 tech professionals.
Our newsletter puts your products and services directly in front of an audience that matters - hundreds of thousands of engineering leaders and senior engineers - who have influence over significant tech decisions and big purchases.
Space Fills Up Fast - Reserve Today
Ad spots typically sell out about 4 weeks in advance. To ensure your ad reaches this influential audience, reserve your space now by emailing sponsorship@bytebytego.com
Like Comment Restack © 2024 ByteByteGo
548 Market Street PMB 72296, San Francisco, CA 94104
Unsubscribe
by "ByteByteGo" <bytebytego@substack.com> - 11:35 - 22 Oct 2024 -
API Performance Testing Tool
Hi,We have published A Survey on API Performance Testing Tool. Our survey will give you updated view of the total market size and market competition environment, market trend and market share, etc., to help you generate strategic ideas of your business.The following manufacturers are covered:TelerikSmartBearPostmanApacheGatlingNeotysKatalonInflectraACCELQTricentis……Segment by TypeLoad Testing ToolsScalability Testing ToolsOthersSegment by ApplicationE-commerceFinanceOthersIf you are interested in our survey, please contact victoria@vicmarketresearch.com. We would be happy to share the sample for your reference.Maybe it will be helpful to the Related Departments or the person in charge of your company. We would be grateful if you could forward it.
by "Diana" <diana@vicglobalintelligence.com> - 04:37 - 22 Oct 2024 -
What physical realities could slow the world’s progress toward net zero?
Only McKinsey Perspectives
A new McKinsey Podcast episode Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Only McKinsey Perspectives. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
•
A vast physical system. To transform the global energy system successfully, focusing on the transition’s physical challenges will be critical, senior partner Humayun Tai and partner Mekala Krishnan explain on a recent episode of The McKinsey Podcast. “We’re talking about 60,000 power plants, a billion vehicles, and many billion tons of materials like steel and cement produced around the world,” Krishnan says. “Today’s energy system is . . . an eye-wateringly vast, complex, and interlinked physical entity.”
•
Tough challenges. To determine what it will take to reach net-zero targets by 2050, Tai, Krishnan, and their coauthors of the McKinsey Global Institute report The hard stuff identified 25 physical challenges that the world needs to overcome to accelerate progress. Twelve of these, such as managing renewables variability and decarbonizing industries, are particularly tough—in part because these challenges depend on solving other difficult ones, calling for a systemic approach. Understand the energy transition’s physical realities.
—Edited by Belinda Yu, editor, Atlanta
This email contains information about McKinsey's research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Only McKinsey Perspectives newsletter, formerly known as Only McKinsey.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:06 - 22 Oct 2024 -
Your essential guide to cloud ERP
Your essential guide to cloud ERP
What cloud ERP experts say about moving growing businesses off-prem and onto the cloud.͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ [ SAP ][ Is there an easier way to the cloud? Probably not ] [[https://event.on24.com/eventRegistration/EventLobbyServlet?target=reg20.jsp&eventid=4476652&sessionid=1&key=0BD7250F4B23B93FFD46EDD5D9A22EED&groupId=5237641&partnerref=website&sourcepage=register&pttId=6796&InteractionType=ICP&LID=aSwfLffmjhWdm4XU8yFDASZJL47yEgbs%2Bhn0rwGZdwXuuziKIQ%3D%3D]]Transitioning finance to a new ERP solution is a major move for any business. But what if the solution was:
- Ready to run, right out of the box
- Designed with built-in, end-to-end best practices
- Simple and collaborative with a modern user experience
- Powered by AI
Yes, it’s still a significant move, but in this webcast series, experts from GROW with SAP and the Business Partnering Institute will share key best practice capabilities that demonstrate why your next move is critical.
It’s a tour of the cloud you can’t afford to miss.
Give me the tourGive me the tour [[https://event.on24.com/eventRegistration/EventLobbyServlet?target=reg20.jsp&eventid=4476652&sessionid=1&key=0BD7250F4B23B93FFD46EDD5D9A22EED&groupId=5237641&partnerref=website&sourcepage=register&pttId=6796&InteractionType=ICP&LID=aSwfLffmjhWdm4XU8yFDASZJL47yEgbs%2Bhn0rwGZdwXuuziKIQ%3D%3D]]If you need a guide to growth in the cloud, contact us.
[ Contact ]See our complete list of local country numbers
SAP ( Legal Disclosure | SAP )
This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.
You are receiving this e-mail for one or more of the following reasons: you are an SAP customer, you were an SAP customer, SAP was asked to contact you by one of your colleagues, you expressed interest in one or more of our products or services, or you participated in or expressed interest to participate in a webinar, seminar, or event. SAP Privacy Statement
This e-mail was sent to info@learn.odoo.com on behalf of the SAP Group with which you have a business relationship. If you would like to have more information about your Data Controller(s) please click here to contact webmaster@sap.com.
This e-mail was sent to you by SAP and provides information on SAP’s products and services that may be of interest to you. If you received this e-mail in error, or if you no longer wish to receive communications from the SAP Group of companies, you can unsubscribe here.
To ensure you continue to receive SAP related information properly, please add sap@mail.sap.com to your address book or safe senders list.
by "SAP" <sap@mail.sap.com> - 10:23 - 21 Oct 2024 -
BT-036016002U #RFQ 014-010-02024 // FOR Bita Industrial Supply
Dear Sir/Madam,
It is a pleasure to inform you that we have received an inquiry for attached items from a client.It would be appreciated if you provide us the technical & commercial offer for requested item,
kindly include following information in your quotation :- Reference Number and Date of the Offer - Validity
- Technical documents
- Manufacture & Country of Origin
- Delivery Time
- Delivery Term
- Estimated Gross Weight & Dimension
- Customs Tariff No
Your timely reply is highly appreciated.
Best Regards,
N. Nazari
Commercial Director
Bita Industrial SupplyEmail:
Mobile:
+989183878850
Telephone:
+982188787870
Address:
Unit.32,No.14, West Taban, Nelson Mandela St., Tehran
by Info@bita-tamin.com - 04:56 - 21 Oct 2024 -
RE: Cost Estimation/Takeoff Services
I'm sure you're busy because I didn't hear anything back from you. I’d appreciate a response to my original email below.
Thanks
From: Eric Steven
Sent: Thursday, October 17, 2024 12:51 PM
Subject: RE: Cost Estimation/Takeoff ServicesJust making sure you saw my original email below regarding our Cost Estimation & Takeoff services.
From: Eric Steven
Sent: Tuesday, October 15, 2024 3:16 PM
Subject: Cost Estimation/Takeoff ServicesHi,
Get accurate and efficient construction project estimates with JU Estimating. Our experienced estimators provide expert solutions for all types of residential and commercial projects. Our pricing strategy is based on a per-project basis and we work with our clients to provide customized solutions that fit their specific needs and budget.
Contact us today to learn more about how we can give you the edge you need to succeed in bidding on projects.
Best Regards,
Eric Steven | (703) 721-8864
JU Estimating LLC
8855 Peregrine Heights Rd Apt 201 Manassas, VA 20111
If you no longer wish to receive emails from us, please respond with unsubscribe. We apologize if this email was not relevant to your needs.
by "Eric Steven" <eric@ju-takeoff.co> - 02:11 - 21 Oct 2024 -
Request for Quotation
Good Day,I hope this email finds you well. On behalf of Ultrafilter SAS, France. We have gone through your Website, Weare interested in buying your product.Kindly send your below details to help us be more familiar with yourcompany's recent changes:1. Your company profiles?2. Product catalogs?(Latest)3.MOQ?(Minimum Order Quantity)4. Price list?(If available)5. Payment TermsAlso confirm your company's mode of shipment.Waiting for your prompt feedback in order to give you our specifications.We hope to hear from you soon.
by "Sonia Martin" <sales_export_71@mail.ru> - 06:08 - 21 Oct 2024 -
RE: The Business Show UK 2024
Good day,
I hope you received my previous email? Any thoughts from you will be greatly appreciated.
Regards,
Gina
From: Gina Bernard
Sent: 18 October 2024 15:25
Subject: The Business Show UK 2024Hi,
Would you be interested in The Business Show UK 2024 Attendees list.
Data fields: Company names, Contact details, email address, number, etc.
Regards,
Gina
Event Attendees Specialist
If you don’t want to receive any more emails from us REPLY “OPT OUT”
by "Gina Bernard" <gina.bernard@serveitoutreach.shop> - 04:54 - 21 Oct 2024 -
Nurturing employees’ mental health: A leader’s guide
Leading Off
Put your mind to it Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Leading Off. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
Mental health is a key element of well-being in the workplace and an increasingly important area of focus for business leaders. Mental health challenges such as anxiety and depression can lead to burnout, which affects an average of one in four employees across the globe. More companies are offering benefits such as therapy, yoga, and meditation app subscriptions to help employees improve their mental health and overall wellness. With the UN designating October as World Mental Health Month, we look at why it’s critical for leaders to support their employees’ mental health and how they can do so.
One of the leading causes of employee burnout and mental health strain is a toxic workplace. McKinsey partner Kana Enomoto says leaders should carefully examine the workplace environment they are creating and provide solutions to help employees feel supported, respected, and included. A good place to start is by articulating a vision and mission that inspires their employees—particularly younger workers, who experience poor mental health at a much higher rate. Gen Z employees “believe they are meant to achieve something, to do something big and important, and when they don’t have that, they often feel an emptiness,” Enomoto says. “This is an opportunity for C-suite leaders to support all their employees in feeling that connection to purpose and meaning in the workplace.” What’s more, improving well-being and overall culture at work makes good business sense. Companies that prioritize their employees’ mental health achieve higher productivity and profitability than others do, according to McKinsey studies.
That’s how much economic value can be created by improving employee health and well-being, according to the McKinsey Health Institute. Such an increase would be the equivalent of raising global GDP by up to 12 percent, say McKinsey’s Barbara Jeffery and Patrick Simon and their coauthors. Leaders can support their employees’ mental health by focusing on six important aspects of well-being: social interaction, mindsets and beliefs, productive activity, stress, economic security, and sleep. “Considering that the average person spends a third of their life at work—more than 90,000 hours in a lifetime—employment can be a critical piece of the puzzle when working toward the goal of improving global health,” the authors say.
That’s McKinsey partner Erica Coe on the teen mental health crisis. She explains that Gen Zers—a cohort that includes young adults who are now in the workforce as well as teens who will enter the job market over the next decade—report less stigma about openly discussing mental health compared with older individuals. According to Coe, this generation’s rising numbers in the workforce will put more pressure on employers to provide robust mental health resources for their employees.
Creating awareness about spiritual health in the workplace—that is, having a sense of meaning, connection, and purpose—can benefit employees and their companies. According to a McKinsey Health Institute survey, employees in good spiritual health are more likely than others to find satisfaction, build resilience and engagement, and improve their mental health at work. While spiritual health might seem like a “loose concept” to business leaders, people who feel they have unmet spiritual needs have much higher healthcare costs, and better spiritual health can lead to less employee absenteeism and less turnover. “For employers, there are real economic or business implications, as well as keeping their employees as healthy and well as they can,” McKinsey’s Kana Enomoto says.
Lead by prioritizing mental health.
— Edited by Eric Quiñones, senior editor, New York
Share these insights
Did you enjoy this newsletter? Forward it to colleagues and friends so they can subscribe too. Was this issue forwarded to you? Sign up for it and sample our 40+ other free email subscriptions here.
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Leading Off newsletter.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey Leading Off" <publishing@email.mckinsey.com> - 04:31 - 21 Oct 2024 -
How might generative AI disrupt the software sector?
Only McKinsey Perspectives
Key questions for software leaders Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Only McKinsey Perspectives. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
•
Disrupting the software sector. In 2023, large global enterprises spent about $15 billion on gen AI solutions—a milestone that took four years to reach during the enterprise software industry’s last major transformation, software as a service (SaaS). According to McKinsey senior partner Jeremy Schneider and coauthors, gen AI is poised to upend the sector’s user segments, value pools, and overall industry dynamics while creating a significant opportunity for new revenue.
—Edited by Belinda Yu, editor, Atlanta
This email contains information about McKinsey's research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Only McKinsey Perspectives newsletter, formerly known as Only McKinsey.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:37 - 21 Oct 2024 -
Showcase Your Telecoms Consultant across 45 leading directories
Showcase Your Telecoms Consultant across 45 leading directories
Hi there,
If you want Your Telecoms Consultant to be found by local customers, business listings are a must.
Business listings are a great way of putting your business in front of people who are searching for a service in your area.
It can be costly and time-consuming to identify, set up and manage high-quality online listings though, not to mention all the online reviews to manage.
Our unique Listing Manager allows you to showcase your business across 45 leading directories, search engines, maps, social media and sat-navs - think a digital version of the Yellow Pages.
So whether your customers are searching on Google, Bing, Apple Maps, Uber, Sat Navs and so on - if your business is listed through our Listing Manager you will come up as a local provider.
Three key benefits of Listing Manager:
All managed in one dashboard - Update your business’ details once, and it will instantly sync to over 45 listings.
Review management - Reply to any review from any listing, from your online dashboard.
Improves Google ranking - Listing Manager boosts your local search engine optimisation, getting you found quicker.
All for just £425 for a full year!
If you'd like to find out more, drop me an email back or give me a call on 0800 089 0879.
Best regards,
Darren Dale
Digital Marketing Consultant
0800 089 0879
infoserve.com
P.S. Here's what Jonathan Anelli had to say recently:
“Been working with infoserve on and off for a number of years. I have found MASSIVELY USEFUL is LISTINGS MANAGER. My business isn't the sort that people search for through listings. However, the one-stop-shop approach for dozens of high-quality links has proved instrumental in my site developing a high authority score! I'm ranking better than competitors simply because I have higher authority... (please don't tell them about this)”
Infoserve Ltd, Southside Aviation, Leeds Airport, LS19 7UG. Registered in England No. 04209122
We have sent this email to info@learn.odoo.com, having found your company details online, as we believe our digital marketing services may be of legitimate interest to your business. If you would no longer like to get emails from us you can stop them here.
by "Darren Dale" <darren@infoserve.uk> - 03:25 - 20 Oct 2024 -
Business Inquiry
Dear Sir,
I am Steve Tim from NTI Forge Group in Kazakhstan, We have read an Exhibition article on the internet about
your range of products and we understand that your company supplies some products that fit our business
requirements. Please kindly send me your catalog or Brochure to learn more about your products.
We look forward to working with you and hope this is the beginning of a long and prosperous business relationship.
Further looking forward to your positive response at the earliest.
Best Regards.
Your Sincerely,
Steve Tim,
Export Manager,
NTI Forge Group,
Nur-Sultan Kazakhstan,
Tel: +7 717 255 2809
Fax: +7 717 255 2800
Email: stevetim432@gmail.com
by "NTI FORGE GROUP" <stevetim432@gmail.com> - 12:43 - 20 Oct 2024