MySQL Support Blogs

This is an aggregated feed of various blogs of Oracle support staff who work and support MySQL customers and users. There is an RSS feed to which you can subscribe.

Larry Ellison: Oracle Is 'Focused on Our Star Products'

When Oracle announced its fiscal year financial results on June 19, Chairman and CTO Larry Ellison made it clear that the company has fast-growing products and fast-shrinking products—and that’s just fine by him.

“We’re focused on our star products, and our star products are now driving our top line higher,” Ellison said.

Some of the biggest stars are Oracle’s Autonomous Database, its Fusion ERP and  …


[Read More]

Three Oracle Analytics Value Propositions

By Rich Clayton

How can institutions best demonstrate the value of analytics to answer important questions so that they can make better information-based decisions and better align their efforts with strategies, goals, and objectives? Here are three value propositions we discuss with our customers and partners.

Let's Start at the Beginning

Higher education institutions face many dilemmas today from growing enrollment to lowering costs to improving student outcomes to deciding which programs to expand and which to retire. Analytics can provide answers to these difficult questions, but too few institutions have a strategy and a culture to use all institutional data in the moments that matter. It's well documented that when well-directed analytics can improve student retention, provide key insights on program viability, and predict applicant conversion, enrollment, and endowment.  

So why is it that many institutions …


[Read More]

3 Best Practices for Building Out 5G Services

In leveraging our experience building web scale cloud and services, we have not only been building software and using processes that work for cloud, but also seeing that in practice, just being cloud native is not enough to be successful in providing digital services.  There is more that we and other vendors can do to help CSPs mitigate the frustrations acknowledged in our previous blog about what cloud native is and how it must be built from actual experience with large clouds, accompanied by process changes.

CSPs recognize it is critical that they make the transition so that their own networks leverage cloud technologies …


[Read More]

Oracle Volunteers Get Their Hands Dirty for a Cleaner Planet

During the month of April, more than 1,300 Oracle Volunteers took action for a healthy planet. They collaborated with 63 leading environmental organizations as part of Focus on Environment, the annual global initiative that makes nature the center of attention.

Wearing red t-shirts and big smiles, Oracle Volunteers followed through on more than 75 projects: cleaning up the coastlines of California, Puerto Rico, Malaysia, and Spain; planting trees in Romania, Lebanon, Hong Kong, and India; and beautifying parks across Italy, Mexico, Canada, the UK, and the US.

Oracle Volunteers rallied their colleagues to get outside and elevated their collective impact by inviting friends, family, and the community to join in—planting flowers with seniors, tending gardens with children, picking up litter, and cleaning waterways with friends old and new.

Here are a few highlights from around the world:

Asia Pacific


[Read More]

Introducing Oracle Intelligent Track and Trace

By Michael Richter, Director Product Marketing, Emerging Technologies

Oracle is a leader in blockchain technology and began its journey with Oracle Blockchain Platform in July of 2018. With a lot of interest and early adoption by customers, the next step in this evolution was to make it easy for business users to implement and further transform their processes using prebuilt blockchain applications. 

Four prebuilt blockchain applications are coming soon. The first of these, Oracle Intelligent Track and Trace, is an application for businesses using supply chain management. It helps to address the challenges of managing complexities in a global network of trading partners. This prebuilt application is ready to deploy and helps to gain …


[Read More]

Oracle Helps Retailers Right-Size Inventory for Every Store

Fast fashion retailers are under an immense amount of pressure to get their in-store product assortments allocated perfectly. While customers expect their desired styles and sizes to be in stock, retailers grapple to minimize excessive inventory and dramatic markdowns. Part of the newly launched Oracle Retail Science Platform Cloud Service, the Size Profile Science features enable retailers to tackle this problem by helping accurately predict sales to ensure they have the right inventory mix in the right locations.

“Customer expectations are higher than ever and retailers are constantly walking a tightrope, balancing between too much of the wrong inventory and not enough of the right,” said Jeff Warren, …


[Read More]

Big IT Operations Aren’t Just Moving To The Cloud. They’re Joining Forces With It.

If you follow tech trends, you know that companies these days are often skipping the cost and hassle of operating data centers and instead using readily available cloud services. For many big companies, though, it’s a matter of using both models: finding ever-more ways to take advantages of cloud computing services while still keeping the best of their data centers.

That’s the fuel behind Oracle’s Exadata Database Machine, which celebrates its 10th year in production, and the launch of its most advanced machine to date, Oracle Exadata Database Machine X8.

In addition to improvements in its performance and capacity, Exadata X8 taps machine learning and artificial intelligence in new ways that boost a team’s productivity. The machine-learning capabilities include …


[Read More]

Flip the Model on Advanced Data Analytics

Amid mounting digital transformation pressures, the top two categories for increased IT spending in 2019 are cloud computing—and on-premises data analytics, according to a recent Morgan Stanley survey of North American CIOs.

Why analytics? IT leaders in large organizations are investing heavily to extract more value from information they already have. For most of them, their critical applications aren’t in the cloud yet. And—for the time being—their center of gravity remains in the data center.

For most organizations, the process of gaining insight from data has long been the same: Extract data from one or more sources, Transform it to be suitable for analytics, and then Load it into a separate environment for analytic processing (ETL).  

Every year, though, …


[Read More]

Oracle and Microsoft Interconnect Clouds to Accelerate Enterprise Cloud Adoption

By Vinay Kumar (Shivagange Chandrashekar), vice president of product management

Since the beginning of the cloud IT era, there’s been talk of hybrid and multicloud deployment. For the most part, however, it’s been just talk. Today, Oracle is excited to announce an alliance with Microsoft that makes multicloud a reality and allows enterprises to build, migrate, and manage solutions that span clouds with ease.

The majority of large enterprises around the world use both Oracle and Microsoft solutions to power their businesses, running these solutions side-by-side in their on-premises data centers. When enterprises migrate their workloads to the cloud, they often become stranded on multiple cloud islands, with little ability to share data between the islands. The alliance between Microsoft and Oracle represents an industry-first offering that gives customers the ability to seamlessly use multiple clouds with much greater effectiveness. It moves …


[Read More]

Bring in AI to Step Up Your Customer Service

Today’s customer service is ill-equipped to handle the toughest interactions—ones that happen quickly, are often emotional, and carry very high stakes for your company. Enter artificial intelligence, a technology that, oddly enough, promises to personalize those interactions more than a human alone ever could.

Here’s an example: 

You and your colleague are flying from London to San Francisco and miss your connection in New York. You both need to rebook, and you get to the counter at JFK at the same time but there’s only one seat left. Who gets it? 

Whoever doesn’t get the seat will remember that interaction for a long time, so the airline had better make the right call, based on sound business logic. Yet as things now stand, that decision more often than not rests in the hands of a front-line employee who has about 15 seconds to make the call, with very little visibility into which passenger is the more loyal, valuable customer.

Maybe the …


[Read More]

Flip the Model on Advanced Data Analytics

Amid mounting digital transformation pressures, the top two categories for increased IT spending in 2019 are cloud computing—and on-premises data analytics, according to a recent Morgan Stanley survey of North American CIOs.

Why analytics? IT leaders in large organizations are investing heavily to extract more value from information they already have. For most of them, their critical applications aren’t in the cloud yet. And—for the time being—their center of gravity remains in the data center.

For most organizations, the process of gaining insight from data has long been the same: Extract data from one or more sources, Transform it to be suitable for analytics, and then Load it into a separate environment for analytic processing (ETL).  

Every year, though, …


[Read More]

Use a Pencil: How a Java Developer Gets Stuff Done

When Java Champion Mani Sarkar talks about technology, you think, “I’ll have what he’s having.” The prolific writer, speaker, and Java and JVM-based developer is a vibrant member of the London Java Community (LJC) as well as a passionate backer of open source projects such as Adopt OpenJDK. Although his day job focuses on strengthening teams, his interests include improving code quality and performance, implementing DevOps and machine learning, and more.

Talking to Sarkar about productivity means tapping into the mother lode. Here is just a sampling of the many ways he suggests improving your Java code and learning new technology more effectively.

Deep Work

“These days I take a lot of inspiration from the book Deep Work by Cal Newport,” says Sarkar. “Getting into the flow of working …


[Read More]

Performance Schema Functions

Tweet

The sys schema was created to make it easier to use the Performance Schema. This included several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings. In MySQL 8.0.16, three of these functions have been implemented as native functions in MySQL Server.


[Read More]

The ‘Unprecedented Challenge’ of Cybersecurity Today

Technological and legal complexities abound in this age of heightened cybersecurity threats—including a rise in state-sponsored hacking. This “unprecedented challenge” was the topic of conversation between Dorian Daley, Oracle executive vice president and general counsel, and Edward Screven, Oracle’s chief corporate architect during Oracle's recent Media Days. Here are five key takeaways from their conversation:

1. Some good news: Businesses are aware of cybersecurity challenges in a way they were not even just a few years ago, when many considered security, generally, as a priority, but didn’t go much beyond that thought, according to Screven. “It’s [become] a front-and-center kind of issue for our customers,” Daley agreed.

2. These same customers would like to make data security “someone else’s problem,” and are right to think that way, Screven added. In …


[Read More]

Oracle Named Among 100 Best Corporate Citizens

Last week, Oracle was named to Corporate Responsibility Magazine’s 2019 100 Best Corporate Citizens list, which recognizes outstanding environmental, social and governance (ESG) transparency and performance amongst the 1,000 largest US public companies. Oracle ranked #41, up from #97 in 2018—a testament to the tremendous progress we have made in our global corporate citizenship efforts in the past year.

“Good corporate citizenship means being intentional and thoughtful about the value we generate as a company—not only for our shareholders, but also for our people, our planet, and future generations,” says Oracle CEO Safra Catz. “It means applying the same level of commitment, rigor, and sincerity to changing lives as we do to building cutting-edge technology for our customers.”

Here are a few key highlights from FY18:

  • Oracle …


[Read More]

The Power of Prioritizing Customer Feedback

We have a tremendous opportunity before us—as companies and as industries—to not only solve problems for customers but also to do something just as important—to delight them with our products and services.

What’s the secret for making this possible? Staying focused on one of our most important resources: the customer. My fellow senior vice president in Oracle’s user experience design group, Jenny Lam, and I are working to create innovative, customer-focused processes known as a design culture. It’s an initiative that’s doubling down on what’s been a goal at Oracle for the past 41 years—giving customers tools they love to use.

Executives at every company say they’re focused on customers—and most of them are, to varying degrees. So, what makes the most customer-centric ones special? They’re better listeners. They start by gathering anonymized, quantitative data that shows how people are using their products and services. Usage data will tell …


[Read More]

The Dashboard for the Modern Database Fleet

This post provides highlights from the recent release of Oracle Enterprise Manager, including management for Oracle Autonomous Database, Oracle Database 19c and more!

“With this new update of Oracle Enterprise Manager, we have introduced support for Oracle Autonomous Database in Oracle Cloud and other capabilities to enable our customers to monitor and manage their hybrid environments using the same tool they’ve been familiar with for years.”  —Wim Coekaerts, Senior Vice President, Engineering, Oracle

A recent survey of the International Oracle User Group shows that most database administrators feel they are spending too much time dealing with day-to-day issues and not enough on user experience and proactive planning. With this release of Oracle Enterprise Manager, we are …


[Read More]

Oracle Analytics Is the Only Solution You Need

By Rich Clayton

If you're seeking to build a more insight-driven organization, you're probably looking for ways to extend and improve your business analytics. There are plenty of products on the market today, but the one you choose will determine just how well—and how quickly—your organization will be able to create value from data. To be effective, the solution must be able to support existing use cases while also allowing your users to connect, enrich, combine, and visualize data on their own.

According to Stewart Bryson, CEO and founder of Red Pill Analytics, that's where Oracle Analytics Cloud stands out from other cloud-based data analytics products.

"With Oracle Analytics Cloud, you get best-of-breed data visualization and cloud connectivity while still being able to satisfy your enterprise use cases—all in a single solution," Bryson says. "Other offerings, such as Microsoft Power BI, …


[Read More]

Connector/Python Connection Attributes

Tweet

MySQL Server has since version 5.6 supported connection attributes for the clients. This has allowed a client to provide information such as which program or connector the client is, the client version, the license, etc. The database administrator can use this information for example to verify whether all clients have been upgraded, which client is executing a particular query, and so forth.

In MySQL 8.0.16 this feature has been included for the X DevAPI in the MySQL connectors as well, including MySQL Connector/Python which I will cover in this blog. First though, let’s take a look at how the attributes are exposed in MySQL Server.


[Read More]

MySQL Server 8.0.16: Thanks for the Contributions

Tweet

MySQL 8.0.16 was released last week and includes many great features including support for CHECK constraints and upgrades without the need of mysql_upgrade. As usual there are also several contributions from the community. These are the ones, I would like to highlight in this blog to say “thank you for the contributions”.


[Read More]


Content reproduced on this page is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.