Showing entries 1 to 10 of 946
10 Older Entries »
Displaying posts with tag: community (reset)
MySQL: Character Sets, Unicode, and UCA compliant collations

With MySQL 8.0, the version of MySQL Database Service aka MDS, the default character set has changed from latin1 to ut8mb4. The default collation is utf8mb4_0900_ai_ci but what does that mean ? and why are the utf8mb4_0900_* the recommended ones ?

Collations like utf8mb4_unicode_520_ci and utf8mb4_0900_ai_ci are based on Unicode Collation Algorithm (UCA). The number in the collation defines the UCA version:

  • UCA 9.0.0 (recommended)
    - example: utf8mb4_0900_ai_ci
  • UCA 5.2.0 (not recommended, see problems below)
    - example: utf8mb4_unicode_520_ci

The …

[Read more]
Reminder when using MySQL Shell

If like me you are using MySQL Shell on many different systems and new installations, there are some commands I often use to benefit from my environment.

What I really want to enable is the history of course, a nicer prompt and sometimes the default mode I want to use.

This blog post is just a little reminder with those commands I usually repeat in all my systems:

mysql-js> shell.options.setPersist('history.autoSave', 1) mysql-js> shell.options.setPersist('history.maxSize', 5000)

The option above is when using MySQL Shell in JS mode which is the default. To play with options using the same command in every mode (JS, Python, SQL), you can use /option like:

\option --persist history.autoSave 1

Then I set the prompt to have something like this:

$ cp /usr/share/mysqlsh/prompt/prompt_256pl+aw.json …

[Read more]
Migrate Ownership of your stored routines, views and triggers for MySQL in 2021

Yesterday my friend and ex-colleague Sveta published a blog post on how to migrate ownership of stored routines, views and triggers in MySQL.

I usually agree a lot with her and even if I agree with what she wrote, there is one single point I would like to comment: use MySQL Shell !

In the blog post, Sveta recommends the use of mysqldump which I don’t. For any logical dump & load operations, I really recommend the use of MySQL Shell’s Dump & Load Utility ! It’s much faster, it has many nice options like hidden Primary Key creation, and is compatible with OCI.

And of course, MySQL Shell also provides …

[Read more]
MDS, PHP and authentication

Recently I blogged about how to easily deploy a LAMP application to MDS.

Using the Terraform module (OCI Resource Manager’s Stack) you also have the possibility to choose the PHP version to install:

But as you should already know, not all versions support the latest default authentication method in MySQL 8.0: caching_sha2_password [1], [2], [3].

Most of the PHP applications are using mysqli and …

[Read more]
Where’s the MySQL team from July - September 2021

As a continue of the previous announcement, please find below the list of shows where you can find MySQL Community and/or the MySQL team during the time of July - September 2021:

  • July 2021:

    • MySQL meetup / Virtual, July 7, 2021

      • Carsten Thalheimer and Abdullah Zarour, the MySQL Principal Solution Engineers will be talking about Oracle Cloud - MySQL Database Service & HeatWave (for Real-time Analytics). 
      • Scheduled for 5:00 PM to 7:00 PM GMT+4. Please make sure you have zoom registration on …
[Read more]
MySQL meetup on MDS & HeatWave

We & local Oracle Cloud Community in Dubai are happy to announce upcoming MySQL OCI meetup scheduled for Wednesday, July 7th, 2021. Please find details below.

  • Date: Wednesday, July 7th, 2021
  • Time: 5:00 PM to 7:00 PM GMT+4
  • Topic: MySQL Database Services (MDS), MySQL HeatWave for Real-time Analytics, demos
  • Speaker: Carsten Thalheimer & Abdullah Zarour, the MySQL Principal Solution Engineers
  • Form: virtual event (via zoom)
  • More information & registration

 

Where’s the MySQL team from April - June 2021 (updated, May 20, 2021)

Please find below the list of shows where you can find MySQL Community and/or the MySQL team at during April to June 2021:

  • April 2021:

    • Data Love Conference/VIRTUAL, April 16, 2021

      • David Stokes, the MySQL Community Manager is going to talk about "Windowing Functions for Database Analytics", for the exact timing please check organizers' website.
    • MidwestPHP/VIRTUAL, April 22-23, 2021
      • David Stokes, the MySQL Community Manager is going to talk about "MySQL 8.0 New Features". The talk is scheduled for 1:50pm-2:30pm on April 22nd. 
[Read more]
Where’s the MySQL team from April - June 2021 (updated, May 20, 2021)

Please find below the list of shows where you can find MySQL Community and/or the MySQL team at during April to June 2021:

  • April 2021:

    • Data Love Conference/VIRTUAL, April 16, 2021

      • David Stokes, the MySQL Community Manager is going to talk about "Windowing Functions for Database Analytics", for the exact timing please check organizers' website.
    • MidwestPHP/VIRTUAL, April 22-23, 2021
      • David Stokes, the MySQL Community Manager is going to talk about "MySQL 8.0 New Features". The talk is scheduled for 1:50pm-2:30pm on April 22nd. 
[Read more]
MySQL Webinar - Best practices for MySQL Performance

We are happy to announce another MySQL Webinar on the topic of "", see details below:

  • Date: Feb 16, 2021
  • Time: 2:00 pm Dubai time (GMT+4)
  • Topic: Best practices for MySQL Performance
  • Description: Of all the features that are available in MySQL, we will still need to optimize and fine tune our environment to our specific needs and the immediate or not-too-distant future growth. In this session we will have a look into ways to analyze the instances' performance and take into consideration some suggestions and best practices.
  • Speaker: Carsten Thalheimer, the MySQL Master Principal Sales Consultant
  • Registration
[Read more]
Where's the MySQL Team from January - March 2021

As a continue of the regular blog posts informing you about where you can find MySQL Community & MySQL team at, please find below a list of shows you can join and listen MySQL talks & sessions. 

  • January 2021:

    • Coud Native Meetup/VIRTUAL, January 26, 2021 - URL to be provided later on.
      • Frederic Descamps, the MySQL User Group Manager will talk on: "MySQL 8.0: Why to use MySQL 8.0 and how to deploy a web application in OCI using MySQL Database Service" 
      • Scheduled for January 26th as EMEA & JAPAC session & January 27th, 2021.
    • OpenSource Conference Osaka/VIRTUAL, January 30, 2021
      • Yoshiaki …
[Read more]
Showing entries 1 to 10 of 946
10 Older Entries »