Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Helm Install MySQL InnoDB Cluster: tls.routerCertAndPKsecretName: secret 'my-mysql-innodbcluster-router-tls' not found in namespace 'default'

Mystic last edited by
When I https://artifacthub.io/packages/helm/mysql-operator/mysql-innodbcluster?modal=install
```
helm install my-mysql-innodbcluster mysql-operator/mysql-innodbcluster --version 2.0.4
```
I get the following error,

Error: INSTALLATION FAILED: execution error at (mysql-innodbcluster/templates/deployment_cluster.yaml:18:8 tls.routerCertAndPKsecretName: secret 'my-mysql-innodbcluster-router-tls' not found in namespace 'default'

How can I resolve it?
Reply Quote 0
1 Reply Last reply
K
kalena last edited by
The instructions for deploying/creating a https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-innodbcluster-simple-helm.html ,

You have two options with MySQL, either deploy with
- A self-signed certificate. This will require setting tls.useSelfSigned
- An externally signed certificate. his will require providing a tls.caSecretName, tls.serverCertAndPKsecretName and tls.serverCertAndPKsecretName
You can set these options like this with --set like this
```
helm install  mysql-operator/mysql-innodbcluster \
  --set tls.useSelfSigned=true
```
No matter what you'll also always have to provide credentials.root.password for this specific chart --set credentials.root.password=foobar

See also,
- https://devops.stackexchange.com/q/16066/18965
Reply Quote 0
1 Reply Last reply

2
Posts

4
Views

Suggested Topics

A

Switch between results
Software Programming • mysql sql union • • Amritpal

2

0
Votes

2
Posts

0
Views

D

By the explanation of the expected return, it would be more appropriate for you to use a http://www.bosontreinamentos.com.br/mysql/mysql-left-e-right-join-consultar-dados-em-duas-ou-mais-tabelas-30/ rather than union, since it intends to bring priority what it has in the second table:SELECT DISTINCT e.nome, e.idade, e.data_nascimento, e.cpf FROM internos i RIGHT JOIN externos e ON e.cpf = i.cpf WHERE e.cpf = '12345678911' Whereas the returned data will be equal in the two tables, distinct You will filter to select only one occurrence (when you have the same user in both).DETAIL: the id of the tables are independent among themselves, so that the distinct function exactly as I said, I removed from the return.By @adventistaam comment, you can try using only the join, validating which date to display:SELECT DISTINCT IF(e.data_nascimento is null, i.nome, e.nome) as nome, IF(e.data_nascimento is null, i.idade, e.idade) as idade, IF(e.data_nascimento is null, i.data_nascimento, e.data_nascimento) as data_nascimento, IF(e.data_nascimento is null, i.cpf, e.cpf) as cpf FROM internos i JOIN externos e ON e.cpf = i.cpf WHERE e.cpf = '12345678911'
R

Generate a pdf from a table in html and php?
Software Programming • php html mysql • • rosemadder

2

0
Votes

2
Posts

0
Views

R

The problem is that you are using file_get_contents.This function, takes what is written inside the content, that means that in this case it takes a lot of codes php that are written. He doesn't consult in the database, for example...What you can do is use one buffer output to temporarily store this data that is generated and then use them in Dompdf. So: use Dompdf\Dompdf; require_once'dompdf/autoload.inc.php'; $dompdf=new DOMPDF(); $html = ""; // html que será usado /* A partir daqui inicia o buffer */ ob_start(); // inicio include "pdf.php"; // roda o arquivo // tudo o que foi gerado até agora, salva na variável $html $html .= ob_get_contents(); ob_end_clean(); // joga fora o buffer $dompdf->load_html($html); $dompdf->render(); $dompdf->stream();
Set MySql read-only from K8s cluster
SQL, Database Testing • mysql read only database • • Laycee

2

0
Votes

2
Posts

0
Views

C

I think that the SUPER privilege allows the user to write to a read_only server. Do NOT use such a user for anything other than admin purposes. Use less-privileged user(s) for application actions. Usually, an "app" user should be granted only ... ON dbname.* ....
mysql innodb cluster 3 nodes, 2 lagging almost 24 hours
SQL, Database Testing • mysql innodb mysql innodb c languagelu • • irl

2

0
Votes

2
Posts

0
Views

Hello for those out there with similar issues I fixed it thanks to this amazing blog post. https://thoughts.t37.net/fixing-a-very-lagging-mysql-replication-db6eb5a6e15d basically my changes: STOP SLAVE; SET GLOBAL slave_parallel_workers=40; START SLAVE; set GLOBAL sync_binlog=0; SET GLOBAL innodb_flush_log_at_trx_commit=2; SET GLOBAL innodb_flush_log_at_timeout=1800;` I already had the MT setup so just needed to add this and 40 workers. Hope this will help other people..
K

MySQL query took 98 seconds to run but EXPLAIN looks okay
SQL, Database Testing • mysql performance query performance slow log • • kalyn

2

0
Votes

2
Posts

0
Views

It's interesting that the slow-query log entry states no rows were examined, and no rows were returned. I wonder if MySQL determined the query produced no results by looking only at indexes. When you say you can't recreate the problem, do you mean MySQL returns the expected results for the query in much less time on subsequent attempts? That's often an indication that the first execution induced a lot of file IO to load data into buffers or cache. Subsequent executions of the same query against the same data benefit from faster access to the data.
J

How to delete a database record in php
Software Programming • php mysql • • Jolied

2

0
Votes

2
Posts

0
Views

S

Even though I will not give you a complete result, I hope this answer will help you understand and solve your problem.The first thing is to keep in mind that unique field we are going to remove the registration, the most appropriate thing if we want to remove a single record is to use the primary key to the table in your example apparently is idUser.When we create the CRUD table we must create a form for each row for the delete button, the form sending when pressing the button is recommended to be type DELETE even if we can use the http verb POST to facilitate things (or any other).Therefore we would have a table similar to the following: <table> <thead> <tr> <th scope="col">Nombre</th> <th scope="col">Nom. Usuario</th> <th scope="col">Borrar</th> <th scope="col">Actualizar</th> </tr> </thead> <tbody> <?php $link=mysqli_connect("localhost", "usuario", "contraseña", "basedatos"); $resultados = mysqli_query($link,"SELECT * FROM tbuser"); while($extraido = mysqli_fetch_assoc($resultados)){ ?> <tr> <td><?= $extraido['nombre'] ?><br><?= $extraido['apellidoP'] ?><br><?= $extraido['apellidoM'] ?></td> <td><?= $extraido['username'] ?></td> <td>  <form method="POST" action="eliminar.php">  <input type="hidden" name="idUser" value="<?= $extraido['idUser'] ?>"> <button name='Borrar' type='submit' class='btn btn-danger btn-md'><img src='img/papelera.png' width='25'></button> </form> </td>  <td><button name='Actualizar' type='button' class='btn btn-success btn-md'><img src='img/refrescar.png' width='21'></button></td> </tr> <?php } ?> </tbody> </table> I've commented on the most relevant thing in the code. Once this has been done we must create the file that will receive idUser and to perform the deletion of the register in the database in the previous example is eliminar.php (defined in the action form):<?php // recibimos el dato $idUser = $_POST['idUser']; // ejecutamos la eliminacion $link = mysqli_connect("localhost", "usuario", "contraseña", "basedatos"); $resultados = mysqli_query($link, "DELETE FROM tbuser WHERE idUser=$idUser"); // redirigimos a la tabla header( 'Location: http://url.es/formulario.php' ); ATTENTION The exposed code is vulnerable to SQL injection and should never be used as in production. For further information, please review: https://es.stackoverflow.com/questions/18232/c%C3%B3mo-evitar-la-inyecci%C3%B3n-sql-en-php
R

Line chart using Flot with data from a MySQL database
Software Programming • javascript php mysql ajax • • Raziyah00

2

0
Votes

2
Posts

0
Views

Finally I could solve it by uniting the two php files into one and putting the result in a final array:echo json_encode(array($return,$returnn)); In AJAX success:success: function(resp) { var result1 = resp[0];//purchases var result2 = resp[1];//sales show_chart(result1,result2); } And in the function show_cart:function show_chart(data1,data2) { var dataset = [{label: "Purchases",data: data1},{label: "Sales",data: data2}]; //y continúa... }
mysql innodb dump restore slows down after upgrade mysql 5.7 to 8.0
SQL, Database Testing • mysql mysql 5.7 mysqldump mysql 8.0 • • emmalee

2

0
Votes

2
Posts

0
Views

F

innodb_log_buffer_size should be no more than 1% of RAM. key_buffer_size should be only 30M, assuming you do not have any active MyISAM tables. Those changes will let you increase innodb_buffer_pool_size to 7G, which might help. Do you have any FULLTEXT or SPATIAL indexes? FOREIGN KEYs? Stored programs (probably not, since you did not ask for them to be dumped)? If those don't help, file a bug with https://bugs.mysql.com
A

mysqldump - select table in database only if it contains a specific string
SQL, Database Testing • mysql mysqldump sc languageripting • • amarantha

2

0
Votes

2
Posts

0
Views

B

What you need is a tool for controlling migrations and upload them to git a.k.a. a version control for MySQL. While you can deploy your own, this is a very well known problem and there are many tools available, some of them free and open source. I am not going to recommend you anything in particular, as they are different on the goals/features/integration with frameworks, but here it is a list of options: Liquibase Flyway c5-db-migration dbdeploy MyBatis Autopatch Sqitch online-migration Some recommended readings: http://en.wikipedia.org/wiki/Schema_migration, http://www.liquibase.org/quickstart and http://www.percona.com/live/mysql-conference-2013/sites/default/files/slides/PLMCE13_online-migration.pdf If you still want to deploy your own tool (not recommended), have a look at least at mysqldbcompare from mysqlutils and some of the percona-toolkit tools.
E

MySQL: How turning off the logging affect the performance?
SQL, Database Testing • mysql performance performanc languagee tuni mysql 5.1 • • emerson

2

0
Votes

2
Posts

0
Views

S

Except for the general log and the slow log with very small long_query_time, performance shouldn't get affected too much when on, as most logging should be written to the filesystem cache (those logs do not need to be transactional safe). There are certain combination of configuration and workloads that certainly can affect negatively performance: example: binary log with binlog_sync and no group commit on a heavy-write server binlog disallows group commit for innodb in earlier versions of mysql huge transactions altering blobs in row-based replication workload is mostly very fast primary key lookups, que log those queries in text (a read generates a write) Error log constantly outputing critical errors with GBs of information But in general, with a health filesystem cache (not too much memory pressure), things should be ok (small to almost negible amount of overhead, or admissible thanks to the extra features that they provide). For example, even the binary log added, let's say, a 5% overhead, it allows read scales through replication and point in time recovery. What should not happen is that disabling them reduces performance. Either that is an error of measure or it is provoked by something else. Also, for future readers, be careful not to confuse "server logs" (error, general, slow, binary) with the InnoDB transaction log.
Delete large number of rows and change index - what steps in which order and things to watch out for
SQL, Database Testing • mysql index delete mysql 8.0 • • briley

2

0
Votes

2
Posts

1
Views

Overflow... Not relevant to the question, but you have disaster coming in a few weeks: INT UNSIGNED will overflow at about 4 billion. DELETEing rows will not prevent this. Plan A: Get rid of the AUTO_INCREMENT PK if you have some other column(s) that is unique and could be used as the PRIMARY KEY. Plan B: Change it to BIGINT. Better now than when the table gets bigger. (That is 4 bytes bigger, but do it if you must.) Note: You can run it this way without losing the old table. This lets you make a mistake without losing data. (Eventually DROP the old table.) Deletes... Deleting a million rows, especially while the table is active, will take a long time because of needing to save them in case of ROLLBACK or crash recovery. The simple solution is to delete only 1000 rows at a time. See http://mysql.rjweb.org/doc.php/deletebig Since you want to delete "old" rows, DROP PARTITION is an excellent option. But it takes some setup. See that link (and another page that it points to). Since you want 12 weeks, I recommend 14 weekly partitions. Aggregates... Build and maintain a "summary table" by hour. See http://mysql.rjweb.org/doc.php/summarytables That will make the 'report' queries much faster. Size... Here are some suggestions on shrinking the disk space for the 'Fact' table. That will indirectly help performance some. spotName VARCHAR(50) NOT NULL looks bulky. Can it be normalized? DOUBLE takes 8 bytes; do you need 16 digits of precision? Or would a 4-byte FLOAT with 7 digits of precision suffice? Get rid of most of the indexes once you build the summary table(s). With rare exceptions, do not split up a date into its component parts. It leads to extra hassles in the code, performance hits, and may even increase disk usage. (Note that there is overhead for each column.) YYYY MM DD HH MM ss SSS looks like 17(?) bytes. TIMESTAMP(3) is only 7 bytes. If SSS is always 0, then use a 5-byte TIMESTAMP. If you don't want to switch to TIMESTAMP, then consider DECIMAL(17,0), which will take 8 bytes and still look like a 17-char string or 17-digit number. INT takes 4 bytes. Check out the smaller options. (I suspect you don't need millions of machine ids.) VIEW... In MySQL, a VIEW is essentially syntactic sugar. No space is saved. No performance is saved. Etc. Rebuild... To delete rows and add partitioning: Create new table with partitioning, changed indexes, different datatypes, normalization, etc `INSERT INTO new-table SELECT revised-columns FROM existing-table WHERE id > ... Note that the WHERE indirectly does the DELETE (by copying over only the rows that are to be kept). That helps things run faster shrinks the result table size and defragments. More... After you have dealt with most of my suggestions, start a new query and we can discuss the index(es) and summary table(s) further. Do include the main SELECTs.
J

What's the difference between a cursor and a trigger?
SQL, Database Testing • mysql mariadb trigger cursors • • jules

2

0
Votes

2
Posts

0
Views

E

Generally, a cursor is used to iterate through a result set that was returned by a SELECT statement. Cursors can be used in stored procedures, stored functions, and triggers. A trigger is a stored program executed automatically to respond to a specific event like an insert, update, or delete. As you can see, these are very different concepts and have very different purposes. I suggest you review these links for the basics on both of these concepts: Triggers, Cursors
R

Install galera cluster without remove existing mariadb
SQL, Database Testing • mysql replication mariadb galera multi master • • rielyn

2

0
Votes

2
Posts

0
Views

J

If you installed MariaDB 10.1, you don't need to remove anything because MariaDB Server and MariaDB Galera Server packages have been combined and Galera packages and their dependencies get installed automatically when installing MariaDB 10.1. So you must only configure galera without remove anything. Reference
B

Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity
SQL, Database Testing • mysql innodb • • baileigh

2

0
Votes

2
Posts

0
Views

At first glance, I would say that your innodb_log_file_size is way too small. It should be bigger to do two things: Accommodate any big BLOB or TEXT fields Holding bigger transactions Here is what you should do for now to see if it helps: STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 3G innodb_log_file_size = 768M STEP 02) service mysql stop STEP 03) rm -f /var/lib/mysql/ib_logfile* STEP 04) service mysql start This will rebuild the following files /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 Give it a Try !!! UPDATE 2013-07-03 12:37 EDT I have updated my other posts on this and missed this one ButtleButkus just commented at 2013-07-03 07:18:56 EDT Wouldn't it be advisable to copy the ib_logfile* to another location for backup before deleting them? Since there could be unfinished transactional data inside, here is what should be done STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 3G innodb_log_file_size = 768M STEP 02) mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;" STEP 03) service mysql stop STEP 04) rm -f /var/lib/mysql/ib_logfile* STEP 05) service mysql start I added SET GLOBAL innodb_fast_shutdown = 0;. What does that do? It forces InnoDB to completely purge transactional changes from all of InnoDB moving parts, including the transactional logs (ib_logfile0, ib_logfile1). Thus, there is no need to backup the old ib_logfile0, ib_logfile1. If deleting them makes you nervous, then make Step 04 mv /var/lib/mysql/ib_logfile* .. to put the old logs in /var/lib. If the recreation of the logs is successful and mysqld starts up, then you can delete the old logs. I have been using this feature for a year now. I have updated my other posts to reflect this... May 20, 2013 : Innodb one file per tablespace May 05, 2013 : Issue after moving the ib_logfile1 and ib_logfile0 files Jan 10, 2013 : Finding and fixing InnoDB index corruption Dec 17, 2012 : MySQL Start/Stop Feb 16, 2011 : How to safely change MySQL innodb variable 'innodb_log_file_size'? (Last Update) Feb 04, 2011 : MySQL InnoDB - innodb_file_per_table cons? (Last Update) Oct 29, 2010 : Howto: Clean a mysql InnoDB storage engine? (Added as Step 03 on Jun 04, 2013) If there are other older posts of mine where I do not mention innodb_fast_shutdown, let me know so I can update it. Thanks again, ButtleButkus.
How MySQL use the InnoDB Buffer?
SQL, Database Testing • mysql performance query performance innodb performanc languagee tuni • • inna

2

0
Votes

2
Posts

0
Views

Short Answer: Rule of Thumb: If you have more than 4GB of RAM, then set innodb_buffer_pool_size to about 70% of available RAM. Set and forget. Long Answer: "Greatly improve QPS?" -- It depends. The buffer_pool is a "cache", maintained roughly as "least-recently-used". If your data + indexes are bigger than the buffer_pool, there may be some slowdown. Either live with the speed or get more RAM. I have seen terabyte datasets run just fine on 32GB servers. It depends on the "working set". If the application only rummages through a portion of the rows (eg, "recent" rows), then a small buffer_pool works just as good as a big one. If you have UUIDs, you are hosed. These lead to random access that leads to slow-due-to-IO versus buy-more-RAM. mysqltuner has some good points and some bad points. Don't increase your buffer_pool to "big enough" unless you have 8GB or more of RAM. Swapping is much worse for performance than shrinking the buffer_pool. With a big enough buffer_pool, no it won't automatically load everything. As a "cache", things (16KB blocks) are loaded as needed, then left there. If it is not big enough and your "working set size" is big, those blocks will be bumped out to make room for other blocks. Automatically. The only cost is speed.

Helm Install MySQL InnoDB Cluster: tls.routerCertAndPKsecretName: secret 'my-mysql-innodbcluster-router-tls' not found in namespace 'default'

Suggested Topics

Switch between results Software Programming • mysql sql union • • Amritpal

Generate a pdf from a table in html and php? Software Programming • php html mysql • • rosemadder

Set MySql read-only from K8s cluster SQL, Database Testing • mysql read only database • • Laycee

mysql innodb cluster 3 nodes, 2 lagging almost 24 hours SQL, Database Testing • mysql innodb mysql innodb c languagelu • • irl

MySQL query took 98 seconds to run but EXPLAIN looks okay SQL, Database Testing • mysql performance query performance slow log • • kalyn

How to delete a database record in php Software Programming • php mysql • • Jolied

Line chart using Flot with data from a MySQL database Software Programming • javascript php mysql ajax • • Raziyah00

mysql innodb dump restore slows down after upgrade mysql 5.7 to 8.0 SQL, Database Testing • mysql mysql 5.7 mysqldump mysql 8.0 • • emmalee

mysqldump - select table in database only if it contains a specific string SQL, Database Testing • mysql mysqldump sc languageripting • • amarantha

MySQL: How turning off the logging affect the performance? SQL, Database Testing • mysql performance performanc languagee tuni mysql 5.1 • • emerson

Delete large number of rows and change index - what steps in which order and things to watch out for SQL, Database Testing • mysql index delete mysql 8.0 • • briley

What's the difference between a cursor and a trigger? SQL, Database Testing • mysql mariadb trigger cursors • • jules

Install galera cluster without remove existing mariadb SQL, Database Testing • mysql replication mariadb galera multi master • • rielyn

Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity SQL, Database Testing • mysql innodb • • baileigh

How MySQL use the InnoDB Buffer? SQL, Database Testing • mysql performance query performance innodb performanc languagee tuni • • inna

Switch between results
Software Programming • mysql sql union • • Amritpal

Generate a pdf from a table in html and php?
Software Programming • php html mysql • • rosemadder

Set MySql read-only from K8s cluster
SQL, Database Testing • mysql read only database • • Laycee

mysql innodb cluster 3 nodes, 2 lagging almost 24 hours
SQL, Database Testing • mysql innodb mysql innodb c languagelu • • irl

MySQL query took 98 seconds to run but EXPLAIN looks okay
SQL, Database Testing • mysql performance query performance slow log • • kalyn

How to delete a database record in php
Software Programming • php mysql • • Jolied

Line chart using Flot with data from a MySQL database
Software Programming • javascript php mysql ajax • • Raziyah00

mysql innodb dump restore slows down after upgrade mysql 5.7 to 8.0
SQL, Database Testing • mysql mysql 5.7 mysqldump mysql 8.0 • • emmalee

mysqldump - select table in database only if it contains a specific string
SQL, Database Testing • mysql mysqldump sc languageripting • • amarantha

MySQL: How turning off the logging affect the performance?
SQL, Database Testing • mysql performance performanc languagee tuni mysql 5.1 • • emerson

Delete large number of rows and change index - what steps in which order and things to watch out for
SQL, Database Testing • mysql index delete mysql 8.0 • • briley

What's the difference between a cursor and a trigger?
SQL, Database Testing • mysql mariadb trigger cursors • • jules

Install galera cluster without remove existing mariadb
SQL, Database Testing • mysql replication mariadb galera multi master • • rielyn

Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity
SQL, Database Testing • mysql innodb • • baileigh

How MySQL use the InnoDB Buffer?
SQL, Database Testing • mysql performance query performance innodb performanc languagee tuni • • inna