home.social

#mysql80 — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #mysql80, aggregated by home.social.

fetched live
  1. lefred @lefred ·

    MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know
    In MySQL 8.0.12, we introduced a new algorithm for DDLs that won't block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games.

    Then in MySQL 8.0.29 we added the possibility to add (or remove) a column anywhere
    lefred.be/content/mysql-innodb
    #80

    #innodb #mysql #mysql80
  2. lefred @lefred ·

    Where to find official MySQL container images ?
    If you are deploying MySQL on containers, one of the first tasks is to find the right image.

    There's a certain amount of confusion, especially when we're trying to help someone who's having problems with their deployment.

    For example, when people say I'm using the official docker image... what does that really mean?

    Doc
    lefred.be/content/where-to-fin
    #80 #81

    #containers #mysql #mysql80
  3. lefred @lefred ·

    As a DBA, develop a critical mind when receiving advice
    On the Internet, you can get a lot of advice from almost anywhere when you're looking for information on how to do your DBA job.

    My blog is one of these sources of advice, and depending on the source, we generally trust the advice more or less.

    But sometimes advice doesn't take the whole picture into account, and
    lefred.be/content/as-a-dba-dev
    #80

    #mysql #mysql80 #replication
  4. lefred @lefred ·

    Deploy Moodle on OCI with Ampere and MySQL HeatWave
    If you want to deploy Moodle on OCI, you can use Ampere compute instances as application server and MySQL HeatWave Database Service to store the data.

    Depending on your requirements, MySQL HeatWave can provide High Availability and Query Acceleration.

    In this post, we will see th
    lefred.be/content/deploy-moodl
    #80

    #cloud #heatwave #mds #moodle #mysql #mysql80
  5. lefred @lefred ·

    About Apache Superset with MySQL 8.0
    Yesterday, I published an article explaining how to easily deploy Apache Superset on OCI using MySQL HeatWave Database Service.

    There are some people not using the automation or not using MySQL HeatWave Database Service on OCI but want to still use Superset with MySQL 8.0.

    In this blog, we will how to fix eventual error
    lefred.be/content/about-apache
    #80

    #apachesuperset #datavisualization #mysql #mysql80 #python
  6. lefred @lefred ·

    Using Cloud Shell with MySQL HeatWave Database Service in OCI
    Last time we tried to connect to a MySQL DB instance in OCI with Cloud Shell, we needed to use the bastion service. See here.

    Now, we also have the possibility to bypass the bastion host as Cloud Shell offers the possibility to change network.

    As you know, in Oracle Cloud Infrastructure
    lefred.be/content/using-cloud-
    #80

    #cloud #heatwave #mds #mysql #mysql80 #oci
  7. lefred @lefred ·

    WordPress with MySQL on OCI always Free
    I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure:

    Using MySQL Database Service for WordPress

    Deploying WordPress on OCI with MySQL Database Service: the easy way !

    Deploy WordPress on OCI using MDS – updated version

    Deploy WordP
    lefred.be/content/wordpress-wi
    #80

    #cloud #mysql #mysql80 #oci #stacks #terraform
  8. lefred @lefred ·

    How to Migrate from MariaDB to MySQL HeatWave
    We see an increase in the demand for database migration from MariaDB to MySQL. This is likely due to recent news about MariaDB. [1][2][3][4][5][6][7][8]

    In this article, we will show you how to migrate from MariaDB to MySQL HeatWave in Oracle Cloud Infrastructure (OCI).

    If you plan to migrate from
    lefred.be/content/how-to-migra
    #80

    #cloud #heatwave #mds #mysql #mysql80 #mysqlshell