How to make 2 root appenders in log4j2?

Question

Java

Good day. I'm trying log4j2.
The task is to log all errors in 2 places: the console and the database (I wrote my appender).
I try like this, but it only logs to the last appender:

<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="WARN" packages="bestapp">
    <Appenders>
        <Console name="CONSOLE" target="SYSTEM_OUT">
            <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
        </Console>
        <MysqlAppender name="MYSQL"/>
    </Appenders>
    <Loggers>
        <Root level="ERROR">
            <AppenderRef ref="CONSOLE" />
        </Root>
        <Root level="ERROR">
            <AppenderRef ref="MYSQL" />
        </Root>
    </Loggers>
</Configuration>

How to make it log in both?
Thanks in advance!

Answer 1

There should be only one root, but there can be many appenders:

<Loggers>
    <Root level="ERROR">
        <AppenderRef ref="CONSOLE" />
        <AppenderRef ref="MYSQL" />
    </Root>
</Loggers>